#1  
Old 15th October 2005, 16:10
badben badben is offline
Senior Member
 
Join Date: Oct 2005
Location: Lancashire, UK
Posts: 103
Thanks: 0
Thanked 2 Times in 2 Posts
Default MySQL problem on install

The install keeps stopping just after choosing the installation mode.

It says that MySQl is not started and stops.

However just before I started the setup process I started all the programs including mysql.

I did notice though that mysql started fine using /etc/init.d/mysqld start
though restart would not work using /etc/init.d/mysqld resart
.. it would stop but not start - it timed out.
I could start it again using /etc/init.d/mysqld start though.

What could be the problem?

I am using Mandrake and followed the setup instructions for the perfect setup.

Ben
Reply With Quote
Sponsored Links
  #2  
Old 15th October 2005, 16:23
themachine themachine is offline
Senior Member
 
Join Date: Oct 2005
Location: Texas, USA
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Default Errors and Logs?

Can you actually verify that mysql is running?

# ps aux | grep mysql


Can you connect to the mysql server? (might be able to just use 'mysql' without any flags if you haven't set a root password)

# host01:/# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1360 to server version: 4.0.24_Debian-10sarge1-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


If not, then I'd check the log files. I'm not familiar with mandrake, but standard places would be /var/log/messages, /var/log/syslog, /var/log/mysql.err, /var/log/mysql.log, /var/log/mysql/*, etc.

see if there are any entries related to mysql after starting it, stopping it, restarting it ... what have you.

If you find any errors please post them.
Reply With Quote
  #3  
Old 15th October 2005, 17:08
badben badben is offline
Senior Member
 
Join Date: Oct 2005
Location: Lancashire, UK
Posts: 103
Thanks: 0
Thanked 2 Times in 2 Posts
Default

This is what I got when I tried

# ps aux | grep mysql

What does that mean?

[root@tidy-hosting install_ispconfig]# ps aux | grep mysql
root 10351 0.0 0.4 2184 1140 ? S 16:04 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/my.cnf --skip-networking --pid-file=/var/run/mysqld/mysqld.pid
mysql 10389 0.2 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10393 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10394 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10395 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10396 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10397 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10398 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10399 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10400 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10401 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
mysql 10402 0.0 6.7 65696 17596 ? S 16:04 0:00 /usr/sbin/mysqld --defaults-file=/etc/my.cnf --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --socket=/var/lib/mysql/mysql.sock --skip-networking
root 10940 0.0 0.1 1648 488 pts/3 R+ 16:05 0:00 grep mysql
Reply With Quote
  #4  
Old 15th October 2005, 17:11
badben badben is offline
Senior Member
 
Join Date: Oct 2005
Location: Lancashire, UK
Posts: 103
Thanks: 0
Thanked 2 Times in 2 Posts
Default

when I try to run mysql with

mysql -u root -p

everything seems ok and it lets me in.

Ben
__________________
Web Developer
Reply With Quote
  #5  
Old 15th October 2005, 17:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

Have you removed skip-networking in the mysql configuration file (my.cnf) and then restarted mysql?
Reply With Quote
  #6  
Old 15th October 2005, 17:22
badben badben is offline
Senior Member
 
Join Date: Oct 2005
Location: Lancashire, UK
Posts: 103
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Where is the file my.cnf?

I appologise for my ignorance.

I am a very novice linux user (i.e. I have no experience except for yesterday and today whatsoever in linux)
__________________
Web Developer
Reply With Quote
  #7  
Old 15th October 2005, 17:47
badben badben is offline
Senior Member
 
Join Date: Oct 2005
Location: Lancashire, UK
Posts: 103
Thanks: 0
Thanked 2 Times in 2 Posts
Default

... and how do I remove skip-networking? ( I have found my.cnf)

There is no mention of skip-networking in the file when I looked at it.

thanks ben

Last edited by badben; 15th October 2005 at 17:49. Reason: found new problem
Reply With Quote
  #8  
Old 15th October 2005, 17:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
Default

It is described in the Howto on page 5:

http://www.howtoforge.com/perfect_se...ndrake_10_2_p5
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
Fedora Core 4 and hp Printer install problem. slopoke_iii Desktop Operation 3 5th May 2007 22:27
MySQL connection problem cartdev Installation/Configuration 17 17th November 2005 22:30
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37
Mysql Problem Adding adamluz General 2 20th September 2005 09:33
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41


All times are GMT +2. The time now is 06:03.


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