Essentially are you able to login to db server from mgmt server using root via
MySQL command and speechify -h db server name?
MySQL.user is the table which controls this.
Sent from my iPhone
> On 19 Aug 2014, at 6:30 pm, tejas.sh...@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
>
