Hi Will,

I can get you up and running with VCL and Openstack if you want to
contact me off list. Well, I should be able to though we are back on
Essex still. ;)

I was going to go through the PDF Young-Hyun and setup a new test
instance sometime this week just to test them out anyways, but if you
want help before that just let me know.

Thanks,
Curtis.

On Tue, Oct 15, 2013 at 1:32 PM, Will Tome (JIRA) <[email protected]> wrote:
>
>     [ 
> 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)



-- 
Twitter: @serverascode
Blog: serverascode.com

Reply via email to