Re: AUTH failures requires restarting smtpd

2019-08-10 Thread Gilles Chehade
On Sat, Aug 10, 2019 at 02:24:57PM -0500, Edgar Pettijohn wrote:
> 
> On Aug 10, 2019 1:05 PM, Gilles Chehade  wrote:
> >
> > On Mon, Jul 22, 2019 at 11:52:45AM -0500, Edgar Pettijohn wrote:
> > > 
> > > On Jul 22, 2019 8:17 AM, Andreas Karlsson  wrote:
> > > >
> > > > On 2019-07-21 18:25, Edgar Pettijohn wrote:
> > > > > Not sure exactly when this started, but I get authentication errors 
> > > > > that require smtpd to be restarted. Here are some logs and other 
> > > > > pertinent data.
> > > > > 
> > > > > Thanks,
> > > > > 
> > > > > Edgar
> > > > > 
> > > > Hi,
> > > > Can you check if there are any issues with the connection to the MySQL 
> > > > database during the time of the credentials lookup fails?
> > > >
> > > > I've had similar issues with Postgresql databases in the past (many 
> > > > OpenSMTPD versions ago) where the psql tcp connection was disconnected 
> > > > due to restarting the psql database. This was not handled well by 
> > > > OpenSMTPD.
> > > >
> > > > br,
> > > >
> > > > -- 
> > > > You received this mail because you are subscribed to misc@opensmtpd.org
> > > > To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
> > > >
> > > 
> > > Maybe something similar. Mysqld is running and double checking the SQL 
> > > from the command line works. Plus dovecot is using the same without error.
> > > 
> > > Thanks,
> > > 
> >
> > Once I tag OpenSMTPD 6.6.0 in August, I'll have a look at extras because
> > they've been out of my sight for a while.
> >
> > -- 
> > Gilles Chehade  @poolpOrg
> >
> > https://www.poolp.org?? patreon: 
> > https://www.patreon.com/gilles
> >
> 
> 
> Thanks.  As an update I upgraded to a snapshot last week with no change. Have 
> a cron job restarting smtpd every hour as a workaround.

You should create an issue on our issue tracker so I don't forget about
this in a week

-- 
Gilles Chehade @poolpOrg

https://www.poolp.orgpatreon: https://www.patreon.com/gilles



Re: AUTH failures requires restarting smtpd

2019-08-10 Thread Edgar Pettijohn

On Aug 10, 2019 1:05 PM, Gilles Chehade  wrote:
>
> On Mon, Jul 22, 2019 at 11:52:45AM -0500, Edgar Pettijohn wrote:
> > 
> > On Jul 22, 2019 8:17 AM, Andreas Karlsson  wrote:
> > >
> > > On 2019-07-21 18:25, Edgar Pettijohn wrote:
> > > > Not sure exactly when this started, but I get authentication errors 
> > > > that require smtpd to be restarted. Here are some logs and other 
> > > > pertinent data.
> > > > 
> > > > Thanks,
> > > > 
> > > > Edgar
> > > > 
> > > Hi,
> > > Can you check if there are any issues with the connection to the MySQL 
> > > database during the time of the credentials lookup fails?
> > >
> > > I've had similar issues with Postgresql databases in the past (many 
> > > OpenSMTPD versions ago) where the psql tcp connection was disconnected 
> > > due to restarting the psql database. This was not handled well by 
> > > OpenSMTPD.
> > >
> > > br,
> > >
> > > -- 
> > > You received this mail because you are subscribed to misc@opensmtpd.org
> > > To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
> > >
> > 
> > Maybe something similar. Mysqld is running and double checking the SQL from 
> > the command line works. Plus dovecot is using the same without error.
> > 
> > Thanks,
> > 
>
> Once I tag OpenSMTPD 6.6.0 in August, I'll have a look at extras because
> they've been out of my sight for a while.
>
> -- 
> Gilles Chehade    @poolpOrg
>
> https://www.poolp.org    patreon: https://www.patreon.com/gilles
>


Thanks.  As an update I upgraded to a snapshot last week with no change. Have a 
cron job restarting smtpd every hour as a workaround.

Re: AUTH failures requires restarting smtpd

2019-08-10 Thread Gilles Chehade
On Mon, Jul 22, 2019 at 11:52:45AM -0500, Edgar Pettijohn wrote:
> 
> On Jul 22, 2019 8:17 AM, Andreas Karlsson  wrote:
> >
> > On 2019-07-21 18:25, Edgar Pettijohn wrote:
> > > Not sure exactly when this started, but I get authentication errors that 
> > > require smtpd to be restarted. Here are some logs and other pertinent 
> > > data.
> > > 
> > > Thanks,
> > > 
> > > Edgar
> > > 
> > Hi,
> > Can you check if there are any issues with the connection to the MySQL 
> > database during the time of the credentials lookup fails?
> >
> > I've had similar issues with Postgresql databases in the past (many 
> > OpenSMTPD versions ago) where the psql tcp connection was disconnected 
> > due to restarting the psql database. This was not handled well by OpenSMTPD.
> >
> > br,
> >
> > -- 
> > You received this mail because you are subscribed to misc@opensmtpd.org
> > To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
> >
> 
> Maybe something similar. Mysqld is running and double checking the SQL from 
> the command line works. Plus dovecot is using the same without error.
> 
> Thanks,
> 

Once I tag OpenSMTPD 6.6.0 in August, I'll have a look at extras because
they've been out of my sight for a while.

-- 
Gilles Chehade @poolpOrg

https://www.poolp.orgpatreon: https://www.patreon.com/gilles



Re: AUTH failures requires restarting smtpd

2019-07-22 Thread Edgar Pettijohn

On Jul 22, 2019 8:17 AM, Andreas Karlsson  wrote:
>
> On 2019-07-21 18:25, Edgar Pettijohn wrote:
> > Not sure exactly when this started, but I get authentication errors that 
> > require smtpd to be restarted. Here are some logs and other pertinent data.
> > 
> > Thanks,
> > 
> > Edgar
> > 
> Hi,
> Can you check if there are any issues with the connection to the MySQL 
> database during the time of the credentials lookup fails?
>
> I've had similar issues with Postgresql databases in the past (many 
> OpenSMTPD versions ago) where the psql tcp connection was disconnected 
> due to restarting the psql database. This was not handled well by OpenSMTPD.
>
> br,
>
> -- 
> You received this mail because you are subscribed to misc@opensmtpd.org
> To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org
>

I think it's good. Dovecot still works and I checked from the terminal and it 
worked. 

Thanks,

Edgar

Re: AUTH failures requires restarting smtpd

2019-07-22 Thread Andreas Karlsson

On 2019-07-21 18:25, Edgar Pettijohn wrote:

Not sure exactly when this started, but I get authentication errors that 
require smtpd to be restarted. Here are some logs and other pertinent data.

Thanks,

Edgar


Hi,
Can you check if there are any issues with the connection to the MySQL 
database during the time of the credentials lookup fails?


I've had similar issues with Postgresql databases in the past (many 
OpenSMTPD versions ago) where the psql tcp connection was disconnected 
due to restarting the psql database. This was not handled well by OpenSMTPD.


br,

--
You received this mail because you are subscribed to misc@opensmtpd.org
To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org



AUTH failures requires restarting smtpd

2019-07-21 Thread Edgar Pettijohn
Not sure exactly when this started, but I get authentication errors that 
require smtpd to be restarted. Here are some logs and other pertinent data.

Thanks,

Edgar
#   $OpenBSD: smtpd.conf,v 1.9 2016/05/03 18:43:45 jung Exp $

# This is the smtpd server system-wide configuration file.
# See smtpd.conf(5) for more information.

pki mail.pettijohn-web.com cert "/etc/ssl/pettijohn-web.com.crt"
pki mail.pettijohn-web.com key "/etc/ssl/private/pettijohn-web.com.key"

table domains mysql:/etc/mail/mysql.conf
table virtuals mysql:/etc/mail/mysql.conf
table credentials mysql:/etc/mail/mysql.conf

filter f01 builtin ehlo fcrdns reject "550 go away punk"
filter f02 builtin helo fcrdns reject "550 go away punk"

filter c01 chain { f01, f02 }

listen on lo0
listen on egress port 25 tls pki mail.pettijohn-web.com filter c01
listen on egress port 587 tls pki mail.pettijohn-web.com auth 

action "act01" lmtp "/var/dovecot/lmtp" rcpt-to virtual 
action "act02" relay

match auth from any for any action act02
match auth from any for domain  action act01
match from any for domain  action act01
Jul 20 19:50:19 mail smtpd[83239]: 624740cbf697f7b7 smtp tls 
ciphers=TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256
Jul 20 19:50:20 mail smtpd[83239]: 624740cbf697f7b7 smtp message msgid=c417104e 
size=2221 nrcpt=1 proto=ESMTP
Jul 20 19:50:20 mail smtpd[83239]: 624740cbf697f7b7 smtp envelope 
evpid=c417104e559c49ed from= 
to=
Jul 20 19:50:20 mail dovecot: lmtp(83688): Connect from local
Jul 20 19:50:20 mail dovecot: 
lmtp(ed...@pettijohn-web.com)<83688>: 
msgid=<20190721002023.ga85...@deathstar.my.domain>: saved mail to INBOX
Jul 20 19:50:20 mail dovecot: lmtp(83688): Disconnect from local: Client has 
quit the connection (state=READY)
Jul 20 19:50:20 mail smtpd[83239]: 624740cce7483448 mda delivery 
evpid=c417104e559c49ed from= 
to= rcpt= user=vmail delay=0s 
result=Ok stat=Delivered
Jul 20 19:50:30 mail smtpd[83239]: 624740cbf697f7b7 smtp disconnected 
reason=quit
Jul 20 19:51:59 mail smtpd[83239]: 624740ce5f80c637 smtp connected 
address=185.234.216.144 host=
Jul 20 19:51:59 mail smtpd[83239]: 624740ce5f80c637 smtp failed-command 
command="EHLO User" result="550 go away punk"
Jul 20 19:52:00 mail smtpd[83239]: 624740ce5f80c637 smtp disconnected 
reason=quit
Jul 20 19:56:32 mail smtpd[83239]: 624740cf131a2d57 smtp connected 
address=73.203.197.238 host=c-73-203-197-238.hsd1.tn.comcast.net
Jul 20 19:56:33 mail smtpd[83239]: 624740cf131a2d57 smtp tls 
ciphers=TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256
Jul 20 19:56:33 mail smtpd[83239]: 624740cf131a2d57 smtp authentication 
user=ed...@pettijohn-web.com result=ok
Jul 20 19:56:33 mail smtpd[83239]: 624740cf131a2d57 smtp message msgid=2fd09838 
size=633 nrcpt=1 proto=ESMTP
Jul 20 19:56:33 mail smtpd[83239]: 624740cf131a2d57 smtp envelope 
evpid=2fd09838a28ee47a from= 
to=
Jul 20 19:56:33 mail smtpd[83239]: 624740d2ef323b04 mta connecting 
address=smtp://104.47.44.33:25 host=104.47.44.33
Jul 20 19:56:33 mail smtpd[83239]: 624740d2ef323b04 mta connected
Jul 20 19:56:33 mail smtpd[83239]: 624740d2ef323b04 mta tls 
ciphers=TLSv1.2:ECDHE-RSA-AES256-SHA384:256
Jul 20 19:56:33 mail smtpd[83239]: smtp-out: Server certificate verification 
succeeded on session 624740d2ef323b04
Jul 20 19:56:34 mail smtpd[83239]: 624740d2ef323b04 mta delivery 
evpid=2fd09838a28ee47a from= 
to= rcpt=<-> source="108.61.222.55" relay="104.47.44.33 
(104.47.44.33)" delay=1s result="Ok" stat="250 2.6.0 
 [InternalId=51861730154703, 
Hostname=SN1NAM04HT127.eop-NAM04.prod.protection.outlook.com] 7045 bytes in 
0.126, 54.586 KB/sec Queued mail for delivery -> 250 2.1.5"
Jul 20 19:56:43 mail smtpd[83239]: 624740cf131a2d57 smtp disconnected 
reason=quit
Jul 20 19:56:44 mail smtpd[83239]: 624740d2ef323b04 mta disconnected 
reason=quit messages=1
Jul 20 19:57:36 mail smtpd[83239]: 624740d3d9418c2d smtp connected 
address=73.203.197.238 host=c-73-203-197-238.hsd1.tn.comcast.net
Jul 20 19:57:36 mail smtpd[83239]: 624740d3d9418c2d smtp tls 
ciphers=TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256
Jul 20 19:57:37 mail smtpd[83239]: 624740d3d9418c2d smtp authentication 
user=ed...@pettijohn-web.com result=ok
Jul 20 19:57:37 mail smtpd[83239]: 624740d3d9418c2d smtp message msgid=ae4c49da 
size=633 nrcpt=1 proto=ESMTP
Jul 20 19:57:37 mail smtpd[83239]: 624740d3d9418c2d smtp envelope 
evpid=ae4c49da106f2b18 from= 
to=
Jul 20 19:57:37 mail smtpd[83239]: 624740d639a1318b mta connecting 
address=smtp://104.47.2.33:25 host=104.47.2.33
Jul 20 19:57:37 mail smtpd[83239]: 624740d639a1318b mta connected
Jul 20 19:57:38 mail smtpd[83239]: 624740d639a1318b mta tls 
ciphers=TLSv1.2:ECDHE-RSA-AES256-SHA384:256
Jul 20 19:57:38 mail smtpd[83239]: smtp-out: Server certificate verification 
succeeded on session 624740d639a1318b
Jul 20 19:57:39 mail smtpd[83239]: 624740d639a1318b mta delivery 
evpid=ae4c49da106f2b18 from= 
to= rcpt=<-> source="108.61.222.55" relay="104.47.2.33 
(104.47.2.33)" delay=2s result="Ok" stat="250 2.6.0 
 [InternalId=52871047466147,