Everton Goularth
2007-Jun-20 12:37 UTC
[asterisk-users] Res: Record CDR in a Oracle database
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/
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-usersTim Panton www.mexuar.net www.westhawk.co.uk/