View Single Post
  #5  
Old 6th April 2012, 10:36
sBuchi sBuchi is offline
Junior Member
 
Join Date: Apr 2012
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hosts-file from slave-server siteA (host120):

127.0.0.1 localhost
x.x.132.120 host120.siteA.tld
x.x.35.172 node172.siteB.tld
x.x.35.173 node173.siteB.tld
x.x.35.174 node174.siteB.tld
x.x.35.175 node175.siteB.tld

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters

Hosts-file from master-server siteB (node172):


127.0.0.1 localhost
x.x.35.172 node172.siteB.tld
x.x.35.173 node173.siteB.tld
x.x.35.174 node174.siteB.tld
x.x.35.175 node175.siteB.tld
x.x.132.120 host120.siteA.tld

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters

Connecting from slave to master from siteA:

root@host120:~# mysql -h x.x.35.172 -u root -p
ERROR 1130 (HY000): Host 'x.x.132.20' is not allowed to connect to this MySQL server

Connecting from a working slave to master from siteB

root@node173:~# mysql -h node172.siteB.tld -u root -p

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

By trying to reconfigure the master-server, this lines appear:


>> Update

Operating System: Debian 6.0 (Squeeze/Sid) or compatible

This application will update ISPConfig 3 on your server.

Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: no

ERROR 1142 (42000) at line 35: DROP command denied to user 'root'@'localhost' for table 'billing_invoice'
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'dbispconfig' when using LOCK TABLES
Checking ISPConfig database .. OK
Starting incremental database update.
Reconfigure Permissions in master database? (yes,no) [no]: yes

PHP Notice: Undefined variable: value in /etc/ispconfig3_install/install/lib/installer_base.lib.php on line 352
ERROR: Unable to get the user rights: Error: SELECT command denied to user 'root'@'localhost' for table 'user'
root@node172:/etc/ispconfig3_install/install#
Reply With Quote