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!

    System:
    Debian 6 64
    ISP Config 3.0.4.6 (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

    Yes...

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

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

    Then run command:
    /usr/local/ispconfig/server/server.sh

    Result "now"
    /usr/bin/fail2ban-client
    /sbin/iptables
    /sbin/ip6tables
    finished.

    Re run and result is
    finished.
     
  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/server.sh

    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
    finished.

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

    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
    finished.

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

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

Share This Page