<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; 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, 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’)]</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 id="">
<div><span style="color: rgb(89, 89, 89); font-family: Cambria, serif; font-size: 11pt;">Steven Searles | </span><a href="mailto:ssearles@zimcom.net" class="" style="font-family: Cambria, serif; font-size: 11pt;">ssearles@zimcom.net</a></div>
<div class="" style="font-family: Helvetica; font-size: 12px;">
<div class="">
<div class="">
<div class="" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">
<span class="" style="font-size: 11pt; font-family: Cambria, serif; color: rgb(89, 89, 89);">Zimcom Internet Solutions | <a href="http://www.zimcom.net/" class="">www.zimcom.net</a><o:p class=""></o:p></span></div>
<div class="" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif; line-height: 24px;">
<span class="" style="font-size: 11pt; line-height: 22px; font-family: Cambria, serif; color: rgb(89, 89, 89);">O: 513.231.9500 | D: 513.233.4130<o:p class=""></o:p></span></div>
<div class="" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: 'Times New Roman', serif;">
<span class="" style="font-size: 11pt; font-family: Cambria, serif; color: rgb(89, 89, 89);"><br class="Apple-interchange-newline">
</span></div>
</div>
</div>
<br class="Apple-interchange-newline">
</div>
<span style="font-family: Calibri;"><img height="36" width="163" apple-inline="yes" id="84FF77AB-3DBB-421B-9F9A-DF6871FA8AB6" apple-width="yes" apple-height="yes" src="cid:A2321117-130E-4138-AB87-8D61EA57071F" class="" type="image/png"></span></div>
</div>
</body>
</html>