[Asterisk-Dev] problem with cdr_odbc

Wed May 19 11:48:24 MST 2004

Yes.  I'll check the freetds issue.

Any pointer on where to find good doc on unixODBC (programer 
level)  I what to rewrite the module without the prepared statements.

Maybye I can give my quest another route.  I'm bassiclly trying to
simulate radius auth and Acct.

I've already made a AGI in perl that does the Auth, but need the
accounting.

I tryed the CCP radius that I saw on the wiki but I doesn't work
(or at least I don't know how to make it work).

Thanks in advance

Pablo

On Wed, 2004-05-19 at 13:28, brian wrote:
> 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
> 
> 
> _______________________________________________
> 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
-- 
Pablo Endres <epablo at comvoz.com>
ComVoz Comunications