SQL Exporter is Not Starting After Installation on Windows Server

[JabirBaig9395]

Hi Team,

I have installed SQL Exporter(sql_exporter-0.16.0.windows-amd64) on windows server 2019, i have installed it using NSSM as a service using the following steps, i am getting the following error while starting the service, can some one look into this.

`C:\Windows\System32>cd C:\nssm-2.24\nssm-2.24\win64
C:\nssm-2.24\nssm-2.24\win64>dir
Directory of C:\nssm-2.24\nssm-2.24\win64

13/12/2024 08:47

.
24/09/2024 07:34 ..
13/12/2024 08:47 0 cd
24/09/2024 07:33 331,264 nssm.exe
2 File(s) 331,264 bytes
2 Dir(s) 29,061,558,272 bytes free

C:\nssm-2.24\nssm-2.24\win64>nssm.exe install sql_exporter C:\sql_exporter-0.16.0.windows-amd64\sql_exporter.exe
Service "sql_exporter" installed successfully!
when i am trying to start the service i am getting the following error msgC:\nssm-2.24\nssm-2.24\win64>sc start sql_exporter

SERVICE_NAME: sql_exporter
TYPE : 10 WIN32_OWN_PROCESS
STATE : 2 START_PENDING
(NOT_STOPPABLE, NOT_PAUSABLE, IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x7d0
PID : 5188
FLAGS :`

[burningalchemist]

Hi @JabirBaig9395,

With NSSM you might have some log files around with the errors from sql_exporter. Could you please share them?

It's likely that you haven't configured the sql_exporter properly.

Do you have sql_exporter.yml config file in place?

I would suggest first to configure and run sql_exporter without NSSM, as I can't really support you there. Once it works well, you can wrap it with NSSM.

I'll convert this issue into a discussion as it's not a bug.

[JabirBaig9395]

i have the following configuration in my sql_exporter.yml, please correct me if i am doing anything wrong

`# The target to monitor and the collectors to execute on it.
target:
  # Data source name always has a URI schema that matches the driver name. In some cases (e.g. MySQL)
  # the schema gets dropped or replaced to match the driver expected DSN format.
    data_source_name: 'sqlserver://pmmadmin:[email protected]:1433'

  # Collectors (referenced by name) to execute on the target.
  # Glob patterns are supported (see <https://pkg.go.dev/path/filepath#Match> for syntax).
  collectors: [mssql_*]

# Collector files specifies a list of globs. One collector definition is read from each matching file.
# Glob patterns are supported (see <https://pkg.go.dev/path/filepath#Match> for syntax).
collector_files: 
  - "*.collector.yml"
`

[JabirBaig9395]

i am getting the following error while trying to configure SQL exporter without using NSSM, can you take a look

`C:\Windows\system32>cd C:\sql_exporter-0.16.0.windows-amd64

C:\sql_exporter-0.16.0.windows-amd64>dir
Directory of C:\sql_exporter-0.16.0.windows-amd64

12/12/2024  06:49    <DIR>          .
12/12/2024  06:49             1,104 LICENSE
12/12/2024  06:49             6,495 mssql_standard.collector.yml
12/12/2024  06:49            17,095 README.md
12/12/2024  06:49        52,191,232 sql_exporter.exe
13/12/2024  08:38             1,769 sql_exporter.yml
               5 File(s)     52,217,695 bytes
               1 Dir(s)  28,958,789,632 bytes free

C:\sql_exporter-0.16.0.windows-amd64>sc.exe create SqlExporterSvc binPath= "C:\sql_exporter-0.16.0.windows-amd64\sql_exporter.exe --config.file=C:\sql_exporter-0.16.0.windows-amd64\sql_exporter.yml" start= auto
[SC] CreateService SUCCESS

C:\sql_exporter-0.16.0.windows-amd64>sc query SqlExporterSvc

SERVICE_NAME: SqlExporterSvc
        TYPE               : 10  WIN32_OWN_PROCESS
        STATE              : 1  STOPPED
        WIN32_EXIT_CODE    : 1077  (0x435)
        SERVICE_EXIT_CODE  : 0  (0x0)
        CHECKPOINT         : 0x0
        WAIT_HINT          : 0x0

C:\sql_exporter-0.16.0.windows-amd64>
`

[burningalchemist]

Hey @JabirBaig9395, as I suggested above, please run sql_exporter as a standalone app, not the service. We need to logs from the app, not Windows.

[burningalchemist]

It doesn't have an installer, the sql_exporter itself is a standalone app, so you can run it from the command line (cmd or powershell) with the config file as a parameter. So it should provide you the reason of errors. 👍

[burningalchemist]

I received an email notification with your latest reply, but I can't find it here anymore. The error you're experiencing is related to the bad configuration in sql_exporter.yml. It might be a bad whitespace/indentation, or you could have removed some fields. Please refer to the reference configuration file which is essential: https://github.com/burningalchemist/sql_exporter/blob/master/examples/sql_exporter.yml

[JabirBaig9395]

Hi,
i successfully installed sql exporter, as guided first i installed as app and then as service.

[JabirBaig9395]

i see only few metrics in sql exporter, can you tell me from where i can gather more metrics.

[burningalchemist]

Hey @JabirBaig9395, feel free to explore these examples - https://github.com/burningalchemist/sql_exporter/tree/master/examples.

Besides that, you'd need to define your own metrics based on your requirements.