Date: Wed, 06 Apr 2005 12:28:59 +0300 From: Vasil Dimov <vd@datamax.bg> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/79597: databases/mysql323-server does not find my.cnf if not placed in /var/db/mysql/ Message-ID: <1112779739.595760.8369.nullmailer@sinanica.bg.datamax> Resent-Message-ID: <200504060950.j369o6rK072359@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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@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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1112779739.595760.8369.nullmailer>