search for: odbc_log

...irectory of the latest CVS, that's what I get: # cd /usr/src/asterisk/cdr # make cc -o cdr_odbc.so cdr_odbc.o -lodbc /usr/lib/gcc-lib/i386-redhat-linux/3.3.2/../../../crt1.o(.text+0x18): In function `_start': : undefined reference to `main' cdr_odbc.o(.text+0x197): In function `odbc_log': : undefined reference to `option_verbose' cdr_odbc.o(.text+0x1ae): In function `odbc_log': : undefined reference to `ast_verbose' cdr_odbc.o(.text+0x251): In function `odbc_log': : undefined reference to `option_verbose' cdr_odbc.o(.text+0x268): In function `odbc_log':...

Hi, is cdr logging using odbc buggy? I'im only getting an error "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". Connecting with isql to the datasource given in cdr_odbc.conf works just fine, and using the database for sippeers also works. The documentation[1] is confusing because it says freeTDS is required and that you must not use multiple databa...

On 12/07/2018 02:25 PM, Joshua C. Colp wrote: > On Fri, Dec 7, 2018, at 9:19 AM, hw wrote: >> >> Hi, >> >> is cdr logging using odbc buggy? I'im only getting an error >> "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed.". >> >> Connecting with isql to the datasource given in cdr_odbc.conf works just >> fine, and using the database for sippeers also works. > > This message is output when the "dsn" value provided in cdr_odbc.co...

HI, I am trying to setup CDR with ODBC and MySQL but get the following error :- [Apr 28 21:30:01] ERROR[14567]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle. CDR failed. I can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=******* ;loguniqueid=yes ;dispositionstring=yes table=cdr...

...dr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts '2016-02-09 16:21:28'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?) [Feb 9 16:21:43] ERROR[2088]: cdr_odbc.c:189 odbc_log: CDR direct execute failed First thing I do not get is that calldate does not exist in the CDR database (I am using the table structure that comes with the asterisk source). If I add that column then start, answer and end do not get populated when the call ends. Next question is which o...

...13][C-000002cb]: res_odbc.c:1527 odbc_obj_connect: Connecting MyAsterisk-asterisk [Apr 25 10:57:06] NOTICE[19013][C-000002cb]: res_odbc.c:1559 odbc_obj_connect: res_odbc: Connected to MyAsterisk-asterisk [MyAsterisk-asterisk] [Apr 25 10:57:06] WARNING[19013][C-000002cb]: cdr_adaptive_odbc.c:739 odbc_log: cdr_adaptive_odbc: Insert failed on 'MyAsterisk-asterisk:cdr'. CDR failed: INSERT INTO cdr (dst,accountcode,clid,src,dcontext,channel,dstchannel,lastapp,duration,billsec,disposition,amaflags,userfield,lastdata,uniqueid) VALUES (blahblahblah, ... ,'1429970147.612')

...terisk-asterisk > > > > [Apr 25 10:57:06] > > NOTICE[19013][C-000002cb]: res_odbc.c:1559 odbc_obj_connect: res_odbc: > > Connected to MyAsterisk-asterisk [MyAsterisk-asterisk] > > > > [Apr 25 10:57:06] > > WARNING[19013][C-000002cb]: cdr_adaptive_odbc.c:739 odbc_log: > > cdr_adaptive_odbc: Insert failed on 'MyAsterisk-asterisk:cdr'. CDR > > failed: INSERT INTO cdr > > (dst,accountcode,clid,src,dcontext,channel,dstchannel,lastapp,duration,billsec,disposition,amaflags,userfield,lastdata,uniqueid) > > VALUES (blahblahblah, ... ,...

...; odbc_obj_connect: Connecting MyAsterisk-asterisk > > [Apr 25 10:57:06] > NOTICE[19013][C-000002cb]: res_odbc.c:1559 odbc_obj_connect: res_odbc: > Connected to MyAsterisk-asterisk [MyAsterisk-asterisk] > > [Apr 25 10:57:06] > WARNING[19013][C-000002cb]: cdr_adaptive_odbc.c:739 odbc_log: > cdr_adaptive_odbc: Insert failed on 'MyAsterisk-asterisk:cdr'. CDR failed: INSERT > INTO cdr > (dst,accountcode,clid,src,dcontext,channel,dstchannel,lastapp,duration,billsec,disposition,amaflags,userfield,lastdata,uniqueid) > VALUES (blahblahblah, ... ,'1429970147.612...

...attempting to reconnect... [Oct 22 21:46:09] NOTICE[952]: res_odbc.c:1472 odbc_obj_connect: Connecting PostgreSQL-asterisk [Oct 22 21:46:09] NOTICE[952]: res_odbc.c:1502 odbc_obj_connect: res_odbc: Connected to PostgreSQL-asterisk [asterisk-connector] [Oct 22 21:46:09] WARNING[952]: cel_odbc.c:733 odbc_log: Insert failed on 'PostgreSQL-asterisk:celnew'. CEL failed: INSERT INTO celnew (uniqueid,linkedid,eventtime,userdeftype,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,accountcode,peeraccount,userfield,peer,amaflags) VALUES ('co-1287780365.0','...

...nected: Yes But when I make a call warnigs appear and I don't acces to database [Feb 21 10:30:53] WARNING[7101][C-00000007]: res_odbc.c:608 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk2 [asterisk-cdr]... [Feb 21 10:30:53] ERROR[7101][C-00000007]: cdr_odbc.c:162 odbc_log: CDR direct execute failed Can someone help me? Thanks, Jordi -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130221/21e0bc48/attachment.htm>

...did start off just talking about getting queue_log into a database table, > though. That's why I changed the subject. Now I started with CDR logging to the database because queue logging seems to be even more difficult, and it's not working because asterisk says "cdr_odbc.c:174 odbc_log: Unable to retrieve database handle. CDR failed." while I can connect to the datasource given in cdr_odbc.conf with isql just fine. I made another post about that, though.

...:01:26'},?,?,?,?,?,?"..., text_length=-3) at SQLExecDirect.c:417 #9 0x009e5397 in execute_cb (obj=0xa2bc0c0, data=0xa4a7c88) at cdr_odbc.c:115 #10 0x003accf8 in ast_odbc_direct_execute (obj=0xa2bc0c0, exec_cb=0x9e4e00 <execute_cb>, data=0xa4a7c88) at res_odbc.c:574 #11 0x009e55f1 in odbc_log (cdr=0xa4a7c88) at cdr_odbc.c:137 #12 0x0808db8a in post_cdr (cdr=0xa4a7c88) at cdr.c:1055 #13 0x0808e36e in ast_cdr_detach (cdr=0xa4a7c88) at cdr.c:1251 #14 0x080c042b in ast_bridge_call (chan=0xa52e8d0, peer=0xb79047a8, config=0x2abe1c0) at features.c:2849 #15 0x026285d9 in try_calling (qe=0x2abe...

On 12/05/2018 05:00 PM, Antony Stone wrote: > On Wednesday 05 December 2018 at 15:31:38, hw wrote: >> I don't see a table for that. > > You need to create that for yourself. > > Asterisk can write to database tables, but doesn't help you set them up, for > reasons I can't comment on. How do I know what the schema needs to be? Does anybody have a scheme for