Hello All
My system is
Code:
Red Hat Enterprise Linux Server release 5 (Tikanga)
We use courier mail server for pop3 mailboxes, and postfix for in/out mail delivery
Code:
tcp 0 0 :::110 :::* LISTEN 5268/couriertcpd
Now Pop3 users, could not authenticate with there username/pass
It does not work now, and I have this message in my log file
Code:
authdaemond: SQL query: SELECT username, password, "", uid, gid, home, maildir, quota, name, "" FROM mailbox WHERE username = "test@test.org.il"
Apr 6 23:05:01 lgw pop3d: LOGIN FAILED, user=test, ip=[::ffff:127.0.0.1]
I could see in my postfix.main
Code:
mysql-virtual_transports_dbname = mail
mysql-virtual_mailbox_limit_maps_dbname = mail
mysql-virtual_forwardings_dbname = mail
mysql-virtual_email2email_dbname = mail
mysql-virtual_domains_dbname = mail
virtualmailboxs_password = pass
mysql-virtual_transports_password = pass
mysql-virtual_mailbox_limit_maps_password = pass
mysql-virtual_forwardings_password = pass
mysql-virtual_email2email_password = pass
mysql-virtual_domains_password = pass
and I could successful run query from mysql
Code:
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7787 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mail
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT username, password, "", uid, gid, home, maildir, quota, name, "" FROM mailbox WHERE username = "test@test.org.il"
-> ;
+----------------------+------------------+--+------+------+-------------+-----------------------+-------+-------+--+
| username | password | | uid | gid | home | maildir | quota | name | |
+----------------------+------------------+--+------+------+-------------+-----------------------+-------+-------+--+
| test@test.org.il | 773359240eb9a1d9 | | 5000 | 5000 | /home/vmail | test@test.org.il/ | 0 | test | |
+----------------------+------------------+--+------+------+-------------+-----------------------+-------+-------+--+
1 row in set (0.00 sec)
I tried to change the password for this user, insert new user to the same tables, but no success to authenticate
I suppose that the problem is authentication of courier mail demon (which in my mind ) should work with mysql 'mail' database in the way is postfix work
Code:
virtualmailboxs_password = pass
virtualmailboxs_dbname = mail
,
I could not find any reference with courir demon to mysql database username,password to authenticate users..
So, my quetions is, if it's possible to tracert mysql db to find out if courier demon 'asking' for authentication, or is there any error with this, and which configuration file should be checked, in order to find out what authentication method is courier mail demon use for
Any input greatly eppreciated
P.S
This is not a new installation, the system has been working good one days ago