Cloud platform 3.0.6 installation in RHEL 6.2 - SQL error
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)
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;