I tried logging in using cloud user too and it was working from mysql prompt but not from cloudstack. But I figured it out. I changed db.properties and changed all "localhost" and "127.0.0.1" with actual management server IP. Management server and DB are on same node but seems somehow mysql was blocking connections accessed with above two and was allowing by actual IP. It is working fine now and I launched my first instance too! Looks cool so far.
Thanks for pointers anyways. Problem was in exactly the same area. ----- Original Message ----- From: "Ilya Musayev" <imusa...@webmd.net> To: cloudstack-users@incubator.apache.org Sent: Saturday, March 9, 2013 2:17:31 AM Subject: RE: Problems starting management server Check your settings in /etc/cloud/management/db.properties file Regards ilya > -----Original Message----- > From: Kirk Kosinski [mailto:kirkkosin...@gmail.com] > Sent: Friday, March 08, 2013 1:56 PM > To: cloudstack-users@incubator.apache.org > Subject: Re: Problems starting management server > > Hi, Aniket. CloudStack doesn't use the root user to connect to the database, > rather it uses the user you specified in the cloud-setup-databases step of the > installation (if you followed the instructions exactly, it is the "cloud" > user). So > you should make sure that the user CloudStack is using can connect and not > just the root user. > > Best regards, > Kirk > > On 03/08/2013 04:00 AM, Aniket wrote: > > We are using Cloudplatform v3.0.6 trial release. I believe underneath > > cloudstack there is v3.0.2. > > I successfully did single node install but then now management server > > refuses to start. When I check server logs it says it's not able to > > connect to mysql. I followed all steps in guide and fo rtime being, in > > fact I tried stopping firewall on the box. I'm manually able to > > connect to "cloud" database as a root user. Also that works from > > remote box. I'm right now completely stuck on this as fro mysql > > context there's no issue but somehow management server is not able to > connect to it. > > > > [root@csk-controller1 CloudStack-3.0.6-1-rhel6.2]# > > /etc/init.d/iptables status > > iptables: Firewall is not running. > > > > [root@csk-controller1 CloudStack-3.0.6-1-rhel6.2]# sestatus > > SELinux status: disabled > > > > [root@csk-controller1 CloudStack-3.0.6-1-rhel6.2]# mysql -h > > 10.43.10.21 -u root -pCloudstack123 Welcome to the MySQL monitor. > > Commands end with ; or \g. > > Your MySQL connection id is 7 > > Server version: 5.1.67-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> > > > > # Still see this in management server logs: > > 2013-03-08 17:19:24,793 ERROR [db.Transaction.Transaction] (main:null) > > Unexpected exception: > > > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: > > Could not create connection to database server. Attempted reconnect 3 > > times. Giving up. > > > > All permissions are granted for root user for all databases (*.*). > > Appreciate any quick help or pointers. This is all Centos 6.3 based > > clean install. > >
