[Asterisk-Users] problem with cdr_odbc

[brian]

Don't install from RPM or even an RPM you built.  It's going to suffer the
same issues no matter what if you keep using an RPM.  Also what FreeTDS
version are you using?

  == Spawn extension (default, 999, 4) exited non-zero on 'SIP/10-6e46'
       > cdr_odbc: Query Successful!

I'm using it with MySQL and MyODBC without issues.  I wrote cdr_odbc.c using
unixODBC 2.2.7 I don't think much as changed since then and current run it
on 2.2.8 without any issues.  You need to test using isql to see if you can
even connect to the DSN.

bkw

> -----Original Message-----
> From: asterisk-users-admin at lists.digium.com [mailto:asterisk-users-
> admin at lists.digium.com] On Behalf Of Pablo Endres
> Sent: Tuesday, May 18, 2004 9:24 AM
> To: asterisk-users at lists.digium.com
> Subject: [Asterisk-Users] problem with cdr_odbc
>
> Hi,
>
> Has  anyone made a successfull instalation of cdr_odbc??
>
> I've install unixODBC-2.2.8 (made my own RPM) and then built the module.
> I'm trying to send the cdrs to a M$ SQL server.  The sql connection
> works because I can do any query via isql.
>
> When I do the calls I get the following output on the asterisk console:
>     -- Executing Hangup("SIP/test1-a5e1", "") in new stack
>   == Spawn extension (test, h, 1) exited non-zero on 'SIP/test1-a5e1'
>        > cdr_odbc: Connected to SQL1
>        > cdr_odbc: Error in Query -1
>        > cdr_odbc: Query FAILED Call not logged!
>        > cdr_odbc: Connected to SQL1
>        > cdr_odbc: Reconnecting to dsn SQL1
>        > cdr_odbc: Trying Query again!
>        > cdr_odbc: Error in Query -2
>        > cdr_odbc: Query FAILED Call not logged!
>
>
> --
> Pablo Endres <epablo at comvoz.com>
> ComVoz Comunications
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users