[AsteriskBrasil] integrando asterisk com ms sql

[Bernini Asterisk]

se vc nao conseguir abrir os anexos

freetds.conf

#   $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $
#
# This file is installed by FreeTDS if no file by the same
# name is found in the installation directory.
#
# For information about the layout of this file and its settings,
# see the freetds.conf manpage "man freetds.conf".

# Global settings are overridden by those in a database
# server specific section
[global]
        # TDS protocol version
        tds version = 8.0
        port = 1433
        try server login = yes
        try domain login = no

        dump file = /tmp/freetds.log
        debug level = 10
        timeout = 10;
        connect timeout = 10;


        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
;       dump file = /tmp/freetds.log
;       debug flags = 0xffff

        # Command and connection timeouts
;       timeout = 10
;       connect timeout = 10

        # If you get out-of-memory errors, it may mean that your client
        # is trying to allocate a huge buffer for a TEXT field.
        # Try setting 'text size' to a more reasonable limit
        text size = 64512

# A typical Sybase server
[egServer50]
        host = symachine.domain.com
        port = 5000
        tds version = 5.0

# A typical Microsoft server
[egServer70]
        host = ntmachine.domain.com
        port = 1433
        tds version = 7.0


odbc.ini
;[asterisk]
;Description = FreeTDS
;Driver = FreeTDS
;Servername = 192.168.10.223
;Database = agenda
;UID = sa
;PWD = teste123
;Port = 1433


;[asterisk]
;description         = Asterisk ODBC for MSSQL
;driver              = FreeTDS
;server              = 192.168.10.223
;port                = 1433
;database            = agenda
;tds_version         = 8.0
;language            = us_english
;UID = sa
;PWD = teste123
[asterisk]

Driver          = FreeTDS
Database        = dados
Server          = 192.168.1.103
UserName        = sa
Password        = teste123
Trace           = No
TDS_Version     = 8.0
Port            = 1433

odbcinst.ini


# Example driver definitions

# See /usr/share/doc/unixODBC*/README.64bit for more information


# Use these definitions with the original unixODBC package

# Driver from the postgresql-odbc package
# Setup from the unixODBC-libs package
[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver          = /usr/lib/psqlodbc.so
Setup           = /usr/lib/libodbcpsqlS.so
Driver64        = /usr/lib64/psqlodbc.so
Setup64         = /usr/lib64/libodbcpsqlS.so
FileUsage       = 1


# Driver from the mysql-connector-odbc package
# Setup from the unixODBC-libs package
[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/libmyodbc3_r.so
Setup           = /usr/lib/libodbcmyS.so
Driver64        = /usr/lib64/libmyodbc3_r.so
Setup64         = /usr/lib64/libodbcmyS.so
FileUsage       = 1


# Use these definitions with the unixODBC64 package

# Driver from the postgresql-odbc64 package
# Setup from the unixODBC64-libs package
[PostgreSQL64]
Description     = ODBC for PostgreSQL (64 bit)
Driver          = /usr/lib/psqlodbcw.so
Setup           = /usr/lib/libodbcpsqlS64.so
Driver64        = /usr/lib64/psqlodbcw.so
Setup64         = /usr/lib64/libodbcpsqlS64.so
FileUsage       = 1


# Driver from the mysql-connector-odbc64 package
# Setup from the unixODBC64-libs package
[MySQL64]
Description     = ODBC for MySQL (64 bit)
Driver          = /usr/lib/libmyodbc5.so
Setup           = /usr/lib/libodbcmyS64.so
Driver64        = /usr/lib64/libmyodbc5.so
Setup64         = /usr/lib64/libodbcmyS64.so
FileUsage       = 1

[FreeTDS]
Description=ODBC for SQL Server
Driver= /usr/local/freetds/lib/libtdsodbc.so
Setup= /usr/local/freetds/lib/libtdsodbbc.so
FileUsage=1






Em Quarta-feira, 22 de Janeiro de 2014 12:23, Bernini Asterisk <asterisk_ti em yahoo.com.br> escreveu:
 
boa tarde
segue em anexo as confs e abaixo o comando que usei

 linhas do comando
[root em IPBX-Linux ~]# isql -v asterisk
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[08S01][unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist
[ISQL]ERROR: Could not SQLConnect
valeuuuu
att
Breno Bernini





Em Quarta-feira, 22 de Janeiro de 2014 12:05, Bernini Asterisk <asterisk_ti em yahoo.com.br> escreveu:
 
opa , vou preparar o email e ja te mando ok ?

muito obrigado msm!!


em alguns minutos ja envio

att

Breno



Em Quarta-feira, 22 de Janeiro de 2014 11:46, Bernini Asterisk <asterisk_ti em yahoo.com.br> escreveu:
 
Então instalei o UNIXODBC + FREETDS, porém quando tento usar o comando isql -v DNS não consigo efetuar a conexão.. 
Aparece o erro s100008s01


usei como base esse tutorial aqui http://herson.objectis.net/artigos/instalando-freetds-e-unixodbc 

, estou usando centOS 

você teria alguma dica ? ta osso to no desespero vei hehhehe valeu mesmo brother




Em Quarta-feira, 22 de Janeiro de 2014 11:16, Bernini Asterisk <asterisk_ti em yahoo.com.br> escreveu:
 
bom dia rapaziada

alguem ai por acaso ja integrou o ms sql ao asterisk ?

estou com uma solicitação aqui porém não consigo fazer nem fudendo

ja tentei com freetds porem não consegui =S

alguem pode ajudar ?


att

Breno 
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20140122/e5f27756/attachment-0001.htm