Ubuntu Installation problem

[toyito]

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....

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

[till]

Did you replace server1.example.com in "mysqladmin -h server1.example.com -u root password mypass" with your own domain?

[falko]

Your MySQL server is listening only on localhost.localdomain:

tcp 0 0 localhost.localdo:mysql *:* LISTEN 11265/mysqld

That's why

mysqladmin -h server1.example.com -u root password mypass

doesn't work.

[toyito]

Thanks

I get it....


Hector

[toyito]

ok ok

Now i have another message:

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

[till]

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

Did you replace "server1.example.com" with your server URL?

[toyito]

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

[toyito]

Hi there

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

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:

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

[falko]

You don't need to run this:

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.