ispcsrv# user database error in system log
I followed the documentation for installing a multi server cluster using these two walkthroughs:
http://www.howtoforge.com/perfect-server-ubuntu-13.04-apache2-bind-dovecot-ispconfig-3 http://www.howtoforge.com/multiserver-setup-with-dedicated-web-email-dns-and-mysql-database-servers-on-debian-squeeze-with-ispconfig-3
The issues that I came across is that after installing everything seemed to work except settings weren't replicating across the servers. Once I turned debugging on I found this error repeating every second from all my servers (santized for security):
DB::query(SELECT * FROM sys_ini WHERE sysini_id = 1) -> mysqli_query SELECT command denied to user 'ispcsrv#'@'MYSERVERHOSTNAME' for table 'sys_ini'
Using myphpadmin I added select privileges to all of the ispcsrv# users for table sys_ini in database dbispconfig and the error stopped appearing in the log. It looks like this might be a permission that needs added to the script that creates these users.
I am using Ubuntu 13.04 server cloud images on Digital Ocean for all my servers.