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/ _______________________________________________ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
