[Dovecot] question about mysql authentication
Hi list,
i use dovecot-1.0-1.2.rc15.el5 installed from rpm centos 5.0
I cant get mysql authetication working: this is my /etc/dove-mysql.conf
######dove-mysql.conf should look like this########## #db_host = 127.0.0.1 #db_port = 3306 db = postfix db_user = postfix db_passwd = secret db_client_flags = 0 default_pass_scheme = PLAIN 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' ####################ends here####################
When I use this conffile:
##############dovecot configured to work with virtual users############ base_dir = /var/run/dovecot/ protocols = imap pop3 imaps pop3s login_dir = /var/run/dovecot-login default_mail_env = mbox:/var/vmail/%d/%n log_timestamp = "%Y-%m-%d %H:%M:%S " log_path = /var/log/maillog mail_extra_groups = mail first_valid_uid = 150 last_valid_uid = 150 maildir_copy_with_hardlinks = yes auth = mysql_auth auth_userdb = mysql /etc/dovecot-mysql.conf auth_passdb = mysql /etc/dovecot-mysql.conf ####################################ends here######################
i get this error:
Error in configuration file /etc/dovecot.conf line 13: Unknown setting: userdb
When I use this: ##############dovecot configured to work with virtual users############ base_dir = /var/run/dovecot/ protocols = imap pop3 imaps pop3s login_dir = /var/run/dovecot-login default_mail_env = mbox:/var/vmail/%d/%n log_timestamp = "%Y-%m-%d %H:%M:%S " log_path = /var/log/maillog mail_extra_groups = mail first_valid_uid = 150 last_valid_uid = 150 maildir_copy_with_hardlinks = yes auth = mysql_auth passdb sql { args = /etc/dovecot-mysql.conf } userdb sql { args = /etc/dovecot-mysql.conf } ####################################ends here######################
i get the following error:
Starting Dovecot Imap: Error: Error in configuration file /etc/dovecot.conf line 13: Unknown section type
What is the correct syntax?
Thank you
On Wed, 2008-01-16 at 16:02 +0100, Chantal Rosmuller wrote:
When I use this:
Starting from dovecot-example.conf would have worked better than trying to modify 0.99 configuration to work with v1.0.
auth = mysql_auth
Replace with:
auth default {
passdb sql { args = /etc/dovecot-mysql.conf } userdb sql {
There's an extra space, probably doesn't matter, maybe does.
args = /etc/dovecot-mysql.conf } }
On Wednesday 16 January 2008 17:32:33 you wrote:
On Wed, 2008-01-16 at 16:02 +0100, Chantal Rosmuller wrote:
When I use this:
Starting from dovecot-example.conf would have worked better than trying to modify 0.99 configuration to work with v1.0.
actually I got the configuration from a howto, maybe I should have looked at the example instead :)
auth = mysql_auth
Replace with:
auth default {
passdb sql { args = /etc/dovecot-mysql.conf } userdb sql {
There's an extra space, probably doesn't matter, maybe does.
args = /etc/dovecot-mysql.conf }
}
Thanks! That works!
However now I get an error in the logfiles: auth(default): Error in configuration file /etc/dovecot-mysql.conf line 4: Unknown setting: db Is there something wrong with my mysql configuration as well?
######dove-mysql.conf should look like this########## db_host = 127.0.0.1 db_port = 3306 db = postfix db_user = postfix db_passwd = secret db_client_flags = 0 default_pass_scheme = PLAIN 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' ####################ends here####################
On Wed, 2008-01-16 at 18:33 +0100, Chantal Rosmuller wrote:
On Wednesday 16 January 2008 17:32:33 you wrote:
On Wed, 2008-01-16 at 16:02 +0100, Chantal Rosmuller wrote:
When I use this:
Starting from dovecot-example.conf would have worked better than trying to modify 0.99 configuration to work with v1.0.
actually I got the configuration from a howto, maybe I should have looked at the example instead :)
Yes, from a HOWTO written for v0.99..
However now I get an error in the logfiles: auth(default): Error in configuration file /etc/dovecot-mysql.conf line 4: Unknown setting: db Is there something wrong with my mysql configuration as well?
Yes, you have it also in 0.99 format. See the dovecot-sql-example.conf included with v1.0 (sources at least) for how it's configured nowadays.
On Wednesday 16 January 2008 18:39:56 Timo Sirainen wrote:
On Wed, 2008-01-16 at 18:33 +0100, Chantal Rosmuller wrote:
On Wednesday 16 January 2008 17:32:33 you wrote:
On Wed, 2008-01-16 at 16:02 +0100, Chantal Rosmuller wrote:
When I use this:
Starting from dovecot-example.conf would have worked better than trying to modify 0.99 configuration to work with v1.0.
actually I got the configuration from a howto, maybe I should have looked at the example instead :)
Yes, from a HOWTO written for v0.99..
However now I get an error in the logfiles: auth(default): Error in configuration file /etc/dovecot-mysql.conf line 4: Unknown setting: db Is there something wrong with my mysql configuration as well?
Yes, you have it also in 0.99 format. See the dovecot-sql-example.conf included with v1.0 (sources at least) for how it's configured nowadays.
Thanks a lot! It works now.
participants (3)
-
Chantal Rosmuller
-
Charles Marcus
-
Timo Sirainen