From: Reindl Harald
Date: September 10 2011 4:57pm
Subject: Re: MySQL daemons restarting every 7 minutes
List-Archive: http://lists.mysql.com/mysql/225714
Message-Id: <4E6B96E0.5000701@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig08BA6DEB9480A3DAE08C77CB"

--------------enig08BA6DEB9480A3DAE08C77CB
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable


Am 10.09.2011 18:52, schrieb a.smith@stripped:
> Quoting walter harms <wharms@stripped>:
>
>> restart it with the same parameter on the command line and see what ha=
ppens
>> the server support a verbos option (never used) perhaps it will tell y=
ou more.
>>
>
> I can start mysqld direct from the command line and reproduce the probl=
em. I checked and it seems the verbose
> option only works in conjunction with --help.
>
> Playing around with a couple of tools that are installed on FreeBSD, I =
ran via truss and ktrace to see if there
> was anything obvious before the process dies but not really. In ktrace =
you can see that it gets as far as
> deciding that the remote connection should not be allowed then rapidly =
just dies:
>
>
>  78353 echo     GIO   fd 1 wrote 44 bytes
>        "You are not welcome to use mysqld from tau.
>        "
>  78353 echo     RET   writev 44/0x2c
>  78353 echo     CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffffffebd0)=

>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  sigprocmask(SIG_BLOCK,0x800638400,0x7fffffffeb80)=

>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  sigprocmask(SIG_SETMASK,0x800638410,0)
>  78353 echo     RET   sigprocmask 0
>  78353 echo     CALL  exit(0)
>
>
> Interesting also to see it exits with status 0 :S. What would be the be=
st tool to debug this further?

"You are not welcome to use mysqld from tau" is NOT from mysqld
remove your hosts.allow/hosts.deny crap and replace it with firewall-rule=
s
if the problem goes away make a bugreport on BSD side becahuse this is NO=
T a mysqld issue



--------------enig08BA6DEB9480A3DAE08C77CB
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/

iEYEARECAAYFAk5rluAACgkQhmBjz394AnlfQACdEHmwAlmoQiw7CHNMPHLMR9lD
4RwAn3RM267LNAkK9Z3sIlffORm21Pim
=+LUR
-----END PGP SIGNATURE-----

--------------enig08BA6DEB9480A3DAE08C77CB--