Alfonso de la Guarda Reyes avatar Alfonso de la Guarda Reyes committed 4469a36

Agregado soporte para Oracle y MSSQL

Comments (0)

Files changed (3)

ictec_db_centos.sh

+#!/bin/bash
+###
+#Guia de procedimientos para instalación de aplicativos web y desarrollo de ICTEC SAC
+###
+echo "ICTEC SAC"
+echo "Instalación de servicios y aplicaciones"
+echo "---------------------------------------"
+###
+#Repositorios básicos y paquetes
+###
+#Repositorio EPEL que contiene últimos paquetes para CentOS
+echo "*** Oracle"
+echo "Descargando rpm"
+wget http://ictec.biz/oracle-xe-client-10.2.0.1-1.0.i386.rpm
+sleep 3
+#Cliente Oracle 10g
+rpm -Uvh oracle-xe-client-10.2.0.1-1.0.i386.rpm
+sleep 3
+#Librerías
+echo "/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib" >> /etc/ld.so.conf
+ldconfig
+#Módulo Python Oracle
+wget http://downloads.sourceforge.net/project/cx-oracle/5.0.4/cx_Oracle-5.0.4-10g-py26-1.i386.rpm
+rpm -Uvh cx_Oracle-5.0.4-10g-py26-1.i386.rpm
+#Instalación de servicios y paquetes básicos para los aplicativos
+echo "*** SQL-Server"
+#Instalando dependencias globales del sistema de los repos estándares
+yum -y install unixODBC unixODBC-devel freetds freetds-devel gcc-c++
+#Configurando conexiones SQL-SERVER
+#Cambiar el contenido de odbc.ini según las necesidades
+cat odbc.ini >> /etc/odbc.ini
+cat odbcinst.ini >> /etc/odbcinst.ini
+#Instalar modulo pyodbc
+pip install pyodbc
+#Se agrega sindicacion al supervisor, es necesario agregar manualmente en [group]
+#cat supervisord.db.conf.add >> /etc/supervisord.conf
+echo "++++++++++++++++++++++++++++++++++++++++++++"
+[MSHOSTNAME]
+Driver=TDS
+Description=MS SQL Test
+#Trace = Yes
+#TraceFile = /tmp/mstest.log
+Server=192.168.1.41
+Database=test
+Port=1433
+TDS_Version=7.0
+[TDS]
+Description = FreeTDS driver
+Driver = /usr/lib/libtdsodbc.so
+Setup = /usr/lib/libtdsodbc.so
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.