Pandora FMS Community

Mysql error after installing

Edgar · 4 feb 2010, 12:44 · 6 mensajes · 60 visitas

  1. Inicio del debate

    Hi, I installed pandora under ubuntu 9, everything was fine but i could not start server... this error shown at log: 2010-02-03 19:02:28 hercules [V1] Pandora FMS Server 'hercules' unhandled error. 2010-02-03 19:02:28 hercules [V1] [E] 'hercules': DBD::mysql::db do failed: Table 'pandora.tsesion' doesn't exist at /usr/local/share/perl/5.10.0/PandoraFMS/DB.pm line 216 What can I do? Best regards

  2. database is wrong, the table where is stored the user sessions is missing, for a best chance, try to reinstall the console... in this process is when the db is created. if it continues going wrong, create it manually: CREATE TABLE IF NOT EXISTS `tsesion` (   `ID_sesion` bigint(20) unsigned NOT NULL auto_increment,   `ID_usuario` varchar(60) NOT NULL default '0',   `IP_origen` varchar(100) NOT NULL default '',   `accion` varchar(100) NOT NULL default '',   `descripcion` varchar(200) NOT NULL default '',   `fecha` datetime NOT NULL default '0000-00-00 00:00:00',   `utimestamp` bigint(20) unsigned NOT NULL default '0',   PRIMARY KEY  (`ID_sesion`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  3. Same error but now tserver

  4. Hi, Thanks a lot for you answer. Can you send me the sql for tserver? Best regards

  5. try to run (from the pandora console directory): cat pandoradb.sql | mysql -D pandora -u root -p This will insert all the tables that were not inserted in the installation process (by the way, it's very strange...) Regards, Raul

  6. Hi, I ran pandoradb.sql file... fine Also, installation did not create apache site

Entra en tu cuenta para publicar.