[SMS]

[baboo]

It doesn't look like this is active. How would I activate it? Have an app that needs it active.

Is this a bad thing?

[gerasimos_h]

It supposed to be active, but the tables upgrade caused some errors.

Remove /var/lib/mysql/ib* /var/lib/mysql/mysql-bin* don't worry as they will recreate, and do a 'mysql_upgrade' and restart mysql server.
Look in /var/lib/mysql/*.err to see if INNODB plugin started succesfully.
You should see something like
"InnoDB: Started; log sequence number 0 44044"


gerasimos_h

[baboo]

Your the Man! thanks for the help

[baboo]

oops!

root@searchers:/home/wolf# mysql_upgrade -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysql/mysql.sock'
mysqlcheck: Got error: 1049: Unknown database 'sqlgreydb' when selecting the database
FATAL ERROR: Upgrade failed


help

[gerasimos_h]

Have you try to restart mysql server and do mysql_upgrade?
Does sqlgrey db exists?

gerasimos_h

[baboo]

I restarted mysql but can not upgrade. I cannot login, doesn't recognize my passwd. So, don't know if sqlgrey is still there.

Next?

[gerasimos_h]

At first look if sqlgreydb exist in /var/lib/mysql.
Look if mysql is running, "ps aux | grep mysql".
What /var/lib/mysql/*.err says?
Do you get access denied?

gerasimos_h

[baboo]

sqlgrey does not show in that directory.

ps aux | grep mysql
root 20328 0.0 0.0 1952 508 pts/1 S+ 12:26 0:00 grep mysql


tail /var/lib/mysql/*.err
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
100629 12:16:11 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
100629 12:16:12 InnoDB: Started; log sequence number 0 44233
100629 12:16:12 [Note] Recovering after a crash using mysql-bin
100629 12:16:12 [Note] Starting crash recovery...
100629 12:16:12 [Note] Crash recovery finished.
100629 12:16:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100629 12:16:12 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended


Yes, access denied.

[gerasimos_h]

mysql doesn't run, don't worry.
If you have uninstall sqlgrey just untar sqlgrey package and cp -a sqlgreydb from package to /var/lib/mysql, do a "chown -R mysql.mysql /vasr/lib/mysql" just in case.
Remove /var/lib/mysql/ib* /var/lib/mysql/mysql-bin* one again and start the server.
And try to upgrade again.
The good thing is that InnoDB started though.

gerasimos_h

[baboo]

I'll try now. Getting nervous.

[baboo]

mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysql/mysql.sock'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

[gerasimos_h]

mysql is not running.
does /var/lib/mysql/*.err outputs same error?
can I login to take look?

gerasimos_h

[baboo]

yes it does. go to email.

[baboo]

okay - so you fixed it

I know you are going to bed soon, but when you get a chance to read and respond to this, was it because msyql.sock could not be found?

The relative path? Have been reading

[gerasimos_h]

During the mysql_upgrade all of your databases moved to mysql@002eold and stay there because of the failure.
Technically you didn't have any database to start. your /var/lib/mysql were empty.

gerasimos_h