• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Need new schema for session_params

S

sgirard

Guest
Apologies for posting this here... I can't find a forum for older Plesk versions and I was thinking maybe someone here could help.

I have an old Plesk 5 server and the mail/mysql partition filled up (basically /var i think).

After a reboot of the system the sessions table in the psa database and and also the session_params table couldn't be written (no disk space left) and became corrupt.

I cleared out some space and found the schema for recreating the sessions table. Basically followed this thread: http://forum.swsoft.com/showthread.php?t=12686

But now I also need to rebuild the session_params table to resolve this error when trying to log back in to the server administrator:

/login_up.php3: Unable to query: Can't find file: 'session_params.MYD' (errno: 2), in /usr/local/psa/admin/plib/class.Session.php3 on line 234, plesk_errormsg=, php_errormsg=

If anyone could provide the CREATE TABLE syntax for that and let me know whether it needs to be populated with any data I would really appreciate it. Thanks!

-sean
 
Got It

Apparently Plesk does a daily dump of the psa database. Mine was in /var/lib/psa. So I got the schema from that and rebuilt the table and I can get back in. Guess I just needed to think out loud.

Thanks,
-sean
 
Back
Top