Error connecting to Replicate server 'local_repsrv'

[kogasawara]

I Installed data movement on linux that Redhat8 of AWS EC2.

I’m trying connect to Oracle database with data integration. but when push test connect button then get about proxy error.

Checking the data movement log file,there is about proxy error following

[ERROR] Error connecting to Replicate server 'local_repsrv'
System.Net.WebException: The proxy tunnel request to proxy 'My proxy adress' failed with status code '307'."

Do you have any good solutions in regards to that?

best regard.

[CF_Debarati]

Hi @kogasawara ,

Please attach the task logs and diagnostic package.

[CF_Debarati]

Hi @kogasawara ,

Please also let us know where your Oracle source is located. Do you have any proxy configuration?

[kogasawara]

Hi Debarati
Thank you for your reply.

I instralled Oracle in Onpremis Windwos Server.
・Data Movement （Redhat8 AWS EC2）
・Oracle 19.3 （Windows Server 2016）

also I attached data movement log file.

best regard.

[CF_Debarati]

Hi @kogasawara ,

Seems you have done proxy configuration for the tenant_url.

1. Please check the Proxy_URL you have set for the tenant. You can check that from the gateway bin folder:

./agentctl qcs show_config

In the proxy_url, we also need to specify the port number. Please check if the proxy_url is accessible from the gateway server.

Command to set proxy_url is:  ./agentctl qcs set_config  --proxy_url "http://<url>:<port>"

2. Restart repagent service.

3.Check if the gateway is now shown as Connected from Management Console ->Data gateways.

Best regards.

[kogasawara]

Hi Debarati
Thank you for your reply.
i checked my proxy setting. However proxy is already set like attached image file.

Also data movement status is "connected" in Qlik Management Console.

any good solutions?

best regards.

[CF_Debarati]

Hi @kogasawara ,

Thank you for the helpful information. While investigation is on, please let us know:

1. Without proxy_url set, are you able to access the Oracle database?

[kogasawara]

Hi Debarati
Thank you for your replay.
I tried without proxy but i got same error.
i installed data movement on premise Linux then connecting to Oracle database is success.

In my case summary
AWS EC-2 Linux with data movement can not connect to oracle database.
on premise Linux with data movement can connect.

I set Both enviroment same setting.
Different setting is network,AWS is using VPC.

But Windows Server that using same VPC can connect to oracle database with data gateway direct access.

best regard.

[CF_Debarati · Accepted solution]

Hi @kogasawara ,

It has been observed that when proxy is enabled only in repagent configuration, it works fine as it sends requests to localhost directly without proxy. But when proxy is also defined at OS level, all requests are sent through the proxy and we get the proxy error.

Please try if the following solution helps and let us know:

1. Please check if you have proxy configuration enabled at OS level on the gateway server:
           a. check PID for agentctl using: ps -ef|grep agentctl   
           b. check variables: cat /proc/<PID>/environ

2. If answer is 'Yes' to step 1, please disable the proxy configuration to localhost:
          a. add the variable: export no_proxy=localhost   to /etc/profile.d/http_proxy.sh

3.Restart the repagent.

[kogasawara]

Hi Debarati Thank you for your replay. I changed proxy setting with /etc/profile.d/http_proxy.sh.
However problem is not resolved.

I tried to change passward repsrv and repagent password like /agentctl agent set_config -p Administrator123.

Finally problem is resolved!!

thank you so much for your help!!!

Best regard!