usmannasir / cyberpanel

Cyber Panel - The hosting control panel for OpenLiteSpeed
GNU General Public License v3.0
1.6k stars 613 forks source link

Connection to Amazon RDS private database error because the install create user with public_IP and connect with private_IP #612

Closed adeogliari closed 3 years ago

adeogliari commented 3 years ago

When we setup a connection to a RDS private database the install fail because the installer get "user@$Server_IP" and when we use a private database, the connection is made with "user@Private_IP(from instance)".

I'm studying and I found this line for IP consult in install script cyberpanel.sh but I don't know where and how to create a option to insert the private IP of instance to connect in Amazon RDS private database:

This is the line of user creation: "CREATE USER 'cyberpanel'@'public_ip' IDENTIFIED BY 'rSZHbKeE62PtWa'"

This is the line of user connection: (1045, "Access denied for user 'cyberpanel'@'private_IP' (using password: YES)")

usmannasir commented 3 years ago

I've not added support for amazon private ip yet.