Hi,
Thanks Roland, strace showed out the problems (authdaemon was not reaching
MySQL database). Now it is working. Below are some details of the
workaround.
If anyone is interested in the full solution Postfix+Courier+MySQL, feel
free to contact me and I'll send the details.
Platform
========
Debian 2.2.r4
courier-authdaemon 0.37.2-1
courier-pop 0.37.2-1
courier-authmysql 0.37.2-1
mysql 3.23.47-1
Problem
=======
authdaemon not connecting to Mysql backend. The only log message was
"courierpop3login: LOGIN FAILED" at mail.log
Solution
========
As Roland suggested I compiled the original package, but not installed it,
just to get authtest utility. I didn't want to replace Debian packages.
Using both
#/usr/bin/strace -ffrTv -a 128 -s 128 /etc/init.d/courier-authdaemon start
#/usr/bin/strace -ffrTv -a 128 -s 128 <courier_source_path>/authlib/authtest
user password
* found that the sock path it was looking for was
/usr/lib/courier/var/authdaemon, instead of the package's path
/var/run/courier/authdaemon. To fix it:
#mkdir /usr/lib/courier/var
#cd /usr/lib/courier/var
#ln -s /var/run/courier/authdaemon /usr/lib/courier/var/authdaemon
* then found some problems with the connection all related to the same
issue: in config file /etc/courier/authmysqlrc I unvoluntary left trailing
tabs. So traced out messages like "Access denied for user\t@localhost" or
"Cannot find database mail\t",etc. I removed spaces and tabs at the right of
every parameter, and that was all.
Comments
========
In Roland's mail:
>> INSERT INTO aliases VALUES
>>
('testuser','test',101,102,'/var/spool/postfix/virtual/virtual_domain/testus
>> er/','/','test@virtual_domain');
>$HOME of your testuser is set to /.
>This directory belongs to someone else and you really dont
>want to do that anyway.
In my configuration all virtual domains are owned by the same user (uid 101,
gid 102). As Postfix needs a maildir column with the full path and I'm using
the same maildir column for both Postfix and Courier, I think the only
solution is to set $HOME to /. So that $HOME/Maildir can reach the same
target. It works, but maybe is not the cleaner solution B-)
Best Regards and thanks again for your help,
Adrian
==========================
Adrian Caneva
NEXT TECHNOLOGY SRL
La Rioja 26
(T4000ISB) Tucuman
Tel/Fax +54 381 4219105
[EMAIL PROTECTED]
www.nexttech.com.ar
==========================
_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
