KNOWLEDGE BASE

Can't Open Lib '/opt/tableau/tableau_Driver/postgresql-Odbc/psqlodbcw.so' : File Not Found Upon Accessing Tableau Server Repository


Published: 11 Sep 2019
Last Modified Date: 21 Apr 2020

Issue

After installing the Postgres driver and accessing the Postgres database used for Tableau Server repository on Linux, the error occurs:
User-added image

The ldd command to print shared libraries/dependencies will likely present an error

Command: 
ldd <path/to/driver>

Command to determine the <path/to/driver> of the postgresql driver:
cat /etc/odbcinst.ini
Example output:
[ODBC Drivers]
PostgreSQL Unicode=Installed

[PostgreSQL Unicode]
Description=ODBC for PostgreSQL
Driver=/opt/tableau/tableau_driver/postgresql-odbc/psqlodbcw.so
FileUsage=1


Among output, some missing expected libraries:
libssl.so.example => not found
libcrypto.so.example => not found

Environment

  • Tableau Server
  • RHEL
  • Centos
  • PostgreSQL

Resolution

Check for the package with the missing shared libraries and install with the following command:

The below command will query to find a package: 
sudo yum whatprovides */libcrypto.so.example

Install the package: 
sudo yum install -y compat-opensslexample-1:1.0.2o-3.el8.x86_64
 

Cause

Either environmental changes or problems with the driver package can result in missing dependencies.
Did this article resolve the issue?