Subject: error installing mysql-server
To: netbsd/macppc <port-macppc@netbsd.org>
From: Philip Brodd <pbrodd@blue.weeg.uiowa.edu>
List: port-macppc
Date: 03/25/2001 10:04:50
Has anyone else gotten this error when installing mysql-server from
pkgsrc (running 1.5):

--- snip ---
install -c -o root -g wheel -m 555 -s mysqld /usr/pkg/libexec/mysqld
Making install in tests
`safe_mysqld' is up to date.
`mysql_install_db' is up to date.
/usr/pkg/bin/mysql_install_db --force
Creating db table
Creating host table
Creating user table
Creating func table
Creating tables_priv table
Creating columns_priv table

/usr/pkg/libexec/mysqld: Fatal error: Can't read from messagefile '/usr/pkg/share/mysql/english/errmsg.sys'

Installation of grant tables failed!

Examine the logs in /var/mysql for more information.
You can also try to start the mysqld demon with:
/usr/pkg/libexec/mysqld --skip-grant &
You can use the command line tool
/usr/pkg/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/pkg/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/mysql 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 /usr/pkg/bin/mysqlbug script!
*** Error code 1

Stop.
*** Error code 1

Stop.
*** Error code 1

Stop.
*** Error code 1

Stop.
--- snip ---


I tried running mysqld with --skip-grant, but I still get the error
"Can't read from messagefile '/usr/pkg/share/mysql/english/errmsg.sys'"
That file seems to exist and is readable by root:

ls -l /usr/pkg/share/mysql/english/
total 36
-r--r--r--  1 root  wheel  8814 Mar 25 03:19 errmsg.sys
-r--r--r--  1 root  wheel  9114 Mar 25 03:19 errmsg.txt

The logs in /var/mysql are empty.

Thanks.

Phil