Configure Jump Server to use SSL for AWS RDS
How to configure Ezeelogin Jump Server to use SSL for AWS RDS database connection?
Refer this article to set up AWS RDS .
You can download certificates for using SSL in AWS RDS from here .
1. Move certificates to a directory and specify them in the below steps.
2. Try connecting RDS with SSL using the below command.
[email protected] ~]# mysql -h mysql–instance1.123456789012.us-east-1.rds.amazonaws.com --ssl-ca= /path_of_cert_file/rds-combined-ca-bundle.pem -P 3306 -u mymasteruser -p
3. Append below lines in /usr/local/etc/ezlogin/ez.conf file and specify the path of cert to use SSL RDS with Ezeelogin.
[email protected] ~]# vim /usr/local/etc/ezlogin/ez.conf
4. Try accessing GUI and Ezeelogin shell to confirm if its using RDS SSL.
5. Run below commands in RDS, if you got database error.
[email protected] ~]# mysql -h mysql–instance1.123456789012.us-east-1.rds.amazonaws.com -u mymasteruser -p
mysql > grant all on ezlogin_databasename.* to 'mysql_username'@'%' identified by 'password' with grant option;
mysql > grant all on ezlogin_databasename.* to 'mysql_username'@'%' identified by 'password';
mysql > flush privileges;
mysql > exit