It works, thanks!nscott wrote:Code: Select all
Configure /etc/freetds.conf and try it with –server. Also try tsql.
Search found 9 matches
- Fri Jan 06, 2012 3:12 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
- Wed Jan 04, 2012 1:50 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
Code: Select all
# yum list installed | grep DBD
perl-DBD-MySQL.x86_64 3.0007-2.el5 installed
perl-DBD-ODBC.x86_64 1.23-1.el5.rf installed
perl-DBD-Sybase.x86_64 1.10-1.el5.rf installed
- Tue Jan 03, 2012 4:13 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
What distro of Linux and version are you running? x64 # cat /proc/version Linux version 2.6.18-274.12.1.el5 (mockbuild@builder10.centos.org) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-51)) #1 SMP Tue Nov 29 13:37:46 EST 2011 # cat /etc/redhat-release CentOS release 5.7 (Final) How did you go about ...
- Mon Jan 02, 2012 2:54 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
I can connect with tsql, but I can't with check_mssql_health # tsql -H 192.168.0.252 -p 1854 -U <user> -P <pass> locale is "hu_HU.UTF-8" locale charset is "UTF-8" 1> select name from master.dbo.sysdatabases; 2> go name master tempdb model msdb ESETRADB (5 rows affected) #./check_...
- Wed Dec 07, 2011 1:57 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
MS-SQL server
- Tue Dec 06, 2011 1:48 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
I've restored to working copy again:
Code: Select all
# yum list installed | grep mssql
php-mssql.x86_64 5.1.6-15.el5.centos.1 installed
- Mon Dec 05, 2011 7:25 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
I've used yum update. Nothing change, again error. :( # rpm -qa | grep mysql mysql-devel-5.0.77-4.el5_6.6 mysql-connector-odbc-3.51.26r1127-1.el5 mysql-5.0.77-4.el5_6.6 mysql-server-5.0.77-4.el5_6.6 php-mysql-5.1.6-27.el5_5.3 libdbi-dbd-mysql-0.8.1a-1.2.2 # cat /var/log/mysqld.log | tail 111205 13:1...
- Thu Dec 01, 2011 2:20 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Re: Upgrade linux & can't connect MS-SQL anymore
Currently (i've restored from a working backup): # rpm -qa | grep mysql mysql-devel-5.0.77-4.el5_6.6 mysql-connector-odbc-3.51.26r1127-1.el5 mysql-5.0.77-4.el5_6.6 mysql-server-5.0.77-4.el5_6.6 php-mysql-5.1.6-27.el5_5.3 libdbi-dbd-mysql-0.8.1a-1.2.2 # cat /var/log/mysqld.log | tail 111130 12:42:10 ...
- Wed Nov 30, 2011 5:49 am
- Forum: Nagios XI
- Topic: Upgrade linux & can't connect MS-SQL anymore
- Replies: 16
- Views: 3914
Upgrade linux & can't connect MS-SQL anymore
Hi! I've upgrade the Nagios server's virtual machine with "yum upgrade". After restart I've got the following errors (because we have lot of MS-SQL servers): CRITICAL - cannot connect to 192.168.0.252. DBI connect(':host=192.168.0.252:port=1854','nagioscheck',...) failed: OpenClient messag...