Problem with phpmyadmin after

Hi,

I followed the multiserver setup with dedicated web email dns and myslq database servers on debian squeeze, but phpmyadmin not work. I get the message "Not Found. The requested URL /phpmyadmin was not found on this server."

Any idea?

Thanks

 

Use the interface link in database section.

This link redirect to https://ip-web-server:8080/phpmyadmin

Any idea?

 

Another problem, can't connect with "myslq -u root -h db_server -p" from web_server to db_server.

 

You might have to adjust the URL in the ISPConfig interface settings under System.

I guess this is just a typo, but the command is mysql, not myslq.

Do you get any error messages?

 

What is the correct link?

ERROR 2003 (HY000): Can't connect to MySQL server on 'db1.nombresweb.net' (110)

 

What's the output of

Code:

netstat -tap

and

Code:

iptables -L

on db1.nombresweb.net

 

Code:

root@db1:/# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.2:smtp          *:*                     LISTEN      6401/master     
tcp        0      0 localhost.localdom:smtp *:*                     LISTEN      6401/master     
tcp        0      0 localhost.localdom:6010 *:*                     LISTEN      6030/0          
tcp        0      0 *:mysql                 *:*                     LISTEN      8075/mysqld     
tcp        0      0 *:sunrpc                *:*                     LISTEN      197/portmap     
tcp        0      0 *:ssh                   *:*                     LISTEN      6158/sshd       
tcp        0      0 db1.mydomain.net:47141 web1.mydomain.net:mysql TIME_WAIT   -               
tcp        0     48 db1.mydomain.net:ssh  122.Red-**-**-**.:41745 ESTABLISHED 6030/0          
tcp6       0      0 localhost.localdom:6010 [::]:*                  LISTEN      6030/0          
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN      6158/sshd       
root@db1:/# iptables -L
Chain INPUT (policy ACCEPT)
target     prot opt source               destination         
fail2ban-ssh  tcp  --  anywhere             anywhere            multiport dports ssh 

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination         

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination         

Chain fail2ban-ssh (1 references)
target     prot opt source               destination         
RETURN     all  --  anywhere             anywhere            

 

That looks ok, MySQL is listening on all interfaces and not blocked by the server's firewall (it is however possible that there's another firewall somewhere on the way between both servers which blocks requests).

Does the DNS record for db1.nombresweb.net point to the correct server?

 

Now work, but I marked "remote access" in database config.

It's necessary mark "remote access"?
For safety I have to add the ip of web server right?

As a cluster expected this to be automatic.

 

Any idea for the phpmyadmin problem?

 

Where/how exactly did you install phpMyAdmin?

 

As the manual says, in the web server:


"
Now install Apache2, PHP5, phpMyAdmin, FCGI, suExec, Pear, and mcrypt as follows:

apt-get -y install apache2 apache2.2-common apache2-doc apache2-mpm-prefork apache2-utils libexpat1 ssl-cert libapache2-mod-php5 php5 php5-common php5-gd php5-mysql php5-imap phpmyadmin php5-cli php5-cgi libapache2-mod-fcgid apache2-suexec php-pear php-auth php5-mcrypt mcrypt php5-imagick imagemagick libapache2-mod-suphp libopenssl-ruby libapache2-mod-ruby sudo zip wget

"

 

Do you have a phpMyAdmin configuration file in /etc/apache2/conf.d/?

 

No file configuration in /etc/apache2/conf.d/

 

Please try this:

Code:

ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
/etc/init.d/apache2 reload

 

Now works, but the open the phpmyadmin in the web1 server instead on db1 server.

 

How can i configure the phpmyadmin to manage the myslq of db1 server?

Need I install phpmyadmin in db1 server?

Thank's for the help.

 

If i have more than one db server, how can i configure the phpmyadmin link to open the corresponding db server?