Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Error connecting to MySQL from Visual Analytics

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Error connecting to MySQL from Visual Analytics

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?


Accepted Solutions
Solution
‎05-23-2016 09:44 AM
Occasional Contributor
Posts: 8

Re: Error connecting to MySQL from Visual Analytics

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.

View solution in original post


All Replies
Trusted Advisor
Posts: 1,292

Re: Error connecting to MySQL from Visual Analytics

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

Occasional Contributor
Posts: 8

Re: Error connecting to MySQL from Visual Analytics

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?

Trusted Advisor
Posts: 1,292

Re: Error connecting to MySQL from Visual Analytics

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

Occasional Contributor
Posts: 8

Re: Error connecting to MySQL from Visual Analytics

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?

Trusted Advisor
Posts: 1,292

Re: Error connecting to MySQL from Visual Analytics

Occasional Contributor
Posts: 8

Re: Error connecting to MySQL from Visual Analytics

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.

Occasional Contributor
Posts: 8

Re: Error connecting to MySQL from Visual Analytics

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.

Solution
‎05-23-2016 09:44 AM
Occasional Contributor
Posts: 8

Re: Error connecting to MySQL from Visual Analytics

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 744 views
  • 0 likes
  • 2 in conversation