Community
 
 
 

CloudPlatform 3.x

343 seguidores
 
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 comentários
0

iniciar sessão para comentar.

 
 

Previous 2 comentários

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
Ações de comentário Permalink
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
Ações de comentário Permalink

Top Contributors