[tpop3d-discuss] auth-mysql-onlogin-query

[Chad Jackson]

Hello,

I have tpop3d up and working, although I have had to make the
auth-mysql-onlogin-query realy simple to allow postfix to handle the
response. I created the ip_access table with the ip field as the primary key
and a field that returns 'OK'. Having the primary key stops multiple records
with the same IP address from being added. I am using the following sql
statement

 insert into ip_access values ('$(clienthost)','OK' )

Prior to this postmap -q ADDRESS mysql:... was returning OK,OK,OK,OK,OK
depending on how often the client was checking for mail.

Although what I have is working I am not happy with the the following entry
in the logs continuosly.

local0.error] auth_mysql_onlogin: mysql_query: Duplicate entry 'ADDRESS' for
key 1

I am looking for info on being more creative with the
auth-mysql-onlogin-query


Any help would be greatly appreciated.

Regards
Chad