FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Debian > Debian User

 
 
LinkBack Thread Tools
 
Old 09-22-2012, 09:16 AM
rudu
 
Default mysqld fails to start at boot time only

Hi,
Running wheezy on my laptop.
I can glimpse while booting a message :
Starting MySQL database server: mysqld ...... Failed!

Indeed a command "ps aux | grep mysql " at the end of the boot returns
nothing.

But I can start it with "service mysql start" ok.

/var/log/mysql.err and mysql.log are empty.
dmesg | grep -i mysql returns nothing

I'm at a loss here.
Anybody sees how I could get mysql to be fired up at boot time ?

TIA
Jean-Marc


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Archive: 505D81E2.2010703@cegetel.net">http://lists.debian.org/505D81E2.2010703@cegetel.net
 
Old 09-22-2012, 01:10 PM
hvw59601
 
Default mysqld fails to start at boot time only

rudu wrote:

Hi,
Running wheezy on my laptop.
I can glimpse while booting a message :
Starting MySQL database server: mysqld ...... Failed!

Indeed a command "ps aux | grep mysql " at the end of the boot returns
nothing.

But I can start it with "service mysql start" ok.

/var/log/mysql.err and mysql.log are empty.
dmesg | grep -i mysql returns nothing

I'm at a loss here.
Anybody sees how I could get mysql to be fired up at boot time ?



Install bootlogd and examine /var/log/boot to see why mysqld failed.

Hugo


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Archive: http://lists.debian.org/k3kdcg$nll$1@ger.gmane.org
 
Old 09-22-2012, 01:22 PM
Camaleón
 
Default mysqld fails to start at boot time only

On Sat, 22 Sep 2012 11:16:18 +0200, rudu wrote:

> Running wheezy on my laptop.
> I can glimpse while booting a message : Starting MySQL database server:
> mysqld ...... Failed!
>
> Indeed a command "ps aux | grep mysql " at the end of the boot returns
> nothing.
> But I can start it with "service mysql start" ok.
>
> /var/log/mysql.err and mysql.log are empty. dmesg | grep -i mysql
> returns nothing
>
> I'm at a loss here.
> Anybody sees how I could get mysql to be fired up at boot time ?

Mmm... a wild guess but what packages do you have installed?

dpkg -l | grep -i mysql

Greetings,

--
Camaleón


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: http://lists.debian.org/k3ke1u$mv$7@ger.gmane.org
 
Old 09-22-2012, 01:23 PM
rudu
 
Default mysqld fails to start at boot time only

Le 22/09/2012 13:51, Avi Greenbury a écrit :

rudu wrote:

Hi,
Running wheezy on my laptop.
I can glimpse while booting a message :
Starting MySQL database server: mysqld ...... Failed!

Indeed a command "ps aux | grep mysql " at the end of the boot
returns nothing.
But I can start it with "service mysql start" ok.

/var/log/mysql.err and mysql.log are empty.
dmesg | grep -i mysql returns nothing

I'm at a loss here.
Anybody sees how I could get mysql to be fired up at boot time ?


You want to be checking syslog, since that's where MySQL's startup
messages go. Does it fail on *every* boot, and succeed on *every*
manual start?



Hi Avi, thanks.(Posting back on the list)

Well it seems a little bit clearer now.

# cat /var/log/syslog | grep -i mysql | tail -n 30
Sep 22 15:06:12 ubajm mysqld:
Sep 22 15:06:12 ubajm mysqld_safe: mysqld from pid file
/var/run/mysqld/mysqld.pid ended
Sep 22 15:07:22 ubajm mysqld_safe: Starting mysqld daemon with databases
from /var/lib/mysql
Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 [Note] Plugin 'FEDERATED'
is disabled.
Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 InnoDB: The InnoDB memory
heap is disabled
Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 InnoDB: Mutexes and
rw_locks use GCC atomic builtins
Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 InnoDB: Compressed tables
use zlib 1.2.3

Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 InnoDB: Using Linux native AIO
Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 InnoDB: Initializing
buffer pool, size = 128.0M
Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 InnoDB: Completed
initialization of buffer pool
Sep 22 15:07:22 ubajm mysqld: 120922 15:07:22 InnoDB: highest supported
file format is Barracuda.
Sep 22 15:07:23 ubajm mysqld: 120922 15:07:23 InnoDB: Waiting for the
background threads to start
Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 InnoDB: 1.1.8 started; log
sequence number 33023319
Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 [Note] Server hostname
(bind-address): '192.168.1.60'; port: 3306
Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 [Note] - '192.168.1.60'
resolves to '192.168.1.60';
Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 [Note] Server socket
created on IP: '192.168.1.60'.
Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 [ERROR] Can't start
server: Bind on TCP/IP port: Cannot assign requested address
Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 [ERROR] Do you already
have another mysqld server running on port: 3306 ?

Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 [ERROR] Aborting
Sep 22 15:07:24 ubajm mysqld:
Sep 22 15:07:24 ubajm mysqld: 120922 15:07:24 InnoDB: Starting shutdown...
Sep 22 15:07:25 ubajm mysqld: 120922 15:07:25 InnoDB: Shutdown
completed; log sequence number 33023319
Sep 22 15:07:25 ubajm mysqld: 120922 15:07:25 [Note] /usr/sbin/mysqld:
Shutdown complete

Sep 22 15:07:25 ubajm mysqld:
Sep 22 15:07:25 ubajm mysqld_safe: mysqld from pid file
/var/run/mysqld/mysqld.pid ended
Sep 22 15:07:35 ubajm /etc/init.d/mysql[3333]: 0 processes alive and
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 22 15:07:35 ubajm /etc/init.d/mysql[3333]: #007/usr/bin/mysqladmin:
connect to server at 'localhost' failed
Sep 22 15:07:35 ubajm /etc/init.d/mysql[3333]: error: 'Can't connect to
local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 22 15:07:35 ubajm /etc/init.d/mysql[3333]: Check that mysqld is
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

Sep 22 15:07:35 ubajm /etc/init.d/mysql[3333]:

What I'm understanding here is that my laptop hasn't got his IP address
yet when mysqld tries to initialize itself ...

Am I right ?
If so, what should I do ?

Jean-Marc


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Archive: 505DBBC2.5070103@cegetel.net">http://lists.debian.org/505DBBC2.5070103@cegetel.net
 
Old 09-23-2012, 03:54 AM
Jude DaShiell
 
Default mysqld fails to start at boot time only

Please check firewall settings and enable port 3306 if a firewall is
installed on that box. If not, then discard this message as being
unhelpful.

---------------------------------------------------------------------------
jude <jdashiel@shellworld.net>
Adobe fiend for failing to Flash



--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: alpine.BSF.2.01.1209222352520.74944@freire1.furyyj beyq.arg">http://lists.debian.org/alpine.BSF.2.01.1209222352520.74944@freire1.furyyj beyq.arg
 
Old 09-23-2012, 03:57 AM
Jude DaShiell
 
Default mysqld fails to start at boot time only

Alternatively in /etc/my.cnf comment all socket= lines and uncomment skip
networking line. This will mean no more external access to mysql though
if you do it but is more secure for those that like it that way.

---------------------------------------------------------------------------
jude <jdashiel@shellworld.net>
Adobe fiend for failing to Flash



--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: alpine.BSF.2.01.1209222355450.74944@freire1.furyyj beyq.arg">http://lists.debian.org/alpine.BSF.2.01.1209222355450.74944@freire1.furyyj beyq.arg
 
Old 09-23-2012, 02:07 PM
hvw59601
 
Default mysqld fails to start at boot time only

Jude DaShiell wrote:
Alternatively in /etc/my.cnf comment all socket= lines and uncomment skip
networking line. This will mean no more external access to mysql though
if you do it but is more secure for those that like it that way.




I think that should be /etc/mysql/my.cnf

Hugo


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Archive: http://lists.debian.org/k3n534$tg7$1@ger.gmane.org
 
Old 09-27-2012, 09:54 AM
rudu
 
Default mysqld fails to start at boot time only

I finally found a workaround.
I commented out the line 'bind-address = ...' in /etc/mysql/my.cnf
Now everything works as expected.

Thanks for your input.
JM


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Archive: 50642251.80200@cegetel.net">http://lists.debian.org/50642251.80200@cegetel.net
 

Thread Tools




All times are GMT. The time now is 03:40 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright ©2007 - 2008, www.linux-archive.org