Wrong Database Right when using auto-installer + Correction
When you use a multi-servers installation :
Since the last patch of auto-installer you have this error :
ERROR 1142 (42000) at line 1: INSERT command denied to user 'ispcsrvXX'@'XXX' for table `dbispconfig`.`server_php`
[ERROR] Exception occured: ISPConfigOSException -> Command mysql --host=XXXXX --user=ispcsrvXX --password=XXX -e 'INSERT IGNORE INTO `dbispconfig`.`server_php`
It can be resolve by adding insert right for slave user in installer_base.lib.php line 809
$query = "GRANT SELECT, INSERT ON ?? TO ?@?";
if ($verbose){
echo $query ."\n";
}
if(!$this->dbmaster->query($query, $value['db'] . '.server_php', $value['user'], $host)) {
$this->warning('Unable to set rights of user in master database: '.$value['db']."\n Query: ".$query."\n Error: ".$this->dbmaster->errorMessage);
}