Return-Path: 
 <users-return-17207-apmail-cloudstack-users-archive=cloudstack.apache.org@cloudstack.apache.org>
X-Original-To: apmail-cloudstack-users-archive@www.apache.org
Delivered-To: apmail-cloudstack-users-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id E572C113D1
	for <apmail-cloudstack-users-archive@www.apache.org>;
 Wed, 20 Aug 2014 04:35:12 +0000 (UTC)
Received: (qmail 75578 invoked by uid 500); 20 Aug 2014 04:35:12 -0000
Delivered-To: apmail-cloudstack-users-archive@cloudstack.apache.org
Received: (qmail 75523 invoked by uid 500); 20 Aug 2014 04:35:12 -0000
Mailing-List: contact users-help@cloudstack.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@cloudstack.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@cloudstack.apache.org>
List-Post: <mailto:users@cloudstack.apache.org>
List-Id: <users.cloudstack.apache.org>
Reply-To: users@cloudstack.apache.org
Delivered-To: mailing list users@cloudstack.apache.org
Received: (qmail 75506 invoked by uid 99); 20 Aug 2014 04:35:11 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Aug 2014 04:35:11 +0000
X-ASF-Spam-Status: No, hits=2.2 required=5.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [119.226.86.163] (HELO fbs-ho-mailserver.frontier.in)
 (119.226.86.163)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Aug 2014 04:35:07 +0000
In-Reply-To: 
 <OF8A368425.B7B3C604-ON65257D3A.0017C4DC-65257D3A.00184071@frontier.in>
References: 
 <OF1DCD6E13.600DF4C5-ON65257D39.0043C8C1-65257D39.0046DAF9@frontier.in>
 <53F3B8F4.5030600@gmail.com>
 <OF8A368425.B7B3C604-ON65257D3A.0017C4DC-65257D3A.00184071@frontier.in>
To: users@cloudstack.apache.org
MIME-Version: 1.0
Subject: Re: mysql-setup-database ERROR 1044 access denied for user root
X-KeepSent: 21E05736:0D2872AF-65257D3A:0018797F;
 type=4; name=$KeepSent
X-Mailer: IBM Notes Release 9.0 March 08, 2013
From: sunil.pichamuthu@frontier.in
Message-ID: 
 <OF21E05736.0D2872AF-ON65257D3A.0018797F-65257D3A.001896E7@frontier.in>
Date: Wed, 20 Aug 2014 09:54:05 +0530
X-MIMETrack: Serialize by Router on fbs-ho-mailserver/frontier/in(Release
 8.5.3FP3|November
 15, 2012) at 08/20/2014 09:54:26,
	Serialize complete at 08/20/2014 09:54:26
Content-Type: multipart/alternative;
 boundary="=_alternative 0018968265257D3A_="
X-Virus-Checked: Checked by ClamAV on apache.org

--=_alternative 0018968265257D3A_=
Content-Type: text/plain; charset="US-ASCII"

Tejas,

You'll need to check if the root user has permissions to connect from any 
server (%) and its permissions on cloud database.

Regards,
Sunil Pichamuthu
IT Consultant
Frontier Business Systems
Ph.: +91-9844844216
"Sure it's a big job; but I don't know anyone Who can do it better than I 
can. - John F. Kennedy"




From:   tejas.sheth@frontier.in
To:     users@cloudstack.apache.org
Date:   20-08-2014 09:51
Subject:        Re: mysql-setup-database ERROR 1044 access denied for user 
root



Hi,

  I can login to remote database server using "mysql -h <ip address> -u 
root" command but if i type "-p" option (mysql -h <ip address> -u root -p) 

then i am not able to connect. but i am able to connect to db server with 
"-p" option if i log in to Database server and use -h localhost.

  When i type show databases it show following databases in DB server.
   +--------------------+
| Database           |
+--------------------+
| information_schema |
| cloud              |
| mysql              |
+--------------------+
3 rows in set (0.00 sec)

  Thanks
  Tejas



From:   ilya musayev <ilya.mailing.lists@gmail.com>
To:     users@cloudstack.apache.org
Date:   08/20/2014 02:11 AM
Subject:        Re: mysql-setup-database ERROR 1044 access denied for user 

root



Can you confirm logging using mysql client?

One other thought, change password to something simple that does not 
have any fancy characters for this installation. I assume this should 
not be an issue, but try it anyway. One other thing you can do as work 
around, install the mysql db locally, run setup script against local 
host, then export all DBs and import to new server. Recreate the users 
and make sure to give your user proper host access (i.e. 
cloud@"10.0.1.72").

On 8/19/14, 5:49 AM, tejas.sheth@frontier.in wrote:
> Hi,
>    I have installed database in septate node (RHEL 6.3) and all the
> configuration steps have been performed as per installation guide.
>   I have also installed cloudstack management server (RHEL 6.3) and all 
the
> configuration. I have disabled firewall in RHEL.
> When i execute cloudstack-setup-databases cloud:<dbpassword>@localhost
> --deploy-as=root:<password> it gives error.
>
>    Kindly suggest the fix. appreciate your help in advance.
>
>    Mysql user name:cloud        [ OK ]
> Mysql user password:******      [ OK ]
> Mysql server ip:10.0.1.70      [ OK ]
> Mysql server port:3306      [ OK ]
> Mysql root user name:root      [ OK ]
> Mysql root user password:******      [ OK ]
> Checking Cloud database files ...      [ OK ]
> Checking local machine hostname ...      [ OK ]
> Checking SELinux setup ...      [ OK ]
> Detected local IP address as 10.0.1.72, will use as cluster management
> server node IP[ OK ]
> Preparing /etc/cloudstack/management/db.properties      [ OK ]
> Applying /usr/share/cloudstack-management/setup/create-database.sql
>
> We apologize for below error:
> ***************************************************************
> Encountering an error when executing mysql script
> ----------------------------------------------------------------------
> table:
> /usr/share/cloudstack-management/setup/create-database.sql
>
> Error:
> ERROR 1045 (28000): Access denied for user 
'root'@'cssrv2.cloudfront.com'
> (using password: YES)
>
>
> Sql parameters:
> {'passwd': 'P@ssw0rd', 'host': '10.0.1.70', 'user': 'root', 'port': 
3306}
> ----------------------------------------------------------------------
>
> ***************************************************************
>
> Thanks
> Tejas
>
>




--=_alternative 0018968265257D3A_=--