| View previous topic :: View next topic |
| Author |
Message |
martindv
Apprentice
Joined: 16 Jul 2005
Posts: 171
Location: Argentina
|
 Posted: Sat Nov 18, 2006 12:11 pm Post subject: MySql doesnt start |
 |
|
Hi Guys,
I've installed MySql from portage on an old box i have. Everything seem to went fine until y tryed to start mysql via /etc/init.d script..
when i try tu run the script i get the following message:
| Code: | Servtoo mysql # /etc/init.d/mysql start
* Starting mysql ...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0)
Servtoo mysql # |
its wired cause i think i have all conf. files well configured. and although i have that error message the deamon starts without problem...
thats the message that i receive when i try to restart the deamon after try to start it
| Code: | Servtoo mysql # /etc/init.d/mysql restart
* Starting mysql ...
* "/var/run/mysqld/mysqld.pid" is still present and the process is running.
* Please stop it "kill 14851" maybe ? [ !! ]
Servtoo mysql #
|
im completelly lost with this.... and i really mysql to run from the script, cause this fail is causing that i cant run apache2 from script either.
please if you have a clue let me know.
Thanks in advance.
_________________
Gentoo Rulez
AMD Athlon XP 2800+ @2.08Ghz
Asus A7V8NX-E-Deluxe
Nvidia Nforce2 chipset
1GB Ram
ASUS GeForce N6600 256MB RAM
2 IDE HDDS @Primary/Secondary Master
1 120GB HDD @Sata Channel #0 |
|
| Back to top |
|
 |
scoon
l33t
Joined: 23 Aug 2003
Posts: 747
Location: Philadelphia, PA
|
| Posted: Sat Nov 18, 2006 12:38 pm Post subject: |
|
|
Hey there,
| Code: | | /etc/init.d/mysql zap |
should fix you right up.
-scoon
_________________
Hope this helps........ |
|
| Back to top |
|
|
logics
n00b
Joined: 05 May 2004
Posts: 6
|
| Posted: Tue Nov 21, 2006 5:04 pm Post subject: Re: MySql doesnt start |
|
|
| martindv wrote: | Hi Guys,
I've installed MySql from portage on an old box i have. Everything seem to went fine until y tryed to start mysql via /etc/init.d script..
when i try tu run the script i get the following message:
| Code: | Servtoo mysql # /etc/init.d/mysql start
* Starting mysql ...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0)
Servtoo mysql # |
|
I was having the same problem here; so... I uncommented DEBUG=4 in /etc/conf.d/mysql and that output looked like it should be working. I saw how it was trying to launch mysqld, so figured I'd give it a whirl.
I ran /usr/sbin/mysqld manually at the shell and saw the following:
| Code: |
$ /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
061121 8:41:51 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_buffer_pool_size=16M'
|
More meat to search for  There was one thread that mentioned how a user was trying to enable innodb (they had explicitly added it as a USE flag, etc.) but was seeing the same failure; which led me to believe that perhaps my configuration didn't have, nor want innodb, but the configuration was bad...
So, I looked in /etc/conf.d/my.cnf and sure enough innodb has lots of things defined. I don't know what innodb is, but I know I don't have the USE flag set for it -- so mysql shouldn't be using it (I would think). So I commented all of those usages out of my.cnf and wha-la... mysql now starts. Happy camper.
You can cheat and use this to edit out innodb variables:
| Code: |
$ sed -i -e "s:^innodb:#innodb:g" -e "s:^\(set-variable.*innodb\):#\1:g" -e "s:skip_innodb:#skip_innodb:g" /etc/mysql/my.cnf
|
Hopefully it will work for you as it did for me... my network is now back up and my users are happy again. If it didn't work, and you're still having problems, perhaps running mysqld manually will give you more output to hunt on.
James
_________________
ipw2100 & ipw2200 developer / ipw3945 developer & maintainer
irc.freenode.net #ipw2100 - http://ipw3945.sf.net - http://bughost.org/repos/ |
|
| Back to top |
|
|
supermihi
Guru
Joined: 09 Feb 2005
Posts: 348
|
| Posted: Mon Mar 19, 2007 1:10 pm Post subject: |
|
|
Thanks - I had the same problem, and this thread helped me to fix it. Btw, please mark the topic as "[SOLVED]".
Edit: If anyone has the same issue: You don't have to comment out every innodb-related stuff in my.cnf, it's enough to just uncomment the "skip-innodb" line; mysql then ignores everything else related to innodb.
_________________
"You may say I'm a dreamer, but I'm not the only one." |
|
| Back to top |
|
|
fbcyborg
Advocate
Joined: 16 Oct 2005
Posts: 3056
Location: ROMA
|
|
| Back to top |
|
|
oc666
Guru
Joined: 15 May 2006
Posts: 330
Location: Israel
|
|
| Back to top |
|
|
|
Other Things Gentoo
