[9.2.1.6] Networking changes in the latest beta?

[Tsaukpaetra]

I've been following the 9.2.1.x nightlies lately (about every week), and I just noticed that my jailed MySQL server keeps launch-looping. It seems to start up just fine, but then silently crashes (upon which mysqld_safe relaunches the process).

Some of the repeating error log: Pastebin full log

Code:

2014-06-10 22:46:01 24647 [Note] Server hostname (bind-address): '192.168.1.184'; port: 3306
2014-06-10 22:46:01 24647 [Note]   - '192.168.1.184' resolves to '192.168.1.184';
2014-06-10 22:46:01 24647 [Note] Server socket created on IP: '192.168.1.184'.
2014-06-10 22:46:01 24647 [Note] Event Scheduler: Loaded 0 events
2014-06-10 22:46:01 24647 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.19'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
140610 22:46:01 mysqld_safe mysqld restarted

The server is fine if I add the following line to my.conf

Code:

skip-networking

But of course that means I can only access it via linux sockets (not so helpful for all my web applications).
I'll try and ask elsewhere, but in the hopes that someone knows any kernel-based issues that may relate, I thought to save some time and grief if it was a known problem.

 

[cyberjock]

Is your jail a linux jail?

If it is I hate to say it, but the linux jails haven't been quite what iX had hoped. If you aren't expecting amazing performance you may want to try running linux in a virtualbox jail. I'm currently experimenting with it and while performance isn't stellar(I wasn't expecting stellar performance since the box is an Intel Avoton Atom based machine) its actually been extremely reliable for me.

 

[Tsaukpaetra]

Nope, it's a good ol' plugin jail. Coincidentally, there are no plugins in it (it was created before I learned the difference between port and plugin types).

Further research indicates it may be because of my hosts.allow file, which I recently attempted to lock down, because once I uncomment the ALL : ALL : allow rule, I get the following:

Code:

2014-06-10 23:08:19 35458 [Warning] IP address '192.168.1.76' could not be resolved: hostname nor servname provided, or not known

which indicates that a port-based client was able to connect.

 

[Tsaukpaetra]

Yeah, definitely a hosts.allow issue in the jail, which leaves me scratching my head, since the line

Code:

mysql : ALL : ALLOW 

should have allowed the mysql service to receive connections (unless it's doing something else I don't know about...)

 

[cyberjock]

Yeah.. I can't help with that.. my experience with MySQL is virtually non-existent.

 

[Tsaukpaetra]

It seems like MySQL was attempting a reverse-dns lookup for some reason? Meh, I'll search the MySQL forums now I know the problem. ;)