Mailing-List: contact cloudstack-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-users@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of rohit.yadav@citrix.com
 designates 203.166.19.134 as permitted sender)
From: Rohit Yadav <rohit.yadav@citrix.com>
To: "cloudstack-users@incubator.apache.org"
	<cloudstack-users@incubator.apache.org>
Date: Sun, 25 Nov 2012 08:20:36 +0530
Subject: RE: Centos 6.3 new install sql connection issue
Thread-Topic: Centos 6.3 new install sql connection issue
Thread-Index: Ac3KmB57Bytj4RxRT8+hzDgAfMvK4QAACZ5gAAdTFI4=
Message-ID: 
 <0BCCCE152323764BB7FD6AE6D7A1D90601004B435ADD@BANPMAILBOX01.citrite.net>
References: <08ony9uv4m0jpcagwhqp88hc.1353646725770@email.android.com>
 <CANfyjVLtr-bbGb9=HuwwK7jjqkPpgEHSSmJYUvHGHZ8rCAt07g@mail.gmail.com>
 <2B63755D65E0A74B938D64465EAC05AC1AAB1A@node-sbs03.node.local>,<2B63755D65E0A74B938D64465EAC05AC1AAB1B@node-sbs03.node.local>
 <0BCCCE152323764BB7FD6AE6D7A1D90601004B435ADA@BANPMAILBOX01.citrite.net>
 <2B63755D65E0A74B938D64465EAC05AC1AAB1D@node-sbs03.node.local>
 <2B63755D65E0A74B938D64465EAC05AC1AAB23@node-sbs03.node.local>,<2B63755D65E0A74B938D64465EAC05AC1AAB29@node-sbs03.node.local>
 <0BCCCE152323764BB7FD6AE6D7A1D90601004B435ADB@BANPMAILBOX01.citrite.net>
 <2B63755D65E0A74B938D64465EAC05AC1AAB2A@node-sbs03.node.local>
 <A97474E9-0BC7-4BD3-B58D-3F89CBA49402@gmail.com>,<2B63755D65E0A74B938D64465EAC05AC1AAB2B@node-sbs03.node.local>
In-Reply-To: <2B63755D65E0A74B938D64465EAC05AC1AAB2B@node-sbs03.node.local>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

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 local=
host 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=3D1
innodb_lock_wait_timeout=3D600
max_connections=3D350
log-bin=3Dmysql-bin
binlog-format =3D 'ROW'

b. Deploy database: (localhost or custom IP or resolvable domain)
cloud-setup-databases cloud:<dbpassword>@localhost --deploy-as=3Droot:<pass=
word>

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 [bcross@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:runseb@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.yadav@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 [bcross@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=3D9aYbPEWduIY
>
> The sequence of commands I'm using is here:
>
> http://pastebin.com/B0LJJtVL
>
> -Brandon Cross