Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 2nd May 2007, 21:46
NuttyGambler NuttyGambler is offline
Junior Member
 
Join Date: Oct 2006
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default Upgrade... lost the database

Just did an upgrade to 2.2.12.

I have lost everything, all sites, users, database etc.

I did use the backup utility a while ago. (didn't before the upgrade) where does this get saved? Are there any auto backups done with the upgrade?

I still have my directories just no database.
Can I just start creating the same domains in the same order or is it going to delete those directories too?

Given all email and web is currently down, for our company, need to either recover what I can or start over very quickly.

Thanks.
Reply With Quote
Sponsored Links
  #2  
Old 2nd May 2007, 22:30
NuttyGambler NuttyGambler is offline
Junior Member
 
Join Date: Oct 2006
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default Update

OK: I have been able to get email back up. Given I believe ISPConfig simply modifies the cfg files of the various applications.

We are not a big company, and the web items are not critical (as to have to have them now), so I would like to refine my question to this.

Can I enter the sites in the same order as they where entered before so I get web1, web2 the same, reenter the users and I will not break the working email applications?

Is there files I should manually back-up before I do this?

Thanks again. Stupid me not having a current database back-up.
Reply With Quote
  #3  
Old 3rd May 2007, 09:16
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,340
Thanks: 810
Thanked 5,170 Times in 4,054 Posts
Default

ISPConfig creates a backup during update. The backup is placed in your /tmp directory.

Why do you lost the database? Did you run the setup script more then once without recreating the /root/ispconfig directory or do you run out of harddisk space during update?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 3rd May 2007, 14:17
NuttyGambler NuttyGambler is offline
Junior Member
 
Join Date: Oct 2006
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default uggh

No I did not do any special creation before rerunning the script.

It did not run correctly the first time, and reran it.

It then wipes out the database?

I do see backups in my tmp directory. But they do not appear large enough either.
I believe someone may have gotten access to the system and wiped out the databases, before I ran the upgrade.
With the assumption I do not have a database backup.

Can I recreate the hosts and users and be OK as long as the hosts are in the right order?

Last edited by NuttyGambler; 3rd May 2007 at 14:23.
Reply With Quote
  #5  
Old 3rd May 2007, 14:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,714 Times in 2,556 Posts
Default

Quote:
Originally Posted by NuttyGambler
I do see backups in my tmp directory. But they do not appear large enough either.
What's the output of
Code:
ls -la /tmp
and
Code:
df -h
?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 3rd May 2007, 14:41
NuttyGambler NuttyGambler is offline
Junior Member
 
Join Date: Oct 2006
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
What's the output of
Code:
ls -la /tmp
and
Code:
df -h
?
ls -la /tmp
total 146128
drwxrwxrwt 14 root root 20480 May 3 07:38 .
drwxr-xr-x 24 root root 4096 May 3 06:57 ..
-rw------- 1 root root 747 May 2 12:59 existing_db_05_02_2007__12_59_09.sql
-rw------- 1 root root 304122 May 2 13:24 existing_db_05_02_2007__13_24_06.sql
-rw------- 1 root root 304122 May 2 13:51 existing_db_05_02_2007__13_51_18.sql
drwxrwxrwt 2 root root 4096 May 3 06:57 .font-unix
drwx------ 3 root root 4096 May 3 06:58 gconfd-root
-rw------- 1 root root 140 May 3 06:58 .gdm425WRT
srw-rw-rw- 1 root root 0 May 3 06:58 .gdm_socket
srwxr-xr-x 1 root root 0 May 3 07:27 gedit.root.3648525463
srwxr-xr-x 1 root root 0 May 2 11:46 gnome-system-monitor.root.2749371787
-rw------- 1 root root 31061993 May 2 12:45 home_admispconfig_05_02_2007__12_59_09.tar.gz
-rw------- 1 root root 31567970 May 2 13:07 home_admispconfig_05_02_2007__13_24_06.tar.gz
-rw------- 1 root root 31568166 May 2 13:36 home_admispconfig_05_02_2007__13_51_18.tar.gz
-rw-rw-r-- 1 apache apache 93 Apr 25 14:16 .htaccess
drwxrwxrwt 2 root root 4096 May 3 06:58 .ICE-unix
drwx------ 2 root root 4096 May 3 06:58 keyring-d6kiXX
drwx------ 2 root root 4096 Nov 15 11:56 keyring-jvDSdE
drwx------ 2 root root 4096 Jan 16 12:38 keyring-N5Jd6o
drwx------ 2 root root 4096 Jan 22 08:41 keyring-Ve8lvZ
drwx------ 2 root root 4096 Dec 5 10:06 keyring-W1Z4Ki
srwxr-xr-x 1 root root 0 May 3 06:58 mapping-root
drwx------ 2 root root 4096 May 3 07:37 orbit-root
srwxr-xr-x 1 root root 0 Nov 15 12:16 OSL_PIPE_0_SingleOfficeIPC_dff687f33e731547a7abecf d29de83
-rw------- 1 root root 18173252 May 2 12:44 root_ispconfig_05_02_2007__12_59_09.tar.gz
-rw------- 1 root root 18167292 May 2 13:07 root_ispconfig_05_02_2007__13_24_06.tar.gz
-rw------- 1 root root 18168069 May 2 13:36 root_ispconfig_05_02_2007__13_51_18.tar.gz
-rw------- 1 root root 0 May 3 07:01 sess_051d2a43936e2447bf49ee0e9de8be7f
-rw------- 1 admispconfig admispconfig 25 May 3 06:55 sess_17712bea37555506455fe13c353c28ee
-rw------- 1 root root 0 May 3 06:58 sess_23f6e5428abae52a939bb71be1822099
-rw------- 1 root root 0 May 3 03:15 sess_56a05ed8e19aa6e3f39c99990b357f7f
-rw------- 1 root root 0 May 3 04:00 sess_68656e9203fed00fa49e5d254925c733
-rw------- 1 admispconfig admispconfig 25 May 3 07:01 sess_a670dcbd86bfcbeeac905924d62b9bd4
-rw------- 1 root root 0 May 3 07:03 sess_be133183ab2a55e21dfdc8b74966cbce
drwx------ 2 root root 4096 May 3 06:58 ssh-UePMNE2959
drwx------ 2 root root 4096 May 3 06:58 virtual-root.Weq8PW
-r--r--r-- 1 root root 11 May 3 06:58 .X0-lock
drwxrwxrwt 2 root root 4096 May 3 06:58 .X11-unix

******************
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
143G 17G 119G 13% /
/dev/sda1 99M 17M 77M 18% /boot
tmpfs 999M 0 999M 0% /dev/shm
Reply With Quote
  #7  
Old 4th May 2007, 13:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,714 Times in 2,556 Posts
Default

Quote:
Originally Posted by NuttyGambler
-rw------- 1 root root 747 May 2 12:59 existing_db_05_02_2007__12_59_09.sql
-rw------- 1 root root 304122 May 2 13:24 existing_db_05_02_2007__13_24_06.sql
-rw------- 1 root root 304122 May 2 13:51 existing_db_05_02_2007__13_51_18.sql
These are your ISPConfig database backups.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #8  
Old 10th June 2007, 10:25
tazmon95 tazmon95 is offline
Junior Member
 
Join Date: Nov 2006
Posts: 29
Thanks: 4
Thanked 1 Time in 1 Post
Default

well I had a similar thing happen. But when I typed in

ls -la /tmp

I don't see anything similar to

-rw------- 1 root root 747 May 2 12:59 existing_db_05_02_2007__12_59_09.sql
-rw------- 1 root root 304122 May 2 13:24 existing_db_05_02_2007__13_24_06.sql
-rw------- 1 root root 304122 May 2 13:51 existing_db_05_02_2007__13_51_18.sql

What happened was I was doing the update via ssh, and I got preoccupied with something else, When I came back my session had timed out but it was to the point where it asked me for an email address for ISPConfig to use. I went back and tried to re-run the install but as soon as I noticed this was for a fresh install I canceled out.

The last backup of the ful database was last night with no changes made since then other than running the upgrade script. What is the best way for me to proceed?

Thanks
Reply With Quote
  #9  
Old 10th June 2007, 14:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,340
Thanks: 810
Thanked 5,170 Times in 4,054 Posts
Default

Please run:

mkdir /root/ispconfig

and unpack and start the ISPConfig setup again. At the point where the installer skas for the email address, the database was not even touched yet.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 10th June 2007, 15:08
tazmon95 tazmon95 is offline
Junior Member
 
Join Date: Nov 2006
Posts: 29
Thanks: 4
Thanked 1 Time in 1 Post
 
Default

Till,

Thanks for the quick reply. I've tried that and I get


########## INSTALLATION ##########

Preparing files. Please wait a moment...
cp: cannot stat `/root/ispconfig/httpd/conf/ssl.*': No such file or directory


Any help would be much appreciated. I have the backup of my database but not a backup of the files.




EDIT: After letting it sit for about 20 mins it continued with the install. I'm going to watch it this time...

Last edited by tazmon95; 10th June 2007 at 15:35.
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
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
Database not migrated after upgrade (2.2.9->2.2.10) okhayat Installation/Configuration 3 3rd March 2007 13:43
Recreating ISPConfig database retran Installation/Configuration 2 15th April 2006 23:22
Postfix conf lost when upgrade Prompt Developers' Forum 0 20th November 2005 23:11


All times are GMT +2. The time now is 07:52.


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