If I can get isql to work correctly, I should be in business, as Zabbix basically sits right on top of ODBC for its database monitoring functions. I spent several hours searching and trying various things but to no avail. This all implies that the problem has to do with the ODBC configuration in the Ubuntu VM. telnet to 192.168.240.1 (the network IP of the local machine) on port 5432 succeeds.port 5432 has been completely opened from Windows Firewall on the local machine.I can successfully connect to Postgres from the admin running on the local (non VM) machine.Is the server running locally and acceptingĬonnections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? I get the following error: could not connect to server: No such file or directory Yet when I test the connection via: isql test -v Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so installed unixODBC driver for Postgres via sudo apt-get install odbc-postgresqlÄriver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbca.so.installed unixODBC via sudo apt-get install unixodbc unixodbc-dev. Zabbix makes use of ODBC, so a preliminary step in the process is to get the ODBC connection to Postgres working correctly. To be clear, I am trying to connect from a Linux Ubuntu virtual machine on my computer to Postgres also running not in a VM on the same computer. I am attempting to use a Zabbix server running on an Ubuntu virtual machine to monitor the Postgres database in our application running on the same host machine (not a VM).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |