Problems with starting MySQL server for Media Wiki

OrangeSuse · September 23, 2009, 2:14pm

I try to install the media wiki on an webserver. I’ve installed all components I need. before intallation of de media wiki, the wiki gives me this status rapport:

"*# PHP 5.2.9 installed

Found database drivers for: MySQL PostgreSQL SQLite

PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title)

Have XML / Latin1-UTF-8 conversion support.

Session save path (/var/lib/php5) appears to be valid.

PHP’s memory_limit is 128M.

Couldn’t find Turck MMCache, eAccelerator, APC or XCache; cannot use these for object caching.

Found GNU diff3: /usr/bin/diff3.

Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads.

Found GD graphics library built-in.

Installation directory: /srv/www/htdocs/mediawiki

Script URI path: /mediawiki

Installing MediaWiki with php file extensions

Environment checked. You can install MediaWiki.*"

But the media wiki can’t connect to te webserver.
"#* Database type: MySQL

Loading class: DatabaseMysql

Attempting to connect to database server as root…failed with error [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)*."

I’ve initialized the grant tables:

linux-zbz3:/home/awo # cd /usr/bin


linux-zbz3:/usr/bin # ./mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h linux-zbz3.site password 'new-password'

Alternatively you can run:
/usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
linux-zbz3:/usr/bin #

But I get this error while startin the MySQL server:

linux-zbz3:/usr/bin # mysqld_safe awo=mysql &
[1] 13639
linux-zbz3:/usr/bin # nohup: invoer genegeerd en stderr gaat naar stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/linux-zbz3.site.pid
090923 14:12:46  mysqld ended

How can I solve this?

hcvv · September 23, 2009, 2:30pm

Your environment might be completely different (I do not have media Wiki), but my mySQL is started via YaST > syem > System services (runlevel).

vodoo · September 23, 2009, 2:37pm

First of all: the proper way to start the MySQL server is from yast or as root on the command line:

prompt# rcmysql start

The argument may be stop or status as well. Then try:

prompt> mysqladmin ping

and it should say ‘mysqld is alive’. If not please have a look at the mysql error log. You find it in /var/lib/mysql and it has a filename ending in *.err

Please post the end of this file where it says why mysql could not start.

OrangeSuse · September 23, 2009, 2:54pm

@hcw: When I try to start MySQL with Yast, I receive this error:
“/etc/init.d/mysql start retourneerde 1 (niet gespecificeerde foutmelding):”

translation:

“/etc/init.d/mysql start returned 1 (not specified error):”

@vodoo

linux-zbz3:~ # prompt# rcmysql start
bash: prompt#: command not found

or do you mean:

linux-zbz3:~ # rcmysql start
Updating MySQL privilege database... 
Looking for 'mysql' in: /usr/bin/mysql
Looking for 'mysqlcheck' in: /usr/bin/mysqlcheck
Running 'mysqlcheck'...
Running 'mysql_fix_privilege_tables'...
ERROR 1005 (HY000) at line 8: Can't create table 'db' (errno: 13)
ERROR 1005 (HY000) at line 13: Can't create table 'host' (errno: 13)
ERROR 1005 (HY000) at line 16: Can't create table 'user' (errno: 13)
ERROR 1005 (HY000) at line 22: Can't create table 'func' (errno: 13)
ERROR 1005 (HY000) at line 25: Can't create table 'tables_priv' (errno: 13)
ERROR 1005 (HY000) at line 27: Can't create table 'columns_priv' (errno: 13)
ERROR 1005 (HY000) at line 30: Can't create table 'help_topic' (errno: 13)
ERROR 1005 (HY000) at line 33: Can't create table 'help_category' (errno: 13)
ERROR 1005 (HY000) at line 36: Can't create table 'help_relation' (errno: 13)
ERROR 1005 (HY000) at line 39: Can't create table 'help_keyword' (errno: 13)
ERROR 1005 (HY000) at line 42: Can't create table 'time_zone_name' (errno: 13)
ERROR 1005 (HY000) at line 45: Can't create table 'time_zone' (errno: 13)
ERROR 1005 (HY000) at line 48: Can't create table 'time_zone_transition' (errno: 13)
ERROR 1005 (HY000) at line 51: Can't create table 'time_zone_transition_type' (errno: 13)
ERROR 1005 (HY000) at line 54: Can't create table 'time_zone_leap_second' (errno: 13)
ERROR 1005 (HY000) at line 57: Can't create table 'proc' (errno: 13)
ERROR 1005 (HY000) at line 60: Can't create table 'procs_priv' (errno: 13)
ERROR 1017 (HY000) at line 76: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 80: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 82: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 83: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 84: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 87: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 88: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 89: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 95: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 100: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 106: Can't find file: './mysql/tables_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 109: Can't find file: './mysql/tables_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 118: Can't find file: './mysql/tables_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 132: Can't find file: './mysql/columns_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 136: Can't find file: './mysql/columns_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 146: Can't find file: './mysql/columns_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 154: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 162: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 164: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 175: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 181: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 191: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 194: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 198: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 201: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 202: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 203: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 204: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 208: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 212: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 237: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 242: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 256: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 260: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 274: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 276: Can't find file: './mysql/func.frm' (errno: 13)
ERROR 1017 (HY000) at line 283: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 288: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 289: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 291: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 292: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 294: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 295: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 300: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 301: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 303: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 304: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 306: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 307: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 312: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 318: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 323: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 324: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 326: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 327: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 329: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 330: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 335: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 336: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 338: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 339: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 341: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 342: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 344: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 345: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 347: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 348: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 353: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 354: Can't find file: './mysql/db.frm' (errno: 13)
ERROR 1017 (HY000) at line 355: Can't find file: './mysql/host.frm' (errno: 13)
ERROR 1017 (HY000) at line 360: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 367: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 369: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 370: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 371: Can't find file: './mysql/user.frm' (errno: 13)
ERROR 1017 (HY000) at line 379: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 383: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 387: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 391: Can't find file: './mysql/procs_priv.frm' (errno: 13)
ERROR 1017 (HY000) at line 399: Can't find file: './mysql/proc.frm' (errno: 13)
ERROR 1017 (HY000) at line 443: Can't find file: './mysql/proc.frm' (errno: 13)
ERROR 1017 (HY000) at line 445: Can't find file: './mysql/proc.frm' (errno: 13)
FATAL ERROR: Upgrade failed

And I’ve no fille *.err…
There are 5 files:
ibdata1
ib_logfile0
ib_logfile1
mysql.log
.run-mysql_upgrade

vodoo · September 23, 2009, 3:54pm

I see. Something is completely broken. How did you install mysql? And what distro are you using?

Please have a look what the permissions are for /var/lib/mysql

ls -ld /var/lib/mysql

And what is the output of

df -l

mysqld should be started as user ‘mysql’ and group ‘mysql’. Please check that these exist.

vodoo · September 23, 2009, 4:16pm

Looking at your initial post again I’m quite sure that you messed things up. You did run ‘mysql_install_db’ as user root with no arguments, didn’t you? When run manually it must have some arguments like this:

mysql_install_db --user=mysql --datadir=/var/lib/mysql

Yast would have taken care of this, but you created /var/lib/mysql with user privileges of root. MySQL can no longer write to this directory. (bummer)

As you have not yet any data you can restart from the beginning. Remove /var/lib/mysql like this (as root)

rm -rf /var/lib/mysql

and then go to yast and enable mysql. Good luck!

OrangeSuse · September 23, 2009, 8:02pm

MySQL works!

I’ve delete the folder /var/lib/mysql
I’ve reinstalled MySQL and MySQL components
After that I’ve used the following commands:

mysql_install_db --user=mysql --datadir=/var/lib/mysql

rcmysql start

awo@linux-zbz3:~> mysqladmin ping
mysqld is alive

And it works now. Thanks!

vodoo · September 24, 2009, 2:52pm

I’m glad it works for you. BTW, step 2 would have taken care of step 1 automagically. And simply activating mysql from yast takes care of everything (except adding a password for root).