Open Stack

Hello everyone, I am trying to enable VPN services on my setup and am seeing the following DB error in the neutron log.  It appears that there are a few column’s missing from my DB and I can’t figure out why.


DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'vpnservices.external_v4_ip' in 'field list'") [SQL: u'SELECT vpnservices.tenant_id AS vpnservices_tenant_id, vpnservices.id AS vpnservices_id, vpnservices.name AS vpnservices_name, vpnservices.description AS vpnservices_description, vpnservices.status AS vpnservices_status, vpnservices.admin_state_up AS vpnservices_admin_state_up, vpnservices.external_v4_ip AS vpnservices_external_v4_ip, vpnservices.external_v6_ip AS vpnservices_external_v6_ip, vpnservices.subnet_id AS vpnservices_subnet_id, vpnservices.router_id AS vpnservices_router_id \nFROM vpnservices \nWHERE vpnservices.tenant_id = %s AND vpnservices.tenant_id IN (%s)'] [parameters: (u'fc197ddac2e946fd97f0e51c7b6bc1ca', u'fc197ddac2e946fd97f0e51c7b6bc1ca’)]


MariaDB [neutron]> describe vpnservices;

+----------------+--------------+------+-----+---------+-------+

| Field          | Type         | Null | Key | Default | Extra |

+----------------+--------------+------+-----+---------+-------+

| tenant_id      | varchar(255) | YES  |     | NULL    |       |

| id             | varchar(36)  | NO   | PRI | NULL    |       |

| name           | varchar(255) | YES  |     | NULL    |       |

| description    | varchar(255) | YES  |     | NULL    |       |

| status         | varchar(16)  | NO   |     | NULL    |       |

| admin_state_up | tinyint(1)   | NO   |     | NULL    |       |

| subnet_id      | varchar(36)  | NO   | MUL | NULL    |       |

| router_id      | varchar(36)  | NO   | MUL | NULL    |       |

+----------------+--------------+------+-----+---------+-------+

8 rows in set (0.00 sec)


MariaDB [neutron]> select * from vpnservices;

Empty set (0.00 sec)


MariaDB [neutron]>


It looks like external_v4ip, external_v6ip are missing.   This is a fresh install of Liberty. I would like to track down when they are created to figure out where I fell off the rails or report it if it is possibly a schema bug? Any help would be greatly appreciated.



Steven Searles  | ssearles at zimcom.net<mailto:ssearles at zimcom.net>
Zimcom Internet Solutions  | www.zimcom.net<http://www.zimcom.net/>
O: 513.231.9500  |  D: 513.233.4130


[cid:A2321117-130E-4138-AB87-8D61EA57071F]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160205/219eca9a/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 847FA943-AFD4-4E4F-BB5E-0DDB37DEAF6A[11].png
Type: image/png
Size: 10713 bytes
Desc: 847FA943-AFD4-4E4F-BB5E-0DDB37DEAF6A[11].png
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160205/219eca9a/attachment.png>