Still muddling through with broken auth...
Hey Everyone,
I’m still muddling through my first install… Followed the tutorials on workaround.org http://workaround.org/ which were very helpful! but don’t include much info if things don’t work 100%… and so far I haven’t been able to pin down where the error is. When I try: telnet localhost 143 this is what shows up in the maillot:
Apr 2 21:06:57 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 21:06:57 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 2 secs Apr 2 21:06:57 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<+lw34IYvVgB/AAAB>
With the failed driver for the database, I tried mysql and sql both of which produce the same error… I have a few other issues but I think those are related farther upstream… Not being able to sign into round cube for webmail, because of it being unable to connect to the storage container… But I think that’s a round cube issue… I want to get postfix and dovecot playing nicely before I worry too much about things like webmail access…
Here is my postconf -n:
[ec2-user@ip-172-31-24-2 dovecot]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_mailbox_domains = hash:/etc/postfix/virtual_mailbox_domains virtual_mailbox_maps = hash:/etc/postfix/virtual_mailbox_users virtual_transport = dovecot [ec2-user@ip-172-31-24-2 dovecot]$
What else can I provide?
Thanks!
Jason Pruim pruimj@gmail.com 352.234.3175
Sent from my iPhone
On Apr 2, 2016, at 4:11 PM, Jason Pruim pruimj@gmail.com wrote:
Hey Everyone,
I’m still muddling through my first install… Followed the tutorials on workaround.org http://workaround.org/ which were very helpful! but don’t include much info if things don’t work 100%… and so far I haven’t been able to pin down where the error is. When I try: telnet localhost 143 this is what shows up in the maillot:
Apr 2 21:06:57 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 21:06:57 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 2 secs Apr 2 21:06:57 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<+lw34IYvVgB/AAAB>
With the failed driver for the database, I tried mysql and sql both of which produce the same error… I have a few other issues but I think those are related farther upstream… Not being able to sign into round cube for webmail, because of it being unable to connect to the storage container… But I think that’s a round cube issue… I want to get postfix and dovecot playing nicely before I worry too much about things like webmail access…
Here is my postconf -n:
[ec2-user@ip-172-31-24-2 dovecot]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_mailbox_domains = hash:/etc/postfix/virtual_mailbox_domains virtual_mailbox_maps = hash:/etc/postfix/virtual_mailbox_users virtual_transport = dovecot [ec2-user@ip-172-31-24-2 dovecot]$
I don't use postfix, but I'm guessing the above hash:/etc/ should probably be some form of mysql:/etc/...
What else can I provide?
Thanks!
Jason Pruim pruimj@gmail.com 352.234.3175
Hey Edgar,
Thanks for catching that! Missed it earlier! Got it changed but I’m still having the same error updated postconf -n:
[ec2-user@ip-172-31-24-2 conf.d]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot [ec2-user@ip-172-31-24-2 conf.d]$
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql'
Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs
Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
I feel like I’m missing something simple but can’t see the forest through the trees…
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 5:54 PM, Edgar Pettijohn edgar@pettijohn-web.com wrote:
Sent from my iPhone
On Apr 2, 2016, at 4:11 PM, Jason Pruim pruimj@gmail.com wrote:
Hey Everyone,
I’m still muddling through my first install… Followed the tutorials on workaround.org http://workaround.org/ which were very helpful! but don’t include much info if things don’t work 100%… and so far I haven’t been able to pin down where the error is. When I try: telnet localhost 143 this is what shows up in the maillot:
Apr 2 21:06:57 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 21:06:57 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 2 secs Apr 2 21:06:57 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 0 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=<+lw34IYvVgB/AAAB>
With the failed driver for the database, I tried mysql and sql both of which produce the same error… I have a few other issues but I think those are related farther upstream… Not being able to sign into round cube for webmail, because of it being unable to connect to the storage container… But I think that’s a round cube issue… I want to get postfix and dovecot playing nicely before I worry too much about things like webmail access…
Here is my postconf -n:
[ec2-user@ip-172-31-24-2 dovecot]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_mailbox_domains = hash:/etc/postfix/virtual_mailbox_domains virtual_mailbox_maps = hash:/etc/postfix/virtual_mailbox_users virtual_transport = dovecot [ec2-user@ip-172-31-24-2 dovecot]$
I don't use postfix, but I'm guessing the above hash:/etc/ should probably be some form of mysql:/etc/...
What else can I provide?
Thanks!
Jason Pruim pruimj@gmail.com 352.234.3175
Am 03.04.2016 um 00:26 schrieb Jason Pruim:
Hey Edgar,
Thanks for catching that! Missed it earlier! Got it changed but I’m still having the same error updated postconf -n:
Why do you provide the Postfix configuration? Absolutely unrelated to the shown dovecot error.
[ec2-user@ip-172-31-24-2 conf.d]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot [ec2-user@ip-172-31-24-2 conf.d]$
While being at Postfix: You have zero SASL configuration, unless it is defined in master.cf for the submission transport.
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
Please provide the output of "doveconf -n". You have a severe configuration error so that the auth process fails.
I feel like I’m missing something simple but can’t see the forest through the trees…
Jason Pruim pruimj@gmail.com 352.234.3175
Alexander
Sent from my iPhone
On Apr 2, 2016, at 5:42 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 00:26 schrieb Jason Pruim: Hey Edgar,
Thanks for catching that! Missed it earlier! Got it changed but I’m still having the same error updated postconf -n:
Why do you provide the Postfix configuration? Absolutely unrelated to the shown dovecot error.
[ec2-user@ip-172-31-24-2 conf.d]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot [ec2-user@ip-172-31-24-2 conf.d]$
While being at Postfix: You have zero SASL configuration, unless it is defined in master.cf for the submission transport.
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
Please provide the output of "doveconf -n". You have a severe configuration error so that the auth process fails.
I feel like I’m missing something simple but can’t see the forest through the trees…
Jason Pruim pruimj@gmail.com 352.234.3175
Alexander
doveadm-auth may be your friend here.
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 6:42 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 00:26 schrieb Jason Pruim:
Hey Edgar,
Thanks for catching that! Missed it earlier! Got it changed but I’m still having the same error updated postconf -n:
Why do you provide the Postfix configuration? Absolutely unrelated to the shown dovecot error.
I provide what I know how to provide :)
[ec2-user@ip-172-31-24-2 conf.d]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot [ec2-user@ip-172-31-24-2 conf.d]$
While being at Postfix: You have zero SASL configuration, unless it is defined in master.cf for the submission transport.
Lets do 1 problem at a time… Unless SASL is needed for sending email?
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
Please provide the output of "doveconf -n". You have a severe configuration error so that the auth process fails.
Here is the output:
[ec2-user@ip-172-31-24-2 conf.d]$ dovecot -n # 2.2.10: /etc/dovecot/dovecot.conf # OS: Linux 4.1.17-22.30.amzn1.x86_64 x86_64 ext4 auth_mechanisms = plain login mail_location = maildir:/var/vmail/%d/%n/Maildir mbox_write_locks = fcntl namespace inbox { inbox = yes location = prefix = separator = . } passdb { args = /etc/dovecot/dovecot-sql.conf.ext driver = sql } protocols = imap lmtp service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { group = postfix mode = 0600 user = postfix } user = dovecot } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } } ssl = no ssl_cert =
It’s been awhile since I’ve run a mail server, and never to this extent… Always through hosting companies except for about 15 years ago when I did it for fun! :)
Thanks for all your help!
Am 03.04.2016 um 01:04 schrieb Jason Pruim:
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 6:42 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 00:26 schrieb Jason Pruim:
Hey Edgar,
Thanks for catching that! Missed it earlier! Got it changed but I’m still having the same error updated postconf -n:
Why do you provide the Postfix configuration? Absolutely unrelated to the shown dovecot error.
I provide what I know how to provide :)
[ec2-user@ip-172-31-24-2 conf.d]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot [ec2-user@ip-172-31-24-2 conf.d]$
While being at Postfix: You have zero SASL configuration, unless it is defined in master.cf for the submission transport.
Lets do 1 problem at a time… Unless SASL is needed for sending email?
Right, 1 problem at a time.
Yes, SASL is needed for your MTA to permit relaying based on authentication.
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
Please provide the output of "doveconf -n". You have a severe configuration error so that the auth process fails.
Here is the output:
[ec2-user@ip-172-31-24-2 conf.d]$ dovecot -n # 2.2.10: /etc/dovecot/dovecot.conf
Where did you get that dovecot version from? The Postfix version seems to indicate a RHEL/CentOS base of major release 6. That one does not ship a dovecot 2.2.x version.
# OS: Linux 4.1.17-22.30.amzn1.x86_64 x86_64 ext4 auth_mechanisms = plain login mail_location = maildir:/var/vmail/%d/%n/Maildir mbox_write_locks = fcntl namespace inbox { inbox = yes location = prefix = separator = . } passdb { args = /etc/dovecot/dovecot-sql.conf.ext
What specified in the dovecot-sql.conf.ext file? Make sure the driver in there is set as "mysql" and not "sql". Not sure whether your dovecot is packaged in a way that you need a another package to provide the SQL driver functionality.
Btw. there is no need to run any SQL based backend, neither for dovecot nor Postfix, while I see a lot of beginners to think it would be. Keep it simple, even most simple while your are doing your first steps.
driver = sql } protocols = imap lmtp service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { group = postfix mode = 0600 user = postfix } user = dovecot } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } } ssl = no ssl_cert =
It’s been awhile since I’ve run a mail server, and never to this extent… Always through hosting companies except for about 15 years ago when I did it for fun! :)
Thanks for all your help!
Regards
Alexander
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 8:01 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 01:04 schrieb Jason Pruim:
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 6:42 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 00:26 schrieb Jason Pruim:
Hey Edgar,
Thanks for catching that! Missed it earlier! Got it changed but I’m still having the same error updated postconf -n:
Why do you provide the Postfix configuration? Absolutely unrelated to the shown dovecot error.
I provide what I know how to provide :)
[ec2-user@ip-172-31-24-2 conf.d]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot [ec2-user@ip-172-31-24-2 conf.d]$
While being at Postfix: You have zero SASL configuration, unless it is defined in master.cf for the submission transport.
Lets do 1 problem at a time… Unless SASL is needed for sending email?
Right, 1 problem at a time.
Yes, SASL is needed for your MTA to permit relaying based on authentication.
Okay, I’ll look at that as soon as I get my server allowing me to login! :)
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
Please provide the output of "doveconf -n". You have a severe configuration error so that the auth process fails.
Here is the output:
[ec2-user@ip-172-31-24-2 conf.d]$ dovecot -n # 2.2.10: /etc/dovecot/dovecot.conf
Where did you get that dovecot version from? The Postfix version seems to indicate a RHEL/CentOS base of major release 6. That one does not ship a dovecot 2.2.x version.
postfix and dovecot were both downloaded from a simple: yum install postfix dovecot command on my amazon linux server
# OS: Linux 4.1.17-22.30.amzn1.x86_64 x86_64 ext4 auth_mechanisms = plain login mail_location = maildir:/var/vmail/%d/%n/Maildir mbox_write_locks = fcntl namespace inbox { inbox = yes location = prefix = separator = . } passdb { args = /etc/dovecot/dovecot-sql.conf.ext
What specified in the dovecot-sql.conf.ext file? Make sure the driver in there is set as "mysql" and not "sql". Not sure whether your dovecot is packaged in a way that you need a another package to provide the SQL driver functionality.
driver = mysql connect = host=127.0.0.1 dbname=mailserver user=validsqluser password=validsqlpassword
default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM virtual_users WHERE email='%u’;
Btw. there is no need to run any SQL based backend, neither for dovecot nor Postfix, while I see a lot of beginners to think it would be. Keep it simple, even most simple while your are doing your first steps.
The tutorial I found on workaround.org had it hooking up to sql so with me trying to learn more about all of linux, I thought why the heck not? :) For hosting multiple domains would it make a difference? I’m planning on hosting 2 from here for starters.
driver = sql } protocols = imap lmtp service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { group = postfix mode = 0600 user = postfix } user = dovecot } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } } ssl = no ssl_cert =
It’s been awhile since I’ve run a mail server, and never to this extent… Always through hosting companies except for about 15 years ago when I did it for fun! :)
Thanks for all your help!
Regards
Alexander
Thanks Alexander!
Sent from my iPhone
On Apr 2, 2016, at 7:07 PM, Jason Pruim pruimj@gmail.com wrote:
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 8:01 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 01:04 schrieb Jason Pruim:
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 6:42 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 00:26 schrieb Jason Pruim:
Hey Edgar,
Thanks for catching that! Missed it earlier! Got it changed but I’m still having the same error updated postconf -n:
Why do you provide the Postfix configuration? Absolutely unrelated to the shown dovecot error.
I provide what I know how to provide :)
[ec2-user@ip-172-31-24-2 conf.d]$ postconf -n alias_database = hash:/etc/aliases alias_maps = hash:/etc/aliases command_directory = /usr/sbin config_directory = /etc/postfix daemon_directory = /usr/libexec/postfix data_directory = /var/lib/postfix debug_peer_level = 2 html_directory = no inet_interfaces = localhost inet_protocols = all mail_owner = postfix mailq_path = /usr/bin/mailq.postfix manpage_directory = /usr/share/man mydestination = $myhostname, localhost.$mydomain, localhost newaliases_path = /usr/bin/newaliases.postfix queue_directory = /var/spool/postfix readme_directory = /usr/share/doc/postfix-2.6.6/README_FILES sample_directory = /usr/share/doc/postfix-2.6.6/samples sendmail_path = /usr/sbin/sendmail.postfix setgid_group = postdrop unknown_local_recipient_reject_code = 550 virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf virtual_transport = dovecot [ec2-user@ip-172-31-24-2 conf.d]$
While being at Postfix: You have zero SASL configuration, unless it is defined in master.cf for the submission transport.
Lets do 1 problem at a time… Unless SASL is needed for sending email?
Right, 1 problem at a time.
Yes, SASL is needed for your MTA to permit relaying based on authentication.
Okay, I’ll look at that as soon as I get my server allowing me to login! :)
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
Please provide the output of "doveconf -n". You have a severe configuration error so that the auth process fails.
Here is the output:
[ec2-user@ip-172-31-24-2 conf.d]$ dovecot -n # 2.2.10: /etc/dovecot/dovecot.conf
Where did you get that dovecot version from? The Postfix version seems to indicate a RHEL/CentOS base of major release 6. That one does not ship a dovecot 2.2.x version.
postfix and dovecot were both downloaded from a simple: yum install postfix dovecot command on my amazon linux server
# OS: Linux 4.1.17-22.30.amzn1.x86_64 x86_64 ext4 auth_mechanisms = plain login mail_location = maildir:/var/vmail/%d/%n/Maildir mbox_write_locks = fcntl namespace inbox { inbox = yes location = prefix = separator = . } passdb { args = /etc/dovecot/dovecot-sql.conf.ext
What specified in the dovecot-sql.conf.ext file? Make sure the driver in there is set as "mysql" and not "sql". Not sure whether your dovecot is packaged in a way that you need a another package to provide the SQL driver functionality.
driver = mysql connect = host=127.0.0.1 dbname=mailserver user=validsqluser password=validsqlpassword
default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM virtual_users WHERE email='%u’;
Btw. there is no need to run any SQL based backend, neither for dovecot nor Postfix, while I see a lot of beginners to think it would be. Keep it simple, even most simple while your are doing your first steps.
The tutorial I found on workaround.org had it hooking up to sql so with me trying to learn more about all of linux, I thought why the heck not? :) For hosting multiple domains would it make a difference? I’m planning on hosting 2 from here for starters.
driver = sql } protocols = imap lmtp service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { group = postfix mode = 0600 user = postfix } user = dovecot } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } } ssl = no ssl_cert =
It’s been awhile since I’ve run a mail server, and never to this extent… Always through hosting companies except for about 15 years ago when I did it for fun! :)
Thanks for all your help!
Regards
Alexander
Thanks Alexander!
Make sure MySQL is running and configured correctly as well.
driver = sql } protocols = imap lmtp service auth { unix_listener /var/spool/postfix/private/auth { group = postfix mode = 0660 user = postfix } unix_listener auth-userdb { group = postfix mode = 0600 user = postfix } user = dovecot } service imap-login { inet_listener imap { port = 143 } inet_listener imaps { port = 993 } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0600 user = postfix } } ssl = no ssl_cert =
It’s been awhile since I’ve run a mail server, and never to this extent… Always through hosting companies except for about 15 years ago when I did it for fun! :)
Thanks for all your help!
Regards
Alexander
Thanks Alexander!
Make sure MySQL is running and configured correctly as well.
Logged in as the same user and was able to run the 3 sql commands that are in the config files…. Best as I can tell it’s up and running properly.
Am 03.04.2016 um 02:07 schrieb Jason Pruim:
Jason Pruim pruimj@gmail.com 352.234.3175
Please answer just to the mailing list and omit to copy your replies to my personal address too. Thanks.
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
rpm -qlv dovecot | grep libdovecot-sql
That should print out something like
lrwxrwxrwx 1 root root 23 Apr 1 03:29 /usr/lib64/dovecot/libdovecot-sql.so.0 -> libdovecot-sql.so.0.0.0 -rwxr-xr-x 1 root root 95058 Apr 1 03:29 /usr/lib64/dovecot/libdovecot-sql.so.0.0.0
If no libdovecot-sql.so is included, then SQL support is missing in that dovecot package.
Alexander
Jason Pruim pruimj@gmail.com 352.234.3175
On Apr 2, 2016, at 9:06 PM, Alexander Dalloz ad+lists@uni-x.org wrote:
Am 03.04.2016 um 02:07 schrieb Jason Pruim:
Jason Pruim pruimj@gmail.com 352.234.3175
Please answer just to the mailing list and omit to copy your replies to my personal address too. Thanks.
My apologies, I had been hitting reply all.
Here is the same error:
Apr 2 22:25:50 ip-172-31-24-2 dovecot: auth: Fatal: Unknown database driver 'sql' Apr 2 22:25:50 ip-172-31-24-2 dovecot: master: Error: service(auth): command startup failed, throttling for 60 secs Apr 2 22:25:50 ip-172-31-24-2 dovecot: imap-login: Disconnected: Auth process broken (disconnected before auth was ready, waited 9 secs): user=<>, rip=127.0.0.1, lip=127.0.0.1, secured, session=
rpm -qlv dovecot | grep libdovecot-sql
That should print out something like
lrwxrwxrwx 1 root root 23 Apr 1 03:29 /usr/lib64/dovecot/libdovecot-sql.so.0 -> libdovecot-sql.so.0.0.0 -rwxr-xr-x 1 root root 95058 Apr 1 03:29 /usr/lib64/dovecot/libdovecot-sql.so.0.0.0
If no libdovecot-sql.so is included, then SQL support is missing in that dovecot package.
Alexander
I started going back over the same tutorial and reran the commands including this one: postconf -e virtual_alias_maps=mysql:/etc/postfix/mysql-virtual-alias-maps.cf,mysql:/etc/postfix/mysql-email2email.cf and as soon as that one hit I was able to login! Now I just need to get it accepting email and sending email!
Thank you for your help and for putting up with my lack of knowledge!
participants (3)
-
Alexander Dalloz
-
Edgar Pettijohn
-
Jason Pruim