#11  
Old 5th September 2006, 09:16
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default

Are you sure this is the old database though? Based on the date, it looks like it was created during the second update attempt. Are you sure it contains all the old users? Or did I replace the old one with a new one when I tried updating ISPConfig?
Reply With Quote
Sponsored Links
  #12  
Old 5th September 2006, 10:02
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:
Originally Posted by m u r
Are you sure this is the old database though? Based on the date, it looks like it was created during the second update attempt. Are you sure it contains all the old users? Or did I replace the old one with a new one when I tried updating ISPConfig?
Please post the output of:

ls -la /var/lib/mysql

To see the date when the database directory has been created.

Please run also:

mysql -u root -p
mysql> USE ispconfigdb;
mysql> SELECT * FROM isp_isp_web WHERE 1;

If you get a list of your websites, this database is the correct old one.
__________________
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:
m u r (5th June 2007)
  #13  
Old 5th September 2006, 19:21
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by m u r
Code:
mysql> mysql> USE ispconfigdb;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> USE ispconfigdb' at line 1
mysql> mysql> SELECT * FROM isp_isp_web WHERE 1;
Don't copy the mysql> from till's post. The queries (without mysql>) are:

Code:
USE ispconfigdb;
SELECT * FROM isp_isp_web WHERE 1;
__________________
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
  #14  
Old 5th September 2006, 20:55
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default

Nice. It looks like my sites are there (There are more, but it was too many characters -- in case you wondered why I was doing all this to salvage a few sites.). So now, I rename the database, install the PERL modules, re-install ISPConfig (The new version or the original version before I tried to update it?), then replace the database with the renamed database?

Last edited by m u r; 2nd August 2007 at 05:17.
Reply With Quote
  #15  
Old 6th September 2006, 08:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by m u r
So now, I rename the database, install the PERL modules, re-install ISPConfig (The new version or the original version before I tried to update it?), then replace the database with the renamed database?
Yes, that's right.
__________________
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
  #16  
Old 6th September 2006, 12:16
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default

So, do I install the new version of ISPConfig or the original version before I tried to update it (2.0.7)? Or does it matter?
Reply With Quote
  #17  
Old 6th September 2006, 18:38
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Try the original one and update later.
__________________
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
  #18  
Old 7th September 2006, 02:18
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default

I renamed "ispconfigdb" and tried to install the PERL modules.

When I tried install Net:NS, I got all kinds of errors, ending in the following:

Code:
DIED. FAILED test 1
        Failed 1/11 tests, 90.91% okay (less 10 skipped tests: 0 okay, 0.00%)
Failed Test               Stat Wstat Total Fail  Failed  List of Failed
-------------------------------------------------------------------------------
t/00-load.t                 75 19200    77  148 192.21%  1 3 5-77
t/01-resolver-env.t        255 65280    13   25 192.31%  1-13
t/01-resolver-file.t         1   256     8    1  12.50%  1
t/01-resolver-opt.t        255 65280    60  119 198.33%  1-60
t/01-resolver.t            255 65280    44   87 197.73%  1-44
t/02-header.t              255 65280    18   35 194.44%  1-18
t/03-question.t            255 65280    11   21 190.91%  1-11
t/04-packet-unique-push.t  255 65280    75  149 198.67%  1-75
t/04-packet.t              255 65280    39   77 197.44%  1-39
t/05-rr-opt.t              255 65280     7   13 185.71%  1-7
t/05-rr-rrsort.t           255 65280    22   44 200.00%  1-22
t/05-rr-sshfp.t              2   512    ??   ??       %  ??
t/05-rr-txt.t              255 65280    28   55 196.43%  1-28
t/05-rr-unknown.t          255 65280    18   35 194.44%  1-18
t/05-rr.t                  255 65280   226  451 199.56%  1-226
t/06-update.t              255 65280    72  143 198.61%  1-72
t/07-misc.t                255 65280    22   42 190.91%  1-22
t/09-tkey.t                  2   512     7   14 200.00%  1-7
t/10-recurse.t               2   512    ??   ??       %  ??
t/11-escapedchars.t          2   512    ??   ??       %  ??
t/11-inet6.t                 1   256    11    1   9.09%  1
2 tests and 17 subtests skipped.
Failed 21/24 test scripts, 12.50% okay. 739/805 subtests failed, 8.20% okay.
make: *** [test_dynamic] Error 1
  /usr/bin/make test -- NOT OK
Running make install
  make test had returned bad status, won't install without force
The final message after trying to install them all was the following:

Code:
/usr/bin/make install UNINST=1 -- OK

Last edited by m u r; 7th September 2006 at 15:03.
Reply With Quote
  #19  
Old 7th September 2006, 10:42
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

Is this a debian installation?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #20  
Old 7th September 2006, 14:54
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
 
Default

No, SuSe 9.2
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


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


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