sm/sm-mysql — Issue #1: sm mysql initialize fails on CentOS 5.7
Author: shayfrendt
Created: 2012-01-17 23:38:52+00:00
State: open

The following commands completed successfully:

```
yum install readline readline-devel ncurses-devel
sm get head
sm set install tools
sm set install mysql
sm mysql install
```

Then this one struggled a bit:

```
# sm mysql initialize
Initializing mysql data directory in /var/db/mysql/5.5.19
Initializing mysql data directory in /var/db/mysql/5.5.19
Installing MySQL system tables...
120117 18:34:19 [Warning] The syntax '--log' is deprecated and will be removed in a future release. Please use '--general-log'/'--general-log-file' instead.

Installation of system tables failed! Examine the logs in
/var/db/mysql/5.5.19 for more information.

You can try to start the mysqld daemon with:

shell> /opt/sm/pkg/versions/mysql/5.5.19/bin/mysqld --skip-grant &

and use the command line tool /opt/sm/pkg/versions/mysql/5.5.19/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /opt/sm/pkg/versions/mysql/5.5.19/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/db/mysql/5.5.19 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 /opt/sm/pkg/versions/mysql/5.5.19/scripts/mysqlbug script!

WARNING: There was an error (1) initializing the database at /var/db/mysql/5.5.19
Installing mysql init script
```

There were no initialization log files that I could find, and `sm mysql initialize --trace=all` didn't show anything more specific. Any ideas?