ISPConfig 2.2.10 Beta, any bugs known?

[till]

Hi,

does anybody found bugs in the current 2.2.10 beta except the SSL certificate bug? If not, I will start the packaging of the 2.2.10 final release today.

Till

[edge]

Till I would love to give you an answer, but this time I did not test it.

[till]

Till I would love to give you an answer, but this time I did not test it.

No problem at all :)

[Hans]

Hi Till,

I did not find anything wrong within the new 2.2.10 beta 1.
As far as i can verify it, all looks good:

-The installation on Debian Sarge was ok.
-Everything works nice and looks ok.

One thing: I have the feeling that not a lot of users, have tested it.
So, i hope it will install without errors on other distros as well.

[till]

One thing: I have the feeling that not a lot of users, have tested it.

I had the same feeling too. According to the logs the beta was downloaded about 50 times. I will do a final test and then release it.

Thanks for testing the Beta :)

[djtremors]

install was fine even though I have to always enter in bogus SSL details and then eventually extract my original certs file backup.

Upon logging in as admin, all sites "Basis" page has blank data.. ie. none of the ticks boxes are ticked and the Domain box is blank..?? weird.

The only thing that appears to stay intacted is the left tree view.

[till]

Please have a look in the mysql database, is the table isp_isp_web empty?

[djtremors]

Actually, it's alot worse.

All the configurations in Management->Server->Settings are totally lost or wrong.:(

The install appeared fine and detected Fedora 5 so I dunno why it put garage settings into my server....????

[djtremors]

Please have a look in the mysql database, is the table isp_isp_web empty?


ARRRGGHHH!!!! Yes it is... who! what! where..! Doh!!!!

[till]

Please have a look at your /tmp folder. Do you have there 2 tar.gz backup files from ISPConfig and a file ending with .sql which contains a backup of the database dump?

Please post the output of:

df -h

[djtremors]

root@ispc:~ # df
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
18981332 8932136 9069436 50% /
/dev/hda1 101086 14562 81305 16% /boot
tmpfs 62356 0 62356 0% /dev/shm


Yeah they exist
-rw-r--r-- 1 root root 804773931 Feb 21 21:07 home_admispconfig_02_21_2007__21_53_40.tar.gz
drwxr-xr-x 3 root root 4096 Feb 1 20:27 installer
-rw-r--r-- 1 root root 17747695 Feb 21 21:02 root_ispconfig_02_21_2007__21_53_40.tar.gz


I guess I gotta clear room. I suppose some more install checks wouldn't be a stray.

[till]

I just see the two tar.gz files. Is there no .sql file?

[djtremors]

sorry, yes.. I didn't select enough from putty...

-rw-r--r-- 1 root root 359137 Feb 21 21:53 existing_db_02_21_2007__21_53_40.sql

[till]

First, store a copy of the tar.gz files and the .sql file in a secure place so they dont get overwritten accidently in your temp directory.

Then try these steps:

1) Make a backup of your current (broken) ispconfig mysql database in case wee need it later.
2) empty the ispconfig database and delete all tables in it.
3) Load the mysqldump "existing_db_02_21_2007__21_53_40.sql" into the empty ispconfig database.

[djtremors]

1) Make a backup of your current (broken) ispconfig mysql database in case wee need it later.
Done.
2) empty the ispconfig database and delete all tables in it.
Done.
3) Load the mysqldump "existing_db_02_21_2007__21_53_40.sql" into the empty ispconfig database.
Oops, 2) didn't take into consideration that the SQL file doesn't create the database or even the tables.

I'm reimporting the backup and nuking the data in them.. brb

[djtremors]

OK.. finally got the database back. Might help to add a --add-drop-table and possibly a --add-drop-database as well as the only thing in that /tmp sql file was INSERTS so it made things harder.

Looks to be all there now and configs look like it's working.

Is that all there is to put this back to normal but upgraded, and what was the main reason for the problem? Something tells me not to apply this one to the office production server :P

[till]

OK.. finally got the database back. Might help to add a --add-drop-table and possibly a --add-drop-database as well as the only thing in that /tmp sql file was INSERTS so it made things harder.

Yes, maybe we can do another dump. This one is used by the installer internally and if it contains the statements for creating tables and the database, the update will fail.

Is that all there is to put this back to normal but upgraded,

Yes.

and what was the main reason for the problem?

Thats not easy to say. You can check the ispconfig_install.log for errors. The prblem was that the installer was not able to load the database dump back to your mysql database. Maybe the database failed in this moment or was unreachable. Having a look at the mysql or syslog log might help too.

Something tells me not to apply this one to the office production server :P

There has nothing changed in the update code that was not there in prior versions. The update works fine generally and if it fails it is a problem specific to this installation, but its up to you if you wont update your office server ;) But then you should not have updated it before as the code of the installer is identical with the code in older versions of the stable branch.

[djtremors]

OK. some things have changed on my version or the way it works now is different.

PHP Safe mode option is no longer there unde the PHP enable option..

also..

:Main:
Speicherplatz Datenbanken:
:ISP Server:Mail:
Passwort Cyrus-Admin:
MX prüfen:

Er.... german again.

[till]

Please have a look at the logs if you can find the error why the update has failed.

As your interface seems to be a bit inconsistent know, I guess it might be nescessary to run the update again to get everything up to date. Maybe there where other failures beside the database dump.

[djtremors]

which logs? i checked /var/log/messages and there's nothing there that could be ispc install related.

[till]

There should be a log /var/log/install_ispconfig.log or ispconfig_install.log

[djtremors]

/var/log/ispconfig_install.log

I read through the logs and there's no errors what so ever. Here's the last part of the logs...
Wed Feb 21 21:02:32 EST 2007 - [ISPConfig] - Directory /var/www/sharedip created.
Wed Feb 21 21:02:33 EST 2007 - [ISPConfig] - Use sharedip_index.html_en as SharedIP default page.
Wed Feb 21 21:02:33 EST 2007 - [ISPConfig] - saved /home/admispconfig/ispconfig/lib/config.inc.php
Wed Feb 21 21:02:33 EST 2007 - [ISPConfig] - saved /home/admispconfig/ispconfig/users
Wed Feb 21 21:02:33 EST 2007 - [ISPConfig] - saved /home/admispconfig/ispconfig/adminmail.txt
Wed Feb 21 21:02:51 EST 2007 - [ISPConfig] - created backup of directory /root/ispconfig/
Wed Feb 21 21:07:38 EST 2007 - [ISPConfig] - created backup of directory /home/admispconfig/
Wed Feb 21 21:07:40 EST 2007 - [ISPConfig] - deleted directory /root/ispconfig/
Wed Feb 21 21:53:37 EST 2007 - [ISPConfig] - unpacked ISPConfig system
Wed Feb 21 21:53:38 EST 2007 - [ISPConfig] - moved directory ispconfig_tmp to /root/ispconfig
Wed Feb 21 21:53:41 EST 2007 - [ISPConfig] - Connected successfully to db db_ispconfig
Wed Feb 21 21:53:44 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 775: dumped old db to file existing_db.sql
Wed Feb 21 21:53:44 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 777: moved root_ispconfig.tar.gz to /tmp/root_ispconfig_02_21_2007__21_53_40.tar.gz
Wed Feb 21 21:53:44 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 778: moved home_admispconfig.tar.gz to /tmp/home_admispconfig_02_21_2007__21_53_40.tar.gz
Wed Feb 21 21:53:44 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 779: copied existing_db.sql to /tmp/existing_db_02_21_2007__21_53_40.sql
Wed Feb 21 21:53:46 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 795: read in db_ispconfig.sql
Wed Feb 21 21:53:46 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 802: imported existing_db.sql
Wed Feb 21 21:53:46 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 884: deleted db_ispconfig.sql
Wed Feb 21 21:53:46 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 885: deleted existing_db.sql
Wed Feb 21 21:53:47 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 961: copied directory scripts to /root/ispconfig/
Wed Feb 21 21:53:47 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 962: copied directory sv to /root/ispconfig/
Wed Feb 21 21:53:47 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 965: copied directory isp to /root/ispconfig/
Wed Feb 21 21:53:47 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 966: copied cronolog to /root/ispconfig/
Wed Feb 21 21:53:47 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 967: copied cronosplit to /root/ispconfig/
Wed Feb 21 21:53:47 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 975: copied ispconfig_server to /etc/rc.d/init.d
Wed Feb 21 21:53:59 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 989: copied directory ispconfig to /home/admispconfig/ispconfig
Wed Feb 21 21:54:03 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 990: chown -R admispconfig:admispconfig /home/admispconfig
Wed Feb 21 21:54:04 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 993: chown -R admispconfig:mysql /home/admispconfig/ispconfig/backup
Wed Feb 21 21:54:04 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 994: chmod -R 770 /home/admispconfig/ispconfig/backup
Wed Feb 21 21:54:04 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1180: chmod 600 /home/admispconfig/ispconfig/lib/config.inc.php
Wed Feb 21 21:54:04 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1181: chown admispconfig:admispconfig /home/admispconfig/ispconfig/lib/config.inc.php
Wed Feb 21 21:54:04 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1273: create /etc/httpd/conf/vhosts/Vhosts_ispconfig.conf
Wed Feb 21 21:54:04 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1275: create /var/log/httpd/ispconfig_access_log
Wed Feb 21 21:54:05 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 582: /etc/rc.d/init.d/crond restart
Wed Feb 21 21:54:05 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1318: cp -f adminmail.txt /home/admispconfig/ispconfig
Wed Feb 21 21:54:05 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1354: mv -f /etc/Bastille /etc/Bastille.backup_02_21_2007__21_53_40
Wed Feb 21 21:54:05 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1356: cp -f isp/conf/bastille-firewall.cfg.master /etc/Bastille/bastille-firewall.cfg
Wed Feb 21 21:54:05 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1357: chmod 644 /etc/Bastille/bastille-firewall.cfg
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1379: mv -f /etc/rc.d/init.d/bastille-firewall /etc/rc.d/init.d/bastille-firewall.backup_02_21_2007__21_53_40
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1380: cp -f security/bastille-firewall /etc/rc.d/init.d
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1381: chmod 700 /etc/rc.d/init.d/bastille-firewall
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1383: mv -f /sbin/bastille-ipchains /sbin/bastille-ipchains.backup_02_21_2007__21_53_40
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1384: cp -f security/bastille-ipchains /sbin
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1385: chmod 700 /sbin/bastille-ipchains
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1387: mv -f /sbin/bastille-netfilter /sbin/bastille-netfilter.backup_02_21_2007__21_53_40
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1388: cp -f security/bastille-netfilter /sbin
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1389: chmod 700 /sbin/bastille-netfilter
Wed Feb 21 21:54:06 EST 2007 - [ISPConfig] - /root/ISPConfig2/install_ispconfig/install.php, Line 1435: delete /root/ispconfig/dist.inc.php
Wed Feb 21 21:54:09 EST 2007 - [ISPConfig] - httpd restart successful
Wed Feb 21 21:54:16 EST 2007 - [ISPConfig] - postfix restart successful
Wed Feb 21 21:54:26 EST 2007 - [ISPConfig] - file /root/ispconfig/dist.info deleted
Wed Feb 21 21:54:41 EST 2007 - [ISPConfig] - directory install_ispconfig deleted
Wed Feb 21 21:54:41 EST 2007 - [ISPConfig] - ##############################

[djtremors]

I just did a reinstall of ISPC 2.2.10 and the exact thing happened. Luckily this time I did a full backup of the database and restored it.

[till]

There is no error in the log. I Updated several servers from our clients with different linux distributions yesterday without any problems. I currently have no idea why it fails on your system.

[djtremors]

Is there some way I can manually update the database without having to butcher the install scripts but enough to make the upgrade possible?

[falko]

That would be very difficult if you don't know exactly what you're doing... :(

[djtremors]

well how about you surprise me. most likely an insert field here and there i'm sure.

[falko]

I mean *very* difficult - so diffcult I don't know myself without taking a look at the source code of the installer.

[djtremors]

I've been going through whats causing my "php safe mode" options to dissappear and I got to this point you might be able to help me figure out why it's like this after the 2.2.10 episodes..

in isp_web class, I've had to comment out the line

if($reseller["limit_frontpage"] != 1) {
//$doc->deck[0]->elements[22]->visible = 0;
$doc->deck[6]->elements[5]->visible = 0;
}


which for some reason element 22 is ACTUALLY the php_safe_mode option and it's somehow 22 and not 18 as per usual.....

any idea where this is messed up so I can try and correct my system?

If I disable this my PHP Safe Mode is visible again and if I use the option it does actually save the php safe mode settings.. it's just mistaken to be frontpage extensions in ISPC....

[djtremors]

FYI. I've repaired my database.

isp_isp_web and isp_isp_user had changes to the table structure which I had to just cut in/out whatever fields needed to make it line up and work.