[tpop3d-discuss] Help with a mysql query.

[Leon Botes]

Here's what i am trying to do:

Mysql database name = exim
Mysql database username = root
Mysql database password = (empty)

I have a table (locals) in the databse with the following fields:
dom ( the local domain name for the user)
user ( the local part a user would sent USER =   PASS = in a POP3 session )
passwd (the plain text password for the user)
mbox_type (essentially always bsd)

All mail gets delivered to /var/mail/(local_part)
I dont want to have subdirectories of domains if possible.

the conf file is now as such:

listen-address: 192.168.254.10
max-children: 20
strip-domain: yes
auth-mysql-enable: yes
auth-mysql-mail-group: mail
auth-mysql-hostname: localhost
auth-mysql-database: exim
auth-mysql-username: root
auth-mysql-password:
auth-mysql-pass-query: SELECT CONCAT('/var/mail/', 'S(local_part)'),
CONCAT('{plaintext}, passwd'), \
                                'user', 'mbox_type' FROM locals WHERE user =
'$(local_part)'

but the debug gives me:

TCP Wrappers support enabled, using daemon name `tpop3d'
listening on address 192.168.254.10, port 110, domain trusc.office
1 authentication drivers successfully loaded
net_loop: tpop3d version 1.4.2 successfully started
connection_sendresponse: client [6]192.168.254.10/trusc.office: sent `+OK
<c5018cf5d664f7994f371bb4efedb93c@trusc.office>'
listeners_post_select: client [6]192.168.254.10/trusc.office: connected
connection_parsecommand: client [6]192.168.254.10/trusc.office: received
`user test1'
connection_sendresponse: client [6]192.168.254.10/trusc.office: sent `+OK
Tell me your password.'
connection_parsecommand: client [6]192.168.254.10/trusc.office: received
`pass [...]'
connection_sendresponse: client [6]192.168.254.10/trusc.office: sent `-ERR
Lies! Try again!'
connection_do: client `[6]192.168.254.10/trusc.office': username `test1': 1
authentication failures

I dont know if this syntax is correct, or if it is something to do with
domains.
If possible i would not like to use domains at any stage of the process.

Please can someone assist.
Thanks in advance.