Subject: Re: error installing mysql-server
To: Philip Brodd <pbrodd@blue.weeg.uiowa.edu>
From: Mike Bush <mike@ieaccess.com>
List: port-macppc
Date: 03/25/2001 10:55:37
I had the same error about a month or so ago... sorry no solutions here :(
Anyone have a fix?

Mike

----- Original Message -----
From: "Philip Brodd" <pbrodd@blue.weeg.uiowa.edu>
To: "netbsd/macppc" <port-macppc@netbsd.org>
Sent: Sunday, March 25, 2001 8:04 AM
Subject: error installing mysql-server


> 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
>
>