Hello,
We are installing DBmail 2,2,5 on freebsd 6,2 with postfix, mysql 5,0,41
(external server), dspam, clamav and sasl2 (rimap).
Receiving of e-mail works.
We are stuck with the problem that users cannot authenticate, using both
IMAP and POP3.
Logfile:
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Info:[serverchild]
serverchild.c,select_and_accept(+252): received connection
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Info:[serverchild]
serverchild.c,select_and_accept(+275): connection accepted
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Message:[serverchild]
serverchild.c,PerformChildTask(+341): incoming connection from
[192.168.0.156] by pid [18107]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[serverchild]
serverchild.c,PerformChildTask(+366): client info init complete, calling
client handler
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[misc]
misc.c,create_unique_id(+111): created: 2027175ff682fb0607ec4a0dc14e2720
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[pop3]
pop3.c,pop3(+295): incoming buffer: [USER sander]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[pop3]
pop3.c,pop3(+309): command issued :cmd [USER], value [sander]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[pop3]
pop3.c,pop3(+321): command looked up as commandtype 1
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[pop3]
pop3.c,pop3(+295): incoming buffer: [PASS 3]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[pop3]
pop3.c,pop3(+309): command issued :cmd [PASS], value [3]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[pop3]
pop3.c,pop3(+321): command looked up as commandtype 2
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[db]
db.c,db_usermap_resolve(+4536): checking userid [sander] in usermap
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[db]
db.c,db_usermap_resolve(+4547): client on inet socket
[inet:192.168.0.188:110]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT login, sock_allow, sock_deny,
userid FROM dbmail_usermap WHERE login in ('sander','ANY') ORDER BY
sock_allow, so
ck_deny]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[db]
db.c,db_usermap_resolve(+4573): login [sander] not found in usermap
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT user_idnr FROM dbmail_users
WHERE lower(userid) = lower('sander')]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT user_idnr, passwd,
encryption_type FROM dbmail_users WHERE user_idnr = 4]
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Error:[pop3]
pop3.c,pop3(+397): user [sander] coming from [192.168.0.156] tried to
login with wrong password
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[pop3]
pop3.c,pop3_error(+253): an invalid command was issued
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Error:[pop3]
pop3.c,pop3_handle_connection(+212): error, incomplete session
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Debug:[serverchild]
serverchild.c,PerformChildTask(+371): client handling complete, closing
streams
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Info:[serverchild]
serverchild.c,PerformChildTask(+373): connection closed
Jul 10 15:57:56 002MS1 dbmail/pop3d[18107]: Info:[serverchild]
serverchild.c,select_and_accept(+223): waiting for connection
Also it is not possible to change user passwords using the dbmail-users
utility. There is no error but there is nothing changed. Changing the
username works. Changing the encryption type doens't help.
Screenoutput:
# dbmail-users -c sander -p plaintext 3
Performing changes for user [sander]...
Done
Logfile:
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[db]
dbmodule.c,db_load_driver(+53): no value for library_directory, using
default [/usr/local/lib/dbmail]
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[db]
dbmodule.c,db_load_driver(+69): looking for mysql as
/usr/local/lib/dbmail/libmysql.so
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[sql]
dbmysql.c,db_query(+290): query [SET NAMES latin1]
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[sql]
dbmysql.c,db_query(+290): query [SHOW VARIABLES LIKE 'collation_%']
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[sql]
dbmysql.c,db_mysql_check_collations(+120): does
[collation_database:latin1_swedish_ci] match
[collation_connection:latin1_swedish_ci]?
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[auth]
authmodule.c,auth_load_driver(+48): no value for library_directory,
using default [/usr/local/lib/dbmail]
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[auth]
authmodule.c,auth_load_driver(+64): looking for auth_sql as
/usr/local/lib/dbmail/libauth_sql.so
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT user_idnr FROM dbmail_users
WHERE lower(userid) = lower('sander')]
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT client_idnr FROM dbmail_users
WHERE user_idnr = 4]
Jul 10 15:55:05 002MS1 dbmail/user[18211]: Debug:[sql]
dbmysql.c,db_query(+290): query [SELECT alias FROM dbmail_aliases WHERE
deliver_to = 4 ORDER BY alias DESC]
I hope you can help me, i really don't no where to look anymore.
Best regards,
Sander van Rijn
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
