cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Moulliard <ch0...@gmail.com>
Subject Re: Why do we need mysql server on the dev machine
Date Mon, 29 Oct 2012 17:50:10 GMT
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 <ch007m@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 <rohit.yadav@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 <rohit.yadav@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
>> > <mailto:ch007m@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
>> > <mailto:rohit.yadav@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 <ch007m@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 <Alex.Huang@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message