MSSQL encryption issue

[transmax]

Hi,

I have an MSSQL database that requires encryption. When using a default install of NagioXI and the check_mssql script I get rejected by the database immediately, probably as expected. The windows application log shows the following error:

Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library. [CLIENT: 10.250.5.170]

Is there anything I can do on the NagiosXI server (the CLIENT) that can get this working?

One obvious workaround is to set the database to NOT require encryption, but that's less than ideal.

Cheers,

Lee Benson
Transmax

[abrist]

What encryption mechanism does the database server use? SSL, ipsec, certs, something else?

[transmax]

If I had to guess, it would be SSL.

It is whatever Microsoft have determined it to be when you select "Force Encryption" in the MSSQL server manager.

Google would seem to indicate that PHP is incapable of making this type of connection from a linux server to a Windows MSSQL server.

This would leave me with using NRPE to do the query on the MSSQL server side as the only solution. Ugly and not very 'portable', I have about 10 MSSQL servers to do this check on.

Regards,

Lee Benson
Transmax

[abrist]

That would appear to be the case unfortunately.

[mcapra]

Split to: https://support.nagios.com/forum/viewto ... 16&t=41066