From owner-freebsd-ports-bugs@FreeBSD.ORG Wed Apr 6 09:50:07 2005 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 73E9616A4CE for ; Wed, 6 Apr 2005 09:50:07 +0000 (GMT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2934E43D2F for ; Wed, 6 Apr 2005 09:50:07 +0000 (GMT) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.3/8.13.3) with ESMTP id j369o7i1072360 for ; Wed, 6 Apr 2005 09:50:07 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.3/8.13.1/Submit) id j369o6rK072359; Wed, 6 Apr 2005 09:50:07 GMT (envelope-from gnats) Resent-Date: Wed, 6 Apr 2005 09:50:07 GMT Resent-Message-Id: <200504060950.j369o6rK072359@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, vd@datamax.bg Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 07AC316A4CE for ; Wed, 6 Apr 2005 09:49:00 +0000 (GMT) Received: from jengal.datamax.bg (jengal.datamax.bg [82.103.104.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6112243D45 for ; Wed, 6 Apr 2005 09:49:00 +0000 (GMT) (envelope-from vd@datamax.bg) Received: from sinanica.bg.datamax (sinanica.bg.datamax [192.168.10.1]) by jengal.datamax.bg (Postfix) with QMQP id D686D87CA for ; Wed, 6 Apr 2005 12:28:59 +0300 (EEST) Received: (nullmailer pid 8370 invoked by uid 1004); Wed, 06 Apr 2005 09:28:59 -0000 Message-Id: <1112779739.595760.8369.nullmailer@sinanica.bg.datamax> Date: Wed, 06 Apr 2005 12:28:59 +0300 From: Vasil Dimov To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Subject: ports/79597: databases/mysql323-server does not find my.cnf if not placed in /var/db/mysql/ X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: vd@datamax.bg List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 06 Apr 2005 09:50:07 -0000 >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: