ports/79597: databases/mysql323-server does not find my.cnf if not placed in /var/db/mysql/

[Vasil Dimov]

>Number:         79597
>Category:       ports
>Synopsis:       databases/mysql323-server does not find my.cnf if not placed in /var/db/mysql/
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Wed Apr 06 09:50:06 GMT 2005
>Closed-Date:
>Last-Modified:
>Originator:     Vasil Dimov
>Release:        FreeBSD 5.4-PRERELEASE i386
>Organization:
DataMax
>Environment:
System: FreeBSD sinanica.bg.datamax 5.4-PRERELEASE FreeBSD 5.4-PRERELEASE #4: Fri Apr 1 12:12:53 EEST 2005 root at sinanica.bg.datamax:/usr/obj/usr/src/sys/SINANICA-SMP i386
>Description:
If nonstandard data directory is used for mysql-server-3.23.59.n.20050301
configuration, for example /var/db/mysql3 (instead of /var/db/mysql) the server
behaves as if there is no (or empty) /var/db/mysql3/my.cnf although
mysql_dbdir="/var/db/mysql3" is set in /etc/rc.conf.local

mysqld is started with appropriate --datadir=/var/db/mysql3

>How-To-Repeat:
Create and setup /var/db/mysql3 as data directory and put
mysql_dbdir="/var/db/mysql3" in /etc/rc.conf.local

Also put some options in /var/db/mysql3/my.cnf for example skip-networking
(even /dev/urandom > /var/db/mysql3/my.cnf will do the work)
and inspect mysql server behavior - it does not honor my.cnf
because it is looking for it in /var/db/mysql/my.cnf
>Fix:
1.
mkdir /var/db/mysql
cp /var/db/mysql3/my.cnf /var/db/mysql
(huh! what an ugly deed)

2.
edit /usr/ports/databases/mysql323-server/Makefile and change line
CONFIGURE_ARGS= --localstatedir=/var/db/mysql \
to
CONFIGURE_ARGS= --localstatedir=/var/db/mysql3 \

Probably DB_DIR functionality in Makefile should be brought back to life?

Yes, I have read ports/UPDATING but this is surely a bug/feature (probably in
mysql server itself) that must be fixed/worked-around somehow.
>Release-Note:
>Audit-Trail:
>Unformatted: