SYMPTOM:
In Strategy Intelligence Server Universal 9.4.x installed on Red Hat Enterprise Linux, when configuring access to a metadata hosted by a MySQL instance using Strategy Configuration Wizard, after entering with the database login, the message below is displayed:
Can’t connect to local MySQL server through socket /tmp/mysql.sock
NOTE:In this case, MySQL is installed on the Strategy Intelligence Server machine.
CAUSE:Since the MySQL instance is installed on the same machine as the Strategy Intelligence Server, Strategy Intelligence Server uses the socket connector instead of the TCP/IP connector to access the database. As the socket file is configured to be written in a directory that MySQL server doesn't have permissions to write, this error occurs.
ACTION:Contact the systems administrator to provide the required permissions.
Third Party Software Installation Warning:The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. Limitation of Liability: Strategy shall have no liability to licensee for any damages of any kind, including, but not limited to, liability for direct, indirect, special, incidental or consequential, damages (which shall include, but not be limited to, loss of data or information, loss of revenue or anticipated profits or lost business). 211246
