From owner-freebsd-ports-bugs@FreeBSD.ORG Mon Sep 12 14:50:06 2011 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3099E106564A for ; Mon, 12 Sep 2011 14:50:06 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 052848FC12 for ; Mon, 12 Sep 2011 14:50:06 +0000 (UTC) Received: from freefall.freebsd.org (localhost [127.0.0.1]) by freefall.freebsd.org (8.14.4/8.14.4) with ESMTP id p8CEo5lw013365 for ; Mon, 12 Sep 2011 14:50:05 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.4/8.14.4/Submit) id p8CEo5W4013364; Mon, 12 Sep 2011 14:50:05 GMT (envelope-from gnats) Resent-Date: Mon, 12 Sep 2011 14:50:05 GMT Resent-Message-Id: <201109121450.p8CEo5W4013364@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, Root User Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id D926F106564A for ; Mon, 12 Sep 2011 14:45:00 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from red.freebsd.org (red.freebsd.org [IPv6:2001:4f8:fff6::22]) by mx1.freebsd.org (Postfix) with ESMTP id AB8E08FC18 for ; Mon, 12 Sep 2011 14:45:00 +0000 (UTC) Received: from red.freebsd.org (localhost [127.0.0.1]) by red.freebsd.org (8.14.4/8.14.4) with ESMTP id p8CEj0Ro027725 for ; Mon, 12 Sep 2011 14:45:00 GMT (envelope-from nobody@red.freebsd.org) Received: (from nobody@localhost) by red.freebsd.org (8.14.4/8.14.4/Submit) id p8CEj0SE027724; Mon, 12 Sep 2011 14:45:00 GMT (envelope-from nobody) Message-Id: <201109121445.p8CEj0SE027724@red.freebsd.org> Date: Mon, 12 Sep 2011 14:45:00 GMT From: Root User To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: Subject: ports/160679: databases/mysql55-server appears to fail to install with normal /var/db/mysql directory set; DB init fails X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 12 Sep 2011 14:50:06 -0000 >Number: 160679 >Category: ports >Synopsis: databases/mysql55-server appears to fail to install with normal /var/db/mysql directory set; DB init fails >Confidential: no >Severity: serious >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: sw-bug >Submitter-Id: current-users >Arrival-Date: Mon Sep 12 14:50:05 UTC 2011 >Closed-Date: >Last-Modified: >Originator: Root User >Release: AMD-64 >Organization: >Environment: FreeBSD localhost 8.2-STABLE FreeBSD 8.2-STABLE #0: Fri Sep 2 14:24:35 CDT 2011 root@localhost:/usr/obj/usr/src/sys/GENERIC amd64 mysql-client-5.5.15 /usr/local/bin/mysql mysql-server-5.5.15_1 /usr/local/libexec/mysqld >Description: a) apparent /var/db/mysql default directory not defined to installed MySQL mysql_install_db --user mysql FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. b) MySQL DB initialization fails [using explicit directory parms due to a)] mysql_install_db --user mysql --datadir=/var/db/mysql --ldata=/var/db/mysql --srcdir=/usr/ports/databases/mysql55-server/work/mysql-5.5.15 Installing MySQL system tables... ERROR: 1049 Unknown database 'mysql' 110909 17:13:04 [ERROR] Aborting 110909 17:13:04 [Note] /usr/ports/databases/mysql55-server/work/mysql-5.5.15/sql/mysqld: Shutdown complete Installation of system tables failed! Examine the logs in /var/db/mysql for more information. You can try to start the mysqld daemon with: shell> /usr/ports/databases/mysql55-server/work/mysql-5.5.15/sql/mysqld --skip-grant & and use the command line tool /usr/ports/databases/mysql55-server/work/mysql-5.5.15/client/mysql to connect to the mysql database and look at the grant tables: shell> /usr/ports/databases/mysql55-server/work/mysql-5.5.15/client/mysql -u root mysql mysql> show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/db/mysql that may be helpful. Please consult the MySQL manual section 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source are the MySQL email archives available at http://lists.mysql.com/. Please check all of the above before mailing us! And remember, if you do mail us, you MUST use the /usr/ports/databases/mysql55-server/work/mysql-5.5.15/scripts/mysqlbug script! c) MySQL userid definitions grep mysql /etc/passwd /etc/group /etc/passwd:mysql:*:88:88:MySQL Daemon:/var/db/mysql:/usr/sbin/nologin /etc/group:mysql:*:88: d) DB init creates two empty directories: /var/db/mysql/mysql /var/db/mysql/test >How-To-Repeat: >Fix: >Release-Note: >Audit-Trail: >Unformatted: