Sys_session mysql error / IPSConfig3 Panel Login Garble

Discussion in 'Installation/Configuration' started by DDArt, Mar 31, 2015.

  1. DDArt

    DDArt Member

    Fairly new install and suddenly after few tweaks and installs not related to msyql I had the sys_session:
    Error File './dbispconfig/sys_session.MYD' not found (Errcode: 2)
    Couldn't get into MySQL or auto-repair nor did the:

    CREATE TABLE `sys_session` (
      `session_id` varchar(64) NOT NULL DEFAULT '',
      `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
      `session_data` longtext,
      PRIMARY KEY (`session_id`),
      KEY `last_updated` (`last_updated`)
    Emaill was down, not working, I ended up deleting dbispconfig database, Uninstall ispconfig3,
    reinstall IPSConfig3, exact same settings, and re-wrote the "database" with a previous day
    backup we had. Wondering if there were any other steps needed to check on but so far
    everything is working just fine.

    This is right before our full server weekly backup would have kicked in .. but so far so good.
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    It might be that the create_table did not work as as only a prt of the table was missing (the table consists of a myd and a form file), so mysql thought that the table was still there.
  3. DDArt

    DDArt Member

    It pays off to have multiple backups, locally and on external service like S3 because it is a matter of a buck or two a month. Thank you, so far so good and all seems to be working.
  4. hajisira

    hajisira New Member

    nice information
    thanks all

Share This Page