SQLgrey Postfix greylisting service

I discovered the same problem with sqlgrey 1.6.8 and mysql 5.0.51 here.

kernel: [687872.658710] sqlgrey[3190]: segfault at 4 ip b7b84874 sp
bfdbae40 error 4 in libmysqlclient.so.15.0.0[b7b16000+1a4000]

The problem is caused by the mysqld connection timeout (wait_timeout
parameter).
If I'm getting this right, sqlgrey starts a connection to mysqld, the
first time sqlgrey is accessed by postfix. This connection is kept open by
sqlgrey all the time.
If there's no other connect within 8 hours (the default for wait_timeout)
or what ever wait_timeout is set to, sqlgrey will seqfault the next time it
gets a connection and tries to use it's (timeouted) mysqlconnection.

So the problem is, sqlgrey does not detect this timeout right and is not
able to reconnect to mysql.

Segfaults can't be caused by pure Perl programs like SQLgrey. This is
probably an hardware problem. Marking invalid.

Logged In: NO

I also have a similar problem.
I run daemon sqlgrey 1.6.8 with Mysql DBMS. DB access is "sync", not
"async".

I have just installed it in test environment with no connection. I start
sqlgrey and it works fine. I make SMTP session: it's ok.
After a day, I made an smtp session: sqlgrey segfault! This is the only
log written:

kernel:<6>sqlgrey[9861]: segfault at 0000000000000008 rip 0000003d2ca489d5
rsp 00007fff031e68e0 error 4

Marco
<falon AT csi.it>

- Can you run it without detaching from terminal (ie: without -d) to get a
look at any error that may be printed when it crashes?
- Which version are you using?