topic Re: Error while connecting to Redshift using Libname statement in Administration and Deployment

Error while connecting to Redshift using Libname statement

karthic2612 — Mon, 13 Aug 2018 09:39:25 GMT

Hi Team,

Receiving error while running the libname statement to connect redshift through odbc engine.

libname redshift ODBC datasrc=MyRedshift user=cyrus_disc_adm password=CyrusAdm!n123;

Error

libname redshift ODBC datasrc=MyRedshift user=cyrus_disc_adm password=XXXXXXXXXXXXX;
ERROR: CLI error trying to establish connection: 523 586
ERROR: Error in the LIBNAME statement.

I have installed and configured the Redshift odbc drivers in SAS server.

[MyRedshift]
# Driver: The location where the ODBC driver is installed to.
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so
Description=Amazon Redshift ODBC Driver (64-bit) DSN
# Required: These values can also be specified in the connection string.
Host=cyrus-discovery-cluster-dev-rs01.cktinyynazra.us-east-1.redshift.amazonaws.com
Port=5439
Database=cyrusdiscoverydb
locale=en-US

Could you please let me know the solution to resolve at the earliest.

Thanks,

Vishal

Re: Error while connecting to Redshift using Libname statement

nhvdwalt — Mon, 13 Aug 2018 09:58:18 GMT

Hi @karthic2612

For security reasons it strongly discouraged to publish user names, passwords or server names online. This is a public forum so it is accessible by everyone on the internet.

I would advise you to immediately change your AWS password if the values in your post are real values.

Re: Error while connecting to Redshift using Libname statement

karthic2612 — Mon, 13 Aug 2018 10:10:30 GMT

Sure. Thanks for your advice.

Could you please help me in resolving this issue

Thanks,

Vishal

Re: Error while connecting to Redshift using Libname statement

nhvdwalt — Tue, 14 Aug 2018 06:33:06 GMT

Hi @karthic2612

Using a simple telnet command, could you try and ping that hostname + port. We need to establish if there is a network path to that host + port. You'll need to do this from the SAS server where your code is running.

Re: Error while connecting to Redshift using Libname statement

Swagat711 — Tue, 14 Aug 2018 07:19:51 GMT

On thr configuration tab, under Cluster properties , Copy the URL of cluster for databse details and paste it in odbc.ini

After that check the connection by isql command

isql -v Myredshift username password

Re: Error while connecting to Redshift using Libname statement

SimonDawson — Tue, 14 Aug 2018 10:29:09 GMT

ERROR: CLI error trying to establish connection: 523 586

Your error messages are not resolved to error messages. This typically mean your environment variables are misconfigured. If they are correctly setup the numbers will be actual strings describing whats wrong.

Re: Error while connecting to Redshift using Libname statement

nhvdwalt — Tue, 14 Aug 2018 10:47:53 GMT

@SimonDawson makes a very good point.

If you have not already done so, have a look at the Redshift configuration in this guide:

http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

Re: Error while connecting to Redshift using Libname statement

BillPerkins — Mon, 08 Jun 2020 15:44:05 GMT

A clue as to what environment variable is misconfigured would be helpful here.