[Openstack] VPN Services in Liberty-RESOLVED

Steve Searles SSearles at zimcom.net
Fri Feb 5 17:48:58 UTC 2016


I found the issue on this. Apparently someone ran neutron-db-manage --service vpnaas upgrade head on the DB when it was not needed.   I ran neutron-db-manage --service vpnaas current  which corrected the issue.


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:6BD51E5E-C4CD-4A24-872D-9FDB2F2ED911]

From: Steve Searles <SSearles at zimcom.net<mailto:SSearles at zimcom.net>>
Date: Friday, February 5, 2016 at 12:33 PM
To: "openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>" <openstack at lists.openstack.org<mailto:openstack at lists.openstack.org>>
Subject: VPN Services in Liberty

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/63a29e97/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 847FA943-AFD4-4E4F-BB5E-0DDB37DEAF6A[13].png
Type: image/png
Size: 10713 bytes
Desc: 847FA943-AFD4-4E4F-BB5E-0DDB37DEAF6A[13].png
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160205/63a29e97/attachment.png>
-------------- 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/63a29e97/attachment-0001.png>


More information about the Openstack mailing list