Date: Mon, 12 Sep 2011 14:45:00 GMT From: Root User <leftfoot@siu.edu> To: freebsd-gnats-submit@FreeBSD.org Subject: ports/160679: databases/mysql55-server appears to fail to install with normal /var/db/mysql directory set; DB init fails Message-ID: <201109121445.p8CEj0SE027724@red.freebsd.org> Resent-Message-ID: <201109121450.p8CEo5W4013364@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201109121445.p8CEj0SE027724>