Description of problem:

On Satellite 6.12 only way to change the redhat_repository_url is when the CDN configuration is set to "Custom CDN".

However, there are specific use-case where some customers need to use a different mirror URL to fetch our content. When using the custom cdn configuration to make this change, access to our mirror is denied because katello won't use certificates to try establishing a connection.

Version-Release number of selected component (if applicable):

6.12

How reproducible:

Always

Steps to Reproduce:
1. Modify the CDN configuration to Custom CDN and use the URL to https://ru-by-exceptions.cdn.redhat.com
2. Try going to Content -> Red Hat Repositories and enable any repository

Actual results: Satellite can't see any repositories

Expected results:
Be able to see and enable our repositories

Additional info:

This is a very specific situation, that affects customers on (apparently) only two countries. In those cases, Akamai redirects any requests that go to cdn.redhat.com to ru-by-exceptions.cdn.redhat.com.

As discussed on [1], we don't follow redirects so only alternative is to manually define a new CDN url. This used to work as a workaround for those customers, but since 6.12 it doesn't work anymore.

An ugly workaround I found was to set the cdn configuration to custom, define the alternative URL and then manually modify the type of the configuration on the DB, like this:

~~~
echo "update katello_cdn_configurations set type = 'redhat_cdn' where url like '%ru-by-exceptions.cdn.redhat.com%'" |su - postgres -c 'psql foreman'
~~~

This is obviously not desired, but the only way I found until now.

[1]: https://bugzilla.redhat.com/show_bug.cgi?id=2090466