ISPConfig 3 and creating db mysql from panel

Discussion in 'General' started by blustem, Jul 12, 2012.

  1. blustem

    blustem New Member

    Hi guys,
    I have a problem that occurred yesterday and is as follows:
    In panel ISPConfig 3, I created a new user, domain, database, and ... surprise, the database is not created!
    I made other attempts, but the problem persists. ISPC does not seem to make the necessary operations to create user / database.
    Through the tool mysql with the command show databases, the database engine does not actually exist;
    the query select * from mysql.user I verified that the user is not created.
    I do not know how to fix it.
    Please help me. Thank you!

    Debian 6 64
    ISP Config (updated)
  2. till

    till Super Moderator

    The most likely reason is that you changed the mysql root password in the mysql database without changing it in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf as well.
  3. blustem

    blustem New Member

    Hello Till,
    having said that the root password was not changed,
    password in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf and password in the database match.
  4. till

    till Super Moderator

  5. blustem

    blustem New Member

    nothing. command returns... finished.
    I'm desperate. This is a server operating whit many domains...
  6. till

    till Super Moderator

    Then you havent debugging enabled as decsribed in the faq.
  7. blustem

    blustem New Member


    * * * * * /usr/local/ispconfig/server/ > /dev/null 2>> /var/log/ispconfig/cron.log

    #* * * * * /usr/local/ispconfig/server/ > /dev/null 2>> /var/log/ispconfig/cron.log

    Then run command:

    Result "now"

    Re run and result is
  8. till

    till Super Moderator

    No, you did just 2 of the 3 nescessary steps, please reread the faq. Debugging has to be enabled in the ispconfig interface first.
  9. blustem

    blustem New Member

    Ok Till,
    I enabled debugging on ispconfig and the result is:

    Creating db prova from ISPC and run by terminal
    > /usr/local/ispconfig/server/

    12.07.2012-15:38 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    12.07.2012-15:38 - DEBUG - Found 1 changes, starting update process.
    12.07.2012-15:38 - DEBUG - Calling function 'db_insert' from plugin 'mysql_clientdb_plugin' raised by event 'database_insert'.
    12.07.2012-15:38 - DEBUG - Created MySQL database: test
    12.07.2012-15:38 - DEBUG - Processed datalog_id 1187
    12.07.2012-15:38 - DEBUG - Remove Lock: usr/local/ispconfig/server/temp/.ispconfig_lock

    Second step
    Removing db and run
    > /usr/local/ispconfig/server/

    12.07.2012-15:43 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    12.07.2012-15:43 - DEBUG - Found 1 changes, starting update process.
    12.07.2012-15:43 - DEBUG - Calling function 'db_delete' from plugin 'mysql_clientdb_plugin' raised by event 'database_delete'.
    12.07.2012-15:43 - DEBUG - Dropping MySQL user: test
    12.07.2012-15:43 - DEBUG - Dropping MySQL database: prova
    12.07.2012-15:43 - DEBUG - Processed datalog_id 1189
    12.07.2012-15:43 - DEBUG - Remove Lock: usr/local/ispconfig/server/temp/.ispconfig_lock

    The db "prove" is correctly created and dropped in mysql only if I run /usr/local/ispconfig/server/

    And now? I try to replace the crontab?
    Last edited: Jul 12, 2012
: ispconfig3, mysql

Share This Page