similar to: CDR database.

Hello list, I've posted my problem on BSD list and i still have the problem. The remote side receives the call , but there's no voice on the call. I tried everything about possible NAT problems .. but ther're on same net. My platform: FreeBSD 5.2.1-Release Asterisk 1.0-RC2 soft phones : X-Lite >>>> -- Executing Dial("SIP/1260-a7ae", "SIP/1262|20")

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

Hello All , In some ocasions i?m getting a problem with my X100P board. I?m trying to trace tre problem , but i didn?t find a possible answer. -> I get those messages when trying to use Zap Channel Sep 29 14:15:46 WARNING[-1094796368]: chan_sip.c:2107 sip_new: Unable to allocate channel structure Sep 29 14:15:46 NOTICE[-1094796368]: chan_sip.c:7283 handle_request: Unable to create/find

> 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: > >

I believe that Asterisk 1.8 and older uses the BerkeleyDB for Asterisk's internal database (AKA the Astdb) and in newer versions use SQLite. However, the basic functionality is the same. Whether you use the Astdb or MySQL really depends on what you want to do with it. The AstDB is not a relational database like MySQL, it simply a key/value store. If you can get away with that, and you need

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

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

Dear all, I'm trying to configure Asterisk to be able to ask the caller to enter a given password in order to continue dialplan execution. I've tested this feature using the Authenticate application like this: exten => _X./5219,1,Answer exten => _X./5219,2,Authenticate(1234,a) exten => _X./5219,3,Playback(pin-number-accepted) exten => _X./5219,4,Dial(SIP/${EXTEN},120)

Hello, I am using CDR mysql to log to remote server: in modules.conf, I preload the modules: [modules] preload => cdr_mysql.so preload => app_mysql.so and in cdr_mysql.conf, I have all the details defined (hostname, dbname, table, password, user, port). In a situation when I start asterisk, and the remote database in unreachable, asterisk waits for several minutes before it actually

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: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

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

I've upgraded my server from asterisk 1.2 to 1.4.18 and CDR has started to log two lines for each failed call (NO ANSWER) instead of one per call as it was done in 1.2. In my extensions.conf, call flow starts in default context and then jumps to a macro where is then dialed the destination. When call isn't answered CDR logs two lines, one with the s extension in "dst" and the

I notice you have MySQL-asterisk as your definition in your odbc.ini but you are trying to connect to simply 'MySQL' with your 'isql' command. Does isql work with 'MySQL-asterisk' as the DSN instead of simply 'MySQL' ? I have machines that use /etc/odbc.ini and machines that use /usr/local/etc/odbc.ini depending on if I used a package to instal ODBC or if I

Every once in a while (like 2 out of 7 times), I get the following message: [Nov 14 12:49:02] NOTICE[6855]: cdr.c:434 ast_cdr_free: CDR on channel 'SIP/5000-082508f0' not posted I look in the cdr table in mySQL and indeed, the record is not posted for that call. This makes me want to create hard file and a compare script between the file cdr and the odbc cdr, but I was wondering if

Hi, all Sorry for null subject last mail. I use Ubuntu 12.04.01 TLS and install asterisk 11.7.0 (tar.gz downloaded 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

Hi, I hope this can help others, so this is it. Use it at your own risk. I have test it on 3 separate systems without any problem. Take care to edit the following files taking into consideration your own settings. If you have all the CDR info in the Master.csv too, then delete all the data from the 'cdr' table in MySQL before running the script bellow in oder to prevent dupplicate

Hi guys, Does someone use a mysql database for accessing data and in the same time for storing cdr ? if that is the case, which module is used ? thanks -- Cyril SCETBON

I'm trying to use the MySQL CDR records. According to dialplan show, the line in the dialplan is: 11. Set(CDR(userfield)=${billing_code}) [pbx_ael] It looks like the value is being set when I watch the console during the call: -- Executing [s at restphone_event_loop:11] Set("SIP/icall-0075a2e0", "CDR(userfield)=boatmenu") in new stack But the record that's

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

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