From: Reindl Harald Date: September 10 2011 2:45pm Subject: Re: MySQL daemons restarting every 7 minutes List-Archive: http://lists.mysql.com/mysql/225708 Message-Id: <4E6B77FE.7080408@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig1A075D741977DE193A5CA26E" --------------enig1A075D741977DE193A5CA26E Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 10.09.2011 16:07, schrieb a.smith@stripped: > Then I thought, what if I have hosts.allow misconfigured and its wide o= pen maybe a remote system is connecting and > messing with it. But hosts.allow was correct (mysql not listed, so deni= ed by the last all:all). I tested connecting > from a remote server, guess what? Mysql daemons restarted in exactly th= e way I was seeing each 7 mins, each time > just by simply running: >=20 > mysql -h tau >=20 > Odd that, so I added a mysql specific line to the hosts.allow=20 who is using hosts.allow for protection instead a firewall in front of th= e machine or iptables (linux) / ipf (bsd)? > As I said I can get it to restart just by doing a remote connect from a= nother server... reproduceable or was it a lucky hit once? if mysqld crashs ypu see normally something in the mysqld-error-log or in= the syslog of the machine, until now ypu provided no silngle line about a crash from= any log --------------enig1A075D741977DE193A5CA26E Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk5rd/4ACgkQhmBjz394AnlPIwCeKPAhAott3g4yxroYcngZd7M4 RJsAnj5lgXSO82ASxHH+ISYMKlSntXi4 =59uw -----END PGP SIGNATURE----- --------------enig1A075D741977DE193A5CA26E--