Catastrophic Installation Failure now!

Sun Jan 10 17:17:36 UTC 2010

MAJOR SCREWUP

I was frustrated by a failure to create a ROOT password and decided to do a
clean reinstall
Did a "make deinstall"  from the following ports

[i]     /usr/ports/databases/mysql54-server
[ii]     /usr/ports/databases/mysql54-client
[iii]    /usr/ports/databases/mysql54-scripts

Did a rm of the /etc/my.cnf file (There were no others in related or
relevant areas)

Also did a rm -rf of the database at /disk02/db/mysql/DATA

Registered packages would be as follows:-
# pkg_info | grep mysql
bsdpan-DBD-mysql-4.013 DBD::mysql - MySQL driver for the Perl5 Database
Interface
php5-mysql-5.2.11_1 The mysql shared extension for php
php5-mysqli-5.2.12  The mysqli shared extension for php
qt4-mysql-plugin-4.4.3 Qt MySQL database plugin

Reinstallation proceeded as follows:
in /usr/ports/databases/mysql54-server ==>
make 'pager=more' 'prompt=mysql54' 'socket=/usr/tmp/mysql.sock'
'localstatedir=/disk02/db/mysql/DATA' 'with_linuxthreads=yes' 'with_ssl=yes'
install clean &

in /usr/ports/databases/mysql54-scripts ==>
make install clean

mysql client apparently installed as a dependency by the server

After compilation and installation
========================

Did the following:
[i]    /usr/local/bin/mysql_install_db       then
[ii]   /usr/local/bin/mysqld_safe &          first startup

Stdout ==>
[1] 37786
ax# 100110 07:05:36 mysqld_safe Logging to
'/disk02/db/mysql/DATA/ax.lall.com.err'.
100110 07:05:37 mysqld_safe Starting mysqld daemon with databases from
/disk02/db/mysql/DATA
100110 07:05:38 mysqld_safe mysqld from pid file
/disk02/db/mysql/DATA/ax.lall.com.pid ended

Now the err log from this is
100110 07:05:37 mysqld_safe Starting mysqld daemon with databases from
/disk02/db/mysql/DATA
100110  7:05:37 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100110  7:05:37 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Neither mutexes nor rw_locks use GCC atomic builtins.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100110  7:05:37  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100110  7:05:37  InnoDB: Log file ./ib_logfile0 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
100110  7:05:37  InnoDB: Log file ./ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100110  7:05:38 InnoDB Plugin 1.0.4 started; log sequence number 0
100110  7:05:38 [ERROR] /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
100110  7:05:38 [ERROR] Fatal error: Can't open and lock privilege tables:
Can't find file: './mysql/host.frm' (errno: 13)
100110 07:05:38 mysqld_safe mysqld from pid file
/disk02/db/mysql/DATA/ax.lall.com.pid ended

repeating the command produced ==>
100110 07:12:01 mysqld_safe Starting mysqld daemon with databases from
/disk02/db/mysql/DATA
100110  7:12:01 [Note] Plugin 'FEDERATED' is disabled.
/usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100110  7:12:01 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Neither mutexes nor rw_locks use GCC atomic builtins.
100110  7:12:01  InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 37356
100110  7:12:01  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 44244
100110  7:12:01  InnoDB: Starting an apply batch of log records to the
database...
InnoDB: Progress in percents: 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
100110  7:12:02 InnoDB Plugin 1.0.4 started; log sequence number 44244
100110  7:12:02 [ERROR] /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
100110  7:12:02 [ERROR] Fatal error: Can't open and lock privilege tables:
Can't find file: './mysql/host.frm' (errno: 13)
100110 07:12:02 mysqld_safe mysqld from pid file
/disk02/db/mysql/DATA/ax.lall.com.pid ended

RUNNING THE SUGGESTED UPGRADE AT "100110" ==>
# /usr/local/bin/mysql_upgrade
Looking for 'mysql' as: /usr/local/bin/mysql
Looking for 'mysqlcheck' as: /usr/local/bin/mysqlcheck
Running 'mysqlcheck with default connection arguments
/usr/local/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL
server through socket '/tmp/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed

Registered packages are now :

# pkg_info | grep mysql
bsdpan-DBD-mysql-4.013 DBD::mysql - MySQL driver for the Perl5 Database
Interface
mysql-client-5.4.3  Multithreaded SQL database (client)
mysql-scripts-5.4.3 Multithreaded SQL database (scripts)
mysql-server-5.4.3  Multithreaded SQL database (server)
php5-mysql-5.2.11_1 The mysql shared extension for php
php5-mysqli-5.2.12  The mysqli shared extension for php
qt4-mysql-plugin-4.4.3 Qt MySQL database plugin

WHAT THE ***bleep*** AM I DOING WRONG ?

-- 
View this message in context: http://old.nabble.com/Catastrophic-Installation-Failure-now%21-tp27100257p27100257.html
Sent from the freebsd-questions mailing list archive at Nabble.com.