similar to: CDRs on multiple servers.

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, I'm getting the following at asterisk startup. OCBC was working with 1.4 no problem, but now under 1.6 (I've tried 1.6.1, 1.6.2-beta3/beta4) I can't seem to get rid of this .... anyone? WARNING[32664]: loader.c:385 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: ast_odbc_clear_cache

Hi all, I am testing with Asterisk 1.8.0 beta3 using realtime with a mssql server using freetds and unixodbc, which works with 1.6.1.20. With the same config in 1.8 I get an error when trying to start asterisk which says: [Aug 23 15:06:12] WARNING[7180]: loader.c:387 load_dynamic_module: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined

Hello, I have a setup with asterisk 16.8.0, I'm facing a problem where calls that fail (CONGESTION) don't have filled in some extra fields we add to the CDRs in the database. We use cdr_adaptive_odbc with MySQL as backend. To simplify the scenario: [sub-hanguphandler] exten => s,1,Set(CDR(foo)=${bar}) same => n,Return() [default] exten => _X.,1,NoOp(New test call) same =>

I have two version 1.6 Asterisks running. One is a small 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

Hello! Most are probably bored seeing another letter about this, but I've put in a fair amount work on a spec for rewriting the CDR system in Asterisk, and I have some questions: First, please look at what I've written so far: svn co http://svn.digium.com/svn/asterisk/team/murf/RFCs and look at the file "CDRfix2.rfc.txt" in the RFCs dir. The spec SIGNIFICANTLY alters the way

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

All, According to my readings CDRs are stored at the end of the call. My concerns is when asterisk goes down (I know that it's never happen but it's just in case) or when the is a power shutdown of the server. then CDRs are not stored in mysql. is there a way to store periodially CDR during a call, and set the periodical timer regarding the context. if no is there a way to retreive CDR,

Hi Like we can define cdr field format for csv, is it possible to define if cdrs are stored in a database? Also, what will be size limit for database CDR storage ? -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110712/b5356cfd/attachment.htm>

Hello, After installing Asterisk from source in Slackware 13.1, I get the following error: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: ast_odbc_clear_cache Then a core dump. If I change the /etc/asterisk/modules.conf in order to preload the 'res_odbc.so' module, then the error dissapears, *but* still crashes

I have created an asterisk.org blog entry: http://www.asterisk.org/node/48358 to describe what I will shortly be committing to trunk to correct the weaknesses of CDRs, that asterisk users and developers have been complaining about for quite some time. Highlights: Restructuring the code and philosophy of CDRs. Plans to eliminate the ForkCDR() application Plans to create

Is there a way to retrieve the Call-ID from a call made using the 'Dial' command on a SIP channel without CDRs (i.e. variable) ? Thanks, - Darren

Hello, I configured asterisk to use mysql for CDR. Well when i check from time to time I realize that asterisk loose connection with mysql (i use phpmyadmin and i watch the processes). Can anybody tell me how can i solve that problem? I want to have all cdr statistics logged in mysql, is very important for billing. Thank you for support. -------------- next part -------------- An HTML attachment

Hello! I have been doing some tests with call transfers and I have been looking at the CDRs that Asterisk generates. Scenario 1: A calls B B answers and does a blind transfer to C (using # key) C answers and talks with A Scenario 2: A calls B B answers and does an attended transfer do C (using the phone's transfer key) C answers, B hangs up, and C talks with A For scenario 1, the CDR shows

Hi guys, Having issue with getting CDR to write to MS-SQL via ODBC. > cdr_odbc: Connected to freetds-connector > cdr_odbc: Error in PREPARE -1 > cdr_odbc: Query FAILED Call not logged! == Spawn extension (cisco, ##########, 2) exited non-zero on 'IAX2/astYYYY-507 Isql test: [xxx at YYYY asterisk]# isql freetds-connector XXXXXXX YYYYYYYYY

Hi, I would like to be able to log call details in Asterisk. The kind of logs that I like to generate is like this: From To Forward Time Incoming Call 604-343-3334 503-233-4454 13:33:32 Extension Routing 503-233-4454 Extension 403

For redundancy I would like to write the CDRs on tow mysql servers. cdr_mysql.conf accept only one configuration [global], how to add a second host? Thanks Rosario -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20050609/9eacbae2/attachment.htm

Does anyone know where that nice .php is that was written to access the CDRs from mysql DB? Bruce W. Hedreen Computer Technologies of Eastern Carolina, LLC --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -------------- next part -------------- An HTML attachment was

Hi, We have free pbx installed on asterisk 1.4.25.1. Mysql is installed and asterisk is connecting to it. CDR modules are all loaded as well. For some reason, it is not creating master.csv and no cdrs are generated. Can anyone help please. --- Kind Regards, Deepika Nijhawan VoIP Engineer Oxygen8 Communications T: +44(0) 871 434 9151 +44(0) 121 620 9151

Hi! I just found out that Asterisk (1.4) does not write CDRs if the incoming call was not forwarded but handled internally without answering the call. E.g.: [from_pstn] exten => 997,1,Answer() exten => 997,2,Playback(tt-weasels) exten => 997,3,Hangup() exten => 999,1,Playback(tt-weasels|noanswer) exten => 999,4,Hangup() For incoming calls to 997 a CDR will be written, but not