hello, when I am forming the ispconfig in the seviers one for one and do they give me error of conecion in the database????? MySQL master server hostname []: web.example.tld MySQL master server root username [root]: MySQL master server root password []: Mypasswordroot MySQL master server database name [dbispconfig]: Unable to connect to mysql server *********** MySQL master server hostname []: please help me,,,,,
webservicio:~# netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:mysql *:* LISTEN 2006/mysqld tcp 0 0 *:39594 *:* LISTEN 1720/rpc.statd tcp 0 0 *:sunrpc *:* LISTEN 1707/portmap tcp 0 0 *:ftp *:* LISTEN 2423/pure-ftpd (SER tcp 0 0 *:ssh *:* LISTEN 1929/sshd tcp 0 0 localhost:smtp *:* LISTEN 2396/exim4 tcp 0 0 webservicio.sytes.n:ssh 192.168.0.108:xtel ESTABLISHED 2563/0 tcp6 0 0 [::]:http-alt [::]:* LISTEN 2478/apache2 tcp6 0 0 [::]:www [::]:* LISTEN 2478/apache2 tcp6 0 0 [::]:tproxy [::]:* LISTEN 2478/apache2 tcp6 0 0 [::]:ftp [::]:* LISTEN 2423/pure-ftpd (SER tcp6 0 0 [::]:ssh [::]:* LISTEN 1929/sshd tcp6 0 0 [::]:https [::]:* LISTEN 2478/apac webservicio:~# 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 In the Master Server, thank Falko
Looks ok. Does web.example.tld point to the master server (i.e., did you create a DNS record that points to the master server)?
sorry to resurrect this old thread but I'm having the same issue. Running the latest versions on both servers. I have a dns record that points to my master server. I've added the IP + hostname Mysql permissions on the Master server for the slave. The slave can ping the master. Code: tcp 0 0 *:mysql *:* LISTEN 17844/mysqld When trying to install I get the following: tcp 0 0 xxxx.xxxx:mysql *:* LISTEN 25594/mysqld tcp 0 1 xxxx.xxxx:43015 xxxx.xxxx.xxxx:mysql SYN_SENT 25774/php s# iptables -L Chain INPUT (policy ACCEPT) target prot opt source destination fail2ban-ssh tcp -- anywhere anywhere multiport dports ssh fail2ban-dovecot-pop3imap tcp -- anywhere anywhere multiport dports pop3,pop3s,imap2,imaps Chain FORWARD (policy ACCEPT) target prot opt source destination Chain OUTPUT (policy ACCEPT) target prot opt source destination Chain fail2ban-dovecot-pop3imap (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-pureftpd (0 references) target prot opt source destination Chain fail2ban-ssh (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-ssh-ddos (0 references) target prot opt source destination I want to add that I can ssh but not telnet (3306) to the master server. So mysql -h is not connecting either.
Not sure which of the above netstat outputs is correct, so can you please post the output of Code: netstat -tap | grep mysql from the MAster again?
from the master: Code: # netstat -tap | grep mysql tcp 0 0 *:mysql *:* LISTEN 2812/mysqld tcp 0 0 localhost:mysql localhost:48119 ESTABLISHED 2812/mysqld tcp 0 0 localhost:48119 localhost:mysql ESTABLISHED 16880/amavisd (ch1-
Looks good. Can you try to connect to the Master MySQL from the slave from the command line? Code: mysql -h web.example.tld -u root -p and Code: mysql -h <ip_address_of_master> -u root -p
doesn't work. I cannot connect to the remote mysql server. I've even tried adding the user on the slave and connect from the Master -> slave. On the Slave -> master -> After several minutes: ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address here' (110) On the Master -> Slave -> ERROR 2003 (HY000): Can't connect to MySQL server on 'IP address here' (110)
could it be that something is blocking the remote connection to/from the slave server on the mysql port?
the master is a dedicated box and the slave is a vps. I'll go check with the vps hosting company and I'll let you know.
Unable to connect to mysql server Hi all, I have issue with similar/same thing, I setting up already 2 testing machines ( 2 DNS servers on local network - master and slave ) and I can't connect to mysql database - from slave 192.168.0.105 as reach2.reachnet.co.uk to master 192.168.0.108 reach1.reachnet.co.uk - gave same same error - unable connect to mysql server. I can connect to master database using hostname and ip address master server, from slave to master I can connect only using IP address, but not using hostname. netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:mysql *:* LISTEN 1727/mysqld tcp 0 0 *:sunrpc *:* LISTEN 775/portmap tcp 0 0 *:ftp *:* LISTEN 1878/pure-ftpd (SER tcp 0 0 reach1.reachnet.:domain *:* LISTEN 1075/named tcp 0 0 localhost.locald:domain *:* LISTEN 1075/named tcp 0 0 *:ssh *:* LISTEN 1886/sshd tcp 0 0 *:smtp *:* LISTEN 2169/master tcp 0 0 localhost.localdoma:953 *:* LISTEN 1075/named tcp 0 0 *:47331 *:* LISTEN 793/rpc.statd tcp 0 0 localhost.localdo:10024 *:* LISTEN 1202/amavisd (maste tcp 0 0 localhost.localdo:10025 *:* LISTEN 2169/master tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54205 ESTABLISHED 1727/mysqld tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54206 ESTABLISHED 1727/mysqld tcp 0 0 reach1.reachnet.c:56202 reach1.reachnet.c:mysql ESTABLISHED 31675/mysql tcp 0 0 reach1.reachnet.c:mysql reach1.reachnet.c:56202 ESTABLISHED 1727/mysqld tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54207 ESTABLISHED 1727/mysqld tcp 58 0 localhost.localdo:48922 localhost.localdo:10025 CLOSE_WAIT 1566/amavisd (ch1-a tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54209 ESTABLISHED 1727/mysqld tcp 0 52 reach1.reachnet.co.:ssh 192.168.0.102:52824 ESTABLISHED 2405/0 tcp6 0 0 [::]op3 [::]:* LISTEN 1517/couriertcpd tcp6 0 0 [::]:imap2 [::]:* LISTEN 1496/couriertcpd tcp6 0 0 [::]:http-alt [::]:* LISTEN 1214/apache2 tcp6 0 0 [::]:www [::]:* LISTEN 1214/apache2 tcp6 0 0 [::]:tproxy [::]:* LISTEN 1214/apache2 tcp6 0 0 [::]:ftp [::]:* LISTEN 1878/pure-ftpd (SER tcp6 0 0 [::]:domain [::]:* LISTEN 1075/named tcp6 0 0 [::]:ssh [::]:* LISTEN 1886/sshd tcp6 0 0 ip6-localhost:953 [::]:* LISTEN 1075/named tcp6 0 0 [::]:https [::]:* LISTEN 1214/apache2 tcp6 0 0 [::]:imaps [::]:* LISTEN 1520/couriertcpd tcp6 0 0 [::]op3s [::]:* LISTEN 1538/couriertcpd and iptables -L Chain INPUT (policy DROP) target prot opt source destination fail2ban-courierimaps tcp -- anywhere anywhere multiport dports imaps fail2ban-sasl tcp -- anywhere anywhere multiport dports smtp fail2ban-ssh tcp -- anywhere anywhere multiport dports ssh fail2ban-pureftpd tcp -- anywhere anywhere multiport dports ftp fail2ban-courierpop3s tcp -- anywhere anywhere multiport dports pop3s fail2ban-courierpop3 tcp -- anywhere anywhere multiport dports pop3 fail2ban-courierimap tcp -- anywhere anywhere multiport dports imap2 DROP tcp -- anywhere loopback/8 ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED ACCEPT all -- anywhere anywhere DROP all -- base-address.mcast.net/4 anywhere PUB_IN all -- anywhere anywhere PUB_IN all -- anywhere anywhere PUB_IN all -- anywhere anywhere PUB_IN all -- anywhere anywhere PUB_IN all -- anywhere anywhere DROP all -- anywhere anywhere Chain FORWARD (policy DROP) target prot opt source destination ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED DROP all -- anywhere anywhere Chain OUTPUT (policy ACCEPT) target prot opt source destination PUB_OUT all -- anywhere anywhere PUB_OUT all -- anywhere anywhere PUB_OUT all -- anywhere anywhere PUB_OUT all -- anywhere anywhere PUB_OUT all -- anywhere anywhere Chain INT_IN (0 references) target prot opt source destination ACCEPT icmp -- anywhere anywhere DROP all -- anywhere anywhere Chain INT_OUT (0 references) target prot opt source destination ACCEPT icmp -- anywhere anywhere ACCEPT all -- anywhere anywhere Chain PAROLE (15 references) target prot opt source destination ACCEPT all -- anywhere anywhere Chain PUB_IN (5 references) target prot opt source destination ACCEPT icmp -- anywhere anywhere icmp destination-unreachable ACCEPT icmp -- anywhere anywhere icmp echo-reply ACCEPT icmp -- anywhere anywhere icmp time-exceeded ACCEPT icmp -- anywhere anywhere icmp echo-request PAROLE tcp -- anywhere anywhere tcp dpt:ftp-data PAROLE tcp -- anywhere anywhere tcp dpt:ftp PAROLE tcp -- anywhere anywhere tcp dpt:ssh PAROLE tcp -- anywhere anywhere tcp dpt:smtp PAROLE tcp -- anywhere anywhere tcp dpt:domain PAROLE tcp -- anywhere anywhere tcp dpt:www PAROLE tcp -- anywhere anywhere tcp dptop3 PAROLE tcp -- anywhere anywhere tcp dpt:imap2 PAROLE tcp -- anywhere anywhere tcp dpt:https PAROLE tcp -- anywhere anywhere tcp dpt:imaps PAROLE tcp -- anywhere anywhere tcp dptop3s PAROLE tcp -- anywhere anywhere tcp dpt:mysql PAROLE tcp -- anywhere anywhere tcp dpt:http-alt PAROLE tcp -- anywhere anywhere tcp dpt:tproxy PAROLE tcp -- anywhere anywhere tcp dpt:webmin ACCEPT udp -- anywhere anywhere udp dpt:domain ACCEPT udp -- anywhere anywhere udp dpt:mysql DROP icmp -- anywhere anywhere DROP all -- anywhere anywhere Chain PUB_OUT (5 references) target prot opt source destination ACCEPT all -- anywhere anywhere Chain fail2ban-courierimap (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-courierimaps (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-courierpop3 (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-courierpop3s (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-pureftpd (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-sasl (1 references) target prot opt source destination RETURN all -- anywhere anywhere Chain fail2ban-ssh (1 references) target prot opt source destination RETURN all -- anywhere anywhere and netstat -tap | grep mysql tcp 0 0 *:mysql *:* LISTEN 1727/mysqld tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54205 ESTABLISHED 1727/mysqld tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54206 ESTABLISHED 1727/mysqld tcp 0 0 reach1.reachnet.c:56202 reach1.reachnet.c:mysql ESTABLISHED 31675/mysql tcp 0 0 reach1.reachnet.c:mysql reach1.reachnet.c:56202 ESTABLISHED 1727/mysqld tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54207 ESTABLISHED 1727/mysqld tcp 0 0 reach1.reachnet.c:mysql 192.168.0.105:54209 ESTABLISHED 1727/mysqld both servers pinging itself hostname and ip addresses, but not pinging using hostname root@reach1:~# ping reach1.reachnet.co.uk PING reach1.reachnet.co.uk (192.168.0.108) 56(84) bytes of data. 64 bytes from reach1.reachnet.co.uk (192.168.0.108): icmp_req=1 ttl=64 time=0.082 ms 64 bytes from reach1.reachnet.co.uk (192.168.0.108): icmp_req=2 ttl=64 time=0.065 ms 64 bytes from reach1.reachnet.co.uk (192.168.0.108): icmp_req=3 ttl=64 time=0.065 ms root@reach1:~# ping reach2.reachnet.co.uk ping: unknown host reach2.reachnet.co.uk dns records/dns zone needs to be created on master server on ispconfig panel? If yes, please tell me step by step. Many thanks for any help
The problem is that you did not configure the /etc/hosts files on both servers correctly as described in the multiserver installation guide. Please reread the guide and then configure the hosts files as described there.
