-
Table ‘pandora.tserver’ doesn’t exist
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
-
3 Replies
-
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 -pwhateverLet me know if this worked out
Manuel -
-
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
http://www.openideas.info/wiki/index.php?title=Pandora_1.3:Documentation_en:Install_Server#Configuring_your_new_Pandora_Server_setupThank you so much for the advice
