search for: cdr_adaptive_odbc

Hi all, I am having trouble getting cdr_adaptive_odbc to work. I have correctly configured the odbc drivers and dsn (I have tested this by connecting directly using isql). I have also configured /etc/asterisk/cdr_adaptive_odbc.conf like so: [test-asterisk] connection=test-asterisk-odbc table=cdr I have tested the ODBC connection test-asterisk-odbc...

Hi to all, I actually have an asterisk server configured to write CDR mysql records in the same machine (localhost), but I want to write this records to another machine also in mysql at the same time, It is possible? It means that I want save the records in both machines. Thanks in advance. Ricardo Melendez -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi folks, I was recently made aware that the only way to currently set custom fields in a relational database for CDR is via the experimental cdr_adaptive_odbc drivers found here: http://svncommunity.digium.com/view/tilghman/branches/1.4/cdr_adaptive_odbc.c?view=log I had no problem compiling the driver, and copied the module to /usr/lib/asterisk/modules on my box and setup /etc/asterisk/cdr_adaptive_odbc.conf with the following: [first] connection=Aste...

I'm running 1.6.2.13 and need to record a small number of custom values use cdr_odbc and cdr_adaptive_odbc, and only the custom fields. The good news is that the custom records are being stored in the database as desired. The bad news is that I get three sets of warnings/notice about 'SQL Exec Direct failed' and dropping then reconnecting the database handle. I traced the SQL calls and found...

...ed from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database "mydatabase") via cdr_adaptive_odbc. The "SIP/A221" is another asterisk machine named it "Elastix24". I have two BIG QUESTIONs about cdr_adaptive_odbc. First, I have answered call from Elastix24 and I can listen the music file played from Asterisk11. In another word, this call should be answered and its billsec...

Hello guys, I need to be able to throw cdrs on more than one servers at a time. Please let me know how this can be done. Thanks

...hing 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 odbc cdr module I should use, cdr_odbc or cdr_adaptive_odbc? Also Asterisk has crashed at least three times with this message: asterisk: /builddir/build/BUILD/mysql-connector-odbc-5.2.5-src/driver/desc.c:110: desc_free_paramdata: Assertion `aprec' failed. [Feb 9 16:28:48] WARNING[3781]: res_odbc.c:1405 _ast_odbc_request_obj2: SetConnectAttr (...

Hello all, I have all configurations done and cdr_odbc works fine. However, cdr_adaptive_odbc doesn't work and I get the following error: relocation error: /usr/lib/libmyodbc3-3.51.26.so: symbol strmov, version libmysqlclient_15 not defined in file libmysqlclient.so.15 with link time reference Please suggest any hints as to how I can rectify the issue. Thanks. -------------- next par...

Hi All I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. The curious thing is I can find them all inside the database. I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for all tables. Environment is: in production Asterisk 11.7.0~dfsg-1ubuntu1 Ubuntu 14.04.1 LTS Any thoughts? Thanx Ethy [Apr 25 10:56:56] WARNING[19013][C-000002cb]: res_odbc.c:64...

I use debian stretch and I have installed unixodbc-dev but I have a dependency on genreric_odbc in make menuselect What am I missing ? Is there an howto ? Thanks PX

...ed from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database "mydatabase") via cdr_adaptive_odbc. The "SIP/A221" is another asterisk machine named it "Elastix24". I have two BIG QUESTIONs about cdr_adaptive_odbc. First, I have answered call from Elastix24 and I can listen the music file played from Asterisk11. In another word, this call should be answered and its billsec...

...dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually compared each column > > with the cdr_adaptive_odbc.c error line. > > > > "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both > > returned OK for all tables. > > > > Environment is: > > in production Asterisk 11.7.0~dfsg-1ubuntu1 > > Ubuntu 14.04.1 LTS > > > >...

...ed from asterisk.org). We named it "Asterisk11". I want to generate a call file to /var/spool/asterisk/outgoing. This call will dial out to Local Channel and return to some Extens. Then Asterisk11 will generate a CDR records to MySQL's cdr table(in database "mydatabase") via cdr_adaptive_odbc. The "SIP/A221" is another asterisk machine named it "Elastix24". I have two BIG QUESTIONs about cdr_adaptive_odbc. First, I have answered call from Elastix24 and I can listen the music file played from Asterisk11. In another word, this call should be answered and its billsec...

Thank you, but unixodbc and odbcinst are installed... end even unixodbc-dev But I get the same need for "generic odbc(E)". On 17/04/2017 10:48, Marcelo Terres wrote: > You need unixodbc and odbcinst packages too, to configure the odbc. > > []s > Marcelo H. Terres <mhterres at gmail.com> > IM: mhterres at jabber.mundoopensource.com.br >

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES ('1000','1000','100','sip','SIP/1000-09388800','AddQueueMember','test,Lo...

Hi all, I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL's cdr table. After my testing, this scenario is working well. After a long idle time, I didn't make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find...

> Hi All > > I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. > > The curious thing is I can find them all inside the database. > I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. > > "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for all tables. > > Environment is: > in production Asterisk 11.7.0~dfsg-1ubuntu1 > Ubuntu 14.04.1 LTS > > Any thoughts? > > Thanx > > Ethy >...

Than you very much. I use asterisk 14, and yes, menuselect shows me the need for generic_odbc(E), res_odbc_transaction(M) and ltdl(E) but what does this imply under debian ? I have unixodbc installed an tested and too libltdl-dev ! But what am I missing ? On 04/19/2017 10:10 AM, Marcelo Terres wrote: > What version of Asterisk are you using? > > When I go to cdr_adaptative_odbc in

...mall hobbyist thing just at home, and the other is handling calls for several customers. On both, I have added the line exten => h,1,Set(CDR(hangupcause)=${HANGUPCAUSE}) to all relevant contexts. On my little hobbyist box this works perfectly; all calls have their hangupcauses recorded with cdr_adaptive_odbc and cdr_custom. On the production server, it only works sporadically; for 4 out of 5 calls the hangupcause field is empty. If I look at the Asterisk console, I see a message like this for every call: -- Executing [h at CallToVPBX:1] Set("DAHDI/49-1", "CDR(hangupcause)=16") i...

Hi, I am using Asterisk 1.6.2.13 and have an issue but I'm not sure if it's a bug or not. I am using the cdr_adaptive_odbc logging module and writing my CDR records to a MS-SQL server. I need to log which end hangs the call up and have placed the relevant CDR(myfield)=caller/callee commands where they need to be. When I watch the call on the console I can see the CDR field being set properly but when I check the CD...