Nokia C3: Unable to start MySQL by using Upstart on Lucid

Unable to start MySQL by using Upstart on Lucid
I don’t know why MySql is not running after booting of Lucid. However can manually start by using below mentioned command
Code:

sudo -u mysql mysqld

however when I am trying to use Upstart I got below mentioned error message.
Quote:
dom@mythbox:~$ start mysql
start: Rejected send message, 1 matched rules; type="method_call", sender=":1.51" (uid=1000 pid=3891 comm="start) interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply=0 destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init"))
Let me know if you are having any idea to resolve the matter will be appreciated. Thanks a lot in advance.
Reply With Quote
#2
Old 31-03-2012
Agavoli Agavoli is offline
Member

Join Date: Jul 2011
Posts: 287
Re: Unable to start MySQL by using Upstart on Lucid
I think you need to start MySQL by using below mentioned commands.
Code:

sudo service mysql restart

or
Code:

sudo service mysql start

Reply With Quote
#3
Old 31-03-2012
Jessalyn Jessalyn is offline
Member

Join Date: Jul 2011
Posts: 253
Re: Unable to start MySQL by using Upstart on Lucid
after going through mysqld upstart job at /etc/init/mysqld.conf and you will be see ‘start on (net-device-up’. Mysql is configure to bind with a specific address and it fails to begin if network interface does not seems to be up. I recommend that you should update mysqld upstart job to ‘start on (net-device-up IFACE=ethX’ to start mysqld only when correct interface is up.
Reply With Quote
#4
Old 03-04-2012
DakshaMira DakshaMira is offline
Member

Join Date: Aug 2011
Posts: 303
Re: Unable to start MySQL by using Upstart on Lucid
You should browse to /etc/init/mysql.conf.
Here you have to edit
Code:

# MySQL Service

Code:

description "MySQL Server"
author "Mario Limonciello "

start on (net-device-up
and local-filesystems
and runlevel [2345])
stop on runlevel [016]

respawn

make sure that there should be space after the term ‘runlevel’.