[tpop3d-discuss] tpop3 & mysql

[ychsiao\(蕭淵鐘\)]

Hi:
	I used postfix+tpop3+mysql, now I have a problem,.
	I send mail to blah@blah.com, then use aliases method write to file
"/popmail/blah".
	Postfix send is ok, but tpop3 tell me the mailbox "+OK Welcome aboard! You
have no messages at all."

	"/popmail/blah" have I send mail, but tpop3 can't read/list it.

	OS:FreeBSD 4.8
	postfix:2.0.15,
	tpop3:-1.5.2
	mysql:3.23.58

	tpop3d.conf :
	strip-domain:true
	append-domain:true

	mailbox: bsd:/popmail1/$(user)
	auth-mysql-enable:true
	auth-mysql-mail-group: mail
	auth-mysql-hostname: 127.0.0.1
	auth-mysql-database: grad91
	auth-mysql-username: blah
	auth-mysql-password: blahblah
	auth-mysql-pass-query: SELECT CONCAT(popbox,'$(local_part)'),
CONCAT('{md5}', password),'nobody','bsd' FROM grad WHERE uid='$(local_part)'

	Regards,
--
Yuan-Chung Hsiao (ychsiao), B.S. student,
Dept. of Information Management & Computer Center
SHU-TE University, Yanchao, Kaohsiung County, Taiwan 824
TEL:+886-7-6158000 Ext. 2410