[Dovecot] dovecot last logged in via sql

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


hello,
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 = 
'%u'

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

thanks!


More information about the dovecot mailing list