<p dir="ltr">Yes, Ideal solution would be to recreate db </p>
<div class="gmail_quote">On Feb 5, 2016 11:02 PM, "Steve Searles" <<a href="mailto:SSearles@zimcom.net">SSearles@zimcom.net</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div>
<div><font face="Calibri,sans-serif">I found the issue on this. Apparently someone ran </font><font face="Helvetica"><span style="font-size:12px">neutron-db-manage --service vpnaas upgrade head on the DB when it was not needed. I ran </span></font><span style="font-family:Helvetica;font-size:12px">neutron-db-manage
--service vpnaas current </span><font face="Helvetica"><span style="font-size:12px">which corrected the issue. </span></font></div>
<div><font face="Helvetica"><span style="font-size:12px"><br>
</span></font></div>
<div><font face="Helvetica"><span style="font-size:12px"><br>
</span></font></div>
<div style="color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">
<div>
<div><span style="color:rgb(89,89,89);font-family:Cambria,serif;font-size:11pt">Steven Searles, | </span><a href="mailto:ssearles@zimcom.net" style="font-family:Cambria,serif;font-size:11pt" target="_blank">ssearles@zimcom.net</a></div>
<div style="font-family:Helvetica;font-size:12px">
<div>
<div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif">
<span style="font-size:11pt;font-family:Cambria,serif;color:rgb(89,89,89)">Zimcom Internet Solutions | <a href="http://www.zimcom.net/" target="_blank">www.zimcom.net</a><u></u><u></u></span></div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif;line-height:24px">
<span style="font-size:11pt;line-height:22px;font-family:Cambria,serif;color:rgb(89,89,89)">O: 513.231.9500 | D: 513.233.4130<u></u><u></u></span></div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif">
<span style="font-size:11pt;font-family:Cambria,serif;color:rgb(89,89,89)"><br>
</span></div>
</div>
</div>
<br>
</div>
<span style="font-family:Calibri"><img height="36" width="163" src="cid:6BD51E5E-C4CD-4A24-872D-9FDB2F2ED911" type="image/png"></span></div>
</div>
</div>
<div style="color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">
<br>
</div>
<span style="color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">
<div style="font-family:Calibri;font-size:12pt;text-align:left;color:black;BORDER-BOTTOM:medium none;BORDER-LEFT:medium none;PADDING-BOTTOM:0in;PADDING-LEFT:0in;PADDING-RIGHT:0in;BORDER-TOP:#b5c4df 1pt solid;BORDER-RIGHT:medium none;PADDING-TOP:3pt">
<span style="font-weight:bold">From: </span>Steve Searles <<a href="mailto:SSearles@zimcom.net" target="_blank">SSearles@zimcom.net</a>><br>
<span style="font-weight:bold">Date: </span>Friday, February 5, 2016 at 12:33 PM<br>
<span style="font-weight:bold">To: </span>"<a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a>" <<a href="mailto:openstack@lists.openstack.org" target="_blank">openstack@lists.openstack.org</a>><br>
<span style="font-weight:bold">Subject: </span>VPN Services in Liberty<br>
</div>
<div><br>
</div>
<div>
<div style="word-wrap:break-word;color:rgb(0,0,0);font-size:14px;font-family:Calibri,sans-serif">
<div>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. </div>
<div><br>
</div>
<div>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
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, <a href="http://vpnservices.id" target="_blank">vpnservices.id</a> AS vpnservices_id, <a href="http://vpnservices.name" target="_blank">vpnservices.name</a> 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’)]</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
<br>
</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
MariaDB [neutron]> describe vpnservices;</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
+----------------+--------------+------+-----+---------+-------+</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| Field | Type | Null | Key | Default | Extra |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
+----------------+--------------+------+-----+---------+-------+</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| tenant_id | varchar(255) | YES | | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| id | varchar(36) | NO | PRI | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| name | varchar(255) | YES | | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| description | varchar(255) | YES | | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| status | varchar(16) | NO | | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| admin_state_up | tinyint(1) | NO | | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| subnet_id | varchar(36) | NO | MUL | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
| router_id | varchar(36) | NO | MUL | NULL | |</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
+----------------+--------------+------+-----+---------+-------+</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
8 rows in set (0.00 sec)</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
<br>
</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
MariaDB [neutron]> select * from vpnservices;</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
Empty set (0.00 sec)</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
<br>
</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
MariaDB [neutron]> </p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
<br>
</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
It looks like external_v4ip, external_v<span style="font-style:italic">6</span>ip 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. </p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
<br>
</p>
<p style="margin:0px;font-size:12px;line-height:normal;font-family:Helvetica">
<br>
</p>
</div>
<div>
<div>
<div><span style="color:rgb(89,89,89);font-family:Cambria,serif;font-size:11pt">Steven Searles | </span><a href="mailto:ssearles@zimcom.net" style="font-family:Cambria,serif;font-size:11pt" target="_blank">ssearles@zimcom.net</a></div>
<div style="font-family:Helvetica;font-size:12px">
<div>
<div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif">
<span style="font-size:11pt;font-family:Cambria,serif;color:rgb(89,89,89)">Zimcom Internet Solutions | <a href="http://www.zimcom.net/" target="_blank">www.zimcom.net</a><u></u><u></u></span></div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif;line-height:24px">
<span style="font-size:11pt;line-height:22px;font-family:Cambria,serif;color:rgb(89,89,89)">O: 513.231.9500 | D: 513.233.4130<u></u><u></u></span></div>
<div style="margin:0in 0in 0.0001pt;font-size:12pt;font-family:'Times New Roman',serif">
<span style="font-size:11pt;font-family:Cambria,serif;color:rgb(89,89,89)"><br>
</span></div>
</div>
</div>
<br>
</div>
<span style="font-family:Calibri"><img height="36" width="163" src="cid:A2321117-130E-4138-AB87-8D61EA57071F" type="image/png"></span></div>
</div>
</div>
</div>
</span>
</div>
<br>_______________________________________________<br>
Mailing list: <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
Post to : <a href="mailto:openstack@lists.openstack.org">openstack@lists.openstack.org</a><br>
Unsubscribe : <a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack" rel="noreferrer" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack</a><br>
<br></blockquote></div>