Report a inscrutable message

[free]

Report a inscrutable message

[free]

Could you please post the whole SQL Exporter log output? It looks like your configuration file isn't loaded as expected. It could be the name doesn't match (you say, "sql_exporter.yaml", the default is "sql_exporter.yml"), or that a different configuration file is loaded. Is your config file located in the directory where you launch SQL Exporter from?

[tangxuye]

I have tried it again,use the version 0.4,but the sql_exporter instance was still show me the error message:
7420 main.go:52] Starting SQL exporter (version=0.4, branch=master, revision=6dfbe982f1e42340e2a87e0d30599383c02f0bed) (go=go1.9.1, user=alin@wheat, date=20171128-15:26:05)
I0122 10:09:13.908697 7420 config.go:18] Loading configuration from sql_exporter.yml
I0122 10:09:13.909541 7420 config.go:131] Loaded collector "mssql_standard" from mssql_standard.collector.yml
I0122 10:09:13.909597 7420 main.go:67] Listening on :9399
I0122 10:09:21.044712 7420 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Unable to open tcp connection with host 'localhost:1433': dial tcp [::1]:1433: getsockopt: connection refused
I0122 10:09:36.042885 7420 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Unable to open tcp connection with host 'localhost:1433': dial tcp 127.0.0.1:1433: getsockopt: connection refused
I0122 10:09:51.046164 7420 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Unable to open tcp connection with host 'localhost:1433': dial tcp [::1]:1433: getsockopt: connection refused
I0122 10:09:51.964435 7420 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Unable to open tcp connection with host 'localhost:1433': dial tcp 127.0.0.1:1433: getsockopt: connection refused
I0122 10:10:06.043939 7420 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Unable to open tcp connection with host 'localhost:1433': dial tcp 127.0.0.1:1433: getsockopt: connection refused
I0122 10:10:21.043266 7420 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Unable to open tcp connection with host 'localhost:1433': dial tcp [::1]:1433: getsockopt: connection refused

Here is my directory of sql_exporter on Linux Server:
total 13884
-rw-r--r-- 1 1000 1000 1071 Nov 20 2017 LICENSE
-rw-r--r-- 1 1000 1000 689 Jan 22 10:08 mssql_standard.collector.yml
-rw------- 1 root root 13324 Jan 22 10:34 nohup.out
-rw-r--r-- 1 1000 1000 7929 Nov 28 2017 README.md
-rwxr-xr-x 1 1000 1000 14180046 Nov 28 2017 sql_exporter
-rw-r--r-- 1 1000 1000 1215 Jan 22 10:06 sql_exporter.yml
[root@localhost sql_exporter_0.4]# pwd
/usr/tmp/sql_exporter_0.4

I used the command : "nohup ./sql_exporter &" to run the sql_exporter
The config of the sql_exporter.yml is:
global:
scrape_timeout_offset: 500ms
min_interval: 0s
max_connections: 3
max_idle_connections: 3

target:
data_source_name: 'sqlserver://nsreader:ns123!@#@192.168.0.100:1433'

collectors: [mssql_standard]

collector_files:

• "*.collector.yml"

Is there any problem with configuration?

[free]

Off the top of my head, that data_source_name looks broken, as there are 2 @ characters in it. You can't expect the driver to figure out which of them is part of the password and which is the separator between password and host name. It probably just chokes on it (trying to use the host name#@192.168.0.100) and falls back to localhost.

[tangxuye]

I guessed the reason is the same, if it is true, I will contact the DBA to change the database password. Let me try again.Thank you very much for your help and reminding

[barywhyte]

Were you able to solve this problem @tangxuye ? I am currently having the same issue but on windows and my password is pretty simple