Bug #30765 mysql_install_db fails looking for errmsg.sys

• Submitted: 3 Sep 2007 8:45
• Modified: 7 Sep 2007 8:05
• Reporter: Jim Dowling
• Status: Duplicate
• Category: MySQL Server: Installing
• Severity: S2 (Serious)
• Version: 5.1.21
• OS: Other (Ubuntu Feisty)
• CPU Architecture: Any
• Tags: mysql_install_db

[3 Sep 2007 8:45] Jim Dowling

Description:
mysql_install_db seems to have path issues again, failing trying to find errmsg.sys in $MYSQL_HOME/share/english/errmsg.sys, 
when it is actually in
$MYSQL_HOME/share/mysql/english/errmsg.sys

How to repeat:
scripts/mysql_install_db --defaults-file=/home/jdowling/.mysql/ndb-5.1.21-beta-linux-i686-glibc23/mysql_1/my-5-1-21.cnf --forceInstalling MySQL system tables...
070903 10:43:18 [ERROR] Can't find messagefile '/home/jdowling/.mysql/mysql-5.1.21-beta-linux-i686-glibc23/share/english/errmsg.sys'
070903 10:43:18 [ERROR] Aborting

070903 10:43:18 [Note] 
Installation of system tables failed!

Examine the logs in /home/jdowling/.mysql/ndb-5.1.21-beta-linux-i686-glibc23/mysql_1/var for more information.
You can try to start the mysqld daemon with:
/home/jdowling/.mysql/mysql-5.1.21-beta-linux-i686-glibc23/bin/mysqld --skip-grant &
and use the command line tool
/home/jdowling/.mysql/mysql-5.1.21-beta-linux-i686-glibc23/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /home/jdowling/.mysql/mysql-5.1.21-beta-linux-i686-glibc23/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /home/jdowling/.mysql/ndb-5.1.21-beta-linux-i686-glibc23/mysql_1/var that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running mysql_install_db',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the ./bin/mysqlbug script!

[3 Sep 2007 9:19] Sveta Smirnova

Thank you for the report.

Please provide your configuration file.

[3 Sep 2007 9:20] Sveta Smirnova

Also please indicate accurate version of MySQL package you use (file name).

[3 Sep 2007 9:21] Jim Dowling

#
# This my.cnf file was generated by ndbinstaller.
#

[mysqld]

basedir         = /home/jdowling/.mysql/mysql-5.1.21-beta-linux-i686-glibc23
datadir         = /home/jdowling/.mysql/ndb-5.1.21-beta-linux-i686-glibc23/mysql_1/var
port            = 3306
socket          = /tmp/mysql.sock

pid-file        = /home/jdowling/.mysql/ndb-5.1.21-beta-linux-i686-glibc23/mysql_1/mysqld.pid

# use NDB storage engine and make NDB the default table type
ndbcluster
default-table-type=NDB

# optimizations to improve performance of NDB
ndb-use-exact-count=0
ndb-force-send=1
engine-condition-pushdown=1

# do not include innodb engine (for easier installation)
skip-innodb

# replication settings go here
server-id=1811
log-bin=mysql-bin

[mysql_cluster]
ndb-connectstring=localhost:1186

[3 Sep 2007 9:47] Jim Dowling

The package is:
mysql-5.1.21-beta-linux-i686-glibc23.tar.gz

[3 Sep 2007 19:28] Sveta Smirnova

Thank you for the feedback.

Verified as described.

[7 Sep 2007 8:05] Daniel Fischer

This is a duplicate of bug#30678, and fixed in 5.1.22.