i can't able to connect mssql server with metricbeat and fetch data into kibana.
i have configured mssql.yml file as
- module: mssql
metricsets:- "transaction_log"
- "performance"
hosts: ["sqlserver://user:password@192.168.1.212:1433"]
period: 10s
i am getting error when running "./metricbeat -e"
2019-07-02T12:19:36.716+0530 INFO module/wrapper.go:244 Error fetching data for metricset mysql.status: dial tcp 127.0.0.1:3306: connectex: No connection could be made because the target machine actively refused it.
logs:
2019-07-02T12:19:35.706+0530 INFO helper/privileges_windows.go:87 SeDebugPrivilege is enabled. SeDebugPrivilege=(Enabled)
2019-07-02T12:19:35.712+0530 INFO cfgfile/reload.go:172 Config reloader started
2019-07-02T12:19:35.715+0530 WARN [cfgwarn] transaction_log/transaction_log.go:58 BETA: The mssql transaction_log metricset is beta.
2019-07-02T12:19:35.753+0530 WARN [cfgwarn] performance/performance.go:52 BETA: The mssql performance metricset is beta.
2019-07-02T12:19:35.780+0530 INFO cfgfile/reload.go:227 Loading of config files completed.
2019-07-02T12:19:36.716+0530 INFO module/wrapper.go:244 Error fetching data for metricset mysql.status: dial tcp 127.0.0.1:3306: connectex: No connection could be made because the target machine actively refused it.
2019-07-02T12:19:38.576+0530 INFO add_cloud_metadata/add_cloud_metadata.go:347 add_cloud_metadata: hosting provider type not detected.
2019-07-02T12:19:39.578+0530 INFO pipeline/output.go:95 Connecting to backoff(elasticsearch(http://localhost:9200))
2019-07-02T12:19:39.581+0530 INFO elasticsearch/client.go:735 Attempting to connect to Elasticsearch version 7.2.0
2019-07-02T12:19:39.622+0530 INFO [index-management] idxmgmt/std.go:252 Auto ILM enable success.
2019-07-02T12:19:39.624+0530 INFO [index-management.ilm] ilm/std.go:134 do not generate ilm policy: exists=true, overwrite=false
2019-07-02T12:19:39.625+0530 INFO [index-management] idxmgmt/std.go:265 ILM policy successfully loaded.
2019-07-02T12:19:39.628+0530 INFO [index-management] idxmgmt/std.go:394 Set setup.template.name to '{metricbeat-7.2.0 {now/d}-000001}' as ILM is enabled.
2019-07-02T12:19:39.629+0530 INFO [index-management] idxmgmt/std.go:399 Set setup.template.pattern to 'metricbeat-7.2.0-*' as ILM is enabled.
2019-07-02T12:19:39.630+0530 INFO [index-management] idxmgmt/std.go:433 Set settings.index.lifecycle.rollover_alias in template to {metricbeat-7.2.0 {now/d}-000001} as ILM is enabled.
2019-07-02T12:19:39.631+0530 INFO [index-management] idxmgmt/std.go:437 Set settings.index.lifecycle.name in template to {metricbeat-7.2.0 {"policy":{"phases":{"hot":{"actions":{"rollover":{"max_age":"30d","max_size":"50gb"}}}}}}} as ILM is enabled.
2019-07-02T12:19:39.639+0530 INFO template/load.go:88 Template metricbeat-7.2.0 already exists and will not be overwritten.
2019-07-02T12:19:39.640+0530 INFO [index-management] idxmgmt/std.go:289 Loaded index template.
2019-07-02T12:19:39.641+0530 INFO [index-management] idxmgmt/std.go:300 Write alias successfully generated.
2019-07-02T12:19:39.642+0530 INFO pipeline/output.go:105 Connection to backoff(elasticsearch(http://localhost:9200)) established
2019-07-02T12:19:47.720+0530 INFO module/wrapper.go:244 Error fetching data for metricset mysql.status: dial tcp 127.0.0.1:3306: connectex: No connection could be made because the target machine actively refused it.