<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16705" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Olá pessoal, estou tendo problemas em usar o cdr
odbc com o asterisk, </FONT><FONT face=Arial size=2>no momento que o asterisk
vai gravar o registro, ele é encerrado, se fecha.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Ao iniciar o asterisk, consigo ver no firebird, ele
estabeleceu a comunicação, e algumas vezes o registro é gravado no firebird
antes do asterisk se fechar.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>já testei o driver odbc usando isql -v interlink,
ele funciona! consigo fazer select, insert, update.. mas com o asterisk a coisa
tá feia.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>a algun tempo atraz tivemos uma discursão onde o
Alexandre de Abreu informou que preferia usar ODBC, e neste momento existe a
necessidade de usar ODBC aqui para me conectar ao Firebird, no entanto já testei
até com MySql Odbc e dá na mesma... ele mata o asterisk no momento de
gravar o registro.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>localhost*CLI></FONT></DIV>
<DIV><FONT face=Arial size=2>Disconnected from Asterisk server</FONT></DIV>
<DIV><FONT face=Arial size=2>Executing last minute cleanups</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Alguma dica?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Alexandre Abreu, poderia enviar detalhes de como vc
utiliza o ODBC com asterisk?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>segue abaixo detalhes...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>obdcinst.ini</FONT></DIV>
<DIV><FONT face=Arial
size=2>-----------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2>[Firebird]</FONT></DIV>
<DIV><FONT face=Arial size=2>Description = Firebird ODBC
Driver</FONT></DIV>
<DIV><FONT face=Arial size=2>Driver
= /usr/lib/libOdbcFb32.so</FONT></DIV>
<DIV><FONT face=Arial size=2>Setup
= /usr/lib/libIscDbc.so</FONT></DIV>
<DIV><FONT face=Arial size=2>Threading =
1</FONT></DIV>
<DIV><FONT face=Arial size=2>FileUsage = 1 "Tentei com
valor maior tb"</FONT></DIV>
<DIV><FONT face=Arial size=2>CPTimeout =</FONT></DIV>
<DIV><FONT face=Arial size=2>CPReuse
=</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>odbc.ini</FONT></DIV>
<DIV><FONT face=Arial
size=2>-----------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2>[interlink]</FONT></DIV>
<DIV><FONT face=Arial size=2>Description =
Firebird</FONT></DIV>
<DIV><FONT face=Arial size=2>Driver
= Firebird</FONT></DIV>
<DIV><FONT face=Arial size=2>Dbname =
127.0.0.1:/meudb.fdb</FONT></DIV>
<DIV><FONT face=Arial
size=2>User =
SYSDBA "Apenas para testes"</FONT></DIV>
<DIV><FONT face=Arial size=2>Password = masterkey
"Apenas para testes"</FONT></DIV>
<DIV><FONT face=Arial size=2>Role
=</FONT></DIV>
<DIV><FONT face=Arial size=2>CharacterSet =</FONT></DIV>
<DIV><FONT face=Arial size=2>ReadOnly = No</FONT></DIV>
<DIV><FONT face=Arial size=2>NoWait =
No</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>modules.conf</FONT></DIV>
<DIV><FONT face=Arial
size=2>-----------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2>preload => res_odbc.so</FONT></DIV>
<DIV><FONT face=Arial size=2>preload => res_config.so</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>cdr_odbc.conf</FONT></DIV>
<DIV><FONT face=Arial
size=2>-----------------------------------------------------------------------------------</FONT></DIV>
<DIV><FONT face=Arial size=2>[global]</FONT></DIV>
<DIV><FONT face=Arial size=2>dsn=interlink</FONT></DIV>
<DIV><FONT face=Arial size=2>username=SYSDBA "Apenas para testes"</FONT></DIV>
<DIV><FONT face=Arial size=2>password=masterkey "Apenas para
testes"</FONT></DIV>
<DIV><FONT face=Arial size=2>loguniqueid=yes</FONT></DIV>
<DIV><FONT face=Arial size=2>dispositionstring=yes</FONT></DIV>
<DIV><FONT face=Arial size=2>table=cdr</FONT></DIV>
<DIV><FONT face=Arial size=2>usegmttime=yes</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>res_odbc.conf</FONT></DIV>
<DIV><FONT face=Arial
size=2>-----------------------------------------------------------------------------------</FONT></DIV>
<DIV>[Firebird]</DIV>
<DIV>enable=yes</DIV>
<DIV>dsn => interlink</DIV>
<DIV>username => SYSDBA "Apenas para testes"</DIV>
<DIV>password => masterkey "Apenas para testes"</DIV>
<DIV>pre-connect => yes</DIV>
<DIV>backslash_is_scape => no</DIV>
<DIV> </DIV></FONT></DIV></BODY></HTML>