cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Cross" <>
Subject RE: Centos 6.3 new install sql connection issue
Date Sun, 25 Nov 2012 03:52:00 GMT
Rohit, thank you. Here's the answers to those questions. 

> No, you run cloud-setup-management only once after deploying or
setting up the database.
In that case, I have done it correctly it appears, because I am running
the database deploy cmd first, and then later after setting up the NFS
mounts, as the final step before attempting to log into the UI, I run

> Looking at your logs, are you running your mgmt server and mysql
server on the same server,

Yes,  I am running them both on the same server which is

> 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:

 The exact cmd I'm deploying with is "cloud-setup-databases
cloud:cloud@localhost --deploy-as=root:12345"
 mysql appears to be running on the default port 3306. I also went ahead
and opened 3306 in iptables and reran the cloud setup database deploy
and setup management commands, but still have been able to log in to the
Since I'm running mysql on localhost, the documentation skips opening
the port 3306 in iptables but I went ahead and did the command anyway
just in case here.
I'm also able to log into mysql as both cloud, and root, locally, and
remotely. When logging in, I'm able to show the database tables, so I
know I'm in the right place.

> 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'

 Yes that has been appended into my my.cnf file

> b. Deploy database: (localhost or custom IP or resolvable domain)
cloud-setup-databases cloud:<dbpassword>@localhost

as above, I've run that command successfully

> c.Finally setup CloudStack, the following configures CloudStack mgmt
server with appropriate settings:
> cloud-setup-management

Yes, I've also run that command successfully

> 4. Set SELinux to permissive:
> setenforce permissive

> Yup, I did that after receiving the errors while deploying the cloud

> 5. You're using MySQL server 5.1.58 or above.

I'm running Server version: 5.1.66

>  Hope this helps.

From: Brandon Cross []
Sent: Sunday, November 25, 2012 4:37 AM
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

-Brandon Cross, MCSE
President, NODE LLC
309 Breesport
San Antonio, TX 78216
Office Phone: (210)319-4382 Ext 102

-----Original Message-----
From: sebgoa []
Sent: Saturday, November 24, 2012 5:04 PM
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.


On Nov 24, 2012, at 11:58 PM, Brandon Cross wrote:

> Rohit, thanks for replying. The logfile can be located here:
> -Brandon Cross
> -----Original Message-----
> From: Rohit Yadav []
> Sent: Saturday, November 24, 2012 4:48 PM
> To:
> 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
> 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 []
> Sent: Sunday, November 25, 2012 4:03 AM
> To:
> Subject: RE: Centos 6.3 new install sql connection issue
> Ok I tried several more times and I consistently get the same
> UI comes up, and I cannot log in.
> I shot a video to demonstrate what I'm doing:
> The sequence of commands I'm using is here:
> -Brandon Cross

View raw message