Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to connect when not utilizing freetds.conf for connection information #22

Open
fmikker opened this issue Mar 14, 2016 · 1 comment

Comments

@fmikker
Copy link

fmikker commented Mar 14, 2016

When trying to use the plugin without specifying the connection information in /etc/freetds.conf and using the flags "--hostname" and "--port" instead to remove the dependency on the configuration file, the plugin fails to connect to the database server.

Microsoft SQL Server 2012
CentOS release 6.7 (Final)
freetds-0.91-2.el6.x86_64
check_mssql_health (1.6.2.3)

The below error is displayed:
./check_mssql_health --hostname ref-sql-03.local --port 1433 --username "DEV\mon" --password "666-passWOR-D" -m database-online --name msdb CRITICAL - cannot connect to ref-sql-03.local. DBI connect(';host=ref-sql-03.local;port=1433','DEV\mon',...) 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. at /opt/plugins/check_mssql_health line 3273

The error message reports that the server name isn't found in configuration files, but that exactly what I want to avoid.

@rhagman
Copy link

rhagman commented Jun 7, 2016

This looks very similar to #10 a comment in that issue refers to a commit in FreeTDS that seems to fix the problem. I have not verified that it does though but looks like it might.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants