[tpop3d-discuss]tpop3d and mysql5

[Barbara Nowak]

Hi,

I try to configure tpop3d with mysql database, but authentication to pop3 
always fails :(

Version:
Tpop3d: 1.5.3
Mysql: 5.0.22


Pop3d and mysql are on others servers.

My config is:

auth-mysql-enable: true
auth-mysql-mail-group: mail
auth-mysql-hostname: mysql.server.com
auth-mysql-database: db
auth-mysql-username: mysql_login
auth-mysql-password: mysql_password
auth-mysql-pass-query:  SELECT CONCAT('/var/spool/mail/SERVERS/','$(domain)','/'
,mbox_name),CONCAT('{plaintext}',password_hash),'mail','maildir' FROM popbox WHE
RE local_part='$(local_part)'
log-facility: mail
append-domain: false

My database:
CREATE TABLE `popbox` (
  `domain_name` varchar(255) NOT NULL default '',
  `local_part` varchar(255) NOT NULL default '',
  `password_hash` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`domain_name`(16),`local_part`(32))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `popbox` (`domain_name`, `local_part`, `password_hash`) VALUES 
('server.com', 'postmaster', 'test');

On client side - pop3 session:
#telnet pop3.server.com 110

+OK <address@hidden>
user postmaster
+OK Tell me your password.
pass test
-ERR Lies! Try again!
quit
+OK Fine. Be that way.

On pop3d server: 
# tpop3d -v -d

parse_listeners: listening on address aa.bb.cc.dd:110
get_mysql_server: now using server mysql.server.com
1 authentication drivers successfully loaded
net_loop: tpop3d version 1.5.3 successfully started
connection_sendresponse: client [1]1.2.3.4/server.com: sent `+OK 
<address@hidden>'
listeners_post_select: client [1]1.2.3.4/server.com: connected to local address 
aa.bb.cc.dd:110
connection_parsecommand: client [1]1.2.3.4/server.com: received `user 
postmaster'
connection_sendresponse: client [1]1.2.3.4/server.com: sent `+OK Tell me your 
password.'
connection_parsecommand: client [1]1.2.3.4/server.com: received `pass [...]'
connection_sendresponse: client [1]1.2.3.4/server.com: sent `-ERR Lies! Try 
again!'
connection_do: client `[1]1.2.3.4/server.com': username `postmaster': 1 
authentication failures
connection_parsecommand: client [1]1.2.3.4/server.com: received `quit'
connection_sendresponse: client [1]1.2.3.4/server.com: sent `+OK Fine. Be that 
way.'
connections_post_select: client [1]1.2.3.4/server.com: disconnected; 34/122 
bytes read/written
net_loop: terminating on signal 2

On mysql server I had only:
060801 13:39:40    3641 Connect     address@hidden on db 
060801 13:41:45    3641 Quit


What I'm doing wrong ?

-- 
Greetings
Barbara