[AsteriskBrasil] ENC: postar Assuntos nestas Lista

[Fernando - F&F]

Ola, Descupa não percebi a falta do Texto,

 

Fiz um UP do 1.6 para 1.8 e ai começou a dor de cabeça com CDR,

 

 

Segue Configuração.:

Segue a minha configuração.:

 

vim /etc/odbc.ini

 

[MySQL-asterisk]

Description = MySQL ODBC Driver Testing

Driver = MySQL

port = 3306

Socket = /var/run/mysqld/mysqld.sock

Server = localhost

User = asterisk

Password = asteriskcdr

Database = asterisk

Option = 3

 

 

vim /etc/odbcinst.ini

 

[MySQL]

Description = ODBC for  MySQL

Driver = /usr/lib/odbc/libmyodbc.so

Setup = /usr/lib/odbc/libodbcmyS.so

FileUsage = 1

 

 

Segue Debug asterisk

 

Segue debug do asterisk

  == Using SIP RTP CoS mark 5

    -- Executing [8001 em from-ramais:1] Dial("SIP/8000-00000006",
"SIP/8001,120,Tt,wW") in new stack

       > [INSERT INTO cdr
(uniqueid,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposit
ion,amaflags,accountcode,userfield,sequence,linkedid) VALUES
('1316457058.6','','','','','','','','','',3,'','','','1316457058.6')]

  == Using SIP RTP CoS mark 5

    -- Called SIP/8001

       > [INSERT INTO cdr
(uniqueid,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposit
ion,amaflags,accountcode,userfield,sequence,linkedid) VALUES
('1316457058.7','','','','','','','','','',3,'','','','1316457058.6')]

    -- SIP/8001-00000007 is ringing

    -- SIP/8001-00000007 is ringing

  == Spawn extension (from-ramais, 8001, 1) exited non-zero on
'SIP/8000-00000006'

       > [INSERT INTO cdr
(uniqueid,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposit
ion,amaflags,accountcode,userfield,sequence,linkedid) VALUES
('1316457058.7','','','','','','','','','',3,'','','','1316457058.6')]

[Sep 19 15:31:11] ERROR[5573]: cdr_odbc.c:148 odbc_log: Unable to retrieve
database handle.  CDR failed.

       > [INSERT INTO cdr
(uniqueid,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposit
ion,amaflags,accountcode,userfield,sequence,linkedid) VALUES
('1316457058.7','','','','','','','','','',3,'','','','1316457058.6')]

       > [INSERT INTO cdr
(uniqueid,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposit
ion,amaflags,accountcode,userfield,sequence,linkedid) VALUES
('1316457058.6','','','','','','','','','',3,'','','','1316457058.6')]

       > [INSERT INTO cdr
(uniqueid,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposit
ion,amaflags,accountcode,userfield,sequence,linkedid) VALUES
('1316457058.6','','','','','','','','','',3,'','','','1316457058.6')]

       > [INSERT INTO cdr
(uniqueid,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,disposit
ion,amaflags,accountcode,userfield,sequence,linkedid) VALUES
('1316457058.6','','','','','','','','','',3,'','','','1316457058.6')]

 

Ele Grava so a data no Mysql, alguém já passou por isso?

 

 

CDR + Mysql alguém já tem em produção.

 

 

 

-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: http://listas.asteriskbrasil.org/pipermail/asteriskbrasil/attachments/20110920/23ba6921/attachment.htm