[Dovecot] State of MySQL authentication

[Timo Sirainen]

On Fri, 2004-01-23 at 14:48, Ian Armstrong  wrote:
> I am looking for a pop3 server that can authenticate via MySQL. It also
> needs to be able to do a POST_LOGIN_QUERY. I want to be able to update a
> "date" field in the database, so that I can see which accounts are active,
> and which are not.
> 
> Please let me know more about Dovecot and MySQL.

There's MySQL patch for Dovecot somewhere in this list's archives. It
will be included in next release.

Dovecot will ask two queries from SQL server. First is "select
password", second is for asking all kind of user information. I think
you should be able to use ';' separator there to separate the actual
query and your post-login-query. Something like:

user_query = SELECT home, uid, gid FROM users WHERE userid = '%u';update table set foo = 'bar' where userid = '%u'

If it doesn't work, I guess adding support for post-login-query would be useful.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20040130/ee09f7ee/attachment.pgp