DaemonForums  

Go Back   DaemonForums > OpenBSD > OpenBSD Packages and Ports

OpenBSD Packages and Ports Installation and upgrading of packages and ports on OpenBSD.

Reply
 
Thread Tools Display Modes
  #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
  #2   (View Single Post)  
Old 27th July 2013
jggimi's Avatar
jggimi jggimi is offline
More noise than signal
 
Join Date: May 2008
Location: USA
Posts: 8,020
Default

Hello, and welcome!
Quote:
Originally Posted by vigidr View Post
... I just found out that folder /var/mysql didn't exist...
Instructions for initial setup of your database are contained in the directory /usr/local/share/doc/pkg-readmes
-- at install time, you missed a message from pkg_add(1) pointing you to this critical documentation.
Reply With Quote
  #3   (View Single Post)  
Old 27th July 2013
vigidr vigidr is offline
New User
 
Join Date: Jul 2013
Posts: 2
Default

Quote:
Originally Posted by jggimi View Post
at install time, you missed a message from pkg_add(1) pointing you to this critical documentation.
Oh, that's correct. Thank you so much! This hint was great and helpfull. And now it's running. Solved!
Reply With Quote
Reply

Tags
installation, mysqld, openbsd 5.3

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems after fresh OpenBSD installation Destorni OpenBSD General 7 22nd March 2013 07:18 PM
fresh install require file flags schg assigned to dir or files? dbach OpenBSD Security 4 1st May 2012 05:50 PM
Doing a fresh install - what to save? Bruco FreeBSD General 4 30th May 2009 01:49 PM
Can't Print (Fresh First Time install) BSD newb Xero FreeBSD Installation and Upgrading 4 15th February 2009 07:11 PM
How do I skip format on some partitions in a fresh install? Quaxo OpenBSD Installation and Upgrading 9 25th June 2008 07:57 PM


All times are GMT. The time now is 07:13 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content copyright © 2007-2010, the authors
Daemon image copyright ©1988, Marshall Kirk McKusick