BookmarkSubscribeRSS Feed
Obsidian | Level 7

I've been trying to create a connection to a MySQL RDS on a SAS platform hosted on linux.  


Now let me first say I can connect to said MySQL on a windows SAS platform.  I simply create the ODBC connection in the OS and then create a library using the dsn.


On the linux platform I am getting the error:


ERROR: CLI error trying to establish connection: [unixODBC][MySQL][ODBC 5.2(w) Driver]Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2)
ERROR: Error in the LIBNAME statement.


Because this on a linux machine I havent set the dsn in the ODBC.ini file.  But have been in touch with the admin to try various configurations like using the IP or the full dns.


Also, the MySQL DB is available via other software in the linux environment.


Has anyone encountered this, and more to the point solved it?


Many thanks


Ammonite | Level 13
Hi @max00d

This issue looks more like on the MySQL part on linux machine.

can you check under MySQL Conf file on what is the exact path of the socket is mentioned?

is it - '/var/lib/mysql/mysql.sock' or '/var/lib/mysql/mysqld.sock'


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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2 in conversation