Community
 
 
 

CloudPlatform 3.x

팔로워 343명
 
Avatar
Pankaj Paliwal

Cloud platform 3.0.6 installation in RHEL 6.2 - SQL error

Avatar

Cloud platform 3.0.6 installation in RHEL 6.2 - SQL error

Hi Team,

when i tring to create the database as part clould platform installation , getting below error, please help me if you have come across this,

[root@od-]# cloud-setup-databases cloud:cisco123@172.20.126.85 --deploy-as=root:cisco123
Mysql user name:cloud [ OK ]
Mysql user password:cisco123 [ OK ]
Mysql server ip:172.20.126.85 [ OK ]
Mysql server port:3306 [ OK ]
Mysql root user name:root [ OK ]
Mysql root user password:cisco123 [ OK ]
Checking Cloud database files ... [ OK ]
Checking local machine hostname ... [ OK ]
Checking SELinux setup ... WARNING: We detected that your SELinux is not configured in permissive. to make sure cloudstack won't block by SELinux after system reboot, we strongly suggest you setting it in permissive in /etc/selinux/config, then reboot the machine.
[ OK ]
Detected local IP address as 172.20.126.85, will use as cluster management server node IP[ OK ]
Preparing /etc/cloud/management/db.properties [ OK ]
Applying /usr/share/cloud/setup/create-database.sql

We apologize for below error:
*************************************************************
Encountering an error when executing mysql script
----------------------------------------------------------------------
table:
/usr/share/cloud/setup/create-database.sql

Error:
ERROR 1045 (28000): Access denied for user 'root'@'od-t-cp01' (using password: YES)

Sql parameters:
{'passwd': 'cisco123', 'host': '172.20.126.85', 'user': 'root', 'port': 3306}
----------------------------------------------------------------------

*************************************************************
Please run:

cloud-setup-database -h

for full help
[root@od-t-]#


Suresh kannan MEMBERS
댓글 2개
0

댓글을 남기려면 로그인하세요.

 
 

Previous 댓글 2개

Avatar
Pankaj Paliwal
Avatar

Cloud platform 3.0.6 installation in RHEL 6.2 - SQL error

It looks like your MySQL DB isn't allowing logins from your CCP management node. This can happen if the GRANTs are configured correctly. Make sure the 'root' can connect to your DB from your management node.

You could open it up from any host (not recommended)

mysql> GRANT ALL PRIVILEGES ON . to 'root'@'%' WITH GRANT OPTION;

Or, you could be more specific

mysql> GRANT ALL PRIVILEGES ON . to 'root'@'<IP of CCPmgmt>' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON . to 'root'@'<hostname of CCPmgmt>' WITH GRANT OPTION;

--Mike


Mike Little MEMBERS
댓글 작업 고유 링크
Avatar
Pankaj Paliwal
Avatar

Thanks Mike.

root@'<hostname>' password was not set, after setting the password with GRAND all PRIVILEGES, it working.


Suresh kannan MEMBERS
댓글 작업 고유 링크

Top Contributors