After creating a testdb database with a testdb user, the database gets created, but not the db user mysql> select * from mysql.user where User="testdb"; Empty set (0.00 sec) --- 11.01.2012-09:39 - DEBUG - Found 1 changes, starting update process. 11.01.2012-09:39 - DEBUG - Replicated from master: REPLACE INTO web_database (`database_id`,`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`type`,`database_name`,`database_user`,`database_password`,`database_charset`,`remote_access`,`remote_ips`,`active`) VALUES ('113','46','46','riud','riud','','23','mysql','testdb','testdb','secret','','n','','y') 11.01.2012-09:39 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'. 11.01.2012-09:39 - DEBUG - Created MySQL database: testdb 11.01.2012-09:39 - DEBUG - Processed datalog_id 25267 11.01.2012-09:39 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock ---
FYI: I have found the same problem: create a user, create a DB with that user and the MySQL user does not get created. I can do it manually in Webmin and the site works fine. I have checked the MySQL root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf and it's correct. It did have a "/" on the end so I changed it to a "@" in the file and in MySQL, then restarted MySQL. No change. However, don't know how but I've just noticed I have ISPConfig 3.1dev running!! Sp, running server.sh after creating a DB in ISPConfig gives: Code: PHP Warning: Invalid argument supplied for foreach() in /usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php on line 86 I assume there should be a check for no results returned by MySQL? Anyway, I'll go install 3.1.6 :/
And you should update indeed as there is no foreach near line 86 in current ISPConfig versions, so the dev version that you use is not the current one.