Jun 4 17:47:39 mail sendmail[28667]: libnss_mysql: mysql_query failed: You have an error in your SQL syntax near ''njdmc:\\documents.and.settings\\iv\\my.documents\\affiliates\\ivo-email\\st' at line 1
libnss_mysql seems to choke on bad data. To get around this I restart mysql.
Is there a better way?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've actually experienced this myself. There must be a bug in the way I'm handling an snprintf or something ... I'll need to look at it and fix it..
Restarting sendmail fixed the problem for me, BTW.. restarting MySQL probably just caused the sendmail clients to stop trying due to a down MySQL server.. but restarting sendmail (parent and all children) should clear it up.
I've got a trace file from when mine did that.. so I'll log a bug and take a look at fixing it ...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I sometimes get errors like the following...
Jun 4 17:47:39 mail sendmail[28667]: libnss_mysql: mysql_query failed: You have an error in your SQL syntax near ''njdmc:\\documents.and.settings\\iv\\my.documents\\affiliates\\ivo-email\\st' at line 1
libnss_mysql seems to choke on bad data. To get around this I restart mysql.
Is there a better way?
I've actually experienced this myself. There must be a bug in the way I'm handling an snprintf or something ... I'll need to look at it and fix it..
Restarting sendmail fixed the problem for me, BTW.. restarting MySQL probably just caused the sendmail clients to stop trying due to a down MySQL server.. but restarting sendmail (parent and all children) should clear it up.
I've got a trace file from when mine did that.. so I'll log a bug and take a look at fixing it ...
You'll be happy to know that I've released 0.9 which fixes this problem. Let me know if you need anything else.