similar to: how to insert dynamic hostname into shared CDR database

cdr_mysql doesn't set the userfield when it's set inside a macro called from a feature (1.4.25, addons 1.4.8). I have a feature code: autorecord => *1,self,Macro,apprecord The apprecord macro looks like: [macro-apprecord] exten => s,1,Playback(beep) exten =>

Hello list, I keep on getting the error : ERROR[1707] cdr_addon_mysql.c: Cannot connect to database server 127.0.0.1: (1045) Access denied for user 'asteriskcdr'@'localhost' (using password: YES) I have a 'cdr' table in my MySQL-DB. On this table the user 'asteriskcdr' has select, insert, update privileges. GRANT SELECT , INSERT ,UPDATE ON `Asterisk`.`cdr`

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 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?ve an issue whit CDR using asterisk 1.4.23.1. I?ve configured mysql to store cdr information, but, while I put into cdr_mysql.conf the field ?userfield=1? and doing a query I found that this field is empty in the cdr table. On the other hand I can?t find records in the cdr table that show me calls generated through AMI using Originate Action, that?s calls are not stored in the CDR, but I

Hi, I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install. The add-ons pack has been installed for a while, so now I'm trying to add the Mysql config. I've created a mysql database, added the grants for a user acces, and can run a mysql -u asteriskcdruser -p and can connect to the database. I've been using this as a guide:

So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the database structure for cdr_mysql is: CREATE TABLE cdr ( calldate datetime NOT NULL default '0000-00-00 00:00:00', clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '', channel

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

Hi, Asterisk version : 1.2.7.1 stable version We try agent.conf setting of createlink=yes We always can not see this link value to be filled in MySQL's table filed : userfield But we can see the record file has been created correctly. In debug mode, no userfiled shown in SQL command, May 17 18:10:51 DEBUG[2889] pbx.c: Function result is '"unknown" <2001>' May

Paul, Thanks - it worked! For the record, this is exactly what I did: cd/usr/src/asterisk/cdr grep -in "userfield" cdr_csv.c (to find the line that had "#define CSV_LOGUSERFIELD 1" commented out) Opened cdr_csv.c and removed the /* and */ comment marks Saved & exited After shutting down * I went to /usr/src/asterisk and did the usual: Make clean Make Make install I also

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

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

Hi guys, I have recently installed a Asterisk Server with CDR Call Detail Records. I have installed it over a Asterisk 1.2 , but now It do not run . I have installed it with the following procedure: # yum install ncurses #yum install openh323-devel # yum install mysql-server # yum install mysql # yum install php-gd # yum install php-mysql # yum install mysqlclient10 # yum install zlib # yum

Hello, I have a TDM400P with 2x2 configuration of FXOs and FXSs. I set a test extension of '444' to dial out a specific zap trunk and call a local #. First time I call out to '444' everything works fine. If I hang up the call, and within 10 seconds dial the same number again, I get a fast busy. Seems it isn't letting go of the trunk or something, and I don't have a

I want to set some custom data in the field of userfield in table CDR as following. exten => s,19,Set(CDR(userfield)=1234) exten => s,20,Dial(SIP/1234) However, the userfield doesn't get update after making the call. After that, I relocate the command as following. exten => s,19,Dial(SIP/1234) exten => s,20,Set(CDR(userfield)=1234) The userfield doens't get update at all. I

Hello I just settup a realtime mysql table for sip_peers. All peers (friends) is autenticateing but when i want to initiate a call between them i got the following error. Someone have some ideea? Thank you. ---<Cut Here>--- pbx*CLI>console dial 1014 == Console is full duplex -- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new stack

Hello, I am running asterisk 1.4.22 and Iam recording calls in agents.conf with the following configuration: recordagentcalls=yes recordformat=wav createlink=yes The calls are being recorded , but no entry appears in mysql cdr, and, on the other hand I have other pbx running asterisk 1.2 that do it with the same configuration. In cdr_mysql.conf I have: userfield=1 accountcode=1 Is there a

I noticed a problem this morning with our cdr logging. We have a cron job that places a call file into the spool directory having asterisk call itself to check to make sure its still handling incoming calls correctly, then queries the CDR database in mysql and makes sure that appropriate records exist. I can confirm that the call is happening correctly, but I'm missing records in the

Hi everybody, i've been googling for quite some time now but can't find an answer to my problem... I'm using Asterisk 1.2.12.1 with mysql as the cdr backend. In the dialplan i've written exten => 1234,n,Set(CDR(userfield)=blah) exten => 1234,n,Answer() exten => 1234,n,Queue(.....) exten => 1234,n,Hangup() When I'm doing a call I can see that the statement is