Ispconfig 3 mysql user problem

Discussion in 'General' started by asovanek, Jun 19, 2013.

  1. 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
    ---
     
  2. ITFixt

    ITFixt Member

    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 :/
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

  4. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  5. florian030

    florian030 Well-Known Member HowtoForge Supporter

Share This Page