Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

"Can't connect to local MySQL server through socket '/tmp/mysql.sock'"

Data Services=3.1

Repository=12.2.2.0000

Red Hat Enterprise 5

Designer,Job Server,Job Engine=12.2.2.3

After an unscheduled server reboot with DS up and running when trying to start a job in either Data Services Management Console or DS Designer getting the following:

"Can't connect to local MySQL server through socket '/tmp/mysql.sock'"

The mysql.sock have never been in /tmp and on the production server it does not exist there and the production server is up and running correctly. If a link is created to mysql.sock(/home/user/boedge31/bobje/mysql) the job will start but return this message:

"Cannot retrieve <Version> from the repository. Additional database information: <SQL submitted to ODBC data source <localrepo> resulted in error <MySQL ODBC 3.51 Driver mysqld-5.0.46-enterprise No database selected>. The SQL submitted is <select VERSION, SECURITYKEY, GUID from AL_VERSION where NAME = 'Repository Version'"

I checked and AL_VERSION and the Version field exist.

Before the shut down DS was working correctly and had no issues. My best guess is a part of the repository was corrupted during the unscheduled shut down. It seems like DS has "forgotten" some of the settings.

Any suggestions on a possible solution?

Former Member
Not what you were looking for? View more on this topic or Ask a question