Koozali.org: home of the SME Server

MySQL won't start

Netrunner

MySQL won't start
« on: March 21, 2005, 02:42:26 PM »
Hello everybody.
I just upgraded mysql to version 4 (on a sme 6.01 installation) as in the how-tos found on this site. Got a few errors in the templates customization part but the installation of the rpms went ok.
Now mysql works only if i start it from command line (using obviously mysqld_safe) but it is kind of a hassle to have to start it manually everytime...
Anybody got an idea on how to make SME start it automatically? i am a total noobie as of templates :P

Thanks in advance for your help
NeT :pint:

Offline arne

  • *****
  • 1,116
  • +0/-4
MySQL won't start
« Reply #1 on: March 21, 2005, 06:18:33 PM »
If I like to make som small "cheating" I just put some cmmands in the end of the /etc/rc.local file. (This is normally the last script that is executet during a Linux boot/start up.)

Well I guess that this is not the way it "should" be done on a sme server, but I believe it can work.

If anybody has a more "correct" solution, plase leave a msg.
......

Offline jackl

  • ****
  • 136
  • +0/-0
MySQL won't start
« Reply #2 on: March 22, 2005, 01:40:49 AM »
Hi Netrunner,

There should be a symbolic link in the folder /etc/rc7.d that points to /etc/init.d/mysqld this will start mysql on boot up. The sym link filename on my system is S90mysqld....  "S" is for start and the number 90 determines the link run order in the rc7.d folder. If you have no sym link look in /etc/rc5.d and copy the one there to /etc/rc7.d, this should save you time if you cannot create the link yourself.

Regards
Jack

ps the number "7" in the rc7 refers to the run level and inserting a "K" instead of an "S" in the symlink name will kill a process.
......

Offline raem

  • *
  • 3,972
  • +4/-0
MySQL won't start
« Reply #3 on: March 22, 2005, 01:53:09 AM »
ln -s /etc/rc.d/init.d/mysql /etc/rc.d/rc7.d/S90mysqld

from
http://mirror.contribs.org/smeserver/contribs/rmitchell/smeserver/howto/MYSQL%20update%20to%20v4%20HOWTO%20for%20sme%20server.htm

There are quite a few HOWTOs for mysql floating around.
...

Netrunner

MySQL won't start
« Reply #4 on: March 24, 2005, 03:51:07 PM »
Thanks guys. I guess The symbolic link was pointing to another directory... it was marked in red. Now I fixed it :)
Thanks again for yourhelp
NeT