Charles,
I tested this on my mb air 10.8.1, mysql 5.5. The procedure works fine.
The database is running on localhost (the air), 192.168.56.1 is the address of
the vbox switch:
lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384
options=3<RXCSUM,TXCSUM>
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff000000
inet6 ::1 prefixlen 128
gif0: flags=8010<POINTOPOINT,MULTICAST> mtu 1280
stf0: flags=0<> mtu 1280
en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 7c:d1:c3:e9:0d:bf
inet6 fe80::7ed1:c3ff:fee9:dbf%en0 prefixlen 64 scopeid 0x4
inet 10.0.0.4 netmask 0xffffff00 broadcast 10.0.0.255
media: autoselect
status: active
p2p0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 2304
ether 0e:d1:c3:e9:0d:bf
media: autoselect
status: inactive
vboxnet0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 0a:00:27:00:00:00
inet 192.168.56.1 netmask 0xffffff00 broadcast 192.168.56.255
The devcloud setup with host-only (replacing the NAT adapter form the default
devcloud) will get IPs from the DHCP setup for the vboxnet adapter. It should
have been configured by default in vbox -> preferences -> network . If you
click on the "screwdriver" you can see the settings.
Make sure that you created a cloud user with cloud password before running:
> mvn -P developer -pl developer -Ddeploydb
Otherwise the tables don't get created (at least that was the case for me).
Cheers,
-sebastien
On Oct 29, 2012, at 5:27 PM, Charles Moulliard <[email protected]> wrote:
> mysql server runs on the local machine 192.168.56.1 but I still get same
> error after running the commands :
>
> mvn -P developer clean install
> mvn -P developer -pl developer -Ddeploydb
>
> That means that I haven't run the command that you mention
>
> mvn -P developer,deploysvr -pl tools/devcloud -Ddeploysvr
>
>
>
> On Mon, Oct 29, 2012 at 2:33 PM, Rohit Yadav <[email protected]> wrote:
>
>> I checked, when we do:
>>
>> mvn -P developer,deploysvr -pl tools/devcloud -Ddeploysvr
>>
>> It in turn calls python to deploy and setup a data centre using
>> devcloud.cfg which uses:
>>
>>
>> "mgtSvr": [
>> {
>> "mgtSvrIp": "127.0.0.1",-
>> "port": 8096
>> }
>> ],
>> "dbSvr":-
>> {
>>> --- "dbSvr": "127.0.0.1",
>>> --- "port": 3306,
>>> --- "user": "cloud",
>>> --- "passwd": "cloud",
>>> --- "db": "cloud"
>> }
>>
>>
>> This is needs fixing, but for now you can run mysql on localhost
>> (192.168.56.1 for host-only network) for this to work or hack
>> tools/devcloud/devcloud.cfg as needed.
>>
>> One more thing, after deploying datacenter, you're required to restart
>> management server, if there are systemvms which had already started you
>> need to destroy them and restart management server. This is because
>> devcloud.cfg sets up host, local storage etc. global settings and if you
>> modify them you're required to restart mgmt server, else console proxy and
>> ssvm functionality may not work, for example say one's unable to see the
>> console for a vm, one is unable to upload template etc.
>>
>> Hope this helps. I'll update the wiki.
>>
>> Regards.
>>
>> On 29-Oct-2012, at 5:31 PM, Charles Moulliard <[email protected]<mailto:
>> [email protected]>> wrote:
>>
>> The mysql database created on Devcloud VM (
>> http://download.cloud.com/templates/devcloud/DevCloud.ova) uses as
>> credential 'root' and not 'cloud'.
>>
>> root@devcloud:~# mysql -h localhost -u root -p cloud
>> Enter password:
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>> Welcome to the MySQL monitor. Commands end with ; or \g.
>> Your MySQL connection id is 41
>> Server version: 5.5.24-0ubuntu0.12.04.1 (Ubuntu)
>>
>> Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights
>> reserved.
>>
>> Oracle is a registered trademark of Oracle Corporation and/or its
>> affiliates. Other names may be trademarks of their respective
>> owners.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> mysql> SHOW TABLES;
>> +--------------------------------------+
>> | Tables_in_cloud |
>> +--------------------------------------+
>> | account |
>> | account_details |
>> | account_network_ref |
>> | account_vlan_map |
>> | alert |
>> | async_job |
>> | cluster |
>> | cluster_details |
>> | cluster_vsm_map |
>> | cmd_exec_log |
>> | configuration |
>> | console_proxy |
>> | data_center |
>> | data_center_details |
>> | dc_storage_network_ip_range |
>> | disk_offering |
>> | domain |
>> | domain_network_ref |
>> | domain_router |
>> | elastic_lb_vm_map |
>> | event |
>> | external_firewall_devices |
>> | external_load_balancer_devices |
>> | firewall_rules |
>> | firewall_rules_cidrs |
>> | guest_os |
>> | guest_os_category |
>> | guest_os_hypervisor |
>> | host |
>> | host_details |
>> | host_pod_ref |
>> | host_tags |
>> | hypervisor_capabilities |
>> | inline_load_balancer_nic_map |
>> | instance_group |
>> | instance_group_vm_map |
>> | keystore |
>> | launch_permission |
>> | load_balancer_stickiness_policies |
>> | load_balancer_vm_map |
>> | load_balancing_rules |
>> | mshost |
>> | mshost_peer |
>> | netapp_lun |
>> | netapp_pool |
>> | netapp_volume |
>> | netscaler_pod_ref |
>> | network_external_firewall_device_map |
>> | network_external_lb_device_map |
>> | network_offerings |
>> | network_rule_config |
>> | networks |
>> | nics |
>> | ntwk_offering_service_map |
>> | ntwk_service_map |
>> | op_dc_ip_address_alloc |
>> | op_dc_link_local_ip_address_alloc |
>> | op_dc_storage_network_ip_address |
>> | op_dc_vnet_alloc |
>> | op_ha_work |
>> | op_host |
>> | op_host_capacity |
>> | op_host_transfer |
>> | op_host_upgrade |
>> | op_it_work |
>> | op_lock |
>> | op_networks |
>> | op_nwgrp_work |
>> | op_pod_vlan_alloc |
>> | op_user_stats_log |
>> | op_vm_ruleset_log |
>> | ovs_tunnel_interface |
>> | ovs_tunnel_network |
>> | physical_network |
>> | physical_network_isolation_methods |
>> | physical_network_service_providers |
>> | physical_network_tags |
>> | physical_network_traffic_types |
>> | pod_vlan_map |
>> | port_forwarding_rules |
>> | port_profile |
>> | project_account |
>> | project_invitations |
>> | projects |
>> | remote_access_vpn |
>> | resource_count |
>> | resource_limit |
>> | resource_tags |
>> | secondary_storage_vm |
>> | security_group |
>> | security_group_rule |
>> | security_group_vm_map |
>> | sequence |
>> | service_offering |
>> | snapshot_policy |
>> | snapshot_schedule |
>> | snapshots |
>> | ssh_keypairs |
>> | stack_maid |
>> | storage_pool |
>> | storage_pool_details |
>> | storage_pool_host_ref |
>> | storage_pool_work |
>> | swift |
>> | sync_queue |
>> | sync_queue_item |
>> | template_host_ref |
>> | template_spool_ref |
>> | template_swift_ref |
>> | template_zone_ref |
>> | upload |
>> | usage_event |
>> | user |
>> | user_ip_address |
>> | user_statistics |
>> | user_vm |
>> | user_vm_details |
>> | version |
>> | virtual_router_providers |
>> | virtual_supervisor_module |
>> | vlan |
>> | vm_instance |
>> | vm_template |
>> | vm_template_details |
>> | volume_host_ref |
>> | volumes |
>> | vpn_users |
>> +--------------------------------------+
>> 127 rows in set (0.01 sec)
>>
>>
>>
>> On Mon, Oct 29, 2012 at 12:50 PM, Charles Moulliard <[email protected]
>> <mailto:[email protected]>>wrote:
>>
>> I use git master of CloudStack and maven 3.0
>>
>> If I try to connect on mysql db on DevCloud VM with parameters provided in
>> db.properties, I cannot connect
>>
>> root@devcloud:~# mysql -h 192.168.56.2 -u cloud -p cloud
>> Enter password:
>> ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.56.2' (111)
>>
>>
>>
>> On Mon, Oct 29, 2012 at 12:45 PM, Rohit Yadav <[email protected]
>> <mailto:[email protected]>>wrote:
>>
>> Hi Charles,
>>
>> On 29-Oct-2012, at 5:09 PM, Charles Moulliard <[email protected]<mailto:
>> [email protected]>> wrote:
>>
>> Hi Rohit,
>>
>> I'm a bit surprised that the procedure fails as it was working perfectly
>> last friday as explained here (
>>
>>
>> https://cwiki.apache.org/confluence/display/CLOUDSTACK/CloudStack+devcloud+environment+setup
>> )
>> with DevCloud VM. Do you know what has changed in the code ?
>>
>> No changes since Friday, as far as I know 4.0 is frozen and tagged.
>>
>> But I think you're confusing devcloud with 4.0 branch which works with
>> ant and things described on the 4.0 release test procedure wiki.
>> You need to checkout master if you want to work with maven as they depend
>> on master.
>>
>> I'm not sure, so I'll test and see if there is something that's failing
>> on master using maven.
>>
>> Regards.
>>
>>
>>
>> Regards,
>>
>> Charles
>>
>> On Mon, Oct 29, 2012 at 11:05 AM, Rohit Yadav <[email protected]
>> wrote:
>>
>>
>> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <[email protected]>
>> wrote:
>>
>> I have created a db.properties.override but same error occurs
>>
>> Check that
>> - you're correct host, password settings;
>> - your db host, db server is reachable
>> - you've granted access for that user for all hosts, i.e root@'%' has
>> access
>> - you can try to pass host, password, etc. via -D to mvn <args>
>>
>>
>> Regards.
>>
>>
>> On Sun, Oct 28, 2012 at 8:23 PM, Alex Huang <[email protected]>
>> wrote:
>>
>> If I'm not mistaken from my limited knowledge of pom, you can set a
>> db.properties.override. If that file is there, it will use this file
>> instead. In there, you should be able to specify a remote mysql
>> server.
>>
>> --Alex
>>
>> -----Original Message-----
>> From: Charles Moulliard [mailto:[email protected]]
>> Sent: Sunday, October 28, 2012 9:30 AM
>> To: [email protected]
>> Subject: Why do we need mysql server on the dev machine
>>
>> Hi,
>>
>> When building the project cloudstack-4.1.0-SNAPSHOT
>> (
>> https://cwiki.apache.org/confluence/display/CLOUDSTACK/CloudStack+de
>> vcloud+environment+setup),
>> I get the following exception :
>>
>> mvn -P developer -pl developer -Ddeploydb
>>
>> [ERROR] Failed to execute goal
>> org.codehaus.mojo:sql-maven-plugin:1.5:execute (drop-database) on
>> project
>> cloud-developer: Communications link failure [ERROR] [ERROR] The
>> last
>> packet sent successfully to the server was 0 milliseconds ago. The
>> driver has
>> not received any packets from the server. Connection refused [ERROR]
>>
>> As utils/conf/db.properties file specifies to use localhost
>> (db.cloud.host=localhost), does that means that MySQL should also be
>> installed on the development machine ?
>>
>> Regards,
>>
>> --
>> Charles Moulliard
>> Apache Committer / Sr. Enterprise Architect (RedHat) Twitter :
>> @cmoulliard |
>> Blog : http://cmoulliard.blogspot.com
>>
>>
>>
>>
>> --
>> Charles Moulliard
>> Apache Committer / Sr. Enterprise Architect (RedHat)
>> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
>>
>>
>>
>>
>> --
>> Charles Moulliard
>> Apache Committer / Sr. Enterprise Architect (RedHat)
>> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
>>
>>
>>
>>
>> --
>> Charles Moulliard
>> Apache Committer / Sr. Enterprise Architect (RedHat)
>> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
>>
>>
>>
>>
>>
>> --
>> Charles Moulliard
>> Apache Committer / Sr. Enterprise Architect (RedHat)
>> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
>>
>>
>
>
> --
> Charles Moulliard
> Apache Committer / Sr. Enterprise Architect (RedHat)
> Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
