Open Stack

don´t know if this is what you want:

use neutron;
show columns from routers;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| tenant_id      | varchar(255) | YES  |     | NULL    |       |
| id             | varchar(36)  | NO   | PRI | NULL    |       |
| name           | varchar(255) | YES  |     | NULL    |       |
| status         | varchar(16)  | YES  |     | NULL    |       |
| admin_state_up | tinyint(1)   | YES  |     | NULL    |       |
| gw_port_id     | varchar(36)  | YES  | MUL | NULL    |       |
+----------------+--------------+------+-----+---------+-------+

Cumprimentos,
Tiago Sousa


On Tue, Jun 10, 2014 at 7:41 PM, Brian Jarrett <celttechie at gmail.com> wrote:

> And now I see I missed the first part of the traceback...  *sigh*.  So the
> relevant error is that the sql query is asking for routers.enable_snat and
> its not in your database.  What does the router table look like?
> On Jun 10, 2014 12:26 PM, "Brian Jarrett" <celttechie at gmail.com> wrote:
>
>> Note:  I accidentally replied directly to Tiago, not to the list. My
>> apologies.  Here is my response:
>>
>> Tiago,
>>
>> I see this in your paste:
>>
>> {'project_name': None, 'user_id': None, 'roles': [u'admin'], 'tenant_id':
>> None, 'timestamp': u'2014-06-10 16:16:21.361813', 'is_admin': True,
>> 'read_deleted': u'no', 'request_id': u'req-4a863a3e-f857-41a8-9f18-b35d4ea716c1',
>> 'tenant_name': None, 'project_id': None, 'user_name': None, 'tenant': None,
>> 'user': None}
>>
>> this tells me that when you give the command to add a router, you aren't
>> passing the variables for what project, tenant, or user you are using.
>>  This information either needs to be part of the command given, or you need
>> to set environment variables to specify this information.  If you have a
>> *-openrc.sh file, you need to source that first.
>>
>> If you are still having issues, please let us know what you are giving as
>> a command that fails.
>>
>> Brian
>>
>
> _______________________________________________
> Mailing list:
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe :
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140610/6954d190/attachment.html>