Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Nicolas de BONFILS
SOLVED ! (the problem, as usual, was between chair and keyboard) I put some nice log in "configure_db" particularly the options dict and see that the sql connection use sqlite:// The step leading to the problem : checkout/update quantum repo, copy the conf file to /etc/quantum but *keep the ori

Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Salvatore Orlando
I admin I have never seen anything like this. The issue must then be either in configure_db or register_models, both in db/api.py, even if I would have expected to see "Database Registration Exception" in the logs. However, I cannot say what's the root cause for the issue - Quantum, sqlAlchemy, or

Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Nicolas de BONFILS
The tables were successfully recreated. The only advice I can give is to 1) verify no table actually appears when you do "show tables" for ovs_quantum, and 2) drop the current ovs_quantum schema and create a new one (with no tables). Did it several times, also check the user privileges in mysql,

Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Salvatore Orlando
I've just tried to reproduce your condition by dropping all the tables on the ovs_quantum db and then relaunching quantum-server, quantum-agent, and quantum-dhcp. The tables were successfully recreated. The only advice I can give is to 1) verify no table actually appears when you do "show tables"

Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Nicolas de Bonfils
It seems you are already in a situation where you have an empty db ("show databases" returns ovs_quantum, but "show tables" returns an empty list). That's it. Quantum-server should recreate the tables for you. If this is not happening, you should have an error during Quantum startup. Can you po

Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Salvatore Orlando
It seems you are already in a situation where you have an empty db ("show databases" returns ovs_quantum, but "show tables" returns an empty list). Quantum-server should recreate the tables for you. If this is not happening, you should have an error during Quantum startup. Can you post the tracebac

Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Nicolas de Bonfils
Hi Salvatore, What do you mean by "creating the schema" ? I got the db "ovs_quantum" empty and the good mysql connection url in configuration file. But I'm stuck after that :/ Thanks --- Nicolas Le Wed Jul 25 15:23:28 2012, Salvatore Orlando a écrit : Nicolas, Quantum and its plugins do n

Re: [Netstack] [DB] Create Quantum DB

2012-07-25 Thread Salvatore Orlando
Nicolas, Quantum and its plugins do not have yet schema versioning. If you've messed up the DB and dropped it, just create the schema in mysql. Quantum (or to be more precise sqlAlchemy) will recreate the tables for you. The name of the db for the OVS plugin is ovs_quantum. DB name can differ from