Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #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 online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,450
Thanks: 813
Thanked 5,218 Times in 4,090 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 online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,450
Thanks: 813
Thanked 5,218 Times in 4,090 Posts
Default

It is described in the Howto on page 5:

http://www.howtoforge.com/perfect_se...ndrake_10_2_p5
Reply With Quote
  #9  
Old 15th October 2005, 18:14
badben badben is offline
Senior Member
 
Join Date: Oct 2005
Location: Lancashire, UK
Posts: 103
Thanks: 0
Thanked 2 Times in 2 Posts
Default

oops.

Thanks

my bad

ben
__________________
Web Developer
Reply With Quote
  #10  
Old 20th December 2005, 08:22
Deepthi Deepthi is offline
Junior Member
 
Join Date: Dec 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
 
Question Internal Server Error

Ive installed Mysql and PERL in RHEL3 and while working with the Mozilla browser im getting this error message.
Even ive started service of mysqld and httpd........ They are working well.I've written my perl scripts in cgi-bin but im still getting this error.

"The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Apache/2.0.46 (Red Hat) Server at 127.0.0.1 Port 80"

Can anyone please help me? ill be thankful to you..........
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 11:06.


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