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

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

 

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.

 

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.

 

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.

 

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.

 

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.

 

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;

 

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#

 

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

 

nvm, found it. it was:

php -f /.../update.php

 

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.

 

How do I find out which table that is?

 

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