Critical problem when trying to update to version 8.0

[BillieGDJoe]

Hi guys,



Im having a critical problem when trying to update to new version (8.0) from 7.5.4. The problem is:


This night, my Plesk 7.5.4 stop to work properly, e-mail service stops, with a error of relay denied. So I try to upgrade to Plesk 8.0. Then, the update from graphical interface not work. So, I try for the command line, with the autoinstaller:

# /usr/local/psa/admin/sbin/autoinstaller --select-release-id PLESK_8_0_0 --install-everything

The process starts well, until I got this error:

===> Installing and configuring Named Server

Stop running named daemon

Now BIND server shutting down...

Trying to stop BIND server... done
Trying to untar named run-root directory structure... done
Trying to set up default permissions... done
Trying to start BIND server... done

BIND server starts Ok.


Now BIND server shutting down...

Trying to stop BIND server... done
Trying to define super-server internet daemon type... xinetd
Trying to comment out old record for service poppassd... done
Trying to set up record for service poppassd... done
Trying to restart xinetd daemon... Trying to install chrooted environment... done
===> Installing phpMyAdmin
done
===> Cumulative upgrade has been started
Trying to install a new key... Installing /etc/psa/psa.key.
done
Trying to apply 8.0.0 changes to database...
ERROR while trying to upgrade SQL database from 750
Check the error reason(see log file: /tmp/psa_8.0.0_RedHat_el4_build80060331.13_upgrade.log), fix and try again

Aborting...

error: %post(psa-8.0.0-rhel4.build80060331.13.i586) scriptlet failed, exit status 1



The file /tmp/psa_8.0.0_RedHat_el4_build80060331.13_upgrade.log have:

===> Installing phpMyAdmin
done
Trying to install a new key... Installing /etc/psa/psa.key.
done
Trying to apply 8.0.0 changes to database... ERROR 1062 (23000) at line 179: Duplicate entry 'Teste-mysql' for key 2

=====================================
060509 15:45:37 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 19 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 119386, signal count 104761
Mutex spin waits 5775874, rounds 12735914, OS waits 56139
RW-shared spins 81828, OS waits 21020; RW-excl spins 257081, OS waits 17021
------------
TRANSACTIONS
------------
Trx id counter 0 17274081
Purge done for trx's n < 0 17271311 undo n < 0 0
History list length 107







Anyone please can help me ?? Thanks in advance !





BJ

 

[CiViX]

I had the same problem only my error was:

Trying to apply 8.0.0 changes to database... ERROR 1062 (23000) at line 179: Duplicate entry 'Joomla-mysql' for key 2

The problem seems to be that it finds entries in the table called "data_bases" (in the database "psa") which have the same name... earlier "joomla" and "Joomla" were considered different, but with PLESK8 it 's now case-insensitive, so these two name are treated as the same, hence the "duplicate error".

First delete the psa database and restore the original database. You'll find a dump of the original psa, mysql and horde databases here:
/var/lib/psa/dump/mysql.preupgrade.dump.gz

If there are multiple files ending with .1, .2 an so forth, use the oldest one (the one which was taken when your tried to upgrade to PLESK8 the first time).

First make a backupcopy and then unzip it:
# cp /var/lib/psa/dump/mysql.preupgrade.dump.gz /root
# gunzip -d /root/mysql.preupgrade.dump.gz

You'll now have the file /root/mysql.preupgrade.dump

Delete psa:
# mysql -uadmin -p psa
(Enter your admin-password when requested.)

mysql> drop database psa;
mysql> create database psa;
mysql> quit

Import the backup:
# mysql -uadmin -p < /root/mysql.preupgrade.dump
(Enter your admin-password when requested.)

When the original database have been restored, it's time to fix the problem.

You need to delete on of the values that are causing the problem. In your case these values are "teste" and "Teste". Log into mysql again and find the offending values:

# mysql -uadmin -p psa
mysql> select * from data_bases where name = 'Teste';

Remember the id og this row. Write down (or copy'n'paste) the values for this row so that you can put it back later.

Delete the row:
mysql> delete from data_bases where id = XXX;
(Where XXX is the id of the row with Teste.)

mysql> quit

Now change to the directory where the base-packages of PLESK8 are. If necessary download the tar.gz from the swsoft site, unpack and then change to the base-directory. Then force a reinstall:
# rpm -Uhv --force *.rpm

After the install is finished, you have to put back the rows you deleted. You can do this either in the shell or by logging into PLESK and using the administrators phpMyAdmin (DB WebAdmin).

I hope this helps!