This is really strange as I can connect as root to the local mysql server running on my MacBookPro
mysql -h localhost -u root and display tables info mysql> CONNECT fuse_demo; mysql> SHOW TABLES; +---------------------+ | Tables_in_fuse_demo | +---------------------+ | Payments | | ProcessedPayments | +---------------------+ 2 rows in set (0.00 sec) On Mon, Oct 29, 2012 at 5:34 PM, Rohit Yadav <[email protected]> wrote: > 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 > -- Charles Moulliard Apache Committer / Sr. Enterprise Architect (RedHat) Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
