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
     
    guimnk, May 31, 2011
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    till, May 31, 2011
    #2
  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...
     
    guimnk, May 31, 2011
    #3
  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.
     
    till, Jun 1, 2011
    #4
  5. guimnk

    guimnk Member

    Yes man, the cron is not working...

    This is my crontab:

    Code:
    root@turbo:~# 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
root@turbo:~#
     
    guimnk, Jun 1, 2011
    #5
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    Please start the cron daemon and then check the syslog if it caused any errors.
     
    till, Jun 1, 2011
    #6
  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
     
    guimnk, Jun 1, 2011
    #7

Share This Page