search

ikzelf / zbxdb

Zabbix database monitoring, the easy and extendable way
GNU General Public License v3.0
94 stars 45 forks source link

How to set db info with none default port in zbxdb config file ? #22

Closed zliangbj closed 5 years ago

zliangbj commented 5 years ago

[zbxdb] db_url = //localhost/fsdb01 username = postgres password = db_type = oracle db_driver = cx_Oracle instance_type = rdbms role = normal out_dir = $HOME/zbxora_out hostname = testhost checks_dir = etc/zbxdb_checks site_checks = sap,ebs password_enc = cjB0cjAwdA==

Is there a filed to set the port if the db not using defautl port? thanks!

zliangbj commented 5 years ago

I‘ve tried to set in cfg file like this: db_url = //localhost:1526/fsdb01 and it returns error:

INFO:main:connecting to dbsnmp/**@//localhost:1526/testdb WARNING:main:(4.1)connection error: [12514] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor for dbsnmp@//localhost:1526/testdb

ikzelf commented 5 years ago

What you did was correct, regarding the setting of the port. You could use lsnrctl status or lsnrctl services to see which services are known by the listener.

ikzelf commented 5 years ago

did you get this working? Do you have any tips to improve this?

zliangbj commented 5 years ago

Yes , it works. I made a spelling mistakes. Thanks!