Re: [tpop3d-discuss]Permission problems with tpop3d

[Rob Fulton]

At 15:04 11/03/2004, you wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thursday 11 March 2004 06:54, Rob Fulton wrote:
> > If we try and run with the more secure permissions, we get the following
> > errors in the tpop3d.log :
> >
> > maildir_build_index: opendir(new): Permission denied
> >
> > This fault appears to be caused by the opendir call in maildir.c, as far as
> > we can tell, if the directory isn't openable as group mail, the call fails,
> > even if the actual server can open it due to it being openable by user
> > mail.
> >
> > Has anyone come across this problem or a fix?
>
> I assume you have 'auth-mysql-mail-group: mail' in your tpop3d.conf file, as
> the group permissions are working correctly.

Yep, reads as :

auth-mysql-mail-group: mail


> Make sure your auth-mysql-pass-query or auth-mysql-apop-query is returning 
> the
> desired username/uid to run as.  An example would be:
>
>         SELECT CONCAT( [blah blah blah] ), CONCAT('{crypt}',master.passwd),
>                 'mail', 'maildir'
>         FROM ....
>
> The third item returned from the query is mail.  I believe this can be either
> a user name or the actual uid to run as.
<snip>

Yep, I've got :
auth-mysql-pass-query: SELECT CONCAT('/var/spool/mail/', '$(local_part)'), 
CONCAT('{crypt}', password), 'mail', 'maildir' FROM popaccounts WHERE 
username = '$(local_part)' and status="A";

Regards

Rob Fulton