Open Stack

Yes,  Ideal solution would be to recreate db
On Feb 5, 2016 11:02 PM, "Steve Searles" <SSearles at 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,  | ssearles at zimcom.net
> Zimcom Internet Solutions  | www.zimcom.net
> O: 513.231.9500  |  D: 513.233.4130
>
>
>
> From: Steve Searles <SSearles at zimcom.net>
> Date: Friday, February 5, 2016 at 12:33 PM
> To: "openstack at lists.openstack.org" <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
> 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 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/20160206/f038184c/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: not available
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160206/f038184c/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 847FA943-AFD4-4E4F-BB5E-0DDB37DEAF6A[13].png
Type: image/png
Size: 10713 bytes
Desc: not available
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20160206/f038184c/attachment-0001.png>