multiserver - remote access db passwd not changed , when changed access from IP to % and vice versa
multiserver - remote access db passwd not changed , when changed access from IP to % and vice versa
It seems there is error in /usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php which appears in multiserver setup, where web server and mysql servers are on separated machines
I tried this in two setups,
- server1 ISPC+DNS, server2 web, server3 mysql, server4 mail
- server1 ISPC+DNS+web, server 2 mail + mysql both are behaving same
It occurswhen you change database access type, which can be done:
1 You have unchecked remote acces and left empty IP field , which results database user is allowed for specified host IP address in mysql user table
- You have remote acces checked and leave empty field for IP adress which results allowed acces for any host - %
In both cases then password for remote user is unchanged in mysql user table
But is hard to always reproduce, it seems be depending os something other. If the password for db users was changed, user deleted or renamed before, or created same user which was deleted before whole sript seems behaving strange.
It seems that problem may be in ISPConfig web_database_user table on slave server when db user is deleted it is deleted from web_database_user on master server but still stays in web_database_user table on slave server