Problems creating new databases

Discussion in 'Installation/Configuration' started by guimnk, May 31, 2011.

  1. guimnk

    guimnk Member

    Hi...

    When I add a new database by the panel ISPConfig, in PHPMyAdmin nothing was created.

    What can I do to fix it?
    Where can I monitor the commands executed by the panel?

    Thanks
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. guimnk

    guimnk Member

    Till

    Code:
    Most likely you changed the mysql root password without changing it in ispconfig too. Please ensure that the root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf is correct.
    
    Yes, the root password is correct.

    Code:
    See ISPConfig FAQ:
    
    http://www.faqforge.com/linux/contro...n-ispconfig-3/
    
    Ok, It's enabled but ispconfig.log is empty...
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Then you might have a problem with the cron daemon on your system, as no configuration gets written when the ispconfig cronjob is not executed. Please ensure that cron is installed and working.

    You can test that by executing this command:

    /usr/local/ispconfig/server/server.sh

    if this creates the database, then your cron daemon is not working correctly.
     
  5. guimnk

    guimnk Member

    Yes man, the cron is not working...

    This is my crontab:

    Code:
    [email protected]:~# crontab -l
    * * * * * /usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log
    30 00 * * * /usr/local/ispconfig/server/cron_daily.sh > /dev/null 2>> /var/log/ispconfig/cron.log
    45 5 * * * /usr/local/bin/removeOldFiles.sh
    45 4 * * * /usr/local/bin/automysqlbackup.sh
    */5 * * * * /usr/local/bin/postfixChangeSmtp.sh
    */60 * * * * /usr/local/bin/clearQueue.sh
    [email protected]:~#
    
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Please start the cron daemon and then check the syslog if it caused any errors.
     
  7. guimnk

    guimnk Member

    Ok.

    Look:

    Code:
    /usr/local/ispconfig/server/cron_daily.sh
    
    When I run this script, I see sql commands and 1 error:

    Code:
    INSERT INTO mail_traffic (month,mailuser_id,traffic) VALUES ('2011-06',379,466318)
    INSERT INTO mail_traffic (month,mailuser_id,traffic) VALUES ('2011-06',380,16546)
    INSERT INTO mail_traffic (month,mailuser_id,traffic) VALUES ('2011-06',381,7682868)
    
    PHP Warning:  symlink(): File exists in /usr/local/ispconfig/server/cron_daily.php on line 445
    find: `./web/wordpress/wp-content/uploads': Permission denied
    
     

Share This Page