[Openstack] [neutron] router error

Tiago Sousa tiagu.asp at gmail.com
Tue Jun 10 20:32:57 UTC 2014


great!

adding that row solved it. (but still don´t know how it wasn´t there in the
first place) oh well

Thanks for the help Brian!

Cumprimentos,
Tiago Sousa


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

> On 06/10/2014 01:04 PM, Tiago Sousa wrote:
>
>> 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    |       |
>> +----------------+--------------+------+-----+---------+-------+
>>
>
> Yep, that's perfect.
>
> I'm looking at my icehouse install that I just created last week. It has
> the enable_snat column as the last column:
>
> | enable_snat    | tinyint(1)    | NO   | NULL    |        |
>
> everything else is the same as your table.
>
> So I don't know how it happened, but when your table was created, it was
> done without that last field.
>
> I'd just try adding the field to the routers table and see if that solves
> your issue.  It will at least fix the SQL query error.
>
>
> B
>
> _______________________________________________
> 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/774b6f3c/attachment.html>


More information about the Openstack mailing list