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
|
+---------------------+---------------+------------+------+------+------+-------------+
| [EMAIL PROTECTED] | 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?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
courier-users mailing list
[email protected]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
