https://sourceforge.net/p/sqlgrey/bugs/24/2010-07-05T11:06:12ZRecent changes to 24: Sqlgrey becomes unresponsive if MySQL server is unavailable2010-07-05T11:06:12Z2010-07-05T11:06:12Zrcb https://sourceforge.net/u/recobo/https://sourceforge.net7f2679a70bc0ec82e3993b577b2417ba4dd92a30

<div class="markdown_content"><p>Version: 1.8.0rc2-1</p> <p>Sqlgrey behaves normally when the mysql server is killed with e.g. /etc/init.d/mysql stop, postfix then continues to deliver e-mail normally<br /> When the server becomes unavailable for other reasons, for example using 'iptables -A INPUT -p tcp --dport 3306 -j DROP', then two different things happen.<br /> - Sqlgrey dies, resulting in 'warning: connect to 127.0.0.1:2501: Connection refused', which gives postfix configuration errors and 4.3.5 error messages to the clients.<br /> - Sqlgrey keeps waiting for the connection to timeout, this results in messages like 'dbaccess: can't connect to DB: Can't connect to MySQL server on '127.0.0.1' (110)'. The effect is the same, 4.3.5 error messages to the clients.</p> <p>This can be reproduced by firewalling MySQL using 'iptables -A INPUT -p tcp --dport 3306 -j DROP'</p></div>