[asterisk-users] Res: Record CDR in a Oracle database

[Tim Panton]

What does the cdr table you created in oracle look like ?

Tim.
On 20 Jun 2007, at 13:37, Everton Goularth wrote:

> Hi All,
>
> Thank's for your hint Tim Panton
>
> I could connect my asterisk machine to my oracle machine.
>
> I used unixODBC-2.2.11.tar.gz,
> oracle-instantclient-basic-10.2.0.3-1.i386.rpm,
> oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm and the drive from
> www.oracle.com (odbc-oracle-3.1.0-linux-x86-glibc.tar) to configure my
> asterisk machine.
> I can connect to my oracle machine with isql and in the asterisk CLI I
> can see that  the odbc is connected to oracle with the following  
> command:
>
> asterisk*CLI> odbc show
>  Name: oracle
>  DSN: oracle
>  Connected: yes
>
> And I can see with netstat in my oracle machine that the my asterisk
> machine is connected in the DB oracle.
>
> But when I finish a call I received the following error:
>
>> cdr_odbc: Connected to oracle
>> cdr_odbc: Error in Query -1
>> cdr_odbc: Query FAILED Call not logged!
>> cdr_odbc: Reconnecting to dsn oracle
>> cdr_odbc: Connected to oracle
>> cdr_odbc: Trying Query again!
>> cdr_odbc: Error in Query -2
>> cdr_odbc: Query FAILED Call not logged!
>
> Does anyone have any ideia?
> Did anyone have this error?? or know how can I do this?
>
> Thank's in advanced...
>
> Everton Goularth
> GoVoIP - Uberlandia - MG
> Brasil
>
> 		
> _______________________________________________________
> Yahoo! Mail - Sempre a melhor opção para você!
> Experimente já e veja as novidades.
> http://br.yahoo.com/mailbeta/tudonovo/
>
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

Tim Panton

www.mexuar.net
www.westhawk.co.uk/