You cannot see this page without javascript.

ODBC 설정

Linux 조회 수 1582 추천 수 0 2015.03.18 00:06:26

Setup guide is using the same hardware and CentOS install we used in our prior how to on Zenoss. I use the Zenoss database on the localhost but this can easly be changed for setting up a ODBC connection on a remote host machines useing any database.

This entire install process is done as root, so login to your server and lets get started.
Install myODBC and unixODBC as a dependency.
yum install mysql-connector-odbc

Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
mysql-connector-odbc i386 3.51.12-2.2 base 142 k
Installing for dependencies:
unixODBC i386 2.2.11-7.1 base 832 k

Transaction Summary
=============================================================================
Install 2 Package(s)
Update 0 Package(s)
Remove 0 Package(s)

Total download size: 973 k
Is this ok [y/N]:
y

Print your config infomation.
odbcinst -j
unixODBC 2.2.11
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
USER DATA SOURCES..: /root/.odbc.ini


Edit /etc/odbc.inst and /etc/odbcinst.ini
Below are my examples.
vi /etc/odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc.so
Setup = /usr/lib/libodbcmyS.so
UsageCount = 2

[MySQL ODBC 3.51 Driver]
Description = ODBC 3.51 for MySQL
DRIVER = /usr/lib/libmyodbc3.so
SETUP = /usr/lib/libmyodbc3S.so
UsageCount = 2


vi /etc/odbc.inst
[zenoss]
Driver = /usr/lib/libmyodbc3.so
SERVER = localhost
PORT = 3306
DATABASE = events
OPTION = 3
USER = root
PASSWORD = BlAh

Note: The PASSWORD: is the one we setup during our Zenoss installation and is REQUIRED because Splunk uses it to authenticate to the database.

Once you create your files and save them here is how you do the install.
Install driver
odbcinst -i -d -f /etc/odbcinst.ini

Install system DSN
odbcinst -i -s -l -f /etc/odbc.ini

Test your DSN install by lisinting your installed data sources.
odbcinst -s -q
[zenoss]

Test that you can connect to the database via the ODBC.
isql -v zenoss root BlAh
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> quit

You are done. Here are some quick and dirty ways to fix some problem I had during the install.
I did not have libtool installed properly.
Install libtool
yum install libtool
edit lb.so.conf

Before the include I added
/opt/splunk/lib <---- I later commented this out.
/user/lib

Load the new ld.so.conf
ldconfig (you will not recive any confermation)

I also had a problem acidently loading user DSN so you can remove the user odbc.ini file or copy the one from /etc to the profile.
rm /home/name/.odbc.ini

How to remove a driver.
odbcinst -u -d -n zenoss
zenoss has been deleted (if it existed at all) because its usage count became zero.

How to remove a datasource.
odbcinst -u -s -l -n zenoss
odbcinst: DSN removed (if it existed at all). ODBC_BOTH_DSN was used as the search path.

Remeber if you change a odbc peramerter you need to install it again.
odbcinst -i -s -l -f /etc/odbc.ini

My next article will be how to setup Splunk to use the Zenoss myODBC connection as a datasource.

List of Articles
번호 제목 글쓴이 날짜 조회 수sort
349 CentOS7 ▒ Doly의 센트OS(CentOS) 7 강좌11 4. 원격접속 - 1.VNC file [11] LynX 2014-10-23 2356
348 Programing OCX --> CAB 작성 file LynX 2014-06-13 2352
347 Linux USB부팅 리눅스의 변경 사항 초기화 [16] LynX 2015-01-07 2340
346 Linux sendmail, dovecot 설치 및 설정 [20] LynX 2014-08-01 2302
345 Programing HTML5 부라우저별 Video코덱 및 포멧변경 [29] LynX 2013-07-20 2301
344 Server Josso file LynX 2013-12-19 2225
343 Windows 7 윈도우7(Windows7) 공유폴더에 암호걸기 file [7] LynX 2013-07-25 1973
342 Programing 웹사이트 APK 만들기 file [1] [17] LynX 2015-07-02 1961
341 Programing meadco print LynX 2013-12-12 1850
340 Linux FreeBSD APM Source Compile LynX 2016-05-20 1743
339 HTML Tag css, cascading style sheets, 스타일 정의 방법 [9] LynX 2015-02-06 1703
338 Server 아파치 - 톰캣 연동하기 (PHP, JSP 같이 사용하기) LynX 2014-05-19 1671
337 Programing make - 07 접미사 규칙 LynX 2017-02-22 1638
» Linux ODBC 설정 [30] LynX 2015-03-18 1582
335 Network GNS3 메뉴 , VPCS file [34] LynX 2015-04-29 1542
334 CentOS bash auto-com file LynX 2016-05-19 1526
333 Server Windows에서 Apache 2.x, Tomcat 7.x 연동 후 가상호스트를 이용하여 서비스하기 LynX 2014-06-10 1523
332 CentOS7 ▒ Doly의 CentOS7 강좌6 2.CenOS 7 설치-4 file LynX 2014-10-23 1491
331 Linux LFS/Building - 빌드하기 [11] LynX 2014-08-06 1430
330 CentOS7 ▒ Doly의 CentOS7 강좌16 6. CentOS 네트워크 1 - 개념, 2 - 이더넷 설정 file [1] LynX 2014-10-23 1381

XE Login