Support for AWS RDS as Remote MySQL Server
For a number of reasons it seems quite difficult to use an RDS instance as a remote server with WHM 11.42. Firstly, since ssh is required, it's not possible to set it as a remote server in WHM and use the automated transfer feature.
Even using mysql-proxy to redirect localhost requests to the RDS instance, there seem to be lots of problems doing things like creating new accounts, etc. Turning off the local mysql server was also problematic as certain functions test its status and turn it back on.
Perhaps three config options should be made available:
1) localhost
2) remote server
3) remote mysql server (everything done through mysql client, no ssh, no start/stop, etc)
I like this idea 
cPanel, WebHost Manager and WHM are registered trademarks of cPanel, L.L.C. for providing its computer software that facilitates the management and configuration of Internet web servers.
Hi all! I'm so sorry for our delay here. Unfortunately the MySQL profiles that we implemented in 11.52 do not solve this feature request, as we do still require "root" type privileges with mysql. This isn't on our roadmap at this time, but I'll update again as soon as there's more information.
Hi all! I'm so sorry for our delay here. Unfortunately the MySQL profiles that we implemented in 11.52 do not solve this feature request, as we do still require "root" type privileges with mysql. This isn't on our roadmap at this time, but I'll update again as soon as there's more information.
This will be a really good feature to have in cPanel. If you can make this feature enabled, I guess cPanel can be truly expanded to work in a total cloud environment. Will love to have this feature on CPanel
This will be a really good feature to have in cPanel. If you can make this feature enabled, I guess cPanel can be truly expanded to work in a total cloud environment. Will love to have this feature on CPanel
Very good feature
Very good feature
Yeah! It would be great!
Yeah! It would be great!
The only thing preventing this from being possible is that Amazon doesn't provide SSH level access to an RDS host.
The only thing preventing this from being possible is that Amazon doesn't provide SSH level access to an RDS host.
One of the things on our backlog for this year is to enhance the remote MySQL support, allowing use of a remote server without requiring operating system access.
One of the things on our backlog for this year is to enhance the remote MySQL support, allowing use of a remote server without requiring operating system access.
We have begun working on a MySQL credential only version of remote MySQL. This should be available in 11.52 and in edge builds soon. This should satisfy this request.
We have begun working on a MySQL credential only version of remote MySQL. This should be available in 11.52 and in edge builds soon. This should satisfy this request.
This is great news!
This is great news!
That is great, since I have been trying to get MySQL proxy to work with cPanel, and RDS for 3 days now...
Everything is so close, but there are still issues. When will this at least be available on edge?
I am probably stuck with doing it the mysql-proxy way though, because I need it done within the next few days. :(
That is great, since I have been trying to get MySQL proxy to work with cPanel, and RDS for 3 days now...
Everything is so close, but there are still issues. When will this at least be available on edge?
I am probably stuck with doing it the mysql-proxy way though, because I need it done within the next few days. :(
As said by Travis, the functionality to connect using the credentials only is present in 11.52.
But when trying to connect to the Amazon RDS: "The MySQL user does not have the proper PRIVILEGES to act as a MySQL superuser."
As mentioned by AWS: "... MySQL SUPER privilege, which is restricted for MySQL RDS DB instances."
(http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html)
So it's really necessary that WHM require SUPER privilege for the database operations available in Cpanel?
As said by Travis, the functionality to connect using the credentials only is present in 11.52.
But when trying to connect to the Amazon RDS: "The MySQL user does not have the proper PRIVILEGES to act as a MySQL superuser."
As mentioned by AWS: "... MySQL SUPER privilege, which is restricted for MySQL RDS DB instances."
(http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Troubleshooting.html)
So it's really necessary that WHM require SUPER privilege for the database operations available in Cpanel?
As this solution doesn't work for AWS RDS (this solution requires SUPER privileges which are not available on RDS servers), can this request be changed from "completed"?
Can this feature be achieved without requiring SSH or SUPER? If not, it won't work with AWS RDS.
As this solution doesn't work for AWS RDS (this solution requires SUPER privileges which are not available on RDS servers), can this request be changed from "completed"?
Can this feature be achieved without requiring SSH or SUPER? If not, it won't work with AWS RDS.
Hi,
Does anyone know if this has progressed at all or if there are workarounds? I'm coming to try and attach a remote profile to RDS and getting the SUPER privileges error as described.
Many thanks,
Phil.
Hi,
Does anyone know if this has progressed at all or if there are workarounds? I'm coming to try and attach a remote profile to RDS and getting the SUPER privileges error as described.
Many thanks,
Phil.
I'm getting the same "super privileges" error as Phil. Are there any updates on this topic or workarounds?
I'm getting the same "super privileges" error as Phil. Are there any updates on this topic or workarounds?
Hi all! I'm so sorry for our delay here. Unfortunately the MySQL profiles that we implemented in 11.52 do not solve this feature request, as we do still require "root" type privileges with mysql. This isn't on our roadmap at this time, but I'll update again as soon as there's more information.
Hi all! I'm so sorry for our delay here. Unfortunately the MySQL profiles that we implemented in 11.52 do not solve this feature request, as we do still require "root" type privileges with mysql. This isn't on our roadmap at this time, but I'll update again as soon as there's more information.
Do you have any updates on this? Why is super required by cPanel? Having RDS as an option would be a very good thing.
Do you have any updates on this? Why is super required by cPanel? Having RDS as an option would be a very good thing.
Why, specifically, isn't known to me at this time, but as soon as there's an update I'll be back here!
EDIT: Got more information on this one:
Why, specifically, isn't known to me at this time, but as soon as there's an update I'll be back here!
EDIT: Got more information on this one:
With cPanel & WHM Version 80 (currently in EDGE, expected to roll out to the other tiers in the next few months) we have enabled RDS support, and released this related documentation:
https://documentation.cpanel.net/display/CKB/Create+an+Amazon+RDS+Instance
As part of this work, however, we identified a number of quirks in the MySQL profiles system. Like normal, please report any bugs that you encounter to your web host or license provider, who will then report them to our support team.
With cPanel & WHM Version 80 (currently in EDGE, expected to roll out to the other tiers in the next few months) we have enabled RDS support, and released this related documentation:
https://documentation.cpanel.net/display/CKB/Create+an+Amazon+RDS+Instance
As part of this work, however, we identified a number of quirks in the MySQL profiles system. Like normal, please report any bugs that you encounter to your web host or license provider, who will then report them to our support team.
Replies have been locked on this page!