Sorry no idea what may be the problem on your machine. (For deploydb, use root user in db.properties etc.) Works for me.
Regards. ________________________________________ From: Charles Moulliard [[email protected]] Sent: Monday, October 29, 2012 9:57 PM To: [email protected] Subject: Re: Why do we need mysql server on the dev machine 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
