Solarwinds Orion - PostgreSQL Error - Unexpected error occurred. pypyodbc.OdbcNoLibrary: 'ODBC Library is not found. Is LD_LIBRARY_PATH set?'

Hi All,

I am having difficulty setting up PostgreSQL monitoring using SAM for Node polled using an agent.

I am not having any issues on setting up PostgreSQL if the polling method is agentless, but once we use the agent, the subject error appears on all odbc monitors.

These are the software installed using agent:

This is the error once we use agent for polling the components:

I have also set up the odbc driver in the Data Source Administrator on the Orion server and it connected successfully.

I think this is a python type error but what else am I missing?

Find more posts tagged with

PostgreSQL

Python

odbc_user_experience

odbc driver

Accepted answers

All comments

chad.every

So if the SAM Template is set to 'Agentless' then Orion will use the ODBC settings on the Orion server. If the template is set to 'agent' then the component monitor is executed on the remote node. You would have to setup the ODBC there for it to work. This is why it is returning 'ODBC library is not found.