Error connecting to MySQL from Visual Analytics

[HussainAkbar]

I just installed SAS with Visual Analytics 9.4 on a Linux X64 system.

After installation, I ran the Deployment Wizard as given in SAS Deployment Wizard User Guide and selected the "Configure SAS/ACCESS Interface to MySQL" task which ran successfully.

Now when I open VA and click on "Data Source" and select MySQL, I get the options window to enter userid, password, server, db name, etc. I do that and click the "Browse" button to view the table. I get this error:

ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysqlclient code appendage could not be loaded.

I even used the sas.servers restart command.

Using the proc setint noalias; command shows that I do have SAS/Access Interface to MySQL.

What am I missing?

[MichelleHomes]

In doing a quick google search, I was able to find a couple of SAS support notes that you might find helpful. If applying these suggestions you still get the error, I suggest contacting SAS Technical Support:

http://support.sas.com/kb/50/165.html

http://support.sas.com/kb/37/512.html

Kind Regards,

Michelle

[HussainAkbar]

Hi

Thanks for the reply.

As for http://support.sas.com/kb/50/165.html: 

I've already done the task for the Deployment Manager (twice, with no effect)

The SASMYL link is already there and pointing to the mylax510 file.

Re http://support.sas.com/kb/37/512.html:

This effects Windows installations. I am using Linux.

The full error I get is:

ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysqlclient code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
3          options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND;

Any other ideas that might help?

[MichelleHomes]

Next suggestion... contact SAS Technical Support. They may provide some steps to help troubleshoot the cause.

Please report back here how you go.

Kind Regards,

Michelle

[HussainAkbar]

Sent them a query.

Just occurred to me: How do I check whether SAS/Access is installed or not? I see that setinit shows I have a license for it, but is it actually installed?

[MichelleHomes]

See this usage note: Using the ViewRegistry Report and other methods to determine the SAS® 9.2 and later software release...

[HussainAkbar]

Hmm.. no. I see that installed can be checked by the existense of sasmyl in /sas/SASHome/SASFoundation/9.4/sasexe. So, I do have it installed. It just doesn't want to play nice.

[HussainAkbar]

By the way, I notice that the documents say that this step should ask me for a MySQL version. I don't see any such prompt.

[HussainAkbar · Accepted solution]

Got it to work.

Edited: $SASHOME/SASFoundation/9.4/bin/sasenv_local and added the line:

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/lib64/mysql

I can now connect and view tables.