[
https://issues.apache.org/jira/browse/VCL-590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13795540#comment-13795540
]
Will Tome commented on VCL-590:
-------------------------------
Young-Hyun,
I have VCL running. I ran into some errors on steps e - i when following your
instructions to modify the VCL database.
mysql> INSERT INTO `vcl`.`provisioningOSinstalltype` (`provisioningid`
,`OSinstalltypeid` ) VALUES ('11', '6');
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint
fails (`vcl`.`provisioningOSinstalltype`, CONSTRAINT
`provisioningOSinstalltype_ibfk_2` FOREIGN KEY (`OSinstalltypeid`) REFERENCES
`OSinstalltype` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
mysql> INSERT INTO `vcl`.`OSinstalltype` (`id` ,`name` )VALUES (NULL ,
'openstack');
Query OK, 1 row affected (0.04 sec)
mysql> INSERT INTO `vcl`.`OS` (`id`, `name`, `prettyname`, `type`,
`installtype`, `sourcepath`, `moduleid`) VALUES (‘’,
-> 'openstack_fedora', 'OpenStack Fedora 19 provisioning', 'windows',
'openstack', ‘’, '12');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '��’,
'openstack_fedora', 'OpenStack Fedora 19 provisioning', 'windows', 'opens' at
line 1
mysql> INSERT INTO `vcl`.`image` (`id`, `name`, `prettyname`, `ownerid`,
`imagetypeid`, `platformid`, `OSid`,
-> `imagemetaid`, `minram`, `minprocnumber`, `minprocspeed`, `minnetwork`,
`maxconcurrent`, `reloadtime`,
-> `deleted`, `test`, `lastupdate`, `forcheckout`, `maxinitialtime`,
`project`, `size`, `architecture`, `description`,
-> `usage`, `basedoffrevisionid`) VALUES (NULL, 'fedoar19-v0', 'Fedora 19',
'1', '7', '1', '45', NULL, '2048', '1', '1000',
-> '10', NULL, '10', '0', '0', NULL, '1', '0', 'vcl', '1450', 'x86', NULL,
NULL, '0');
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint
fails (`vcl`.`image`, CONSTRAINT `image_ibfk_7` FOREIGN KEY (`OSid`) REFERENCES
`OS` (`id`) ON UPDATE CASCADE)
mysql> INSERT INTO `imagerevision`(`id`, `imageid`, `revision`, `userid`,
`datecreated`, `deleted`, `datedeleted`,
-> `production`, `comments`, `imagename`, `autocaptured`) VALUES (NULL,
'2', '0', '1',NULL, '0',NULL, '1',NULL,
-> 'fedoar19-v0', '0');
ERROR 1048 (23000): Column 'datecreated' cannot be null
Also, where do I place the .pm modules and how do I add OpenStack compute to
VCL?
Thank you,
Will
> Openstack Essex Module
> ----------------------
>
> Key: VCL-590
> URL: https://issues.apache.org/jira/browse/VCL-590
> Project: VCL
> Issue Type: New Feature
> Components: database, vcld (backend)
> Affects Versions: 2.2.1
> Environment: OpenStack Essex with Ubuntu 12.04 x64 server
> Reporter: Young-Hyun
> Attachments: openstack_euca2ool .pm,
> OpenStack_Installation_RHEL6.pdf, openstack_nova_api.pm,
> VCL_Configuration_OpenStack.pdf
>
>
> The OpenStack module supports the VCL provisioning module for OpensStack
> Essex that is open source software for building private and public clouds
> (http://www.openstack.org/)
--
This message was sent by Atlassian JIRA
(v6.1#6144)
