Re: wblist.php permissions issue (David Morton)

On Thu, July 2, 2015 3:00 pm, [email protected] wrote:
> Send Maia-users mailing list submissions to
> [email protected]
>
> 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
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Maia-users digest..."
>
>
> Today's Topics:
>
>
> 1. Maia on Postgresql issues (Eric McCorkle)
> 2. wblist.php permissions issue ([email protected])
> 3. Re: wblist.php permissions issue (David Morton)
>
>
>
> ----------------------------------------------------------------------
>
>
> Message: 1
> Date: Wed, 01 Jul 2015 07:00:29 -0400
> From: Eric McCorkle <[email protected]>
> To: [email protected]
> Subject: [Maia-users] Maia on Postgresql issues
> Message-ID: <[email protected]>
> 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
> URL:
> <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
> From: [email protected]
> To: [email protected]
> Subject: [Maia-users] wblist.php permissions issue
> Message-ID: <[email protected]>
> 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
> error when trying to add a new entry to the W/B list:
>
>
> 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
> From: David Morton <[email protected]>
> To: [email protected]
> Subject: Re: [Maia-users] wblist.php permissions issue
> Message-ID: <[email protected]>
> 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.
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

> On 7/2/15 11:00 AM, [email protected] wrote:
>
>> 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 error when trying to add a new entry to the W/B list:
>>
>> 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
>> [email protected]
>> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>>
>
>
> --
> David Morton
> [email protected]
>
>
> ------------------------------
>
>
> Subject: Digest Footer
>
>
> _______________________________________________
> Maia-users mailing list
> [email protected]
> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>
>
>
> ------------------------------
>
>
> End of Maia-users Digest, Vol 141, Issue 1
> ******************************************
>
>


_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users