#1  
Old 2nd January 2006, 20:47
zalo zalo is offline
Member
 
Join Date: Jan 2006
Posts: 33
Thanks: 7
Thanked 0 Times in 0 Posts
Question Mysql error (2005)

Hello

I`m getting this error every time i try to run the install script. Does anybody know what is causing this error or how to fix it??


Mandriva 2006
--------------------------------------------------------------------------
for d in uudeview.1 uuenview.1 xdeview.1 ; do \
./install-sh -c -m 644 ./man/$d /home/admispconfig/ispconfig/tools/uudeview/man/man1/$d ; \
done
All prerequisites are fulfilled.
Here we go...
Please enter your MySQL server:localhost
Please enter your MySQL user:ispconfig
Please enter your MySQL password:
ERROR 2005 (HY000): Unknown MySQL server host ' localhost' (2)
ERROR: The provided MySQL password is wrong! The installation routine stops here!
[root@webserver install_ispconfig]#
--------------------------------------------------------------------------
Reply With Quote
Sponsored Links
  #2  
Old 2nd January 2006, 21:28
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,458
Thanks: 813
Thanked 5,240 Times in 4,108 Posts
Default

This means that either your mysql server is not installed, not running or not listening on localhost. If your mysql server is running, you maybe have the "skip-networking" option in you mysql my.cnf config file.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 2nd January 2006, 21:40
zalo zalo is offline
Member
 
Join Date: Jan 2006
Posts: 33
Thanks: 7
Thanked 0 Times in 0 Posts
Default

Mysql is installed and running:
-mysqld (pid 2033) is running...

I have removed --skip-networking from the file:
/etc/sysconfig/mysqld

I dident find any --skip-networking in the my.cnf file

How do i make mysql listen to "localhost"
Reply With Quote
  #4  
Old 2nd January 2006, 22:10
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,726 Times in 2,565 Posts
Default

Please restart MySQL. Then post the output of
Code:
netstat -tap
here as well as the content of /etc/hosts.
__________________
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 2nd January 2006, 22:37
zalo zalo is offline
Member
 
Join Date: Jan 2006
Posts: 33
Thanks: 7
Thanked 0 Times in 0 Posts
Default

[root@webserver salomon]# /etc/init.d/mysqld restart
Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]
[root@webserver salomon]# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN 3760/xinetd
tcp 0 0 *op3s *:* LISTEN 3760/xinetd
tcp 0 0 *:mysql *:* LISTEN 20206/mysqld
tcp 0 0 server1.zalo.net:10026 *:* LISTEN 3906/master
tcp 0 0 *op3 *:* LISTEN 3760/xinetd
tcp 0 0 *:imap *:* LISTEN 3760/xinetd
tcp 0 0 *:sunrpc *:* LISTEN 2098/portmap
tcp 0 0 *:http *:* LISTEN 4113/httpd
tcp 0 0 *:10000 *:* LISTEN 3962/perl
tcp 0 0 *:ftp *:* LISTEN 3930/proftpd: (acce
tcp 0 0 *:smtp *:* LISTEN 3906/master
tcp 0 0 *:https *:* LISTEN 4113/httpd
tcp 0 0 *:ssh *:* LISTEN 3717/sshd
tcp 0 0 ::ffff:192.168.2.31:ssh ::ffff:192.168.2.51:3431 ESTABLISHED 30403/sshd: salomon
tcp 0 0 ::ffff:192.168.2.31:ssh ::ffff:192.168.2.51:3333 ESTABLISHED 9661/sshd: salomon
[root@webserver salomon]#
--------------------------------------------------------------------------
etc/hosts

127.0.0.1 server1.zalo.net server1 localhost

--------------------------------------------------------------------------
Do i need to write anything in \etc\hosts.allow???

Last edited by zalo; 2nd January 2006 at 22:41.
Reply With Quote
  #6  
Old 2nd January 2006, 22:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,726 Times in 2,565 Posts
Default

Looks ok. Can you connect to MySQL when you run
Code:
mysql -h localhost -u root -p
on the shell?

Quote:
Originally Posted by zalo
All prerequisites are fulfilled.
Here we go...
Please enter your MySQL server:localhost
Please enter your MySQL user:ispconfig
Please enter your MySQL password:
ERROR 2005 (HY000): Unknown MySQL server host ' localhost' (2)
ERROR: The provided MySQL password is wrong! The installation routine stops here!
[root@webserver install_ispconfig]#
When you install ISPConfig you should enter root as MySQL user instead of ispconfig!
__________________
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
  #7  
Old 2nd January 2006, 22:53
zalo zalo is offline
Member
 
Join Date: Jan 2006
Posts: 33
Thanks: 7
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
Looks ok. Can you connect to MySQL when you run
Code:
mysql -h localhost -u root -p
on the shell?

Yes,that worked fine


Quote:
Originally Posted by falko
When you install ISPConfig you should enter root as MySQL user instead of ispconfig!
I have tried whih user "ispconfig" and "root", but i get the same error same error
Reply With Quote
  #8  
Old 3rd January 2006, 00:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,726 Times in 2,565 Posts
Default

Quote:
Originally Posted by zalo
I have tried whih user "ispconfig" and "root", but i get the same error same error
Have you tried to install ISPConfig again now that you have started 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
  #9  
Old 3rd January 2006, 14:53
zalo zalo is offline
Member
 
Join Date: Jan 2006
Posts: 33
Thanks: 7
Thanked 0 Times in 0 Posts
Default

I fixed it, i had to comment out the line in /etc/sysconfig/mysqld
like this:

# (oe) Remove --skip-networking to enable network access from
# non local clients. Access from localhost will still work.
#MYSQLD_OPTIONS=""

I had only removed the --skip-networking text not the hole line

I also added
#Mysql
mysqld 127.0.0.1
in hosts.allow
--------------------------------------------------------------------------

But it dindent last long at the next step i got a new error, can somebody help me?? (almost there)

done
All prerequisites are fulfilled.
Here we go...
Please enter your MySQL server:localhost
Please enter your MySQL user:root
Please enter your MySQL password:
OK
Please enter a name for the ISPConfig database (e.g. db_ispconfig):ispconfigdb
Please enter the IP address of the ISPConfig web (e.g. 192.168.0.1):192.168.2.31
ERROR: The IP address you provided is not reachable! The installation routine stops here!
[root@webserver install_ispconfig]#
Reply With Quote
  #10  
Old 3rd January 2006, 17:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,726 Times in 2,565 Posts
 
Default

Make sure that this IP address can be pinged. Might be your firewall that's blocking pings.
http://www.howtoforge.com/forums/showthread.php?t=839
__________________
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
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Failed at MySQL lhatle Installation/Configuration 4 29th November 2005 01:26
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41
Mysql ejs Installation/Configuration 5 12th August 2005 07:01


All times are GMT +2. The time now is 09:10.


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