1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

PSA database corrupted

Discussion in 'Plesk for Linux - 8.x and Older' started by Matt.D, Sep 25, 2005.

  1. Matt.D

    Matt.D Guest

    0
     
    Here I am again..

    First, thank you all for providing us nOObs with so much help and being so patient with it all.

    The other week my server suffered a major issue. I was forced to have the OS re-installed. As part of the migration back the SW-Soft engineers have been very helpful.

    However...

    today, one of the account holders has decided to do some of his own backing-up / restoring. Now PSA database has gone belly up.

    Trying to run the rpm packages again, I came across this error message:-

    Code:
     Now BIND server shutting down...
    
     Trying to stop BIND server... done
    ERROR 1016 at line 1: Can't open file: 'misc.InnoDB'. (errno: 1)
    VERSION MISMATCH:
    PLESK DATABASE VERSION:
    PLESK INSTALLATION VERSION: 075
    
    ERROR while trying to check version match
    Check the error reason(see log file: /tmp/psa_7.5.4_FedoraCore_1_build75050824.12_upgrade.log), fix and try again
    
    Aborting...
    
    error: %pre(psa-7.5.4-fc1.build75050824.12) scriptlet failed, exit status 1
    error:   install: %pre scriptlet failed (2), skipping psa-7.5.4-fc1.build75050824.12
      19:psa-api-cli            ########################################### [ 73%]
      20:psa-horde              ########################################### [ 77%]
      21:psa-imp                ########################################### [ 81%]
      22:Mambo                  ########################################### [ 85%]
      23:osCommerce             ########################################### [ 88%]
      24:psa-bu                 ########################################### [ 92%]
    Generate public/private keys pair for server ...
    domain_bu: Can't find 'bu_cert_id parameter in database: 'Can't open file: 'misc.InnoDB'. (errno: 1)
    domain_bu: Can't find 'bu_cert_id parameter in database: 'Can't open file: 'misc.InnoDB'. (errno: 1)
    domain_bu: Can't find 'bu_cert_id parameter in database: 'Can't open file: 'misc.InnoDB'. (errno: 1)
    domain_bu: Can't find 'bu_cert_id parameter in database: 'Can't open file: 'misc.InnoDB'. (errno: 1)
    domain_bu: Unable to define max id: Can't open file: 'certificates.InnoDB'. (errno: 1)
    domain_bu: Unable to define max id: Can't open file: 'certificates.InnoDB'. (errno: 1)
    domain_bu: Can't insert server keypair into certificates table: 'Can't open file: 'certificates.InnoDB'. (errno: 1)
    domain_bu: Can't insert server keypair into certificates table: 'Can't open file: 'certificates.InnoDB'. (errno: 1)
    Server keys generating done
      25:psa-api-rpc            ########################################### [ 96%]
    ===> Updating /etc/psa/psa.conf...
    
    the contents of the error pages are not worth mentioning until the very end were it goes:-

    Code:
     Now BIND server shutting down...
    
     Trying to stop BIND server... Stopping named: [  OK  ]
    done
    mysqld (pid 31421) is running...
    VERSION MISMATCH:
    PLESK DATABASE VERSION:
    PLESK INSTALLATION VERSION: 075
    
    ERROR while trying to check version match
    
    Aborting...
    

    Does anyone know how I can fix this issue?

    please help [domains are currently runnign fine (including the databases for them), however ALL EMAIL ACCOUNTS ARE UNRESPONSIVE! ]
     
  2. Matt.D

    Matt.D Guest

    0
     
    a quick update...

    from what I have been able to find, the psa database is currput

    when in console I log in into mySQL it tells me that it cannot find any fields in any of the tables in the PSA database.

    is there any SQL script I can use to create all the necessary tables for the PSA database from scratch?
     
Loading...