Yes, Ideal solution would be to recreate db On Feb 5, 2016 11:02 PM, "Steve Searles" <ssear...@zimcom.net> wrote:
> 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 > Zimcom Internet Solutions | www.zimcom.net > O: 513.231.9500 | D: 513.233.4130 > > > > From: Steve Searles <ssear...@zimcom.net> > Date: Friday, February 5, 2016 at 12:33 PM > To: "openstack@lists.openstack.org" <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 > Zimcom Internet Solutions | www.zimcom.net > O: 513.231.9500 | D: 513.233.4130 > > > > _______________________________________________ > 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 > >
_______________________________________________ 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