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, | ssear...@zimcom.net<mailto:ssear...@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 <ssear...@zimcom.net<mailto:ssear...@zimcom.net>> Date: Friday, February 5, 2016 at 12:33 PM To: "openstack@lists.openstack.org<mailto:openstack@lists.openstack.org>" <openstack@lists.openstack.org<mailto:openstack@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 | ssear...@zimcom.net<mailto:ssear...@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]
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
