Multi server setup problem.

I have ISPconfig 3 installed on an AWS EC2 and it works without problem, but i am trying to install a second server for second dns server, but when installing and running through the questions from the command line, i get this error when i try to connect to the master DB.

WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT ON dbispconfig.`server` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'server'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, INSERT ON dbispconfig.`sys_log` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'sys_log'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, UPDATE(`status`, `error`) ON dbispconfig.`sys_datalog` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'sys_datalog'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, UPDATE(`status`) ON dbispconfig.`software_update_inst` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'software_update_inst'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, UPDATE(`updated`) ON dbispconfig.`server` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'server'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, UPDATE (`ssl_request`, `ssl_cert`, `ssl_action`, `ssl_key`) ON dbispconfig.`web_domain` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'web_domain'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT ON dbispconfig.`sys_group` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'sys_group'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, UPDATE (`action_state`, `response`) ON dbispconfig.`sys_remoteaction` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'sys_remoteaction'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, INSERT , DELETE ON dbispconfig.`monitor_data` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'monitor_data'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`mail_traffic` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'mail_traffic'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, INSERT, UPDATE ON dbispconfig.`web_traffic` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'web_traffic'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, UPDATE ON dbispconfig.`aps_instances` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'aps_instances'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT, INSERT, DELETE ON dbispconfig.`web_backup` TO 'ispcsrv5'@'ns2.example.com'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'web_backup'
WARNING: Unable to set rights of user in master database: dbispconfig
Query: GRANT SELECT ON dbispconfig.`server` TO 'ispcsrv5'@'xx.xx.xx.xx'
Error: GRANT command denied to user 'root'@'ec2-xx-xx-xx-xx.eu-west-1.compute.amazonaws.com' for table 'server'
WARNING: Unable to set rights of user in master database: dbispconfig

there is more but hopefully its enough.

I can login to the master server DB with PHPMYADMIN so I know the password is good.
I've tried using ns1.example.com and the ip address when asked for

MySQL master server hostname

I have all ports open on both servers just incase its the issue (will close when working) in AWS VPS

Any help would be appreciated

Andy

 

bit more info, I'm running Cent OS.

When i run the install and get the errors above, id does create the ns2.example.com in Server along side ns1.example.com on the main ISPConfig server.

Andy

 

Hi

Did you choose to update permisions in master database during update? If not, please rerun the update manually by downloading ispconfig tar.gz (the procedure is described in the ispconfig release notes of each version) and choose to update the permissions in the master database.

Br//
Srijan

 

Do i still need to do this even through its a new install of the main server not an upgrade?

Andy

 

Hi,
I've ran the update on the main server, and re-run the install on the secondary server, all goes well until i get to

MySQL master server database name [dbispconfig]:

and it throws up this error

ERROR: Stopped: Database already contains some tables.

do you know which tables i need to delete to get the install to work?

Andy

 

thanks for the reply, I've managed to sort it now.

Is there or can you point me to any documentation on how you get the dns records to populate the db on the second server for bind?

Andy

 

thanks for the info, I've mirrored the server and ran resync

it Resynced

Resynced DNS zone: example.com.
Resynced DNS zone: xx.xx.xx.in-addr.arpa.
Resynced DNS zone: example.net.

but I've checked the slave server in /var/named and they are not there, should they be? or are the put some where else?

Andy