ports/188352: databases/mysql55-server rc script returns before mysqld is running.

[Mathieu Arnold]

>Number:         188352
>Category:       ports
>Synopsis:       databases/mysql55-server rc script returns before mysqld is running.
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Apr 07 15:40:00 UTC 2014
>Closed-Date:
>Last-Modified:
>Originator:     Mathieu Arnold
>Release:        FreeBSD 10.0-RELEASE i386
>Organization:
Absolight
>Environment:
System: FreeBSD aragorn.in.absolight.net 10.0-RELEASE FreeBSD 10.0-RELEASE #0 r260789: Fri Jan 17 01:46:25 UTC 2014 root at snap.freebsd.org:/usr/obj/usr/src/sys/GENERIC i386
>Description:

At startup, the mysql-server rc script returns a few seconds before the mysql
server is really up, running and able to accept connections requests.

>How-To-Repeat:

Install mysql*-server any port that needs it and reboot.

The ones I have problems with are:

ports-mgmt/tinderbox on the redports cluster, where I added a dummy rc script
with a sleep 10 that REQUIRES: mysql-server and BEFORE: tinderd.

dns/opendnssec on my company's DNS servers, I rebooted it today, one of the
daemons that come with it exited with:

Apr  7 17:05:39 ns1 ods-enforcerd: ERROR: unable to connect to database - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

>Fix:

In the mysql_poststart function, maybe test for /tmp/mysql.sock's existence,
and that a server is accepting connections with it, or something.

>Release-Note:
>Audit-Trail:
>Unformatted: