Still muddling through with broken auth...

[Alexander Dalloz]

Am 03.04.2016 um 01:04 schrieb Jason Pruim:
>
> Jason Pruim
> pruimj at gmail.com
> 352.234.3175
>
>
>> On Apr 2, 2016, at 6:42 PM, Alexander Dalloz <ad+lists at 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 at 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 at 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=<leZR+ocvhwB/AAAB>
>>
>> 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 at 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 = </etc/pki/dovecot/certs/dovecot.pem
> ssl_key = </etc/pki/dovecot/private/dovecot.pem
> ssl_protocols = !SSLv2 !SSLv3
> userdb {
>    args = uid=vmail gid=vmail home=/var/mail/vhosts/%d/%n
>    driver = static
> }
> protocol lmtp {
>    mail_plugins = " sieve"
> }
> protocol lda {
>    mail_plugins = " sieve"
> }
> [ec2-user at ip-172-31-24-2 conf.d]$
>
>
> 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