Dovecot Postfix MySQL Authentication Issues

[Gerard E. Seibert]

On Sun, 29 Dec 2019 07:58:23 -0500, jason hirsh stated:
>I am I a situation where I have to wipe my remote server and
>reinstall, Its been a while since I built a server and I am not as
>sharp as I use to be I am running FreeBSD 12.1. well at least the
>server is... I am getting constant authentication errors like
>
>
>Dec 28 22:10:18 triggerfish dovecot[21809]: imap-login: Aborted login
>(auth failed, 1 attempts in 6 secs): user=<jason at example.com>,
>method=PLAIN, rip=73.150.178.106, lip=x.x.x.x, TLS,
>session=<QFSvEM+aA8lJlrJq> Dec 28 22:10:19 triggerfish dovecot[21809]:
>imap-login: Aborted login (client didn't finish SASL auth, waited 4
>secs): user=<>, method=LOGIN, rip=73.150.178.106, lip=x.x.x.x, TLS,
>session=<FNjXEM+aBMlJlrJq> Dec 28 22:10:19 triggerfish dovecot[21809]:
>imap-login: Disconnected (no auth attempts in 0 secs): user=<>,
>rip=73.150.178.106, lip=x,x,x,x, TLS: Connection closed,
>session=<pNccEc+aBslJlrJq> Dec 28 22:10:24 triggerfish dovecot[21809]:
>imap-login: Aborted login (auth failed, 1 attempts in 6 secs):
>user=<jason at example.com>, method=LOGIN, rip=73.150.178.106,
>lip=x,x,x,x, TLS, session=<hukLEc+aBclJlrJq>
>
>
>results of postconf -n are
>
>broken_sasl_auth_clients = yes
>command_directory = /usr/local/sbin
>compatibility_level = 2
>daemon_directory = /usr/local/libexec/postfix
>data_directory = /var/db/postfix
>debug_peer_level = 2
>debugger_command = PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
>ddd $daemon_directory/$process_name $process_id & sleep 5
>dovecot_destination_recipient_limit = 1 html_directory =
>/usr/local/share/doc/postfix inet_protocols = ipv4
>mail_owner = postfix
>mailq_path = /usr/local/bin/mailq
>manpage_directory = /usr/local/man
>message_size_limit = 25600000
>meta_directory = /usr/local/libexec/postfix
>mydestination = localhost
>mydomain = example.com
>myhostname = mail.example.com
>mynetworks_style = host
>newaliases_path = /usr/local/bin/newaliases
>queue_directory = /var/spool/postfix
>readme_directory = /usr/local/share/doc/postfix
>relay_recipient_maps =
>mysql:/usr/local/etc/postfix/mysql-virtual-mailbox-maps.cf
>sample_directory = /usr/local/etc/postfix sendmail_path =
>/usr/local/sbin/sendmail setgid_group = maildrop
>shlib_directory = /usr/local/lib/postfix
>smtp_tls_note_starttls_offer = yes
>smtp_use_tls = yes
>smtpd_delay_reject = yes
>smtpd_helo_required = yes
>smtpd_helo_restrictions = permit_mynetworks,
>permit_sasl_authenticated, reject_invalid_hostname,
>reject_unknown_hostname, reject_non_fqdn_hostname,
>reject_non_fqdn_helo_hostname, reject_invalid_helo_hostname, permit
>smtpd_recipient_restrictions = permit_mynetworks,
>permit_sasl_authenticated, reject_non_fqdn_hostname,
>reject_non_fqdn_sender, reject_non_fqdn_recipient,
>reject_unauth_destination, reject_unauth_pipelining, reject_rbl_client
>bl.spamcop.net, reject_rbl_client sbl-xbl.spamhaus.org,
>reject_rbl_client zen.spamhaus.org, reject_rbl_client dnsbl.sorbs.net,
>reject_rbl_client rhsbl.sorbs.net, reject_rbl_client db.wpbl.info,
>reject_rbl_client cbl.abuseat.org, reject_rbl_client
>proxies.blackholes.wirehub.net, reject_rbl_client
>query.bondedsender.org permit smtpd_relay_restrictions =
>permit_mynetworks permit_sasl_authenticated defer_unauth_destination
>smtpd_sasl_auth_enable = yes smtpd_sasl_path = private/auth
>smtpd_sasl_type = dovecot smtpd_sender_restrictions =
>permit_mynetworks, permit_sasl_authenticated, reject_non_fqdn_sender,
>reject_unknown_sender_domain, reject_unlisted_sender, permit
>smtpd_tls_auth_only = yes smtpd_tls_cert_file =
>/usr/local/etc/ssl/more/server.crt smtpd_tls_key_file =
>/usr/local/etc/ssl/more/server.key smtpd_tls_loglevel = 0
>smtpd_tls_mandatory_protocols = !SSLv2,!SSLv3
>smtpd_tls_received_header = yes smtpd_tls_session_cache_timeout =
>3600s smtpd_use_tls = yes soft_bounce = no tls_random_source =
>dev:/dev/urandom unknown_local_recipient_reject_code = 550
>virtual_alias_maps =
>mysql:/usr/local/etc/postfix/mysql-virtual-alias-maps.cf
>virtual_mailbox_domains =
>mysql:/usr/local/etc/postfix/mysql-virtual-domains-maps.cf
>virtual_mailbox_limit = 51200000 virtual_mailbox_maps =
>mysql:/usr/local/etc/postfix/mysql-virtual-mailbox-maps.cf
>virtual_transport = lmtp:unix:private/dovecot-lmtp
>
>
>
>
>Not sure if I need to post main.cf.  
>
>I have been beating my head against the screen for a week and thought
>I'd try here. Probably some stupid typo or stupid action on my part.
>Feel free to slap me around

What version of MySQL are you employing?

-- 
Jerry
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 488 bytes
Desc: OpenPGP digital signature
URL: <https://dovecot.org/pipermail/dovecot/attachments/20191229/1942db66/attachment-0001.sig>