Comments (4)
A possibly relevant clue from rails-sqlserver/activerecord-sqlserver-adapter#168 (comment):
You are using dataserver and host, one trumps the other.
from check_mssql_health.
I have similarly found that the script can't connect to a MS SQL server using IP and port. However I don't receive that error, in fact there is nothing more helpful than "(no error string)", even enabling full DBI trace adds little. I tried many variations of the connection string to no avail. I thought it might be that the TDS version is incorrect or a bug in one of the libraries.
The only way it works for me is using server name with matching entries in freetds.conf, which is kind of annoying as more servers are involved.
from check_mssql_health.
I can confirm the problem
Tested with
DBD::Sybase: 1.15
freetds: 0.95.67
It looks like the work on DBD::Sybase has stopped.
use DBI;
use strict;
my $username = "sa";
my $password = "password";
my $dsn = "DBI:Sybase:;host=myhost.com;port=61234";
if (my $dbh = DBI->connect(
$dsn, $username, $password,
{ RaiseError => 1, AutoCommit => 0, PrintError => 1 })) {
printf "connection succeeded\n";
} else {
printf "connection failed\n";
}
Error message:
DBI connect(';host=myhost.com;port=61234','sa',...) failed: OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (44)
Server , database
Message String: Server name not found in configuration files.
OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (45)
Server , database
Message String: Unknown host machine name.
from check_mssql_health.
Problem solved in freetds FreeTDS/freetds@49333d5
from check_mssql_health.
Related Issues (20)
- SQL Server Express 2014 check_mssql_health with on LibreNMS HOT 12
- sql-runtime does not work on v 2.6.4.10 HOT 1
- DBD:SYBASE Change to BBDD Mysql HOT 1
- failed-jobs undefined value as array on Microsoft SQL Server 2000 SP4 HOT 1
- Class MyDatabases is not a subclass of Monitoring::GLPlugin HOT 10
- Adaptive Server connection failed with V2.6.4.13 HOT 2
- need encoding...
- Not working in SQLServer 2016 HOT 1
- Fail at user creation HOT 1
- Blacklist is not working HOT 5
- configure does not exist
- Mode xxxxx is not implemented for this type of device
- connected_users should be connected_sessions
- Read query from file with SQL Mode HOT 1
- Database offline/deleted but Check status OK HOT 3
- Database not accepting connections - Because of "Auto Close"
- doesn't support Azure MSSQL
- The database-log-free mode does not show the correct free log space it has left
- No connect to MSSQL Server 2022 HOT 1
- Backup Status alerts on multiple Availability Groups when split over 2 or more hosts
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from check_mssql_health.