Ahmad, thanks for the response. It's true that I must start the mysql service each time I restart. I also must start tomcat, and run cloud-setup-management with my current config. I have mysql started for sure before running any of the cloud database deployment, or cloud management setup commands... I also start those after each reboot while testing.
I am able to use the cloud user account to log into mysql, here's the exact output: [root@nodedev4 ~]# service mysqld status mysqld (pid 3945) is running... [root@nodedev4 ~]# mysql -u cloud -pcloud Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.1.66-log Source distribution Copyright (c) 2000, 2012, 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 databases; +--------------------+ | Database | +--------------------+ | information_schema | | cloud | | cloud_usage | | cloudbridge | +--------------------+ 4 rows in set (0.03 sec) mysql> exit Bye [root@nodedev4 ~]# -Brandon Cross -----Original Message----- From: Ahmad Emneina [mailto:ahmad.emne...@citrix.com] Sent: Saturday, November 24, 2012 7:04 PM To: cloudstack-users@incubator.apache.org Subject: Re: Centos 6.3 new install sql connection issue Are you able to log into the mysql server with the cloud user credentials? In the command excerpts, I didn¹t see a chkconfig for mysql, your db server might not be running especially after the reboots. On 11/24/12 3:07 PM, "Brandon Cross" <bcr...@nodetx.com> wrote: >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 > > -- Æ
