[courier-users] authmysql + esmtp

Hello everybody,

I'm trying to switch my courier-(esmtpd+pop+imap) server
from authuserdb to authmysql.
I'm using sarge packages (I know many people here don't
like them, but that's the way things are, sorry).

Authmysql seems to work correctly, because I can login into
accounts defined only in the MySQL backend database.
However those accounts never get mail messages delivered
to them: despite the logs say "success: Message delivered"
the Maildir directory never sees a new file coming in.

Here is my authmysqlrc (without sensitive informations):

------ authmysqlrc --------
MYSQL_SERVER localhost
MYSQL_USERNAME <username>
MYSQL_PASSWORD <pwd>
MYSQL_PORT 3306
MYSQL_OPT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
MYSQL_UID_FIELD uid
MYSQL_GID_FIELD gid
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD home
MYSQL_NAME_FIELD name
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/Maildir')
------ End of authmysqlrc --------

And here is the user row in the database:
# mysql
use mail
SELECT * FROM users;
+---------------------+---------------+------------+------+------+------+-------------+
| email | password | quota | uid | gid | name | home |
+---------------------+---------------+------------+------+------+------+-------------+
| prova@domain.com | ddoVWgUx5K2As | 2147483647 | 1004 | 1004 | NULL | /home/posta |
+---------------------+---------------+------------+------+------+------+-------------+
1 row in set (0.00 sec)

The user's Maildir is:

# ls -lR /home/posta/domain.com/prova/
totale 4
drwx------ 5 posta posta 4096 2006-12-06 10:03 Maildir

/home/posta/domain.com/prova/Maildir:
total 12
drwx------ 2 posta root 4096 2006-12-06 10:03 cur
drwx------ 2 posta root 4096 2006-12-06 10:03 new
drwx------ 2 posta root 4096 2006-12-06 10:03 tmp
[cut...]

Finally:
# id posta
uid=1004(posta) gid=1004(posta) groups=1004(posta)

What's wrong? Shouldn't courier be logging an error if
it isn't able to delivery the message for any reason?

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?p...rge&CID=DEVDEV
_______________________________________________
courier-users mailing list
courier-users@lists.sourceforge.net
Unsubscribe: https://lists.sourceforge.net/lists/.../courier-users