Pandora FMS Community

Table 'pandora.tserver' doesn't exist

oliverm · 7 ene 2008, 13:05 · 4 mensajes · 66 visitas

  1. Inicio del debate

    Hi chaps :) Ok, can now start the server. However, when I do I get the error; Table 'pandora.tserver' doesn't exist I have created the pandora database by hand, along with the pandora user in mysql and assigned permissions so that the pandora user has full rights on the pandora DB. I've tried starting the server without a DB in place, thinking it may create it, but it gave me a DB doesnt exist error. Is there a script I'm meant to run which creates the tables in the DB ? Olly

  2. Hi, Glad you fixed it :-) Secondly, ummm, why did you create everything by hand? The webconsole has a web wizard that install the whole database, even if you do not want to use the wizard, there're two scripts called pandora_dbdata.sql and pandoradb.sql in the pandora_console/ Both of them can be run manually and will allow you to create the database, you have to run them using (and in this order) cat pandoradb.sql | mysql -D pandora -u root -pwhatever cat pandora_dbdata | mysql -D pandora -u root -pwhatever Let me know if this worked out Manuel

  3. Ahhhhhhhhhhhhhhhhhhh That'll teach me to not read the next page of the manual :) For people like me it would be good to have a link at the bottom of the server installation page on the wiki taking you to the next step (console setup) :)

  4. Yes, you're totally right. I've edited "Configuring your new Pandora Server setup" section in the wiki and added a link, here you are the new version (Link not available anymore) Thank you so much for the advice

Entra en tu cuenta para publicar.