hi,

I am using Horde 3.0.5 / IMP -h3-4.0.4 to host a webmail server with MySQL Authentication. As MySQL is a container which hosts all the data, so I would like the IMAP server, Dovecot to use MySQL to run through the authentication so that no more authentication is needed.

and I found that in the dovecot.conf, I can configure the authenticate method by MySQL, which is like this:

auth userdb = mysql /etc/dovecot/dovecot-mysql.conf
auth passdb = mysql /etc/dovecot/dovecot-mysql.conf

though the file of dovecot-mysql. However, I don't know how to set the last two command:

password_query = SELECT password FROM users WHERE userid = '%u'
user_query = SELECT home, uid, gid FROM users WHERE userid = '%u'

Can I use the attributes in Horde SQL config to modify to

password_query = SELECT user_pass FROM horde_users WHERE user_uid = '%u'

How about the user database? how to do this ? I am exhausted of setting about this, please give me a hand!