View Single Post
  #1   (View Single Post)  
Old 27th July 2013
vigidr vigidr is offline
New User
 
Join Date: Jul 2013
Posts: 2
Default OpenBSD 5.3 fresh install - mysql does not run

Hi everyone,

I've an issue with my fresh installed OpenBSD 5.3 (VM). I tried to install PHP FastCGI and MySQL-Server. Anyhow PHP runs properly with built-in nginx together. But mysqld doesn't want to start right.

After installing all packages you have to change password of root user in mysql. Well, I'd like to do that, but MySQL has to start before. If I try this I get the following:

Code:
# /etc/rc.d/mysqld -d start
doing rc_read_runfile
doing rc_check
mysqld
doing rc_start
doing rc_wait start
doing rc_check
130727 11:47:07 mysqld_safe Logging to '/var/mysql/devilbox.local.err'.
doing rc_check
130727 11:47:08 mysqld_safe Starting mysqld daemon with databases from /var/mysql
130727 11:47:09 mysqld_safe mysqld from pid file /var/mysql/devilbox.local.pid ended
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_check
doing rc_rm_runfile
(failed)
Now, that's a better output than the first one where I just found out that folder /var/mysql didn't exist at all. So I had to mkdir /var/mysql manually to get an error log. And this says the following:
Code:
# cat /var/mysql/devilbox.local.err
130727 11:45:19 mysqld_safe Starting mysqld daemon with databases from /var/mysql
130727 11:45:19 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
 /usr/local/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
130727 11:45:20 [ERROR] Aborting

130727 11:45:20 [Note] /usr/local/libexec/mysqld: Shutdown complete

130727 11:45:20 mysqld_safe mysqld from pid file /var/mysql/devilbox.local.pid ended
130727 11:47:08 mysqld_safe Starting mysqld daemon with databases from /var/mysql
130727 11:47:09 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
 /usr/local/libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)
130727 11:47:09 [ERROR] Aborting

130727 11:47:09 [Note] /usr/local/libexec/mysqld: Shutdown complete

130727 11:47:09 mysqld_safe mysqld from pid file /var/mysql/devilbox.local.pid ended
Remember: It's a very fresh installation of OpenBSD (newest version) and installing all packets using pkg_add command.

So I wonder why a fresh installed mysqld doesn't run. And I don't understand what's the problem. My questions are:
  1. Does anyone else faces these problems?
  2. Does anyone know how to fix it?
Many thanks and regards
vigidr
Reply With Quote