[URGENT] : no more "sites" since update

[mumbly]

Hi,
i've done the update from ispconfig 2.2.23 to 2.2.24 on my Ubuntu 8.04 hardy heron server
Since this, some sites point to the "It works !" apache2 page... AND when i connect to ispconfig admin panel, i can see Clients and Sites. But if i click on the custumer's name/Site settings tab "Gestion de site" (in french), there is nothing !!!

I can see columns IP - Host Domain but there is several empty lines with nothing inside. This is the same thing for EVERY sites !

Hope i explain well : can you help me ???

[till]

1) Did you run the setup script more then once eg. because it stopped during update?
2) Any errors during update?

[mumbly]

1) no stop during update
2) just ran once !
3) no errors ...

[sites running again sionce i have reput the Vhosts_ispconfig.conf backup in /etc/apache2/vhost]

[mumbly]

It seems it's a SQL base problem ... I can say that because clients and sites seem no more "synced" and one of my site give an sql error :
Unknown column 'domaintype' in 'where' clause ...
Hum ... am i right ?
And the domain names in the "site ISP" tab are ALL gone !

[UPDATE] : isp_isp_web base is empty !!!
What happened ?

[mumbly]

OK ... all is ok now ... but i had to put my isp_isp_web backup because it was all empty after the update from 2.2.23 to 2.2.24 ...
I don't know what happened ...
When you have time, can you send me some advices about that ? thanx !

[falko]

What's the output of

df -h

?

[mumbly]

$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda2 146G 62G 78G 45% /
varrun 498M 132K 497M 1% /var/run
varlock 498M 0 498M 0% /var/lock
udev 498M 20K 498M 1% /dev
devshm 498M 0 498M 0% /dev/shm
/dev/sda1 38M 11M 26M 30% /boot

[gamma1it]

I am having a similar problem. I did the bind update on July 11th, after the update all was still working. I then rebooted the machine and the web server in ISP config control panel said web server offline and the sites were not on the web. I then went to update ispconfig and got an error that pointed to the httpd.conf file. I commented out the last include line ( Include /etc/apache2/vhosts/Vhosts_ispconfig.conf )and tried to update ISP config again. The update seemed okay this time and the web server ran but I got the Apache error screen for all site names. Today the server sudenly rebooted itself (code 15) and since then I no longer even get the Appache error message and the Web server says offline but is set to on. I have uncommented the line in the httpd.conf but its still ofline. All my sites are down and like an idiot.........I have no back up just RAID.

In my warn logs (SuSe 10.3) I see this message "zone my-domain.tld/IN: NS 'ns1.my-domain.tld' has no address records (A or AAAA)"

I still swear by ISP config and have a great deal of confidence in your support forums. Thanks in advance for all your efforts to get this resolved.

Aaron

[falko]

Any errors in Apache's error log?

[gamma1it]

Originally Posted by falko

Any errors in Apache's error log?

Hi Falko, nice to have your assistance again. Here is the end of my apache error log (found in /var/log/apache2/error_log) The first error (PHP) has been occurring since may but did not seem to have much of impact. The only trouble I was having was with the FTP.


[Fri Jul 11 12:17:37 2008] [error] an unknown filter was not added: PHP
[Fri Jul 11 12:18:27 2008] [error] an unknown filter was not added: PHP
[Fri Jul 11 12:18:27 2008] [error] an unknown filter was not added: PHP
[Fri Jul 11 12:18:33 2008] [error] an unknown filter was not added: PHP
[Fri Jul 11 12:18:33 2008] [error] an unknown filter was not added: PHP
[Fri Jul 11 12:18:35 2008] [error] an unknown filter was not added: PHP
[Fri Jul 11 12:18:35 2008] [error] an unknown filter was not added: PHP
[Fri Jul 11 12:20:49 2008] [notice] caught SIGTERM, shutting down
[Fri Jul 11 12:58:49 2008] [warn] Init: Session Cache is not configured [hint: SSLSessionCache]
[Fri Jul 11 12:58:49 2008] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec2)
[Fri Jul 11 12:58:50 2008] [notice] Apache/2.2.4 (Linux/SUSE) mod_ssl/2.2.4 OpenSSL/0.9.8e PHP/5.2.6 with Suhosin-Patch configured -- resuming normal operations
[Fri Jul 11 12:58:59 2008] [notice] caught SIGTERM, shutting down
[Fri Jul 11 12:58:59 2008] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec2)
[Fri Jul 11 12:58:59 2008] [notice] Apache/2.2.4 (Linux/SUSE) mod_ssl/2.2.4 OpenSSL/0.9.8e PHP/5.2.6 with Suhosin-Patch configured -- resuming normal operations
[Fri Jul 11 12:59:20 2008] [error]

I deleted the rest for this post

You guys are brilliant, thanks again!

Regards,

Aaron