[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[tpop3d-discuss]tpop3d and mysql5
From: |
Barbara Nowak |
Subject: |
[tpop3d-discuss]tpop3d and mysql5 |
Date: |
Tue, 1 Aug 2006 12:34:02 +0000 (GMT) |
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
- [tpop3d-discuss]tpop3d and mysql5,
Barbara Nowak <=