Download Server offline, Project should use alternative Download source as fallback

[janhoffmann]

@praveend

https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at you@your.address to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

IBM_HTTP_Server Server at public.dhe.ibm.com Port 443

[bimalkjha]

@janhoffmann Try to open https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/ in your browser or run ping public.dhe.ibm.com. If any fails, then your network or firewall setting is blocking access of this url. Please work with your IT team.
Alternatively, you can download it using https://170.225.126.18/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/linuxx64_odbc_cli.tar.gz or
https://github.com/ibmdb/db2drivers/raw/main/clidriver/linuxx64_odbc_cli.tar.gz url. It should work for you. Thanks.

[janhoffmann]

local isp:

$ ping public.dhe.ibm.com
PING public.dublindata.ibm.com (170.225.119.151) 56(84) bytes of data.
^C
--- public.dublindata.ibm.com ping statistics ---
72 packets transmitted, 0 received, 100% packet loss, time 72682ms

hetzner:

$ ping public.dhe.ibm.com                                                                                               
PING public.dublindata.ibm.com (170.225.119.151) 56(84) bytes of data.
^C
--- public.dublindata.ibm.com ping statistics ---
53 packets transmitted, 0 received, 100% packet loss, time 53246ms

another provider:

ping public.dhe.ibm.com
PING public.dublindata.ibm.com (170.225.119.151) 56(84) bytes of data.
^C
--- public.dublindata.ibm.com ping statistics ---
22 packets transmitted, 0 received, 100% packet loss, time 21501ms

@bimalkjha the error seems to be on your side.

another download source is no option, because its hardcoded into the gem. right now all my pipelines fail.

[bimalkjha]

@janhoffmann The link is live and we can access it. I can access it from my mobile too. There seems some network issue in your area that you are unable to ping the host. You can try after few hours to see if it is fixed.

C:\>ping public.dhe.ibm.com

Pinging public.southdata.ibm.com [170.225.126.18] with 32 bytes of data:
Reply from 170.225.126.18: bytes=32 time=256ms TTL=243
Reply from 170.225.126.18: bytes=32 time=254ms TTL=243
Reply from 170.225.126.18: bytes=32 time=257ms TTL=243
Reply from 170.225.126.18: bytes=32 time=255ms TTL=243

Ping statistics for 170.225.126.18:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 254ms, Maximum = 257ms, Average = 255ms

C:\>

Are you able to ping 170.225.126.18? we can see your ping is getting redirected to public.dublindata.ibm.com (170.225.119.151) while in my ping output, it is public.southdata.ibm.com [170.225.126.18]. Can you try opening https://170.225.126.18/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/ in your browser? It should work.

Another user from IBM complained today that their jenkins job is unable to download clidriver from public.dhe.ibm.com. Your pipeline is also unable to download. Others are able to download. So, looks some internet/dsn/network issue. The link is live and others can access it. Later, they changed the url in pipeline code to download from github url and it worked.

Another option is to update pipeline code to download clidriver from github, untar it, then set environment variable IBM_DB_HOME=, and then install ruby driver. If IBM_DB_HOME is set, driver uses the existing clidriver and do not download it from public.dhe.ibm.com.

I would suggest @praveen-db2 to update driver code to download clidriver from https://github.com/ibmdb/db2drivers/raw/main/clidriver/ as a fallback url if download from public.dhe.ibm.com fails. It is implemented in node, python and go ibm_db drivers.

Thanks.

[janhoffmann]

The server seems to be reachable from Germany again. I updated the ticket headline to reflect the direction our discussion has taken while investigating. I totally agree that the project should have a GitHub fallback to ensure the best possible user experience.

[janhoffmann]

@praveen-db2 @bimalkjha Systems not reachable again.

[praveen-db2]

@janhoffmann Please use alternative suggested by @bimalkjha, download clidriver manually from github. We will have it fixed in next month. As of now we are in middle of delivery, once its done we shall take this.