1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

PSA database version does not match

Discussion in 'Plesk for Linux - 8.x and Older' started by ghazaly, Feb 10, 2007.

  1. ghazaly

    ghazaly Guest

    0
     
    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:

    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.
     
  2. Mirco@

    Mirco@ Basic Pleskian

    24
    53%
    Joined:
    Aug 1, 2001
    Messages:
    43
    Likes Received:
    0
    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.
     
  3. ghazaly

    ghazaly Guest

    0
     
    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!
     
  4. ghazaly

    ghazaly Guest

    0
     
    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!
     
  5. cd_boyz

    cd_boyz Guest

    0
     
    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 ?
     
  6. ghazaly

    ghazaly Guest

    0
     
    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!
     
  7. cd_boyz

    cd_boyz Guest

    0
     
    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
     
  8. cd_boyz

    cd_boyz Guest

    0
     
    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';
     
  9. ghazaly

    ghazaly Guest

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

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

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    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.
     
  11. ghazaly

    ghazaly Guest

    0
     
    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!
     
  12. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    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.
     
  13. ghazaly

    ghazaly Guest

    0
     
    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!
     
  14. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    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.
     
  15. nibb@

    nibb@ Guest

    0
     
    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.
     
  16. nibb@

    nibb@ Guest

    0
     
    ===> 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
     
Loading...