search

free / sql_exporter

Database agnostic SQL exporter for Prometheus
MIT License
539 stars 172 forks source link

why not support sqlserver2005 conncect? #77

Open guochaoqun8 opened 4 years ago

guochaoqun8 commented 4 years ago

data_source_name: 'sqlserver://sa:a123456!@192.168.191.80:1433' running info

[root@DB3 sql_exporter]# ./sql_exporter I0821 18:00:24.978808 127262 main.go:52] Starting SQL exporter (version=0.5, branch=master, revision=fc5ed07ee38c5b90bab285392c43edfe32d271c5) (go=go1.11.3, user=root@f24ba5099571, date=20190114-09:24:06) I0821 18:00:24.979826 127262 config.go:18] Loading configuration from sql_exporter.yml I0821 18:00:24.980410 127262 config.go:131] Loaded collector "dir_mssql_collector" from dir_mssql.collector.yml I0821 18:00:24.980508 127262 main.go:67] Listening on :9399 I0821 18:00:37.546241 127262 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Login error: EOF I0821 18:00:52.551666 127262 promhttp.go:38] Error gathering metrics: [from Gatherer #1] Login error: EOF

burningalchemist commented 4 years ago

@guochaoqun8 Your problem is unrelated to sql_exporter, but the underlying MSSQL driver or your connection string. Please, take a look at the issue here and other issues in the respective driver repository. Alternatively, try to connect to your database with usql first, it should help finding the problem. 🙂