BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
karthic2612
Obsidian | Level 7

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
SimonDawson
SAS Employee
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.

View solution in original post

7 REPLIES 7
nhvdwalt
Barite | Level 11

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.

karthic2612
Obsidian | Level 7

Sure. Thanks for your advice.

 

Could you please help me in resolving this issue

 

Thanks,

Vishal

nhvdwalt
Barite | Level 11

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.

Swagat711
Fluorite | Level 6
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
SimonDawson
SAS Employee
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.
nhvdwalt
Barite | Level 11

@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

 

BillPerkins
Fluorite | Level 6
A clue as to what environment variable is misconfigured would be helpful here.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 3146 views
  • 0 likes
  • 5 in conversation