Code: Select all
http://wikis.openlinksw.com/UdaWikiWeb/TDSVersionsExplained
Code: Select all
http://wikis.openlinksw.com/UdaWikiWeb/TDSVersionsExplained
Code: Select all
dump file = /tmp/freetds.log
Code: Select all
Force Encryption Off
Code: Select all
[myserver]
host = db.firstworks.com
port = 1433
tds version = 7.0
encryption = require
Code: Select all
# TDS protocol version
tds version = 7.0
# Whether to write a TDSDUMP file for diagnostic purposes
# (setting this to /tmp is insecure on a multi-user system)
; dump file = /tmp/freetds.log
; debug flags = 0xffff
# Command and connection timeouts
; timeout = 10
; connect timeout = 10
# If you get out-of-memory errors, it may mean that your client
# is trying to allocate a huge buffer for a TEXT field.
# Try setting 'text size' to a more reasonable limit
text size = 64512
# A typical Sybase server
[egServer50]
host = symachine.domain.com
port = 5000
tds version = 5.0
# A typical Microsoft server
[egServer70]
host = ntmachine.domain.com
port = 1433
tds version = 7.0
# Change to your MSSQL server settings below:
[myserver]
host = db.firstworks.com
port = 1433
tds version = 7.0
encryption = require
Code: Select all
http://software.firstworks.com/2017/04/tlsssl-encryption-with-ms-sql-server.html
Code: Select all
[host.domain.com]
host = host.domain.com
port = 1433
tds version = 7.1
encryption = require
Code: Select all
[root@nagios libexec]# /usr/local/nagios/libexec/check_mssql.php --hostname host.domain.com --username username --password password --port 1443 --database database --query "EXEC some_sp @val1=2815, @val2=76;"
PHP Notice: Undefined variable: db_connstr in /usr/local/nagios/libexec/check_mssql.php on line 416
CRITICAL: Could not connect to as username (Exception: SQLSTATE[01002] Adaptive Server connection failed (host.domain.com) (severity 9)).
Code: Select all
[root@nagios libexec]# /usr/local/nagios/libexec/check_mssql.php --hostname host.domain.com --username username --password password --port 1443 --database database --query "EXEC some_sp @val1=2815, @val2=76;"
OK: Query duration=0.026843 seconds. Query result=2815 Query result=09 Query result=4.220000 Query result=45.500 Query result=3.978000 Query result=0.000000 Query result=4.220000 Query result=3.978000 Query result=89 Query result=1 Query result=1 Query result=1 Query result=1|query_duration=0.026843s;; 'someValue'=1;