[Dovecot] dovecot last logged in via sql

Daniel Petre daniel.petre at pitesti.rcs-rds.ro
Mon Jul 5 11:46:53 EEST 2010

i am currently matching users via sql database with:

password_query = SELECT clear as password FROM users,domains WHERE 
users.username = '%u' \
AND users.enabled = '1' AND (users.type='local' OR users.type='piped') 
and domains.enabled='1' \
 and domains.domain_id = users.domain_id

user_query = SELECT pop as home, uid, gid FROM users WHERE username = 

is there any way i can also insert into database when users successfully 
logged in?


More information about the dovecot mailing list