Plugins » Katello

Http proxy is referenced in postgres even after being removed from the server
Cloned from 16161848

Description of problem:

The http_proxy was deleted and the current values are empty.

[root@sat ~]# hammer settings show --name=content_default_http_proxy
Id: content_default_http_proxy
Name: content_default_http_proxy
Description: Default HTTP Proxy for syncing content
Category: Content
Settings type: string
Value:

[root@sat ~]# hammer settings set --name=content_default_http_proxy --value=""
Setting [content_default_http_proxy] updated to [].

However, the server shows the below:

Jul 15 14:06:31 test.sat receptor: aiohttp.client_exceptions.ClientProxyConnectionError: Cannot connect to host xx.xxx.x.xxx:
3128 ssl:<ssl.SSLContext object at 0x7fcf29abd048> [Connect call failed ('xx.xx.x.xxx', 3128)]

Where 'xx.xx.x.xxx' is the http proxy.

We can see the proxy_url is still set:

[root@sat ~]# sudo u postgres psql pulpcore -c 'select url, proxy_url from core_remote'
could not change directory to "/root": Permission denied
url | proxy_url
-----------------------------------------------------------------------------------------+--------------------------
https://cdn.redhat.com/content/dist/rhel8/8.8/x86_64/baseos/kickstart |
https://cdn.redhat.com/content/dist/rhel8/8.10/x86_64/appstream/kickstart |
https://cdn.redhat.com/content/eus/rhel8/8.6/x86_64/appstream/os |
https://dl.fedoraproject.org/pub/epel/8/Modular/x86_64/ | http://xx.xx.x.xxx:3128
https://dl.fedoraproject.org/pub/epel/8/Everything/x86_64/ | http://xx.xx.x.xxx:3128
https://dl.fedoraproject.org/pub/epel/7/x86_64/ | http://xx.xx.x.xxx:3128
https://cdn.redhat.com/content/dist/rhel/server/7/7Server/x86_64/sat-capsule/6.11/os |
  
Pulp repo refresh does not make any changes.

1. foreman-rake katello:refresh_pulp_repo_details