cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Cross" <bcr...@nodetx.com>
Subject RE: Centos 6.3 new install sql connection issue
Date Sun, 25 Nov 2012 02:40:57 GMT
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.Emneina@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" <bcross@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: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=9aYbPEWduIY
>> 
>> The sequence of commands I'm using is here:
>> 
>> http://pastebin.com/B0LJJtVL
>> 
>> -Brandon Cross
>
>


--
Æ




Mime
View raw message