I'm dying!

[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?

[till]

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.

[falko]

Originally Posted by m u r

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:

USE ispconfigdb;
SELECT * FROM isp_isp_web WHERE 1;

[m u r]

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?

[falko]

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.

[m u r]

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?

[falko]

Try the original one and update later.

[m u r]

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:

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:

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

[till]

Is this a debian installation?

[m u r]

No, SuSe 9.2