#1  
Old 20th April 2008, 19:39
bixa bixa is offline
Junior Member
 
Join Date: Mar 2006
Location: Sierndorf, Austria
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default Update Problem

I'm using ISPC for years now, never had any serious Problems. Thanks for this great software.
I did a update to 2.2.23, everthing fine except I had to input the mysql config. But then i was editing a client and i didnot find any db stuff under options. It even removed the db users AND the databases of this client (only from the client i was editing).
So i recovered the dbs from backup, but i can't create any db-users in ISPConfig and when i view(!) a client, his dbs get dropped. Do you have a hint for me?
Thanks!
Reply With Quote
Sponsored Links
  #2  
Old 20th April 2008, 19:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Quote:
I did a update to 2.2.23, everthing fine except I had to input the mysql config.
Please explain what you id exactly here. Thats most likely causing the problems. The SQL dump can not be inserted manually, if you do it, ISPConfig will fail.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 20th April 2008, 19:56
bixa bixa is offline
Junior Member
 
Join Date: Mar 2006
Location: Sierndorf, Austria
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default

I started the update normaly (.setup)
ssh was interrupted (*smells like the orgin of troubles*) i had no screen active, so startet the ./setup again.
The setupscript asked for the mysqlserver, user,....
I think I've skrewed up the updateprocess and did a normal install.

(i've just restored the client dump so far)
Reply With Quote
  #4  
Old 20th April 2008, 20:47
bixa bixa is offline
Junior Member
 
Join Date: Mar 2006
Location: Sierndorf, Austria
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default

I had a look in the install log:
The first upgrade deleted the directory /root/ispconfig befor it was interrupted.
Therefor the second one was fresh install.

So the problem is:
I did a fresh install over a existing install!
Now there is this db-dropping-problem.
Where there any changes in the db layout?
Reply With Quote
  #5  
Old 20th April 2008, 22:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Please have a look in the /tmp directory if there are any backups made by the installer during first upgrade attempt.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 21st April 2008, 08:45
bixa bixa is offline
Junior Member
 
Join Date: Mar 2006
Location: Sierndorf, Austria
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
Default

No, I'm afraid there is nothing usefull in /tmp
"find /tmp -atime 1" only shows crap.

Is it possible to insert the dump from ispconfigdb taken before the update and then redo the update?

btw
This all things sound like this is the perfekt time to update to deb 4.0 ("never change a RUNNING system"). Would it be possible to reinstall ispconfig on etch and insert the dump as a backup?

btw
Thanks for your effort.
Reply With Quote
  #7  
Old 21st April 2008, 11:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Quote:
Is it possible to insert the dump from ispconfigdb taken before the update and then redo the update?
Yes, that should work.

Quote:
This all things sound like this is the perfekt time to update to deb 4.0 ("never change a RUNNING system"). Would it be possible to reinstall ispconfig on etch and insert the dump as a backup?
Yes and no. Beside the database backup, you will have to move the system users manually. Please have a look here to get a list of needed files:

http://www.howtoforge.com/forums/showthread.php?t=2717
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
bixa (21st April 2008)
  #8  
Old 21st April 2008, 12:10
bixa bixa is offline
Junior Member
 
Join Date: Mar 2006
Location: Sierndorf, Austria
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
 
Default

Thanks a lot. Everything is working again!
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
Strange problem with Firefox and PHP after update of ISPconfig heinerlamprecht Installation/Configuration 3 10th October 2008 14:23
php4 problem after update Aloa Installation/Configuration 2 14th February 2008 12:23
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 19:38
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19


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


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