HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   upgrade to 2.2.5 emptied my DB? (http://www.howtoforge.com/forums/showthread.php?t=5913)

robd 31st July 2006 15:42

upgrade to 2.2.5 emptied my DB?
 
Hello

I have just upgraded from 2.2.2 to 2.2.5 following from earlier issues with my administration login.

I have attempted to login and I am unable to do so as my db_ispconfig is empty! :eek:

This clearly should not have happened!

What / how should I recover my database! (I have a backup.....)

I am not able to login to the isp_config administration server on :81

robd 31st July 2006 15:52

Quote:

Originally Posted by robd
how should I recover my database! (I have a backup.....)

To restore my db_ispconfig I did this:
Quote:

mysql -uroot -pmypassword db_ispconfig < restore.sql
I now have all the data in my database again. PHEW!
now what.....?

robd 31st July 2006 15:56

with data reimported into my db I am now unable to get to any of the sites that were hosted on this server. I am also unable to get to the https:81 admin sites.

One thing to point out - when I did the upgrade to 2.2.5 all was OK. I then connected to the https:81 admin insterface and received an error stating my certificate was invalid becuase it had a duplicate serial number. I recreated my certificates and then I discovered that I could get to the admin interface but not log in. This is how I discovered that I had nothing in my db_ispconfig.

robd 31st July 2006 16:06

here is my isp_config upgrade log
 
I guess this was the problem
Quote:

Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - Connected successfully to db db_ispconfig
Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 745: WARNING: could not dump old db to file existing_db.sql
Here is the rest of the log.
Quote:

Mon Jul 31 13:20:30 BST 2006 - [ISPConfig] - ##############################
Mon Jul 31 13:29:25 BST 2006 - [ISPConfig] - installation directory: /root/install_ispconfig
Mon Jul 31 13:29:25 BST 2006 - [ISPConfig] - operating system: Fedora 4.0
Mon Jul 31 13:29:29 BST 2006 - [ISPConfig] - Upgrade einer existierenden ISPConfig-Installation. / Upgrading an existing ISPConfig installation. / Mise ? jour d'une installation d'ISPConfig existante.
Mon Jul 31 13:29:29 BST 2006 - [ISPConfig] - ISPConfig server stopped
[root@ns5 log]#
Mon Jul 31 13:00:32 BST 2006 - [ISPConfig] - saved /home/admispconfig/ispconfig/lib/config.inc.php
Mon Jul 31 13:00:32 BST 2006 - [ISPConfig] - saved /home/admispconfig/ispconfig/users
Mon Jul 31 13:00:32 BST 2006 - [ISPConfig] - saved /home/admispconfig/ispconfig/adminmail.txt
Mon Jul 31 13:00:40 BST 2006 - [ISPConfig] - created backup of directory /root/ispconfig/
Mon Jul 31 13:00:44 BST 2006 - [ISPConfig] - created backup of directory /home/admispconfig/
Mon Jul 31 13:00:45 BST 2006 - [ISPConfig] - deleted directory /root/ispconfig/
Mon Jul 31 13:20:00 BST 2006 - [ISPConfig] - unpacked ISPConfig system
Mon Jul 31 13:20:01 BST 2006 - [ISPConfig] - moved directory ispconfig_tmp to /root/ispconfig
Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - Connected successfully to db db_ispconfig
Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 745: WARNING: could not dump old db to file existing_db.sql
Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 747: moved root_ispconfig.tar.gz to /tmp/root_ispconfig_07_31_2006__13_20_05.tar.gz
Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 748: moved home_admispconfig.tar.gz to /tmp/home_admispconfig_07_31_2006__13_20_05.tar.gz
Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 749: copied existing_db.sql to /tmp/existing_db_07_31_2006__13_20_05.sql
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 765: read in db_ispconfig.sql
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 772: imported existing_db.sql
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 854: deleted db_ispconfig.sql
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 855: deleted existing_db.sql
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 931: copied directory scripts to /root/ispconfig/
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 932: copied directory sv to /root/ispconfig/
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 935: copied directory isp to /root/ispconfig/
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 936: copied cronolog to /root/ispconfig/
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 937: copied cronosplit to /root/ispconfig/
Mon Jul 31 13:20:06 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 945: copied ispconfig_server to /etc/rc.d/init.d
Mon Jul 31 13:20:11 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 959: copied directory ispconfig to /home/admispconfig/ispconfig
Mon Jul 31 13:20:11 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 960: chown -R admispconfig:admispconfig /home/admispconfig
Mon Jul 31 13:20:11 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 963: chown -R admispconfig:mysql /home/admispconfig/ispconfig/backup
Mon Jul 31 13:20:11 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 964: chmod -R 770 /home/admispconfig/ispconfig/backup
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1140: chmod 600 /home/admispconfig/ispconfig/lib/config.inc.php
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1141: chown admispconfig:admispconfig /home/admispconfig/ispconfig/lib/config.inc.php
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1233: create /etc/httpd/conf/vhosts/Vhosts_ispconfig.conf
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1235: create /var/log/httpd/ispconfig_access_log
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 573: /etc/rc.d/init.d/crond restart
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1277: cp -f adminmail.txt /home/admispconfig/ispconfig
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1313: mv -f /etc/Bastille /etc/Bastille.backup_07_31_2006__13_20_05
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1315: cp -f isp/conf/bastille-firewall.cfg.master /etc/Bastille/bastille-firewall.cfg
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1316: chmod 644 /etc/Bastille/bastille-firewall.cfg
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1338: mv -f /etc/rc.d/init.d/bastille-firewall /etc/rc.d/init.d/bastille-firewall.backup_07_31_2006__13_20_05
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1339: cp -f security/bastille-firewall /etc/rc.d/init.d
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1340: chmod 700 /etc/rc.d/init.d/bastille-firewall
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1342: mv -f /sbin/bastille-ipchains /sbin/bastille-ipchains.backup_07_31_2006__13_20_05
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1343: cp -f security/bastille-ipchains /sbin
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1344: chmod 700 /sbin/bastille-ipchains
Mon Jul 31 13:20:12 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1346: mv -f /sbin/bastille-netfilter /sbin/bastille-netfilter.backup_07_31_2006__13_20_05
Mon Jul 31 13:20:13 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1347: cp -f security/bastille-netfilter /sbin
Mon Jul 31 13:20:13 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1348: chmod 700 /sbin/bastille-netfilter
Mon Jul 31 13:20:13 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 1394: delete /root/ispconfig/dist.inc.php
Mon Jul 31 13:20:13 BST 2006 - [ISPConfig] - httpd restart successful
Mon Jul 31 13:20:16 BST 2006 - [ISPConfig] - postfix restart successful
Mon Jul 31 13:20:24 BST 2006 - [ISPConfig] - file /root/ispconfig/dist.info deleted
Mon Jul 31 13:20:30 BST 2006 - [ISPConfig] - directory install_ispconfig deleted

robd 31st July 2006 21:29

suggestion for next release
 
Suggest that in the next release there is an exception inserted to the upgrade script. When you run the ./setup the script checks to see if it is upgrading an existing installation and makes backups of the config files and database.

It would have been helpful if the upgrade stopped - or at least prompted - when the backup of the system db fails when upgrading. At present the following message is written to the log file
Quote:

Mon Jul 31 13:20:05 BST 2006 - [ISPConfig] - /root/install_ispconfig/install.php, Line 745: WARNING: could not dump old db to file existing_db.sql
I say would have been as I am currently crying into my beer over a very kippered server.

Boo Hoo. :(

till 1st August 2006 08:06

Quote:

Originally Posted by robd
Suggest that in the next release there is an exception inserted to the upgrade script. When you run the ./setup the script checks to see if it is upgrading an existing installation and makes backups of the config files and database.

The script makes backups of the database and files.

Quote:

It would have been helpful if the upgrade stopped - or at least prompted - when the backup of the system db fails when upgrading. At present the following message is written to the log file
Yes, the setup script shall stop then.

This problem may only happen if you changed your ISPConfig database settings or your mysql configuration that ISPConfig is not able anymore to connect to the database. This caused also your login problem.

Do you have a database dump as backup?

robd 1st August 2006 08:47

Hi Till, Thanks for your response. The upgrade script is great - it has worked on my other servers no problem. You like the idea of prompting the user in the failure of backup? :)

Last night I have recovered my system database from my backup - I will post my steps here later to share with others.

All things working - all good :) /rob


All times are GMT +2. The time now is 18:20.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.