rsyslog

■バージョン確認
rsyslogd -v

■reload
service rsyslog reload

■/etc/rsyslog.conf

tsql freetds

tsql -S <CONFNAME> -U <USERNAME> -P <PASSWORD>
tsql -H <IPADDRESS> -p <PORTNUMBER> -U <USERNAME> -P <PASSWORD>

インストール

]# unzip -d /tmp/SQL-TS/ unixODBC-2.2.14-12.el6_3.x86_64.zip
Archive:  unixODBC-2.2.14-12.el6_3.x86_64.zip
[unixODBC-2.2.14-12.el6_3.x86_64.zip] unixODBC-2.2.14-12.el6_3.x86_64.rpm password:
  inflating: /tmp/tsql/unixODBC-2.2.14-12.el6_3.x86_64.rpm
  inflating: /tmp/tsql/freetds-0.64-1.el6.rf.x86_64.rpm
  inflating: /tmp/tsql/libtool-ltdl-2.2.6-15.5.el6.x86_64.rpm


]# rpm -Uvh *.rpm
warning: freetds-0.64-1.el6.rf.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 6b8d79e6: NOKEY
warning: libtool-ltdl-2.2.6-15.5.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de     : NOKEY
Preparing...                ########################################### [100%]
   1:libtool-ltdl           ########################################### [ 33%]
   2:unixODBC               ########################################### [ 67%]
   3:freetds                ########################################### [100%]
]#

confファイル編集

nano  /etc/freetds.conf

[BRABRA]
   host =IPADDRESS
   port = 1433
   tds version = 8.0

 

接続

]# tsql -S BRABRA -U user -P pass
locale is "en_US.UTF-8"
locale charset is "UTF-8"
1> ^C