Manny Marinho
2015-07-18 13:44:15 UTC
Send Maia-users mailing list submissions to
To subscribe or unsubscribe via the World Wide Web, visit
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Maia-users digest..."
1. Maia on Postgresql issues (Eric McCorkle)
3. Re: wblist.php permissions issue (David Morton)
----------------------------------------------------------------------
Message: 1
Date: Wed, 01 Jul 2015 07:00:29 -0400
Subject: [Maia-users] Maia on Postgresql issues
Content-Type: text/plain; charset="utf-8"
Hello everyone,
I recently set up maia with postgresql as the underlying database. It
works more or less ok, but I ran into a few issues along the way.
First, the maia UI would display email addresses and some text fields as
'\x<hex-encoded stuff>'. After googling a bit, I discovered that you
apparently need to un-escape bytea fields in postgresql in order to get
legible text. After I edited the .php files to add the unescapes, it
worked well enough. So this is fixed on my setup, but it probably ought
to get re-integrated into the main development branch.
The second issue, which I still haven't resolved, seems to be related.
The logs show that database inserts are failing for some emails (namely,
in the maia_store_mail function), due to invalid syntax of bytea values. I
suspect this can be fixed by inserting the proper escaping code, but I
lack the perl experience to do it effectively.
Lastly, it looks like something's not working if a mail is classified as
spam. I've had a couple of obvious spams come through that seem to get
passed on through without being flagged at all. However, when I run
spamassassin on them myself, they score quite high. I'm not sure if this
is related to the second issue.
Best,
Eric
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
<http://www.renaissoft.com/pipermail/maia-users/attachments/20150701/610e
cf81/attachment-0001.sig>
------------------------------
Message: 2
Date: Thu, 02 Jul 2015 16:00:46 +0000
Subject: [Maia-users] wblist.php permissions issue
Content-Type: text/plain; charset=UTF-8; format=flowed; DelSp=Yes
Hello, using the admin account I am having issues adding new entries
to the W/B list for some users. Other users work fine so it makes no sense
if it's a permissions issue. I have even tried deleting the domain or user
account within maia and re-creating it but same issue. I get the following
Forbidden
You don't have permission to access /maia/wblist.php on this server.
Additionally, a 404 Not Found error was encountered while trying to
use an ErrorDocument to handle the request.
Apache/2.4.12 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Server at
mydomain.com Port 443
Also I have some users that have a large W/B list and I find that
sometimes this causes issues with maia where the W/B no longer functions.
Is there a way through mySQL or through one of the scripts
where I can either completely empty out the W/B list or trim it down as
needed? Doing this through the web interface would take me a huge amount
of time since you can't just select all entries and delete them (you have
to select each entry via radio button individually which is very painful).
Thank you.
-Manny
------------------------------
Message: 3
Date: Thu, 2 Jul 2015 11:49:38 -0500
Subject: Re: [Maia-users] wblist.php permissions issue
Content-Type: text/plain; charset=utf-8
That error sounds like a file permission problem on the server. Did
you edit that file as root or change the unix permissions?
Hi David thanks for the reply. Yes at one point I may have done both.To subscribe or unsubscribe via the World Wide Web, visit
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
or, via email, send a message with subject or body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Maia-users digest..."
1. Maia on Postgresql issues (Eric McCorkle)
3. Re: wblist.php permissions issue (David Morton)
----------------------------------------------------------------------
Message: 1
Date: Wed, 01 Jul 2015 07:00:29 -0400
Subject: [Maia-users] Maia on Postgresql issues
Content-Type: text/plain; charset="utf-8"
Hello everyone,
I recently set up maia with postgresql as the underlying database. It
works more or less ok, but I ran into a few issues along the way.
First, the maia UI would display email addresses and some text fields as
'\x<hex-encoded stuff>'. After googling a bit, I discovered that you
apparently need to un-escape bytea fields in postgresql in order to get
legible text. After I edited the .php files to add the unescapes, it
worked well enough. So this is fixed on my setup, but it probably ought
to get re-integrated into the main development branch.
The second issue, which I still haven't resolved, seems to be related.
The logs show that database inserts are failing for some emails (namely,
in the maia_store_mail function), due to invalid syntax of bytea values. I
suspect this can be fixed by inserting the proper escaping code, but I
lack the perl experience to do it effectively.
Lastly, it looks like something's not working if a mail is classified as
spam. I've had a couple of obvious spams come through that seem to get
passed on through without being flagged at all. However, when I run
spamassassin on them myself, they score quite high. I'm not sure if this
is related to the second issue.
Best,
Eric
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
<http://www.renaissoft.com/pipermail/maia-users/attachments/20150701/610e
cf81/attachment-0001.sig>
------------------------------
Message: 2
Date: Thu, 02 Jul 2015 16:00:46 +0000
Subject: [Maia-users] wblist.php permissions issue
Content-Type: text/plain; charset=UTF-8; format=flowed; DelSp=Yes
Hello, using the admin account I am having issues adding new entries
to the W/B list for some users. Other users work fine so it makes no sense
if it's a permissions issue. I have even tried deleting the domain or user
account within maia and re-creating it but same issue. I get the following
Forbidden
You don't have permission to access /maia/wblist.php on this server.
Additionally, a 404 Not Found error was encountered while trying to
use an ErrorDocument to handle the request.
Apache/2.4.12 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Server at
mydomain.com Port 443
Also I have some users that have a large W/B list and I find that
sometimes this causes issues with maia where the W/B no longer functions.
Is there a way through mySQL or through one of the scripts
where I can either completely empty out the W/B list or trim it down as
needed? Doing this through the web interface would take me a huge amount
of time since you can't just select all entries and delete them (you have
to select each entry via radio button individually which is very painful).
Thank you.
-Manny
------------------------------
Message: 3
Date: Thu, 2 Jul 2015 11:49:38 -0500
Subject: Re: [Maia-users] wblist.php permissions issue
Content-Type: text/plain; charset=utf-8
That error sounds like a file permission problem on the server. Did
you edit that file as root or change the unix permissions?
Right now my maia install facing the web resides in:
/home/myname/public_html/maia
The "maia" folder has the following permissions:
drwxr-xr-x 9 myusername myusername
The permissions for the file "wblist.php" for example are:
-rw-r--r-- 1 myusername myusername 7372 May 1 2014 wblist.php
I'm using CentOS 6.6 on my webserver with Apache. My apache user/group is
nobody/nobody. I think at one point I tries changing all maia permissions
to be owned by the apache user/group nobody but it broke everything
(probably because I didn't use the correct syntax). What I find odd is
that while using the maia admin account to manage spam for all domains I
am able to add to the W/B list to some domains/user accounts but not
others. In the past I even tried deleting the domain/account and adding it
back but same issue. Thank you.
-Manny
Hello, using the admin account I am having issues adding new entries to
the W/B list for some users. Other users work fine so it makes no
sense if it's a permissions issue. I have even tried deleting the domain
or user account within maia and re-creating it but same issue. I get the
Forbidden
You don't have permission to access /maia/wblist.php on this server.
Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/2.4.12 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Server at
mydomain.com Port 443
Also I have some users that have a large W/B list and I find that
sometimes this causes issues with maia where the W/B no longer functions.
Is there a way through mySQL or through one of the scripts
where I can either completely empty out the W/B list or trim it down as
needed? Doing this through the web interface would take me a huge
amount of time since you can't just select all entries and delete them
(you
have to select each entry via radio button individually which is very
painful). Thank you.
-Manny
_______________________________________________
Maia-users mailing list
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
--the W/B list for some users. Other users work fine so it makes no
sense if it's a permissions issue. I have even tried deleting the domain
or user account within maia and re-creating it but same issue. I get the
Forbidden
You don't have permission to access /maia/wblist.php on this server.
Additionally, a 404 Not Found error was encountered while trying to use
an ErrorDocument to handle the request.
Apache/2.4.12 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4 Server at
mydomain.com Port 443
Also I have some users that have a large W/B list and I find that
sometimes this causes issues with maia where the W/B no longer functions.
Is there a way through mySQL or through one of the scripts
where I can either completely empty out the W/B list or trim it down as
needed? Doing this through the web interface would take me a huge
amount of time since you can't just select all entries and delete them
(you
have to select each entry via radio button individually which is very
painful). Thank you.
-Manny
_______________________________________________
Maia-users mailing list
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
David Morton
------------------------------
Subject: Digest Footer
_______________________________________________
Maia-users mailing list
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
------------------------------
End of Maia-users Digest, Vol 141, Issue 1
******************************************