Linux [Ubuntu Server] Mysql does not start at boot

G

Gaurish

ex-Mod
Hi,

I have a Ubuntu server running 10.04 LTS. Now the problem is after

every reboot I have to manually start mysql which is causing

lot of downtime:ashamed:

I tried chkconfig mysql on but it does not work

Anyone knows to get mysql to start automatically after reboot?
 
Code: 
[root@booo ~]# chkconfig --level 5 mysqld off

[root@booo ~]# chkconfig --list | grep mysql

mysqld          0:off   1:off   2:off   3:on    4:off   5:off   6:off

[root@booo ~]# chkconfig --level 5 mysqld on

[root@booo ~]# chkconfig --list | grep mysql

mysqld          0:off   1:off   2:off   3:on    4:off   5:on    6:off

[root@booo ~]#

I mean its mysqld not mysql. d for daemon.
 
Code: 
root@dev:~# chkconfig --level 5 mysqld off

mysqld: unknown service

root@dev:~# chkconfig --list | grep mysql

mysql                     0:off  1:off  2:on   3:on   4:on   5:on   6:off

root@dev:~# chkconfig --level 5 mysqld on

mysqld: unknown service
 
root@dev:~# chkconfig --list | grep mysql

mysql 0:eek:ff 1:eek:ff 2:eek:n 3:eek:n 4:eek:n 5:eek:n 6:eek:ff
Click to expand...

^so it means its already on. there should be some problem with your mysql installation. check ~/.my.cnf file to locate the log file and check for errors.
 
vishalrao said:
OT question @Gaurish: Where/what server do you have? I have a VPS @ lahsiv.net also running the same LTS :)
Click to expand...
I have a 512MB/1GB VPS from thrustvps.com. use it to host my personnel blog. You using amazon ec2?
 
Yes I'm using Amazon EC2 free options (micro instance) which are free for a year! :D

Running backups on to S3 (simple storage service 5gb) and EBS (elastic block storage 10gb) micro instances using the "backup_manager" script.

Got my website/blog etc (lahsiv.net) all running in there, and some friends have accounts there too.

All this controlled from a landscape.canonical.com free cloud command and control center :p
 
vishalrao said:
Yes I'm using Amazon EC2 free options (micro instance) which are free for a year! :D
Click to expand...

I am thinking of jumping the ship and switching to Amazon's free tier but need to find a VCC to do this

Running backups on to S3 (simple storage service 5gb) and EBS (elastic block storage 10gb) micro instances using the "backup_manager" script.
Click to expand...

Currently I am using Dropbox for the same. advantage is, it syncs backups on my personel computer as well. Quite Handy

Got my website/blog etc (lahsiv.net) all running in there, and some friends have accounts there too.
Click to expand...

Do you use a control panel like Cpanel or something Currently I am running it all bare which works very well for me but other method are scared of using command line.

All this controlled from a landscape.canonical.com free cloud command and control center :p
Click to expand...

Started using it but I don't find it useful for 1instance. maybe it does help when you have 100instances to maintain but single instance ssh works pretty well.

PS: Which firewall you use?
 
A few control panels here n there but mostly SSH based admin I do too :)

Firewall? Whats that? :p I have just disabled all/most services/ports, my system is WIDE OPEN for all you dirty hackers hehe (a.k.a. its a honeypot too) ! mwwwahahahahahaha!

--- Updated Post - Automerged ---

Note that I only pay for my VPS, all amazon services are free for one year.
 
vishalrao said:
A few control panels here n there but mostly SSH based admin I do too :)

Firewall? Whats that? :p I have just disabled all/most services/ports, my system is WIDE OPEN for all you dirty hackers hehe (a.k.a. its a honeypot too) ! mwwwahahahahahaha!
Click to expand...

What control panels?

Note that I only pay for my VPS, all amazon services are free for one year.
Click to expand...
Doesn't 750 hours of Amazon EC2 Linux Micro Instance comes bundled, then pay?
 
Sorry, my control panel information is top-secret, classified information for reasons of [strike]national[/strike], er, personal security. Meaning if I told you I would have to "kill -9" you :p

Yes, according to Amazon itself, if you run the micro instance 24x7 you still don't consume the free duration for one year! Do the math :D

So I have created a micro instance and booted it up and left it running... so effectively I have TWO VPSes :D
 
Back
Top