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 3rd January 2007, 15:33
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default problem after upgrade from 2.2.8 to 2.2.9

Hello to all,

I have the following BIG, I think, problem after upgrade.
The database table isp_isp_web is empty. All the sites not working and options default users and all else value -1, boxes unchecked.

When I try to edit any of them it gives similar error to this:

This website already has 2 user(s). You cannot decrease the number of users.
This website already has 2 domain(s). You cannot decrease the number of domains.
This website already has 1 database(s). You cannot decrease the number of databases.

And I'm not trying to decrease anything.
Also the domain is empty.

Any ideas how to make it work? Even manually - by adding values to the database table or anything else.
It is a machine that I intended to put into production by the end of this week and it already has few sites.

Thanks,

Apostol
Reply With Quote
Sponsored Links
  #2  
Old 3rd January 2007, 16:33
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default mess

additionally ISPConfig deleted the whole /var/www/*
I use it with FC6 and everything was perfect before the upgrade

It deletes the whole directory when I delete one site - i checked it by recreating /var/www and deleting one of the sites in ISPConfig.

Last edited by smartcall; 3rd January 2007 at 16:38.
Reply With Quote
  #3  
Old 3rd January 2007, 17:57
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,241 Times in 4,108 Posts
Default

Never heard of that. What is the website root setting in ISPConfig?

Maybe you had not enough space in /tmp or /root or the update was interrupted.

Please have a look at your /tmp directory, there must be 2 tar.gz files with the Backup of the ISPConfig files and a .sql file with the content of the database.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 3rd January 2007, 18:23
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default problem

the root setting for the website is /var/www

the space:
Filesystem Size Used Avail Use% Mounted on
/dev/md0 23G 2.2G 20G 10% /
tmpfs 1014M 0 1014M 0% /dev/shm
/dev/md1 675G 355M 640G 1% /var

The only reason I can think of is that I added a new field in isp_isp_web table in order to make it possible to switch between php4 and php5. I used the form editor to to so.
And somehow this maybe confused the installer.

The installation went as usual with no interruption.
The very strange thing is the deletion of the /var/www after I emptied the recycle bin.
Could and inconsistency in the database do that?
All general settings are there and OK.

So what I finally did was to delete all sites and some leftovers from the database due to its inconsistency. Now it looks like working server, but all sites are lost.

Thanks,

Apostol

Last edited by smartcall; 3rd January 2007 at 18:36.
Reply With Quote
  #5  
Old 4th January 2007, 15:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
Default

Quote:
Originally Posted by smartcall
The only reason I can think of is that I added a new field in isp_isp_web table in order to make it possible to switch between php4 and php5. I used the form editor to to so.
And somehow this maybe confused the installer.
That's the problem. The updater makes an SQL dump of the old database (with your new field), then it creates the structure of the new database and imports the SQL dump. Because of your new field the import process failed, and at least the isp_isp_web table is empty.
__________________
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 4th January 2007, 15:39
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default how to prevent?

Quote:
Originally Posted by falko
That's the problem. The updater makes an SQL dump of the old database (with your new field), then it creates the structure of the new database and imports the SQL dump. Because of your new field the import process failed, and at least the isp_isp_web table is empty.
1. What would be the best solution to prevent this from happening in the future?
For example, finding the database sructure in the new version and creating the field in the SQL of the new database structure?

2. And still no ideas about the deleted /var/www?

The wrong database dump is the reason for the empty table, but I'm already afraid to delete and empty the Recycle Bin.

Regards,

Apostol
Reply With Quote
  #7  
Old 4th January 2007, 15:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
Default

Do you have a backup of /var/www somewhere?
To repair your ISPConfig, I suggest you restore the old version from the backups in the /tmp directory.
__________________
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 4th January 2007, 15:56
smartcall smartcall is offline
Senior Member
 
Join Date: Nov 2006
Posts: 116
Thanks: 10
Thanked 7 Times in 3 Posts
Default repaired

I repaired it by deleting all the sites and clients after it has deleted them all along with the parent www directory.
But now I just want to know is it safe to use it. Once it deleted the whole directory, could I expect similar behaviour in the future?

Regards,

Apostol
Reply With Quote
  #9  
Old 5th January 2007, 11:04
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,241 Times in 4,108 Posts
Default

Thats not easy to predict. I have never seen this behaviour before and I know many ISPConfig installations I can not imagine how it could have happened if the document root is set correctly
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #10  
Old 5th January 2007, 16:07
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
 
Default

Quote:
Originally Posted by smartcall
But now I just want to know is it safe to use it. Once it deleted the whole directory, could I expect similar behaviour in the future?

Regards,

Apostol
I think the problem was that the isp_isp_web table was empty after your update, and then you went into the ISPConfig web interface and made some changes there, so ISPConfig started to configure your system, and when it saw that there were no web sites in the isp_isp_web table, it removed the existing web sites in /var/www (this is part of the clean-up code in ISPConfig to free unused space).
__________________
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
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
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 12:20
Failed upgrade 2.2.8 to 2.2.9 bwrob Installation/Configuration 2 16th December 2006 18:29
2.2.8 wont upgrade my 2.2.7 bwrob Installation/Configuration 23 22nd November 2006 20:05
problem with upgrade [Debian Sarge] pontifex Installation/Configuration 1 24th June 2006 03:37
problem with upgrade badben Installation/Configuration 24 4th March 2006 14:22


All times are GMT +2. The time now is 06:09.


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