You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cloudstack.apache.org by Charles Moulliard <ch...@gmail.com> on 2012/10/28 17:29:37 UTC
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+devcloud+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
Re: Why do we need mysql server on the dev machine
Posted by Charles Moulliard <ch...@gmail.com>.
That could be interesting to have in a file the script containing the
commands to be executed by maven sql plugin. Which such a scriptI could
perhaps figure out what happen here.
On Mon, Oct 29, 2012 at 5:42 PM, Charles Moulliard <ch...@gmail.com> wrote:
> 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 <ro...@citrix.com>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 [ch007m@gmail.com]
>> Sent: Monday, October 29, 2012 9:57 PM
>> To: cloudstack-users@incubator.apache.org
>> 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 <ro...@citrix.com>
>> 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 <ch007m@gmail.com<mailto:
>> > ch007m@gmail.com>> 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 <ch007m@gmail.com
>> > <ma...@gmail.com>>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 <rohit.yadav@citrix.com
>> > <ma...@citrix.com>>wrote:
>> >
>> > Hi Charles,
>> >
>> > On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch007m@gmail.com<mailto:
>> > ch007m@gmail.com>> 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 <rohit.yadav@citrix.com
>> > wrote:
>> >
>> >
>> > On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com>
>> > 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 <Al...@citrix.com>
>> > 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:ch007m@gmail.com]
>> > Sent: Sunday, October 28, 2012 9:30 AM
>> > To: cloudstack-users@incubator.apache.org
>> > 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
>
>
>
--
Charles Moulliard
Apache Committer / Sr. Enterprise Architect (RedHat)
Twitter : @cmoulliard | Blog : http://cmoulliard.blogspot.com
Re: Why do we need mysql server on the dev machine
Posted by Charles Moulliard <ch...@gmail.com>.
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 <ro...@citrix.com> 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 [ch007m@gmail.com]
> Sent: Monday, October 29, 2012 9:57 PM
> To: cloudstack-users@incubator.apache.org
> 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 <ro...@citrix.com>
> 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 <ch007m@gmail.com<mailto:
> > ch007m@gmail.com>> 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 <ch007m@gmail.com
> > <ma...@gmail.com>>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 <rohit.yadav@citrix.com
> > <ma...@citrix.com>>wrote:
> >
> > Hi Charles,
> >
> > On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch007m@gmail.com<mailto:
> > ch007m@gmail.com>> 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 <rohit.yadav@citrix.com
> > wrote:
> >
> >
> > On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com>
> > 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 <Al...@citrix.com>
> > 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:ch007m@gmail.com]
> > Sent: Sunday, October 28, 2012 9:30 AM
> > To: cloudstack-users@incubator.apache.org
> > 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
RE: Why do we need mysql server on the dev machine
Posted by Rohit Yadav <ro...@citrix.com>.
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 [ch007m@gmail.com]
Sent: Monday, October 29, 2012 9:57 PM
To: cloudstack-users@incubator.apache.org
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 <ro...@citrix.com> 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 <ch007m@gmail.com<mailto:
> ch007m@gmail.com>> 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 <ch007m@gmail.com
> <ma...@gmail.com>>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 <rohit.yadav@citrix.com
> <ma...@citrix.com>>wrote:
>
> Hi Charles,
>
> On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch007m@gmail.com<mailto:
> ch007m@gmail.com>> 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 <rohit.yadav@citrix.com
> wrote:
>
>
> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com>
> 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 <Al...@citrix.com>
> 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:ch007m@gmail.com]
> Sent: Sunday, October 28, 2012 9:30 AM
> To: cloudstack-users@incubator.apache.org
> 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
Re: Why do we need mysql server on the dev machine
Posted by Sebastien Goasguen <ru...@gmail.com>.
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 <ch...@gmail.com> 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 <ro...@citrix.com> 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 <ch007m@gmail.com<mailto:
>> ch007m@gmail.com>> 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 <ch007m@gmail.com
>> <ma...@gmail.com>>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 <rohit.yadav@citrix.com
>> <ma...@citrix.com>>wrote:
>>
>> Hi Charles,
>>
>> On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch007m@gmail.com<mailto:
>> ch007m@gmail.com>> 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 <rohit.yadav@citrix.com
>> wrote:
>>
>>
>> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com>
>> 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 <Al...@citrix.com>
>> 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:ch007m@gmail.com]
>> Sent: Sunday, October 28, 2012 9:30 AM
>> To: cloudstack-users@incubator.apache.org
>> 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
Re: Why do we need mysql server on the dev machine
Posted by Charles Moulliard <ch...@gmail.com>.
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 <ro...@citrix.com> 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 <ch007m@gmail.com<mailto:
> ch007m@gmail.com>> 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 <ch007m@gmail.com
> <ma...@gmail.com>>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 <rohit.yadav@citrix.com
> <ma...@citrix.com>>wrote:
>
> Hi Charles,
>
> On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch007m@gmail.com<mailto:
> ch007m@gmail.com>> 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 <rohit.yadav@citrix.com
> wrote:
>
>
> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com>
> 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 <Al...@citrix.com>
> 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:ch007m@gmail.com]
> Sent: Sunday, October 28, 2012 9:30 AM
> To: cloudstack-users@incubator.apache.org
> 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
Re: Why do we need mysql server on the dev machine
Posted by Rohit Yadav <ro...@citrix.com>.
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 <ch...@gmail.com>> 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 <ch...@gmail.com>>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 <ro...@citrix.com>>wrote:
Hi Charles,
On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch...@gmail.com>> 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 <rohit.yadav@citrix.com
wrote:
On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com>
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 <Al...@citrix.com>
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:ch007m@gmail.com]
Sent: Sunday, October 28, 2012 9:30 AM
To: cloudstack-users@incubator.apache.org
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
Re: Why do we need mysql server on the dev machine
Posted by Charles Moulliard <ch...@gmail.com>.
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 <ch...@gmail.com>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 <ro...@citrix.com>wrote:
>
>> Hi Charles,
>>
>> On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch...@gmail.com> 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 <rohit.yadav@citrix.com
>> >wrote:
>> >
>> >>
>> >> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com>
>> 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 <Al...@citrix.com>
>> >> 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:ch007m@gmail.com]
>> >>>>> Sent: Sunday, October 28, 2012 9:30 AM
>> >>>>> To: cloudstack-users@incubator.apache.org
>> >>>>> 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
Re: Why do we need mysql server on the dev machine
Posted by Charles Moulliard <ch...@gmail.com>.
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 <ro...@citrix.com>wrote:
> Hi Charles,
>
> On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch...@gmail.com> 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 <rohit.yadav@citrix.com
> >wrote:
> >
> >>
> >> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com> 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 <Al...@citrix.com>
> >> 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:ch007m@gmail.com]
> >>>>> Sent: Sunday, October 28, 2012 9:30 AM
> >>>>> To: cloudstack-users@incubator.apache.org
> >>>>> 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
Re: Why do we need mysql server on the dev machine
Posted by Rohit Yadav <ro...@citrix.com>.
Hi Charles,
On 29-Oct-2012, at 5:09 PM, Charles Moulliard <ch...@gmail.com> 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 <ro...@citrix.com>wrote:
>
>>
>> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com> 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 <Al...@citrix.com>
>> 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:ch007m@gmail.com]
>>>>> Sent: Sunday, October 28, 2012 9:30 AM
>>>>> To: cloudstack-users@incubator.apache.org
>>>>> 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
Re: Why do we need mysql server on the dev machine
Posted by Charles Moulliard <ch...@gmail.com>.
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 ?
Regards,
Charles
On Mon, Oct 29, 2012 at 11:05 AM, Rohit Yadav <ro...@citrix.com>wrote:
>
> On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com> 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 <Al...@citrix.com>
> 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:ch007m@gmail.com]
> >>> Sent: Sunday, October 28, 2012 9:30 AM
> >>> To: cloudstack-users@incubator.apache.org
> >>> 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
Re: Why do we need mysql server on the dev machine
Posted by Rohit Yadav <ro...@citrix.com>.
On 29-Oct-2012, at 2:35 PM, Charles Moulliard <ch...@gmail.com> 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 <Al...@citrix.com> 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:ch007m@gmail.com]
>>> Sent: Sunday, October 28, 2012 9:30 AM
>>> To: cloudstack-users@incubator.apache.org
>>> 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
Re: Why do we need mysql server on the dev machine
Posted by Charles Moulliard <ch...@gmail.com>.
I have created a db.properties.override but same error occurs
On Sun, Oct 28, 2012 at 8:23 PM, Alex Huang <Al...@citrix.com> 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:ch007m@gmail.com]
> > Sent: Sunday, October 28, 2012 9:30 AM
> > To: cloudstack-users@incubator.apache.org
> > 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
RE: Why do we need mysql server on the dev machine
Posted by Rohit Yadav <ro...@citrix.com>.
Updated in https://cwiki.apache.org/confluence/display/CLOUDSTACK/Building+with+Maven#BuildingwithMaven-DeployingDatabase
Another shortcut would be to pass any vars ${} that are defined or used in developer/pom.xml using -Dvar=value, for example
mvn -P developer -pl developer -Ddeploydb -Ddb.cloud.host=10.20.30.40 -Ddb.cloud.port=9000
Thanks for bringing the issue.
> -----Original Message-----
> From: Charles Moulliard [mailto:ch007m@gmail.com]
> Sent: Sunday, October 28, 2012 9:30 AM
> To: cloudstack-users@incubator.apache.org
> 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
RE: Why do we need mysql server on the dev machine
Posted by Rohit Yadav <ro...@citrix.com>.
Charles, that's right what Alex advises;
just copy utils/conf/db.properties to utils/conf/db.properties.override and edit as needed.
the .override file is not tracked by git and is in .gitignore.
Regards.
________________________________________
From: Alex Huang [Alex.Huang@citrix.com]
Sent: Monday, October 29, 2012 12:53 AM
To: cloudstack-users@incubator.apache.org
Subject: RE: Why do we need mysql server on the dev machine
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:ch007m@gmail.com]
> Sent: Sunday, October 28, 2012 9:30 AM
> To: cloudstack-users@incubator.apache.org
> 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
RE: Why do we need mysql server on the dev machine
Posted by Alex Huang <Al...@citrix.com>.
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:ch007m@gmail.com]
> Sent: Sunday, October 28, 2012 9:30 AM
> To: cloudstack-users@incubator.apache.org
> 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