Hi all, I'm trying to link in my "online" community of users, via mysql, with my mailserver.
I have dovecot 1.0.7.
I am using mysql to authenticate, and I'm trying to figure out what I should be doing to my sql query that checks the username which has a username field and a database field. everything works, as long as the username is "u%@d%" in the field, but to work with my other web application, the username is in one field, and the database is in another. can anyone make a suggestion as to how i can do the user_query to work this way? (both with dovecot and the postfix)
any help would be greatly appreciated!
dovecot: connect = host=localhost dbname=pplsnet user=xxxx password=xxxxxxx password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 150 AS uid, 12 AS gid, concat('dirsize:storage=',quota) AS quota FROM mailbox WHERE username ='%u' AND active ='1'
postfix: user = mail password = xxxx hosts = localhost dbname = mail table = mailbox select_field = CONCAT(domain,'/',maildir) where_field = username additional_conditions = and active = '1'