PSA database version does not match

[ghazaly]

Hi..

I have a problem with my Plesk installation after I upgraded to the most recent version. The installation stopped because there was a problem with starting MySQL. Afterwards, I looked at the errors generated by the installation script and I think I know that some PSA database upgrading was not completed. This installation that failed was done thru the GUI.

I read some posts on how to correct the MySQL would not start problem (something to do with the .sock file) so I managed to get MySQL back up. At this stage my Plesk Admin was not working.

So I try to find posts in this forum on how I could fix it. I read some posts on the forum and tried one of the suggestions of using "./autoinstaller" from the terminal. So I did that and then the installation somehow proceeded smoothly (it didn't terminate mid-way this time.. but finished until the end). Although there were some errors in inserting data into MySQL (coz the table / column is not there you see).

So now, I have the most recent version of Plesk files, but a previous version of the PSA database. And when I try to access the Plesk Admin page, I get the following error:

ERROR: PleskFatalException


StatInfo->getProductVersion failed: file_get_contents() failed:

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/common_func.php3:153
psaerror(string 'StatInfo->getProductVersion failed: file_get_contents() failed: ')
1: /usr/local/psa/admin/plib/common_func.php3:37
getProductNameVersion()
2: /usr/local/psa/admin/htdocs/login.php3:32

Please, can someone tell me what to do or give me some ideas on how to proceed ? Is there somewhere I can download the PSA database structure for a certain Plesk version, so that I can fix my old PSA database to match the correct one?

Or is there any way I could downgrade my Plesk to the version I was using before (i.e. same as the PSA database).

Please someone... help me!
Any help or feedback is greatly appreciated.

 

[Mirco@]

Hello,

During the update it will create a backup of the required databases (psa, horde and mysql) in $DUMP_D/mysql.preupgrade.dump.gz
which you can use to restore your databases to the previous version.

 

[ghazaly]

Hi Mirco,

thanks for the reply...

however, my PSA database is already the "previous version" since it wasn't upgraded.

What I need is either:

1. New database structure for PSA

OR

2. Downgrade my Plesk files to match the old PSA database that I have

I think I prefer no. (2) above since I don't have to mess with the database, just need to replace Plesk files.

appreciate any help on this matter...
Thanks!

 

[ghazaly]

Please help....

please someone help me....
can anyone tell me how to "downgrade" my Plesk version?

If I use "./autoinstaller", I can only see the latest version of Plesk available. How can I select the previous version to downgrade?

Thanks!

 

[cd_boyz]

Unfortunately, there is no way to downgrade the Plesk other than fresh install the Plesk earlier version, and restore the data back.

Is there any error message in the upgrade log which located in /tmp ?

 

[ghazaly]

Hi... thanks for your answer!

How can I reinstall Plesk for a specific version? Where can I download the installer for e.g. version 7.5 etc.?

How can I check which version of the PSA database I have so that I can properly select the Plesk version to install?

I will post the errors later.

Thank you!

 

[cd_boyz]

Originally posted by ghazaly
Hi... thanks for your answer!

How can I reinstall Plesk for a specific version? Where can I download the installer for e.g. version 7.5 etc.?

How can I check which version of the PSA database I have so that I can properly select the Plesk version to install?

You may download the Plesk installer here (ftp://download1.swsoft.com/). Then just do a fresh install and restore the earlier dump.

I have no idea how to check the PSA database version... Anyone in this forum knows?

What version do you get when you run below command?
# rpm -qa | grep psa

# cat /usr/local/psa/vesrion

For the log file, it should looks like tmp/psa-8.1.0-...upgrade.log

 

[cd_boyz]

Originally posted by cd_boyz


I have no idea how to check the PSA database version... Anyone in this forum knows?

Just check in my Plesk, to get the version of the psa DB, run this command in mysql.
mysql> select * from misc where param='version';

 

[ghazaly]

cd_boyz... thank you so much for your answers.

I will try what you suggested and report back later on the results.

 

[lvalics]

ls /usr/local/psa/etc/

see here, should be all DB SQL
hope this help, but need to execute manually.

I suggest to do a DIFF to your actual version.

 

[ghazaly]

Hi all,

i have tried running the installer, but I think there is a problem because it detects that I already have Plesk installed. Do I need to uninstall first and then reinstall?

How can I uninstall the current broken Plesk I have?

BTW, can someone please share his/her fresh "PSA" database dump here or send it to me via e-mail. Because I'm sure if I just converted my current 7.5.4 PSA database to the latest 8.1 version everything would work fine (I think!).

I tried to find the script that actually does the "upgrading" of the database but cannot find it. I think it's somewhere in there, hidden among the RPM files.

I managed to "fix" the earlier error I mentioned on my Plesk admin login page. I was just missing the "/usr/local/psa/version" file. However, now I have a new error and it says something about a missing table.

So that's why I think I just need to upgrade my 7.5.4 PSA database to the latest version to solve my problem.

Please... can anyone help?
Thanks!

 

[lvalics]

You cannot uninstall will not work as you expect.
So you need to do manually the job, I know it take usually 3-4 hours of work until you can see the diff between actual PSA Db and latest installed PLESK DB.

 

[ghazaly]

Hi Ivalics,

thank you for your reply... but, I'm sorry I did not quite get what you were saying. You mean I should not uninstall?

Can you please explain what do you mean by doing the job manually?

FYI, I don't have the latest PSA database so I cannot DIFF against anything. The PSA database in my MySQL server is the same as the one in the backup folder (which was made just before the upgrade process started). So if I DIFF'ed that, I will get 0 (no difference).

If you have a fresh 8.1 installation, can you please share your PSA database? I think I just need the structure, but I don't really know, because there might be some new fields for the new features.

Thanks!

 

[lvalics]

I think (not sure) that your database was not upgraded on upgrade.
You can see all databases on shell:
ls /usr/local/psa/etc/

Here you will see all DB.
Export your one and compare with latest from here.

The upgrade the difference.
Also you can export actual one as backup, with DATA as well.
Delete the tables from it and install from psa_db.sql all data, then go into your backup and all INSERT INTo try to import into new DB. This is how I fixed a broken upgrade, it was the only way.
I hope this help.
Then after this is done, try to install again the update 8.1 from PLESK.

Also check /usr/local/psa/version, what is here?
Also there is possibilities to not upgraded this number and then you will need to upgrade it manually.

 

[nibb@]

Well i think i have the same problem. I runned the installer from the panel from 8.01 to 8.1. It updated everything except Plesk. The plesk panel still says 8.01 but i see some new features on 8.1. It only upgraded to the half it seems since i get tons of Database errors.

[root@server temp]# rpm -qa | grep psa
psa-qmail-1.03-rhel3.build81061129.22
frontpage-5.0-72psa.rhel3
psa-autoinstaller-3.1.0-build31061201.02
psa-fcgi-2.4.0-1
psa-horde-3.1.3-rhel3.build81070201.15
psa-8.0.1-rhel3.build80060613.20
psa-mimp-1.0-rhel3.build81061129.22
perl-HTML-Format-1.23-53psa.rhel3.build81061129.22
psa-8.1.0-rhel3.build81061129.22
perl-MLDBM-2.01-63psa.rhel3.build81061129.22
psa-proftpd-1.3.0-rhel3.build81061129.22
psa-courier-imap-add-8.1.0-rhel3.build81061129.22
psa-hotfix7-8.0.1-rhel3.build80061018.17
psa-api-rpc-8.1.0-rhel3.build81061226.14
psa-mod_fcgid-1.10-3
psa-hotfix4-8.0.1-rhel3.build80060728.17
psa-hotfix3-8.1.0-rhel3.build81061212.22
psa-ruby-rake-0.7.1-200610081530
psa-hotfix5-8.0.1-rhel3.build80060903.14
psa-migration-manager-8.1.0-rhel3.build81061226.14
psa-mailman-configurator-8.1.0-rhel3.build81061129.22
psa-passwd-3.0-rhel3.build81061129.22
psa-watchdog-2.0.2-rhel3.build81061129.22
psa-ftputil-8.1.0-rhel3.build81061129.22
perl-Font-AFM-1.18-63psa.rhel3.build81061129.22
psa-ruby-fcgi-0.8.7-200610081531
psa-locale-es-ES-8.1-build81061127.19
psa-hotfix5-8.1.0-rhel3.build81070201.15
perl-FreezeThaw-0.43-63psa.rhel3.build81061129.22
drweb-base-4.33-rh5_psa
psa-backup-manager-8.1.0-rhel3.build81061226.14
psa-mod-fcgid-configurator-1.0-13
psa-locale-base-en-US-8.1.0-rhel3.build81070201.15
psa-ruby-activerecord-1.14.4-200610081530
drweb-daemon-4.33-rh5_psa
psa-proftpd-xinetd-1.3.0-rhel3.build81061129.22
psa-ruby-activesupport-1.3.1-200610081530
mod_jk-ap20-1.2.15-42psa.rhel3
perl-Text-Iconv-1.2-24psa.rhel3.build81061129.22
psa-ruby-actionpack-1.12.5-200610081531
psa-hotfix2-8.1.0-1
psa-ruby-rails-1.1.6-200610081532
psacct-6.3.2-35.rhel3
psa-pylibplesk-8.1.0-rhel3.build81061130.15
psa-ruby-actionmailer-1.2.5-200610081531
psa-kronolith-2.1.3-rhel3.build81061129.22
psa-imp-4.1.3-rhel3.build81061129.22
drweb-updater-4.33-rh4_psa
psa-spamassassin-8.1.0-rhel3.build81061129.22
psa-mnemo-2.1.1-rhel3.build81061129.22
perl-MLDBM-Sync-0.30-63psa.rhel3.build81061129.22
psa-hotfix6-8.1.0-rhel3.build81070224.19
psa-boost-1.32.0-6.rhel3
psa-firewall-1.0.1-rhel3.build81061129.22
psa-php4-configurator-1.0.0-rhel3.build80060331.13
psa-logrotate-3.7-rhel3.build81061129.22
psa-qmail-rblsmtpd-0.70-rhel3.build81061129.22
psa-api-8.1.0-rhel3.build81061226.14
psa-hotfix9-8.0.1-rhel3.build80061203.19
psa-tomcat-configurator-8.1.0-rhel3.build81061129.22
psa-hotfix1-8.0.1-rhel3.build80060618.11
psa-predb-8.1.0-rhel3.build81061213.17
psa-ingo-1.1.2-rhel3.build81061129.22
psa-hotfix4-8.1.0-rhel3.build81061226.14
psa-libpam-plesk-8.1.0-rhel3.build81061129.22
psa-rubyrails-configurator-1.1.6-rhel3.build81061129.22
psa-turba-2.1.3-rhel3.build81061129.22
psa-ruby-1.8.5-200610081528
psa-ruby-actionwebservice-1.1.6-200610081531

This command gives:
[root@server temp]# cat /usr/local/psa/version
8.0.1 RedHat el3 81070224.19

I runned the autoinstallee to see if i could fix this, i downloaded it from Plesk for Red Hat Es 3
And i get until here:
Download file base/psa-locale-base-en-US-8.1.0-rhel3.build81070224.19.noarch.rpm: 100% done.
Download file opt/ruby/psa-ruby-mysql-2.7-200610081532.i386.rpm: 100% done.
Download file opt/PPWSE/PPWSE-1.1-rhel3.build81061129.22.i586.rpm: 24%..58%..95%..100% done.
Start packages installation
Install package psa-locale-base-en-US-8.1.0-rhel3.build81070224.19.noarch
error: Failed dependencies:
psa-locale-base = 8.0.1 is needed by (installed) psa-8.0.1-rhel3.build80060613.20
Error while execute command rpm -U /root/swsoft/PSA_8.1.0/dist-rpm-RedHat-el3-i386/base/psa-locale-base-en-US-8.1.0-rhel3.build81070224.19.noarch.rpm
ERROR: error while executing RPM
ERROR: Installation failed

Im for days now. If i have to make a fresh OS i will not use plesk anymore. I have a Rain of complaints, and its not my fault that a so Expensive software from a company cannot even make an upgrade safe. And SW Soft only charges 150$ the hour to fix upgrades. I must recurre to the forum, im sure nobody is going to help until more and more people start having the problem. I dont know what to do anymore.

 

[nibb@]

===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash
/bin/rbash is already registered as login shell

mysqld (pid 7559) is running...
===> Installing psa database
Trying to check psa database... Trying to find psa database...

ERROR while trying to mysql datadir not found

Aborting...

STOP psa-8.1.0-rhel3.build81061129.22 upgrading AT Sat Mar 3 06:02:14 ART 2007
START psa-8.1.0-rhel3.build81061129.22 upgrading AT Sat Mar 3 06:09:21 ART 2007
Trying to define super-server internet daemon type... xinetd
Trying to check if xinetd daemon is running... done

Trying to start MySQL server... Initializing MySQL database: [ OK ]

chown: failed to get attributes of `/var/lib/mysql\r': No such file or directory
chown: failed to get attributes of `/var/lib/mysql\r': No such file or directory
chmod: failed to get attributes of `/var/lib/mysql\r': No such file or directory
Starting MySQL: [ OK ]

done
Trying to establish test connection... connected
Making some checks before upgrading

Now BIND server shutting down...

Trying to stop BIND server... Stopping named: [ OK ]

done
Trying to start BIND server... Starting named: [ OK ]

done

BIND server starts Ok.

mysqld (pid 7559) is running...

===> Checking for the necessary system accounts
Checking for the system groups and users necessary for Qmail...
Checking for the group 'qmail'...
Group 'qmail' already exists

Checking for the group 'nofiles'...
Group 'nofiles' already exists

Checking for the user 'alias'...
User 'alias' already exists

Checking for the user 'qmaild'...
User 'qmaild' already exists

Checking for the user 'qmaill'...
User 'qmaill' already exists

Checking for the user 'qmailp'...
User 'qmailp' already exists

Checking for the user 'qmailq'...
User 'qmailq' already exists

Checking for the user 'qmailr'...
User 'qmailr' already exists

Checking for the user 'qmails'...
User 'qmails' already exists

Checking for the group 'popuser'...
Group 'popuser' already exists

Checking for the user 'popuser'...
User 'popuser' already exists

done
Checking for the system groups and users necessary for MySQL...
Checking for the group 'mysql'...
Group 'mysql' already exists

Checking for the user 'mysql'...
User 'mysql' already exists

Checking for the system groups and users necessary for admin server...
Checking for the group 'psaadm'...
Group 'psaadm' already exists

Checking for the user 'psaadm'...
User 'psaadm' already exists

Checking for the system groups and users necessary for Apache...
Checking for the group 'apache'...
Group 'apache' already exists

Checking for the user 'apache'...
User 'apache' already exists

Checking for the group 'psaftp'...
Group 'psaftp' already exists

Checking for the user 'psaftp'...
User 'psaftp' already exists

Checking for the group 'psaserv'...
Group 'psaserv' already exists

Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'apache'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaftp'... already there
Checking for the group 'psaserv'...
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Checking for the group 'psacln'...
Group 'psacln' already exists

Checking for the system groups and users necessary for Apache...
Checking for the group 'apache'...
Group 'apache' already exists

Checking for the user 'apache'...
User 'apache' already exists

`/var/lib/psa/dumps/mysql.preupgrade.dump.gz' -> `/var/lib/psa/dumps/mysql.preupgrade.dump.gz.10'
Trying to backup MySQL database... done
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.dump.gz
Checking that /bin/false registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

STOP psa-8.1.0-rhel3.build81061129.22 upgrading AT Sat Mar 3 06:09:36 ART 2007
START psa-8.1.0-rhel3.build81061129.22 upgrading AT Sat Mar 3 06:10:18 ART 2007
Setting the default locale
The default locale is set to en-US (ENGLISH, UNITED STATES)


===> Installing rbash
Checking that /bin/rbash registered as login shell...
/bin/rbash
/bin/rbash is already registered as login shell

mysqld (pid 7559) is running...
===> Installing psa database
Trying to check psa database... Trying to find psa database...

ERROR while trying to mysql datadir not found

Aborting...

STOP psa-8.1.0-rhel3.build81061129.22 upgrading AT Sat Mar 3 06:10:20 ART 2007