#1  
Old 25th August 2005, 17:10
iceberg iceberg is offline
Junior Member
 
Join Date: Aug 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL is not running!!

hi all, during installation i got this error

Code:
ERROR: MySQL is not running! Please start your MySQL database and run the ISPConfig setup again.
i am running MySQL server...

Code:
# service mysqld status
mysqld (pid 31869) is running...
and here...

Code:
# mysqladmin ping
mysqld is alive
So, any suggestions??
Thanks for reading
Reply With Quote
Sponsored Links
  #2  
Old 25th August 2005, 18:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Do you see MySQL when you run
Code:
netstat -tap
? MySQL has to run over TCP, not on local Unix sockets. To change that, edit /etc/my.cnf, comment out skip-networking and restart MySQL.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 25th August 2005, 18:16
iceberg iceberg is offline
Junior Member
 
Join Date: Aug 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i can't skip-networking in /etc/my.cnf. here is /etc/my.cnf

Code:
more /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with old and
# shorter password hash.
# Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Reply With Quote
  #4  
Old 25th August 2005, 18:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Can you post the output of
Code:
netstat -tap
here?

Quote:
i can't skip-networking in /etc/my.cnf. here is /etc/my.cnf
Depending on your distribution there might be further configuration files under /etc/sysconfig or /etc/default.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 25th August 2005, 18:36
iceberg iceberg is offline
Junior Member
 
Join Date: Aug 2005
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, i figured it out
Reply With Quote
  #6  
Old 22nd November 2005, 15:07
Avatar Avatar is offline
Junior Member
 
Join Date: Nov 2005
Location: Remscheid / NRW / Germany
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to Avatar
Default

Since I upgraded ISPConfig from 2.1.0 to 2.1.1 today, I get an error by eMail that mysql is not running, every half an hour. But mysql IS running:

Code:
# netstat -tap
tcp        0      0 server.domain:mysql  *:*                     LISTEN     2446/mysqld
I also don't have an "skip-networking" option in my my.cnf, but the new way of binding to localhost isn't active, too:

Code:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 123.456.789.10
The my.cnf seems to be touched during the installation, but I cannot see any changes. I already rebootet the server. No results, I still get the mail.

It's a debian 3.1 distribution.

What can I do?
--
Best regards...
Ace
Reply With Quote
  #7  
Old 2nd January 2008, 04:00
bassplayer bassplayer is offline
Junior Member
 
Join Date: Jan 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default mysql not runing during install

I use fresh install Redhat 9.0
during install it says MySQL not running,
my> netstat -tap
tcp 0 0 *:mysql *:* LISTEN 2997/

my /etc/mycnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

BTW, i dont see php-mysql on my instalation, i cannot find in redhat9 disc,
is it the problem.
thanks in advance.
Reply With Quote
  #8  
Old 2nd January 2008, 22:31
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Is there a special reason why you're using such an old distribution? I suggest you try Fedora 8 or CentOS 5.1 instead.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 3rd January 2008, 01:56
bassplayer bassplayer is offline
Junior Member
 
Join Date: Jan 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Falko,
I use Old Computer, PIII 500Mhz, 192Mhz Memory, 20GB Hdd
thats the reason I use RedHat9, I'm Thinking to use CentOS 4.2
But I'm Affraid the Computer didnot met the requirement,
Please advice,
Thanks for the quick reply.
Regards,
Reply With Quote
  #10  
Old 3rd January 2008, 15:10
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

If you want to use it as a server, I suggest that you try Debian Etch. IT should work well on your hardware.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error in Mysql pontifex Installation/Configuration 4 26th April 2006 09:31
Mysql ejs Installation/Configuration 5 12th August 2005 07:01
Error in Instalation (mysql header) juampi Installation/Configuration 2 5th August 2005 22:37
MySQL Privileges mcfly Server Operation 4 26th May 2005 19:00
MySQL support in PHP tobi Installation/Configuration 3 2nd May 2005 22:20


All times are GMT +2. The time now is 00:01.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.