similar to: CLIR missing in MySQL CDR records

Hi all, A few days ago I found out with help of some of you guys how to set CLIR. (Calling line identification restriction) My first idea was to use the keypad protocol to set the CLIR with dialing *31* before the number but this was not possible. So thanks to Damon Estep I got it to work with executing 'SetCallerPres(prohib)' before the dial command. This works perfectly! But now

I'm trying to configure CDR records to store them in MySQL database but those instruction are not very clear from: http://www.voip-info.org/tiki-index.php?page=Asterisk+cdr+mysql I've MySQL up and running I'm just not sure what database to create and as the configuration Sample cdr_mysql.conf is not consistent from instruction on: Create the database Do I create database name

I installed asterisk on two machine to load balance and to fail over. One is local and one is on a remote location. The record the cdr I use the mysql module and odbc. So I update a local (on each asterisk box) mysql db using mysql module and also I update a centralized mysql db using ODBC. I tought in this way I couldn't loose any record. But this is not true. Even with 2 updating process I

hi I have a passive isdn port configured in modem.conf in extention.conf i use this two channel (ttyI0 and ttyI1) with the string: exten => _NXXXXXXXXX,1,Dial,Modem/g1:${EXTEN}|60|r how can i hide my msn? is it possible to activate the clir with the @ before the ${EXTEN}? thanks Cristian

I would like to send the CDR records from all our machines around the world to a single database. But I need the hostname included with each record for monitoring purposes. Is there a better way than using the userfield and adding SetCDRUserfield for every call to set the userfield to the name of the host? Thanks...

Hi all, I need 2 CDR Records of below 2 numbers for outgoing calls, detail is given as below: *96XXXXXXXX88XXXXXXXX* *=> Call file : outbound call generate through below file* Test.call ====== Channel: local/s at outgoing/n WaitTime: 45 Context: outgoing_ivrs Extension: s Priority: 1 Set: contact_no=96XXXXXXXX extensions.conf ============ [outgoing] exten => s,1,NoOP(----- First LEG

Hello Asterisk-Users, For some reason my CDR records for disposition and billsec are not working correctly. I always receive a 0 for billsec and the disposition is always at "NO ANSWER', even when I grab the calls. I experience this with Asterisk 1.6.0.1 and Asterisk 1.4.22. Here is information on how I do the call: -----------------------------------------------------------------

My CDR is displaying wildly inaccurate results. When I make a call the CDR records the time between connecting into the server and hanging up, instead of recording the time between dialling from the server to the PSTN destination via VOIP termination. It is alright to log the duration of the connection to the server, but why it does not log calls for termination via voip provider is the main

Hi list, I use AMI to originate calls for outbound campaigns via local channel. I use CDR records to have status of the calls such as : disposition, if call was answered by live human or answering machine, reason of call failure and make accounting based on total calls that have been made. My problem is that I have more than one CDR records for a single call. One for the Leg A

Hi ! I just wrote cdr_sqlite.c, see http://bugs.digium.com/bug_view_advanced_page.php?bug_id=0001986 This little app creates automatically the sqlite database file in /var/log/asterisk/cdr.db, creates a table 'cdr' inside it and inserts all CDR records into this table. Please comment. I'll use this in my project DESTAR (http://www.holgerschurig.de/destar.html) to show these

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:

dear all, i facing one big issue in CDR , i have one user connected in meetme and then and after some time one user are joined meetme bu this user was originally dialed by , AMI via Originate and when remote user picked up call he joined meetme room everything is fine , but now 1 st user kicked 2 nd user , via using menu options or by typing "meetme kick 1234 2' user disconnected

What would it do if you exten => h,1,ResetCDR(w) exten => h,2,NoCDR() exten => h,3,DEADAGI(get-unqiueid.php) I have not tried it but in theory it should write the first CDR and then kill the write of the second NO ANSWER CDR. Let me know if it works for you as I may need to do it on some of my h exten code as well. Bryant ---------------------------------------- From:

Hi list, I am using Asterisk1.6.2 form a long time and upgarding to Asterisk-1.8.23.1. I am using mysql backend for cdr. in asterisk-1.6.2 i have usegmtime=yes and it works as expected insert cdr date in GMT0. now i tested Asterisk-1.8.23.1 and asterisk-11.5 with same results no matter what i configure in cdr_mysql.conf "timezone=UTC usegmtime=yes" cdr always inserted in local time. I

Hello folks, i installed asterisk 1.8 from repo: https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages And Looked at this article about CDR in mysl. http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql I installed asterisk-mysql pacakge from debian repo. The cdr in mysql is working, but i can not get cdr adaptive colums are not, i use this in my extension.conf exten =>

Hi Rosario, I have a problem about CDR: inbound calls are not correctly logged in CDR, it says they are always answered even if they are not. It is very strange since outbound calls and internal calls don't suffer this problem. I'll tell you more: I made Asterisk print the DIALSTATUS variable and it is ok, says BUSY when my internal hardphone SIP is busy. Or maybe it is allright and

> Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my cdr.conf so: > >

Luca Bertoncello wrote: > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my

Hello, I have now been playing with Asterisk for about a week and absolutely love it! Unfortunately I seam to be having a problem with cdr records and mysql via the ODBC method It would appear to all be set up properly, and I am able to successfully. log inbound/outbound activity into my mysql cdr database. All the inserted values appear to be correct and meaningful but for the Duration

I am experiencing a very wired problem. Some of my cdr are lost. I use logging cdr to csv, mysql and odbc. But some of them are lost. They miss in csv mysql and odbc, so i'm pretty sure it is related to asterisk functioning. I am running asterisk 1.0.7; this is simple configuration file: extensions.conf [general] static=yes writeprotect=no [macro-gw-voipjet] exten =>