Jason Pruim pruimj at gmail.com 352.234.3175> On Apr 2, 2016, at 8:01 PM, Alexander Dalloz <ad+lists at uni-x.org> wrote: > > 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.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=<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.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 = </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 > > AlexanderThanks Alexander!
Sent from my iPhone> On Apr 2, 2016, at 7:07 PM, Jason Pruim <pruimj at gmail.com> wrote: > > > Jason Pruim > pruimj at gmail.com > 352.234.3175 > > >> On Apr 2, 2016, at 8:01 PM, Alexander Dalloz <ad+lists at uni-x.org> wrote: >> >> 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. > > 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=<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. > > 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 = </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 > > > 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 = </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 >> >> >> 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 at gmail.com > 352.234.3175Please 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=<leZR+ocvhwB/AAAB>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 at gmail.com 352.234.3175> On Apr 2, 2016, at 9:06 PM, Alexander Dalloz <ad+lists at uni-x.org> wrote: > > Am 03.04.2016 um 02:07 schrieb Jason Pruim: >> >> Jason Pruim >> pruimj at 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=<leZR+ocvhwB/AAAB> > > 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. > > AlexanderI 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!