After upgrade from old svn to 3.0.1.6 no more apache config updates

Discussion in 'Installation/Configuration' started by quentusrex, Feb 14, 2010.

  1. quentusrex

    quentusrex New Member

    Where are the 'updates' that should be changed for cron stored? I don't see a table for them.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    And you are really sure that you commented out the crontab? Post output of:

    crontab -l

    and that no more jobs are listed in the jobqueue?

    The results and answers are inkonsistent, so its not possible that no jobs are listed in the queue if the cronjob is commented out and you added or modified a entry in the ispconfig interface.

    What exactly did you do?
     
  3. quentusrex

    quentusrex New Member

    Cron:
    #* * * * * /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


    The databases got dropped. So I dumped the database as it was after the install, ran the database creation script for 3.0.6, then inserted the data for my old site back into the database.
     
  4. quentusrex

    quentusrex New Member

    Now a different message:

    /usr/local/ispconfig/server/server.sh
    22.02.2010-01:42 - DEBUG - Set Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    22.02.2010-01:42 - WARNING - Unable to connect to local server.
    22.02.2010-01:42 - DEBUG - Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock
    finished.
     
  5. quentusrex

    quentusrex New Member

    I think there is a typo. The query "$server_db_record = $app->db->queryOneRecord("SELECT * FROM server WHERE update = 1 AND server_id = ".$conf["server_id"]);" there is no column called update.
     
  6. quentusrex

    quentusrex New Member

    I think the issue could be how I reloaded the info back into the database. Yeah, I probably screwed this up. The table is probably different.


    edited: Nope. In the install sql file there is no column for update. So there is an issue with the server.php select statement.
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    a) Then your database layout might be incompatible with the installed ispconfig release or incomplete. What was the exact reason that the database was dropped, did you had added or modified a database table?

    b) Add a new website in ispconfig. then check the the monitor, there must be a item in the mailqueue.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Thats no typo. All current ispconfig releases have this column. So your db layout is not compatible with the ispconfig version you use.
     
  9. quentusrex

    quentusrex New Member

    Basically I tried to upgrade from an svn revision around 3.0.1 straight to 3.0.1.6. It didn't like something about the database, so it dropped the tables. All my data was gone. so I went through the backup and restored the data, and kept as much of the sql structure the same as I could.
     
  10. quentusrex

    quentusrex New Member

    From the sql file I used for the install. The column is not there:


    --
    -- Table structure for table `server`
    --

    CREATE TABLE `server` (
    `server_id` int(11) unsigned NOT NULL auto_increment,
    `sys_userid` int(11) unsigned NOT NULL default '0',
    `sys_groupid` int(11) unsigned NOT NULL default '0',
    `sys_perm_user` varchar(5) NOT NULL default '',
    `sys_perm_group` varchar(5) NOT NULL default '',
    `sys_perm_other` varchar(5) NOT NULL default '',
    `server_name` varchar(255) NOT NULL default '',
    `mail_server` tinyint(1) NOT NULL default '0',
    `web_server` tinyint(1) NOT NULL default '0',
    `dns_server` tinyint(1) NOT NULL default '0',
    `file_server` tinyint(1) NOT NULL default '0',
    `db_server` tinyint(1) NOT NULL default '0',
    `vserver_server` tinyint(1) NOT NULL default '0',
    `config` text NOT NULL,
    `updated` bigint(20) unsigned NOT NULL default '0',
    `active` tinyint(1) NOT NULL default '1',
    PRIMARY KEY (`server_id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=1;
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    The system files do not match the sql database layout. This means that you have not a completed update on your system. Download ispconfig 3.0.1.6 and run the update again.
     
  12. quentusrex

    quentusrex New Member

    ispconfig_update.sh


    --------------------------------------------------------------------------------
    _____ ___________ _____ __ _
    |_ _/ ___| ___ \ / __ \ / _(_)
    | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _
    | | `--. \ __/ | | / _ \| '_ \| _| |/ _` |
    _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| |
    \___/\____/\_| \____/\___/|_| |_|_| |_|\__, |
    __/ |
    |___/
    --------------------------------------------------------------------------------


    >> Update

    Please choose the update method. For production systems select 'stable'.
    The update from svn is only for development systems and may break your current setup.

    Select update method (stable,svn) [stable]:

    There are no updates available for ISPConfig 3.0.1.6
    root@virt3:~/ispconfig3_install/install#
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    Please download ispconfig 3.0.1.6 again and then run the update.php script and not to run ispconfig_update.sh.
     
  14. quentusrex

    quentusrex New Member

    what is the command for that? php /.../update.php
     
  15. quentusrex

    quentusrex New Member

    nvm, found it. it was:

    php -f /.../update.php
     
  16. quentusrex

    quentusrex New Member

    Finished the upgrade. Still the same thing. I'll post the output:

    root@virt3:~/ispconfig3_install/install# php -f update.php


    --------------------------------------------------------------------------------
    _____ ___________ _____ __ _
    |_ _/ ___| ___ \ / __ \ / _(_)
    | | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _
    | | `--. \ __/ | | / _ \| '_ \| _| |/ _` |
    _| |_/\__/ / | | \__/\ (_) | | | | | | | (_| |
    \___/\____/\_| \____/\___/|_| |_|_| |_|\__, |
    __/ |
    |___/
    --------------------------------------------------------------------------------


    >> Update

    Operating System: Debian Lenny/Sid or compatible

    This application will update ISPConfig 3 on your server.
    MySQL root password []: ********************

    Reconfigure Services? (yes,no) [yes]:

    Configuring Postfix
    Configuring Jailkit
    Configuring SASL
    Configuring PAM
    Configuring Courier
    Configuring Spamassassin
    Configuring Amavisd
    Configuring Getmail
    Configuring Pureftpd
    Configuring MyDNS
    Configuring Apache
    Configuring vlogger
    Configuring Database
    Configuring Firewall
    Updating ISPConfig
    ISPConfig Port [8080]:

    Reconfigure Crontab? (yes,no) [yes]:

    Updating Crontab
    Restarting services ...
    * Stopping MySQL database server mysqld
    ...done.
    * Starting MySQL database server mysqld
    ...done.
    * Checking for corrupt, not cleanly closed and upgrade needing tables.
    * Stopping Postfix Mail Transport Agent postfix
    ...done.
    * Starting Postfix Mail Transport Agent postfix
    ...done.
    * Stopping SASL Authentication Daemon saslauthd
    ...done.
    * Starting SASL Authentication Daemon saslauthd
    ...done.
    Stopping amavisd: amavisd-new.
    ERROR 126 (HY000) at line 1: Incorrect key file for table '/tmp/#sql_213e_0.MYI'; try to repair it
    Starting amavisd: amavisd-new.
    * Stopping ClamAV daemon clamd
    ...done.
    * Starting ClamAV daemon clamd
    LibClamAV Warning: ***********************************************************
    LibClamAV Warning: *** This version of the ClamAV engine is outdated. ***
    LibClamAV Warning: *** DON'T PANIC! Read http://www.clamav.net/support/faq ***
    LibClamAV Warning: ***********************************************************
    LibClamAV Warning: ***********************************************************
    LibClamAV Warning: *** This version of the ClamAV engine is outdated. ***
    LibClamAV Warning: *** DON'T PANIC! Read http://www.clamav.net/support/faq ***
    LibClamAV Warning: ***********************************************************
    ...done.
    * Stopping Courier authentication services authdaemond
    ...done.
    * Starting Courier authentication services authdaemond
    ...done.
    * Stopping Courier IMAP server...
    ...done.
    * Starting Courier IMAP server...
    ...done.
    * Stopping Courier IMAP-SSL server...
    ...done.
    * Starting Courier IMAP-SSL server...
    ...done.
    * Stopping Courier POP3 server...
    ...done.
    * Starting Courier POP3 server...
    ...done.
    * Stopping Courier POP3-SSL server...
    ...done.
    * Starting Courier POP3-SSL server...
    ...done.
    * Restarting web server apache2
    ... waiting ...done.
    Restarting ftp server: Running: /usr/sbin/pure-ftpd-mysql -l mysql:/etc/pure-ftpd/db/mysql.conf -l pam -b -A -O clf:/var/log/pure-ftpd/transfer.log -E -u 1000 -H -B
    Update finished.
     
  17. till

    till Super Moderator Staff Member ISPConfig Developer

    Might be that your database is broken and that the reason why you lost the data the first time too. Chack and repair your db with phpmyadmin and when everything is repaired, run the update again.
     
  18. quentusrex

    quentusrex New Member

    How do I find out which table that is?
     
  19. till

    till Super Moderator Staff Member ISPConfig Developer

    Seloect all tables in phpmyadmin and select check and then select all tables again and repair them.
     
  20. quentusrex

    quentusrex New Member

    All tables passed the phpmyadmin check. And I ran the update again, and the same issue.
     

Share This Page