[Asterisk-Dev] problem with cdr_odbc

[brian]

Using MSSQL 2000?

bkw

> -----Original Message-----
> From: asterisk-dev-admin at lists.digium.com [mailto:asterisk-dev-
> admin at lists.digium.com] On Behalf Of Pablo Endres
> Sent: Wednesday, May 19, 2004 11:03 AM
> To: asterisk-dev at lists.digium.com
> Subject: Re: [Asterisk-Dev] problem with cdr_odbc
>
> I know someone toldme yesturday that the subject was out of line
> for this list, but I've checked and the problem is down to dev (src
> code).
>
> Oka.. heres what I got until now:
> I'm using unixODBC and freetds to go against a M$ SQL Server, the conn y
> good I can even see the open conn from asterisk in the
> process list on the server.
>
> The problem comes when the statement is executed.  I pumped up the
> verbosity on freetds and found the following log (each time cdr_odbc
> tries to write a log)
>
> pid: 30035:Received packet @ 11:02:14.897325
> 0000 aa 82 00 e9 03 00 00 01-0f 37 00 4c 00 69 00 6e |........ .7.L.i.n|
> 0010 00 65 00 20 00 31 00 3a-00 20 00 4c 00 65 00 6e |.e. .1.: . .L.e.n|
> 0020 00 67 00 74 00 68 00 20-00 6f 00 72 00 20 00 70 |.g.t.h.  .o.r. .p|
> 0030 00 72 00 65 00 63 00 69-00 73 00 69 00 6f 00 6e |.r.e.c.i .s.i.o.n|
> 0040 00 20 00 73 00 70 00 65-00 63 00 69 00 66 00 69 |. .s.p.e .c.i.f.i|
> 0050 00 63 00 61 00 74 00 69-00 6f 00 6e 00 20 00 30 |.c.a.t.i .o.n. .0|
> 0060 00 20 00 69 00 73 00 20-00 69 00 6e 00 76 00 61 |. .i.s.  .i.n.v.a|
> 0070 00 6c 00 69 00 64 00 2e-00 04 53 00 51 00 4c 00 |.l.i.d.. ..S.Q.L.|
> 0080 31 00 00 01 00 aa 54 00-89 00 00 00 02 0f 20 00 |1.....T. ...... .|
> 0090 4d 00 75 00 73 00 74 00-20 00 64 00 65 00 63 00 |M.u.s.t.  .d.e.c.|
> 00a0 6c 00 61 00 72 00 65 00-20 00 74 00 68 00 65 00 |l.a.r.e.  .t.h.e.|
> 00b0 20 00 76 00 61 00 72 00-69 00 61 00 62 00 6c 00 | .v.a.r. i.a.b.l.|
> 00c0 65 00 20 00 27 00 40 00-50 00 31 00 27 00 2e 00 |e. .'. at . P.1.'...|
> 00d0 04 53 00 51 00 4c 00 31-00 00 01 00 aa 6e 00 f4 |.S.Q.L.1 .....n..|
> 00e0 1f 00 00 01 10 23 00 53-00 74 00 61 00 74 00 65 |.....#.S .t.a.t.e|
> 00f0 00 6d 00 65 00 6e 00 74-00 28 00 73 00 29 00 20 |.m.e.n.t .(.s.). |
> 0100 00 63 00 6f 00 75 00 6c-00 64 00 20 00 6e 00 6f |.c.o.u.l .d. .n.o|
> 0110 00 74 00 20 00 62 00 65-00 20 00 70 00 72 00 65 |.t. .b.e . .p.r.e|
> 0120 00 70 00 61 00 72 00 65-00 64 00 2e 00 04 53 00 |.p.a.r.e .d....S.|
> 0130 51 00 4c 00 31 00 0a 73-00 70 00 5f 00 70 00 72 |Q.L.1..s .p._.p.r|
> 0140 00 65 00 70 00 61 00 72-00 65 00 01 00 79 f4 1f |.e.p.a.r .e...y..|
> 0150 00 00 ac 09 00 00 01 38-00 00 00 26 04 00 fe 02 |.......8 ...&....|
> 0160 00 e0 00 00 00 00 00   -                        |.......|
>
> I checked the code on cdr_odbc, but it seems to be setting the value in
> the prepared statement.
>
> Any ideas on what could be wrong?
>
>
>
> --
> Pablo Endres <epablo at comvoz.com>
> ComVoz Comunications
>
> _______________________________________________
> Asterisk-Dev mailing list
> Asterisk-Dev at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-dev
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev