[tpop3d-discuss] problem with mysql (no query)

[Salim Gasmi]

Hello, All

We use here tpop3d for years now and are happy with it.

We are trying to switch to a mysql database for authentication.

I have recompiled tpop3d succesfully with mysql support.

When I run tpop3d, it connects succesfully to the database (seen in mysql logs)
but when we try to authenticate, no query is sent to the mysql server (no 
query seen in the mysql log)
and of course the authentication fails.

Here follow somes informations:

The tpop3d.conf file :

------------------------
listen-address: 0.0.0.0:110
timeout-seconds: 600
max-children: 40
mailbox: maildir:$(home)
auth-mysql-enable: yes
auth-mysql-mail-group: mail
auth-mysql-hostname: XXXXXXXX (hidden)
auth-mysql-database: XXXXXXXX (hidden)
auth-mysql-username: XXXXXXXX (hidden)
auth-mysql-password: XXXXXXXX (hidden)
auth-mysql-pass-query: SELECT 
home,CONCAT('{crypt_md5}',cpass),uid,'maildir' FROM auth WHERE 
user='$(local_part)';
auth-mysql-apop-query: none
auth-mysql-onlogin-query: none
log-facility: local0
----------------------------------

The debug output of tpop3d:
----------------------------------
/tpop3d -d -vvv
listening on address XX.XX.XX.XX port 110, domain sdv.fr
1 authentication drivers successfully loaded
net_loop: tpop3d version 1.5.3 successfully started
connection_sendresponse: client [6]212.95.65.16/sdv.fr: sent `+OK 
<e9e913d6e146abb094c4913e8f0d8108@sdv.fr>'
listeners_post_select: client [6]212.95.65.16/sdv.fr: connected
connection_parsecommand: client [6]212.95.65.16/sdv.fr: received `user 
testuser'
connection_sendresponse: client [6]212.95.65.16/sdv.fr: sent `+OK Tell me 
your password.'
connection_parsecommand: client [6]212.95.65.16/sdv.fr: received `pass [...]'
connection_sendresponse: client [6]212.95.65.16/sdv.fr: sent `-ERR Lies! 
Try again!'
connection_do: client `[6]212.95.65.16/sdv.fr': username `testuser': 1 
authentication failures
connection_parsecommand: client [6]212.95.65.16/sdv.fr: received `quit'
connection_sendresponse: client [6]212.95.65.16/sdv.fr: sent `+OK Fine. Be 
that way.'
connections_post_select: client [6]212.95.65.16/sdv.fr: disconnected; 
29/122 bytes read/written
----------------------------------

The Log of mysql
----------------------------------
040114 10:17:55     163 Connect     mail@XX.XX.XX.XX on
040114 10:18:09     163 Quit

We use Mysql 4.0.16
Tryed with tpop3d 1.5.3 and 1.4.2

Any clue/idea why tpop3d does not send any query to mysql ?

Best regards,

Salim Gasmi


-------------------------------------------------------------
Salim Gasmi
Directeur technique - Sdv Plurimedia - <http://www.sdv.fr>
-------------------------------------------------------------