No, you run cloud-setup-management only once after deploying or setting up the database. Looking at your logs, are you running your mgmt server and mysql server on the same server, 192.168.2.220?
In case, checklist: 0. You deployed database using correct IP, username and password. 1. Are you able to reach the mysql server and it is running either on localhost or the correct host IP. 2. MySql server is running on its default port, 3306, if not make sure you specify custom port while setting up database see 3. Also, the port is not blocked, check iptables. 3. You have used correct CloudStack deployment procedure: a. Change (append or search and update) the following values in /etc/my.cnf or /etc/mysql/my.cnf: innodb_rollback_on_timeout=1 innodb_lock_wait_timeout=600 max_connections=350 log-bin=mysql-bin binlog-format = 'ROW' b. Deploy database: (localhost or custom IP or resolvable domain) cloud-setup-databases cloud:<dbpassword>@localhost --deploy-as=root:<password> c.Finally setup CloudStack, the following configures CloudStack mgmt server with appropriate settings: cloud-setup-management 4. Set SELinux to permissive: setenforce permissive 5. You're using MySQL server 5.1.58 or above. Hope this helps. ________________________________________ From: Brandon Cross [bcr...@nodetx.com] Sent: Sunday, November 25, 2012 4:37 AM To: cloudstack-users@incubator.apache.org Subject: RE: Centos 6.3 new install sql connection issue Should I run cloud-setup-management before deploying the databases? I have to run cloud-setup-management upon each reboot, or the UI will not load to give me a login prompt on my web browser at http://server-ip:8080/client -Brandon Cross, MCSE President, NODE LLC 309 Breesport San Antonio, TX 78216 Skype ID: NODETX Office Phone: (210)319-4382 Ext 102 WWW.NODETX.COM -----Original Message----- From: sebgoa [mailto:run...@gmail.com] Sent: Saturday, November 24, 2012 5:04 PM To: cloudstack-users@incubator.apache.org Subject: Re: Centos 6.3 new install sql connection issue Brandon, can you try running cloud-setup-management on the mgt server. I believe you are running in a doc bug. -Sebastien On Nov 24, 2012, at 11:58 PM, Brandon Cross wrote: > Rohit, thanks for replying. The logfile can be located here: > > http://www.nodetx.com/management-server.log > > -Brandon Cross > > -----Original Message----- > From: Rohit Yadav [mailto:rohit.ya...@citrix.com] > Sent: Saturday, November 24, 2012 4:48 PM > To: cloudstack-users@incubator.apache.org > Subject: RE: Centos 6.3 new install sql connection issue > > Brandon, I'm not sure what exactly is the issue, can you share the > logs somewhere? > Also, can you try with a different MySQL server version? There was a > global lock bug in mysql long ago, but guess should not be an issue now. > > Lastly, you may try with a MySQL server setup on a different machine > (possibly a different distro/environment) and deploy database > (cloud-setup-database). > > Regards. > > ________________________________________ > From: Brandon Cross [bcr...@nodetx.com] > Sent: Sunday, November 25, 2012 4:03 AM > To: cloudstack-users@incubator.apache.org > Subject: RE: Centos 6.3 new install sql connection issue > > Ok I tried several more times and I consistently get the same result... > UI comes up, and I cannot log in. > > I shot a video to demonstrate what I'm doing: > > http://www.youtube.com/watch?v=9aYbPEWduIY > > The sequence of commands I'm using is here: > > http://pastebin.com/B0LJJtVL > > -Brandon Cross