Adding a new server (multiserver)

Hi

I'm using ISPConfig 3.0.1.4 and Debian Lenny in a fresh instal, all work ok. But when add new server to this ha say a error:

ispconfig-2:/usr/local/src/ispconfig3_install/install# php -q install.php
Select language (en,de) [en]:
Installation mode (standard,expert) [standard]: expert
Full qualified hostname (FQDN) of the server, eg server1.domain.tld [ispconfig-2.ilba.cat]:
MySQL server hostname [localhost]:
MySQL root username [root]:
MySQL root password []: password
MySQL database to create [dbispconfig]:
MySQL charset [utf8]:
Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y
MySQL master server hostname []: ispconfig-1.ilba.cat
MySQL master server root username [root]:
MySQL master server root password []: password
MySQL master server database name [dbispconfig]:
Adding ISPConfig server record to database.
ERROR: Unable to create database user in master database: ispcsrv4 Error: GRANT command denied to user 'root'@'ispconfig-1.ilba.cat' for table 'server'

I verify the correct access of the user root to the remote database from new install to the server with ispconfig:

ispconfig-2:~# mysql -h ispconfig-1.ilba.cat -u root -p
CREATE DATABASE test;
DROP DATABASE test;

thats works fine, the slave (ispconfig-2) access to ispconfig-1 and add data, every error I remove the data of table server.... and drop the local database ( following this post: http://www.howtoforge.com/forums/showthread.php?p=205959 )

ispconfig-1:~# mysql
USE dbispconfig;
DELETE FROM server WHERE server_name = 'ispconfig-2.ilba.cat';

ispconfig-2:~# mysql
DROP DATABASE dbispconfig;

To grant access to root I add to mysql of ispconfig-1:

ispconfig-1:~# mysql
GRANT ALL ON *.* TO root@'ispconfig-2.ilba.cat' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;



Thanks in advance

 

Im usually adding slave to master by inserting following SQL command in
mysql user table on master server:

Code:

INSERT INTO `user` (`Host`, `User`, `Password`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Reload_priv`, `Shutdown_priv`, `Process_priv`, `File_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Show_db_priv`, `Super_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Execute_priv`, `Repl_slave_priv`, `Repl_client_priv`, `Create_view_priv`, `Show_view_priv`, `Create_routine_priv`, `Alter_routine_priv`, `Create_user_priv`, `ssl_type`, `ssl_cipher`, `x509_issuer`, `x509_subject`, `max_questions`, `max_updates`, `max_connections`, `max_user_connections`) VALUES
('192.168.0.1', 'root', 'md5password', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0),
('server.example.com', 'root', '* md5password', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0);

Only thing to change is host part and password that you copy from root user of master server.

Im adding one where the host is IP, and second with the FQDN.

I never fails when im connection slaves to master

 

Sorry but the table user don't exist, remember..... I'm using ISPConfig 3.0.1.4 not ISPConfig 2

mysql> SHOW TABLES;
+-----------------------+
| Tables_in_dbispconfig |
+-----------------------+
| attempts_login |
| client |
| client_template |
| country |
| cron |
| dns_rr |
| dns_soa |
| dns_template |
| firewall |
| ftp_user |
| mail_access |
| mail_content_filter |
| mail_domain |
| mail_forwarding |
| mail_get |
| mail_greylist |
| mail_mailman_domain |
| mail_traffic |
| mail_transport |
| mail_user |
| mail_user_filter |
| monitor_data |
| remote_session |
| remote_user |
| server |
| server_ip |
| shell_user |
| software_package |
| software_repo |
| software_update |
| software_update_inst |
| spamfilter_policy |
| spamfilter_users |
| spamfilter_wblist |
| support_message |
| sys_config |
| sys_datalog |
| sys_dbsync |
| sys_filesync |
| sys_group |
| sys_ini |
| sys_log |
| sys_user |
| web_database |
| web_domain |
| web_traffic |
+-----------------------+
46 rows in set (0.00 sec)

 

this is in mysql database

 

Can you show me the structure database, because I want create manually

mysql> DESCRIBE user;

thanks

 

ok..... I can't create manually, but howto add slave ispconfig to master ispconfig ?

The procedure of the top of post is correct ?

 

Thanks till, the problem was related to permissions on the Master ISPConfig.

One question more......

Having the DB on master, once used the wizard in order to create the slave (succesfully), how can we create a DB replica in the slave ? (using the wizard ?, manualy ?.). Do you have any procedure ?