Question

UNKNOWN: Timeout for centreon_mssql.pl

  • 23 February 2023
  • 4 replies
  • 157 views

Badge +1

Hi,

The services for the mssql plugin are unknown.

I've done some research but I can't find the solution

 

mssql plugin is not working :

Connexion user sql ok :

I have a timeout for all services :

/usr/lib/centreon/plugins//centreon_mssql.pl --plugin database::mssql::plugin --hostname 192.168.50.10 --port 1433 --username '***' --password '****'   --mode='connected-users' --warning-connected-user='' --critical-connected-user='' --verbose
UNKNOWN: Timeout

 

I have centreon 22.10 on almalinux 8, my host configution is :

Are you a solution for me please?

 

Thanks


4 replies

Userlevel 4
Badge +13

👋 @Gerome25 

 

Have you tried running the command directly in the terminal?

 

time /usr/lib/centreon/plugins//centreon_mssql.pl --plugin database::mssql::plugin --hostname 192.168.50.10 --port 1433 --username '***' --password '****'   --mode='connected-users' --warning-connected-user='' --critical-connected-user='' --verbose

 

Badge +1

Hi

@ponchoh 

yes, the result is : UNKNOWN: Timeout

Userlevel 4
Badge +13

https://docs.centreon.com/pp/integrations/plugin-packs/procedures/applications-databases-mssql/#freetds-configuration  🤔

Badge +2

Hi,

Verify port 1433 is open in jour SQL serveur and is use by sql base ?

telnet SQLserverIP 1433

 

You can try for username=’domaine\username’

 

Reply