#1  
Old 5th May 2006, 06:11
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default Ubuntu Installation problem

Hi...i have a ISPConfig server running fine, but it crash after a electric failure, now when i trying to make a fresh install a get the following errors....

Quote:
root@server1:~# mysqladmin -u root password mypass
root@server1:~# mysqladmin -h server1.example.com -u root password mypass
mysqladmin: connect to server at 'server1.example.com' failed
error: 'Unknown MySQL Server Host 'server1.example.com' (1)'
Check that mysqld is running on server1.example.com and that the port is 3306.
You can check this by doing 'telnet server1.example.com 3306'
root@server1:~#
root@server1:~#
root@server1:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:mysql *:* LISTEN 11265/mysqld
tcp 0 0 192.168.0.185:domain *:* LISTEN 10631/named
tcp 0 0 localhost.locald:domain *:* LISTEN 10631/named
tcp 0 0 *:smtp *:* LISTEN 11094/master
tcp 0 0 localhost.localdoma:953 *:* LISTEN 10631/named
tcp6 0 0 *:ssh *:* LISTEN 9869/sshd
tcp6 0 0 ip6-localhost:953 *:* LISTEN 10631/named
tcp6 0 452 ::ffff:192.168.0.18:ssh andhe01.mshome.net:2221 ESTABLISHED9920/0
Can u help me pls

Hector
Reply With Quote
Sponsored Links
  #2  
Old 5th May 2006, 10:01
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,751
Thanks: 840
Thanked 5,602 Times in 4,413 Posts
Default

Did you replace server1.example.com in "mysqladmin -h server1.example.com -u root password mypass" with your own domain?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 5th May 2006, 12:23
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Your MySQL server is listening only on localhost.localdomain:

Quote:
tcp 0 0 localhost.localdo:mysql *:* LISTEN 11265/mysqld
That's why
Code:
mysqladmin -h server1.example.com -u root password mypass
doesn't work.
__________________
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
  #4  
Old 5th May 2006, 14:43
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

Thanks

I get it....


Hector

Last edited by toyito; 5th May 2006 at 16:05.
Reply With Quote
  #5  
Old 5th May 2006, 18:15
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

ok ok

Now i have another message:

Quote:
root@server1:~# mysqladmin -u root password mypass
root@server1:~# mysqladmin -h server1.example.com -u root password mypass
mysqladmin: connect to server at 'server1.example.com' failed
error: 'Lost connection to MySQL server during query'

root@server1:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:mysql *:* LISTEN 11196/mysqld
tcp 0 0 server1.example.:domain *:* LISTEN 10528/named
tcp 0 0 localhost.locald:domain *:* LISTEN 10528/named
tcp 0 0 *:smtp *:* LISTEN 11025/master
tcp 0 0 localhost.localdoma:953 *:* LISTEN 10528/named
tcp6 0 0 *:ssh *:* LISTEN 9873/sshd
tcp6 0 0 ip6-localhost:953 *:* LISTEN 10528/named
tcp6 0 0 server1.example.com:ssh andhe01.mshome:ninstall ESTABLISHED9876/0
I really dont know what it means....i see that my mysql are listening but i still having errors...can i continue whit the setup or i need to fix it first???

Hector
Reply With Quote
  #6  
Old 5th May 2006, 18:23
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,751
Thanks: 840
Thanked 5,602 Times in 4,413 Posts
Default

You will have to fix this before you can install ISPConfig.

Did you replace "server1.example.com" with your server URL?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 5th May 2006, 18:44
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

HI

No Till, im using "exactly" the same configuration in the How To...thats what i did last time and all work perfect...Ok lets me try again..

Hector
Reply With Quote
  #8  
Old 5th May 2006, 19:43
toyito toyito is offline
Senior Member
 
Join Date: Oct 2005
Posts: 106
Thanks: 1
Thanked 1 Time in 1 Post
Default

Hi there

I do exactly what the How To says...but i get the same error:

Quote:
root@server1:~# mysqladmin -u root password mypass
root@server1:~# mysqladmin -h server1.example.com -u root password mypass
root@server1:~# ect to server at 'server1.example.com' failed
root@server1:~# nection to MySQL server during query'
Whats wrong...can u help me pls.

Hector

the netstat -tap:

Quote:
root@server1:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:mysql *:* LISTEN 7487/mysqld
tcp 0 0 server1.example.:domain *:* LISTEN 6781/named
tcp 0 0 localhost.locald:domain *:* LISTEN 6781/named
tcp 0 0 *:smtp *:* LISTEN 7316/master
tcp 0 0 localhost.localdoma:953 *:* LISTEN 6781/named
tcp6 0 0 *:ssh *:* LISTEN 6054/sshd
tcp6 0 0 ip6-localhost:953 *:* LISTEN 6781/named
tcp6 0 0 server1.example.com:ssh andhe01.mshome.net:1360 ESTABLISHED6147/0
Reply With Quote
  #9  
Old 5th May 2006, 20:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

You don't need to run this:

Code:
mysqladmin -h server1.example.com -u root password mypass
if MySQL is listening only on localhost. You only have to run this if MySQL is listening on all IP addresses because otherwise anybody could login using server1.example.com.
__________________
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
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 13:20
ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" Problem with ISPConfig chipw Installation/Configuration 6 30th October 2006 10:38
Installation problem... please help... francis Installation/Configuration 2 26th April 2006 05:13
Ubuntu Installation Fails - ISPConfig mateo107 Installation/Configuration 5 9th March 2006 08:54
Installation problem xma Installation/Configuration 15 26th September 2005 14:22


All times are GMT +2. The time now is 22:32.


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