Dovecot auth error

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Dovecot auth error

Mathieu R.
I just tried to configure a new dovecot/postfix server, and i end up with a
dovecot auth error at startup.
I can't find a solution by myself.
Below are details, thanks in advance for your precious help, and excuse my
poor english :

dovecot --version
2.2.27 (c0f36b0) (Debian)

Dovecot -n :
https://400iso.net/public/dov.txt


grep -v '^ *\(#.*\)\?$' /etc/dovecot/dovecot-sql.conf
driver = mysql
connect = host=127.0.0.1 dbname=postfix user=postfix password=password
default_pass_scheme = MD5-CRYPT
user_query = SELECT '/srv/vmail/%d/%n' AS home, 3000 AS uid, 3000 AS gid,
CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM mailbox WHERE
username = '%u' AND active='1'
password_query = SELECT password FROM mailbox WHERE username = '%u'


Here is part of the server's log :

Nov  4 20:57:49 vps81550 postfix/postscreen[21578]: CONNECT from
[209.85.215.51]:47485 to [149.56.x.x]:25
Nov  4 20:57:49 vps81550 postfix/dnsblog[21583]: addr 209.85.215.51 listed
by domain dnsbl.sorbs.net as 127.0.0.6
Nov  4 20:57:55 vps81550 postfix/postscreen[21578]: PASS OLD
[209.85.215.51]:47485
Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: connect from
mail-lf0-f51.google.com[209.85.215.51]
Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: Untrusted TLS connection
established from mail-lf0-f51.google.com[209.85.215.51] TLSv1.2 with cipher
ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)
Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
configuration file /etc/dovecot/dovecot-sql.conf.ext
Nov  4 20:57:55 vps81550 dovecot: master: Error: service(auth): command
startup failed, throttling for 2 secs
Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: fatal: no SASL
authentication mechanisms
Nov  4 20:57:56 vps81550 postfix/master[21528]: warning: process
/usr/lib/postfix/sbin/smtpd pid 21585 exit status 1
Nov  4 20:57:56 vps81550 postfix/master[21528]: warning:
/usr/lib/postfix/sbin/smtpd: bad command startup -- throttling
--

Mathieu R.
Reply | Threaded
Open this post in threaded view
|

Re: Dovecot auth error

Aki Tuomi-2


On 05.11.2017 03:02, Mathieu R. wrote:

> I just tried to configure a new dovecot/postfix server, and i end up with a
> dovecot auth error at startup.
> I can't find a solution by myself.
> Below are details, thanks in advance for your precious help, and excuse my
> poor english :
>
> dovecot --version
> 2.2.27 (c0f36b0) (Debian)
>
> Dovecot -n :
> https://400iso.net/public/dov.txt
>
>
> grep -v '^ *\(#.*\)\?$' /etc/dovecot/dovecot-sql.conf
> driver = mysql
> connect = host=127.0.0.1 dbname=postfix user=postfix password=password
> default_pass_scheme = MD5-CRYPT
> user_query = SELECT '/srv/vmail/%d/%n' AS home, 3000 AS uid, 3000 AS gid,
> CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM mailbox WHERE
> username = '%u' AND active='1'
> password_query = SELECT password FROM mailbox WHERE username = '%u'
>
>
> Here is part of the server's log :
>
> Nov  4 20:57:49 vps81550 postfix/postscreen[21578]: CONNECT from
> [209.85.215.51]:47485 to [149.56.x.x]:25
> Nov  4 20:57:49 vps81550 postfix/dnsblog[21583]: addr 209.85.215.51 listed
> by domain dnsbl.sorbs.net as 127.0.0.6
> Nov  4 20:57:55 vps81550 postfix/postscreen[21578]: PASS OLD
> [209.85.215.51]:47485
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: connect from
> mail-lf0-f51.google.com[209.85.215.51]
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: Untrusted TLS connection
> established from mail-lf0-f51.google.com[209.85.215.51] TLSv1.2 with cipher
> ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)
> Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
> configuration file /etc/dovecot/dovecot-sql.conf.ext
> Nov  4 20:57:55 vps81550 dovecot: master: Error: service(auth): command
> startup failed, throttling for 2 secs
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: fatal: no SASL
> authentication mechanisms
> Nov  4 20:57:56 vps81550 postfix/master[21528]: warning: process
> /usr/lib/postfix/sbin/smtpd pid 21585 exit status 1
> Nov  4 20:57:56 vps81550 postfix/master[21528]: warning:
> /usr/lib/postfix/sbin/smtpd: bad command startup -- throttling
This usually means that you have not installed mysql support for
dovecot. In dovecot, it's usually a separate package,
called dovecot-mysql.

Aki
Reply | Threaded
Open this post in threaded view
|

Re: Dovecot auth error

Mathieu R.
In reply to this post by Mathieu R.
Maybe i got no answer because there is an error which seem obvious in my
logs :

Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
configuration file /etc/dovecot/dovecot-sql.conf.ext

I've obviously seen that, and tried to configure driver in that file, but
it had no positive outcome, sous i reversed my config to the previous state.

Considering what i've read, dovecot's MySQL configuration should be OK, but
i still have that fatal error

Le sam. 4 nov. 2017 à 21:02, Mathieu R. <[hidden email]> a écrit :

> I just tried to configure a new dovecot/postfix server, and i end up with
> a dovecot auth error at startup.
> I can't find a solution by myself.
> Below are details, thanks in advance for your precious help, and excuse my
> poor english :
>
> dovecot --version
> 2.2.27 (c0f36b0) (Debian)
>
> Dovecot -n :
> https://400iso.net/public/dov.txt
>
>
> grep -v '^ *\(#.*\)\?$' /etc/dovecot/dovecot-sql.conf
> driver = mysql
> connect = host=127.0.0.1 dbname=postfix user=postfix password=password
> default_pass_scheme = MD5-CRYPT
> user_query = SELECT '/srv/vmail/%d/%n' AS home, 3000 AS uid, 3000 AS gid,
> CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM mailbox WHERE
> username = '%u' AND active='1'
> password_query = SELECT password FROM mailbox WHERE username = '%u'
>
>
> Here is part of the server's log :
>
> Nov  4 20:57:49 vps81550 postfix/postscreen[21578]: CONNECT from
> [209.85.215.51]:47485 to [149.56.x.x]:25
> Nov  4 20:57:49 vps81550 postfix/dnsblog[21583]: addr 209.85.215.51 listed
> by domain dnsbl.sorbs.net as 127.0.0.6
> Nov  4 20:57:55 vps81550 postfix/postscreen[21578]: PASS OLD
> [209.85.215.51]:47485
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: connect from
> mail-lf0-f51.google.com[209.85.215.51]
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: Untrusted TLS connection
> established from mail-lf0-f51.google.com[209.85.215.51] TLSv1.2 with
> cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)
> Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
> configuration file /etc/dovecot/dovecot-sql.conf.ext
> Nov  4 20:57:55 vps81550 dovecot: master: Error: service(auth): command
> startup failed, throttling for 2 secs
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: fatal: no SASL
> authentication mechanisms
> Nov  4 20:57:56 vps81550 postfix/master[21528]: warning: process
> /usr/lib/postfix/sbin/smtpd pid 21585 exit status 1
> Nov  4 20:57:56 vps81550 postfix/master[21528]: warning:
> /usr/lib/postfix/sbin/smtpd: bad command startup -- throttling
> --
>
> Mathieu R.
>
--

Mathieu R.
Reply | Threaded
Open this post in threaded view
|

Re: Dovecot auth error

Aki Tuomi-2
In reply to this post by Mathieu R.
apparently my reply got lost.. have you installed dovecot-mysql package?


---Aki TuomiDovecot oy
-------- Original message --------From: "Mathieu R." <[hidden email]> Date: 07/11/2017  16:18  (GMT+02:00) To: [hidden email] Subject: Re: Dovecot auth error
Maybe i got no answer because there is an error which seem obvious in my
logs :

Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
configuration file /etc/dovecot/dovecot-sql.conf.ext

I've obviously seen that, and tried to configure driver in that file, but
it had no positive outcome, sous i reversed my config to the previous state.

Considering what i've read, dovecot's MySQL configuration should be OK, but
i still have that fatal error

Le sam. 4 nov. 2017 à 21:02, Mathieu R. <[hidden email]> a écrit :

> I just tried to configure a new dovecot/postfix server, and i end up with
> a dovecot auth error at startup.
> I can't find a solution by myself.
> Below are details, thanks in advance for your precious help, and excuse my
> poor english :
>
> dovecot --version
> 2.2.27 (c0f36b0) (Debian)
>
> Dovecot -n :
> https://400iso.net/public/dov.txt
>
>
> grep -v '^ *\(#.*\)\?$' /etc/dovecot/dovecot-sql.conf
> driver = mysql
> connect = host=127.0.0.1 dbname=postfix user=postfix password=password
> default_pass_scheme = MD5-CRYPT
> user_query = SELECT '/srv/vmail/%d/%n' AS home, 3000 AS uid, 3000 AS gid,
> CONCAT('*:bytes=', CAST(quota AS CHAR)) AS quota_rule FROM mailbox WHERE
> username = '%u' AND active='1'
> password_query = SELECT password FROM mailbox WHERE username = '%u'
>
>
> Here is part of the server's log :
>
> Nov  4 20:57:49 vps81550 postfix/postscreen[21578]: CONNECT from
> [209.85.215.51]:47485 to [149.56.x.x]:25
> Nov  4 20:57:49 vps81550 postfix/dnsblog[21583]: addr 209.85.215.51 listed
> by domain dnsbl.sorbs.net as 127.0.0.6
> Nov  4 20:57:55 vps81550 postfix/postscreen[21578]: PASS OLD
> [209.85.215.51]:47485
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: connect from
> mail-lf0-f51.google.com[209.85.215.51]
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: Untrusted TLS connection
> established from mail-lf0-f51.google.com[209.85.215.51] TLSv1.2 with
> cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)
> Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
> configuration file /etc/dovecot/dovecot-sql.conf.ext
> Nov  4 20:57:55 vps81550 dovecot: master: Error: service(auth): command
> startup failed, throttling for 2 secs
> Nov  4 20:57:55 vps81550 postfix/smtpd[21585]: fatal: no SASL
> authentication mechanisms
> Nov  4 20:57:56 vps81550 postfix/master[21528]: warning: process
> /usr/lib/postfix/sbin/smtpd pid 21585 exit status 1
> Nov  4 20:57:56 vps81550 postfix/master[21528]: warning:
> /usr/lib/postfix/sbin/smtpd: bad command startup -- throttling
> --
>
> Mathieu R.
>
--

Mathieu R.
Reply | Threaded
Open this post in threaded view
|

Re: Dovecot auth error

Dave-2
In reply to this post by Mathieu R.
On 07/11/2017 14:18, Mathieu R. wrote:
> Maybe i got no answer because there is an error which seem obvious in my
> logs :
>
> Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
> configuration file /etc/dovecot/dovecot-sql.conf.ext

This might sound silly, but in your doveconf you have:

passdb {
  args = /etc/dovecot/dovecot-sql.conf.ext
  driver = sql
}

Yet from this:

>> grep -v '^ *\(#.*\)\?$' /etc/dovecot/dovecot-sql.conf

It sounds like the config file you're working with is
/etc/dovecot/dovecot-sql.conf, not /etc/dovecot/dovecot-sql.conf.ext.
It's not as simple as a filename problem, is it?

--
David Zambonini
Reply | Threaded
Open this post in threaded view
|

Re: Dovecot auth error

Mathieu R.
It was ! Thank you a lot. It's always small mistake like that which give me
headache...

Le mar. 7 nov. 2017 à 10:20, David Zambonini <[hidden email]> a
écrit :

> On 07/11/2017 14:18, Mathieu R. wrote:
> > Maybe i got no answer because there is an error which seem obvious in my
> > logs :
> >
> > Nov  4 20:57:55 vps81550 dovecot: auth: Fatal: sql: driver not set in
> > configuration file /etc/dovecot/dovecot-sql.conf.ext
>
> This might sound silly, but in your doveconf you have:
>
> passdb {
>   args = /etc/dovecot/dovecot-sql.conf.ext
>   driver = sql
> }
>
> Yet from this:
>
> >> grep -v '^ *\(#.*\)\?$' /etc/dovecot/dovecot-sql.conf
>
> It sounds like the config file you're working with is
> /etc/dovecot/dovecot-sql.conf, not /etc/dovecot/dovecot-sql.conf.ext.
> It's not as simple as a filename problem, is it?
>
> --
> David Zambonini
>
--

Mathieu R.