I'm currently using Asterisk running version 1.2.5 and trying to use cdr_odbc to connect to a Microsoft SQL database. I have everything running, but the insert statement being sent to database doesn't appear to have the "start, answer, end" information in it.
Below is the insert statement that MS Profiler shows being sent. As you can see those fields are missing.
INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14)
Here is the record that shows up in cdr-csv
"","4718","2599576","default","""Asterisk2"" <4718>","SIP/4718-af52","IAX2/visioniax-1","Dial","
IAX2/visioniax/[EMAIL PROTECTED]","2006-03-29 10:29:23","2006-03-29 10:29:25","2006-03-29 10:29:34",11,9,"ANSWERED","DOCUMENTATION"
that record looks fine.
Please let me know if I'm missing anything here.
Thanks,
-Brian
_______________________________________________ --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
