ispconfig 3.1.2: Mysql errors trying to add a server to a multiserver setup
Getting mysql errors on first server trying to be added to a multiserver setup.
On the master mysql server, remote rights where granted;
grant all on . to 'root'@'%' identified by 'xxx' with GRANT OPTION;
Also tested manual if my remote root has a lack of rights:
mysql -h 10.4.1.234 -u root -p
MariaDB [mysql]> create database bla; Query OK, 1 row affected (0.00 sec)
MariaDB [mysql]> grant all on bla.* to 'bla'@'%' identified by 'bla'; Query OK, 0 rows affected (0.01 sec)
Does not seem the case.
php -q install.php
|_ / | ___ \ / __ \ / () /
| | \--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ / | |
--. \ / | | / _ | ' | | |/ ` | | | | |/_/ / | | _/\ () | | | | | | | (| | \
_/_/_| ____/___/|_| |_|_| |_|__, | ____/ / | |_/Initial configuration
Operating System: CentOS 7.3
Following will be a few questions for primary configuration so be careful. Default values are in [brackets] and can be accepted with <ENTER>. Tap in "quit" (without the quotes) to stop the installer.
Select language (en,de) [en]:
Installation mode (standard,expert) [standard]: expert
Full qualified hostname (FQDN) of the server, eg server1.domain.tld [xxx]:
MySQL server hostname [localhost]:
MySQL server port [3306]:
MySQL root username [root]:
MySQL root password []: xxx
MySQL database to create [dbispconfig]:
MySQL charset [utf8]:
The next two questions are about the internal ISPConfig database user and password. It is recommended to accept the defaults which are 'ispconfig' as username and a random password. If you use a different password, use only numbers and chars for the password.
ISPConfig mysql database username [ispconfig]:
ISPConfig mysql database password [xxx]:
Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y
MySQL master server hostname []: 10.4.1.234
MySQL master server port []: 3306
MySQL master server root username [root]:
MySQL master server root password []: xxx
MySQL master server database name [dbispconfig]:
Adding ISPConfig server record to database.
WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(
status
,error
) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(status
) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(updated
) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (ssl
,ssl_letsencrypt
,ssl_request
,ssl_cert
,ssl_action
,ssl_key
) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE (action_state
,response
) ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT , DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, UPDATE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, INSERT, DELETE ON ?? TO ?@? Error: WARNING: Unable to set rights of user in master database: dbispconfig Query: GRANT SELECT, UPDATE(dnssec_initialized
,dnssec_info
,dnssec_last_signed
) ON ?? TO ?@? Error: Configure Mail (y,n) [y]: