Hi Brandon, Could you check which address is your MySQL listening to? You can try "netstat -napt | grep :3306".
thx On Sun, Nov 25, 2012 at 4:52 AM, Brandon Cross <bcr...@nodetx.com> wrote: > 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 > cloud-setup-management > > > Looking at your logs, are you running your mgmt server and mysql > server on the same server, 192.168.2.220? > > Yes, I am running them both on the same server which is 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: > > 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 > UI... > 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 > --deploy-as=root:<password> > > 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 > database > > > 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 [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 > >
