Comment 4 for bug 1454566

Revision history for this message
Zhenmei (zma-4) wrote :

1.Use the dumped icehouse db schema
mysql -uroot -ppassw0rd neutron <neutron.sql

The schema of table `portbindingports` in neutron.sql
--
-- Table structure for table `portbindingports`
--

DROP TABLE IF EXISTS `portbindingports`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `portbindingports` (
  `port_id` varchar(36) NOT NULL,
  `host` varchar(255) NOT NULL,
  PRIMARY KEY (`port_id`),
  CONSTRAINT `portbindingports_ibfk_1` FOREIGN KEY (`port_id`) REFERENCES `ports` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `portbindingports`
--

LOCK TABLES `portbindingports` WRITE;
/*!40000 ALTER TABLE `portbindingports` DISABLE KEYS */;
INSERT INTO `portbindingports` VALUES ('ce00ddaa-af63-4fa8-9c17-79601719d0a3','zma-virtual-machine');
/*!40000 ALTER TABLE `portbindingports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `portqueuemappings`
--

2. Upgrade neutron db from icehouse to kilo
#neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/vmware/nsx.ini upgrade head