<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://www.zabbix-es.com.es/index.php?action=history&amp;feed=atom&amp;title=Instalaci%C3%B3n_de_ODBC_para_Zabbix</id>
	<title>Instalación de ODBC para Zabbix - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://www.zabbix-es.com.es/index.php?action=history&amp;feed=atom&amp;title=Instalaci%C3%B3n_de_ODBC_para_Zabbix"/>
	<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Instalaci%C3%B3n_de_ODBC_para_Zabbix&amp;action=history"/>
	<updated>2026-11-21T23:17:01Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.46.2</generator>
	<entry>
		<id>https://www.zabbix-es.com.es/index.php?title=Instalaci%C3%B3n_de_ODBC_para_Zabbix&amp;diff=154&amp;oldid=prev</id>
		<title>Unknown user: Created page with &quot;==Instalacion de ODBC en Zabbix==  # yum -y install unixODBC unixODBC-devel  ==Instalamos los drivers que necesitemos==  &#039;&#039;&#039;Nota:&#039;&#039;&#039; En la siguiente URL tenemos todos los driv...&quot;</title>
		<link rel="alternate" type="text/html" href="https://www.zabbix-es.com.es/index.php?title=Instalaci%C3%B3n_de_ODBC_para_Zabbix&amp;diff=154&amp;oldid=prev"/>
		<updated>2020-05-28T14:06:23Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;==Instalacion de ODBC en Zabbix==  # yum -y install unixODBC unixODBC-devel  ==Instalamos los drivers que necesitemos==  &amp;#039;&amp;#039;&amp;#039;Nota:&amp;#039;&amp;#039;&amp;#039; En la siguiente URL tenemos todos los driv...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==Instalacion de ODBC en Zabbix==&lt;br /&gt;
 # yum -y install unixODBC unixODBC-devel&lt;br /&gt;
&lt;br /&gt;
==Instalamos los drivers que necesitemos==&lt;br /&gt;
 &amp;#039;&amp;#039;&amp;#039;Nota:&amp;#039;&amp;#039;&amp;#039; En la siguiente URL tenemos todos los drivers disponibles. http://www.unixodbc.org/drivers.html&lt;br /&gt;
 # yum list *-odbc&lt;br /&gt;
 # yum install mysql-connector-odbc&lt;br /&gt;
 # yum install postgresql-odbc&lt;br /&gt;
&lt;br /&gt;
==Configuramos los drivers [odbcinst.ini]==&lt;br /&gt;
 # vi /etc/odbcinst.ini&lt;br /&gt;
 # Driver from the postgresql-odbc package&lt;br /&gt;
 # Setup from the unixODBC package&lt;br /&gt;
 [PostgreSQL]&lt;br /&gt;
 Description     = ODBC for PostgreSQL&lt;br /&gt;
 Driver          = /usr/lib/psqlodbcw.so&lt;br /&gt;
 Setup           = /usr/lib/libodbcpsqlS.so&lt;br /&gt;
 Driver64        = /usr/lib64/psqlodbcw.so&lt;br /&gt;
 Setup64         = /usr/lib64/libodbcpsqlS.so&lt;br /&gt;
 FileUsage       = 1&lt;br /&gt;
 &lt;br /&gt;
 &lt;br /&gt;
 # Driver from the mysql-connector-odbc package&lt;br /&gt;
 # Setup from the unixODBC package&lt;br /&gt;
 [MySQL]&lt;br /&gt;
 Description     = ODBC for MySQL&lt;br /&gt;
 Driver          = /usr/lib/libmyodbc5.so&lt;br /&gt;
 Setup           = /usr/lib/libodbcmyS.so&lt;br /&gt;
 Driver64        = /usr/lib64/libmyodbc5.so&lt;br /&gt;
 Setup64         = /usr/lib64/libodbcmyS.so&lt;br /&gt;
 FileUsage       = 1&lt;br /&gt;
&lt;br /&gt;
==Configuramos el datasource [odbc.ini]==&lt;br /&gt;
 # vi /etc/odbc.ini&lt;br /&gt;
 [DBTest]&lt;br /&gt;
 Description = MySQL test database&lt;br /&gt;
 Driver      = MySQL&lt;br /&gt;
 Server      = 127.0.0.1&lt;br /&gt;
 User        = root&lt;br /&gt;
 Password    =&lt;br /&gt;
 Port        = 3306&lt;br /&gt;
 Database    = zabbix&lt;br /&gt;
&lt;br /&gt;
 [zbxssoodb]&lt;br /&gt;
 Driver     = PostgreSQL&lt;br /&gt;
 Servername = 127.0.0.1&lt;br /&gt;
 Port       = 5432&lt;br /&gt;
 Database   = zabbix&lt;br /&gt;
 Username   = zabbix&lt;br /&gt;
 Password   = MiPassword&lt;br /&gt;
&lt;br /&gt;
 # chmod 600 /etc/odbc.ini &lt;br /&gt;
&lt;br /&gt;
==Verificamos la configuracion==&lt;br /&gt;
 # odbcinst -j&lt;br /&gt;
&lt;br /&gt;
==Probamos el Driver==&lt;br /&gt;
 # isql zbxssoodb&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 | Connected!                            |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 | sql-statement                         |&lt;br /&gt;
 | help [tablename]                      |&lt;br /&gt;
 | quit                                  |&lt;br /&gt;
 |                                       |&lt;br /&gt;
 +---------------------------------------+&lt;br /&gt;
 SQL&amp;gt; quit&lt;/div&gt;</summary>
		<author><name>Unknown user</name></author>
	</entry>
</feed>