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.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
