I want to create a ADO SQL Sensor using the psqlODBC driver (PostgressQL). My connectionstring looks as follows (changed sensitive info):

Driver={PostgreSQL ANSI};Password=aBcD*+.&B;Server=10.10.1.10;Port=5432;Database=test;Uid=test_user;

It looks ok but the user can not authenticate. I have tested with other SQL tools on same machine with no issues. I believe it is caused but the special characters in the password. I have tried & to escape but no result. I have tried single and double quotes around the password but that doesn't work.

Any ideas how to solve this issue?

Article Comments

Hello,

if you save the connection string in the Settings of the sensor, and then view it again, is it still complete?

best regards.


Apr, 2012 - Permalink

Update: I discovered that a certain moment it was working with & as escape code but it seems that PRTG is adding extra SQL queries. My query was SELECT COUNT(*) FROM Database but PRTG also send the query select * from database. Because database is large and remote located it can take many minutes to complete this query, at least more than the 60 seconds sensor update rate. Effectively there wil contninues traffic to the database and never a response for the sensor.

So now I moved tp a custom sensor written in .net That is working.


Apr, 2012 - Permalink

WWT de Beer,

Would you mind sharing the custom sensor you created? I have a large postgres install base that I need to monitor.

Thanks.


Nov, 2012 - Permalink