Database user is not deleted correctly when using remoting API
- Create a DB User
- Create a Database and Link DB to the Db User in #1 (closed)
Fun begins:
- Delete DB User in #1 (closed)
Notes: The above db user record will be deleted on the Master database but will NOT be deleted on the respective db slave server. Conclusion: Deleting a user who's already a attached to a database only deletes the user on master server but not on slave server rendering the user deletion function useless (at that point)...
- Now, delete the database you created in #2 (closed) Notes: Despite deleting the above database, the supposed to be deleted user in #3 (closed) still exists on the db slave server though the record is deleted from the master server.
HOWEVER
- From #2 (closed) :: Delete the database in #2 (closed), Notes: That deletes the DB User in #1 (closed) on the slave db server despite having not deleted the db user. The db-user record is exist-ant on master since was not deleted.
added information
#1 (closed)) is still true, The db user record will be deleted on the Master database but will NOT be deleted on the respective db slave server. Looking through the sys_datalog, NO "action"->"d" record is created in that table. I see only "action"->"i" records
3 (Delete DB User in#4 (closed) (Delete the database you created in #2 (closed)), the database is deleted from both ISPConfig databases (Master and Slave server) as expected and I see also sys_datalog record of "action"=>"d". ONLY problem is in #3 (closed) above, the db user is still existant on slave server despite being deleted from the master, and that could be explained by the failure to create the sys_datalog record when executed through API.
###5 (closed) Also noticed the following Creating a database user through API (who'is not attached to any database) creates the record on master server but does NOT create the user on the slave server. Also No record is created in sys_datalog. Same thing applies to deleting the NON linked database user, record only is deleted from the master and NO record is crated in sys_datalog.