Hi all. I just tried upgrading to version 7.5.3 from 7.5.2. And now i get this error when trying to access my plesk login screen. Also, my webmail (horde) recieves a imap timeout message. and pop3 is not working as well.

ERROR: Unable to query: Can't open file: 'misc.InnoDB'. (errno: 1) 0: /usr/local/psa/admin/plib/common_func.php3:177 psaerror(string "Unable to query: Can't open file: 'misc.InnoDB'. (errno: 1)") 1: /usr/local/psa/admin/plib/common_func.php3:365 db_query(string "select param, val from misc") 2: /usr/local/psa/admin/plib/class.Session.php:99 get_param(string "login_timeout") 3: /usr/local/psa/admin/auto_prepend/auth.php3:114 session->session()

Any suggestions how to fix?

Thanks,

matthew

First i would like to thank JLChafardet and agruetz(from Ev1servers IRC) for the help they provided. So, major props to them. Here is what we found.

I was originally told by EV1servers that i would need to have a system restore done. Which i almost had done.

Nonetheless, during the upgrade to 7.5.3 it appears that the PSA database was purged of all data, providing the the error above. Fortunately, there were several backups of database located at var/lib/psa/dumps .

ls -la gave

-rw------- 1 root root 231 Jul 15 05:14 mysql.daily.dump
-rw------- 1 root root 53996 Jul 14 05:14 mysql.daily.dump.0.gz
-rw------- 1 root root 53746 Jul 13 05:14 mysql.daily.dump.1.gz
-rw------- 1 root root 53643 Jul 12 05:14 mysql.daily.dump.2.gz
-rw------- 1 root root 53561 Jul 11 05:14 mysql.daily.dump.3.gz
-rw------- 1 root root 53590 Jul 10 05:14 mysql.daily.dump.4.gz
-rw------- 1 root root 53051 Jul 9 05:14 mysql.daily.dump.5.gz
-rw------- 1 root root 53172 Jul 8 05:14 mysql.daily.dump.6.gz
-rw------- 1 root root 53156 Jul 7 05:14 mysql.daily.dump.7.gz
-rw------- 1 root root 53124 Jul 6 05:14 mysql.daily.dump.8.gz
-rw------- 1 root root 55257 Jul 15 20:25 mysql.preupgrade.dump.gz

if you look at july 15 the db size is 231, a far cry from 53996 from the previous day.

We took the July 14 file, gunziped and inserted tables back to the psa database: syntax is:

mysql -u --password="password" -h < filethatcontainssql

When we first ran this, it did not work, because some of the tables already existed in the current psa db file. What you need to do is to rename the current psa db to psa.old, then run the mysql command again. The psa and all other databases are located in var/lib/mysql

After that download the plesk update extract the rpms, goto the base folder then run rpm -Uhv --force *rpm

If your password does not work when you try to login to the plesk interface, then just /sbin/services psa stop all then /sbin/services psa start all

One last thing we needed to do was to update the vhosts files to get the global sub domain webmail.domain.com to be recognized. All of my domains were redirecting back to my main domain. But after i ran
/usr/local/psa/admin/sbin/websrvmng -a -v

Everything was back to normal, and running smooth

I hope this helps others out.

Matthew

it is always a pleasure to help , I am realy glad that you got your server back up without requesting the restore and all your info remained intact

Best regards,