#1  
Old 31st July 2006, 16:42
robd robd is offline
Member
 
Join Date: Dec 2005
Posts: 44
Thanks: 1
Thanked 1 Time in 1 Post
Exclamation 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!

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
Reply With Quote
Sponsored Links
  #2  
Old 31st July 2006, 16:52
robd robd is offline
Member
 
Join Date: Dec 2005
Posts: 44
Thanks: 1
Thanked 1 Time in 1 Post
Default

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.....?
Reply With Quote
  #3  
Old 31st July 2006, 16:56
robd robd is offline
Member
 
Join Date: Dec 2005
Posts: 44
Thanks: 1
Thanked 1 Time in 1 Post
Default

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.
Reply With Quote
  #4  
Old 31st July 2006, 17:06
robd robd is offline
Member
 
Join Date: Dec 2005
Posts: 44
Thanks: 1
Thanked 1 Time in 1 Post
Default 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
Reply With Quote
  #5  
Old 31st July 2006, 22:29
robd robd is offline
Member
 
Join Date: Dec 2005
Posts: 44
Thanks: 1
Thanked 1 Time in 1 Post
Default 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.
Reply With Quote
  #6  
Old 1st August 2006, 09:06
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,791
Thanks: 840
Thanked 5,612 Times in 4,423 Posts
Default

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?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 1st August 2006, 09:47
robd robd is offline
Member
 
Join Date: Dec 2005
Posts: 44
Thanks: 1
Thanked 1 Time in 1 Post
 
Exclamation

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question on upgrade to 2.2.5 ctroyp Installation/Configuration 12 2nd August 2006 14:15
Upgrade from Fedora 4 to Fedora 5 adamluz Installation/Configuration 4 16th June 2006 04:00
Upgrading failed, ispconfig broken and ispconfig won't upgrade again dfriis Installation/Configuration 7 14th June 2006 18:54
fedor core upgrade rahulgandhi Kernel Questions 1 11th April 2006 16:14
fedor core upgrade rahulgandhi Installation/Configuration 1 10th April 2006 22:51


All times are GMT +2. The time now is 12:42.


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