similar to: re: cdr_mysql and system time

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

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

Hi. here is a brand new cdr_mysql . Is based on the previous one, but with lots of changes, so I include here the whole file, not a patch. What I've changed: added new fields, in order to reflect cdr csv : * call start time * call answer time * call end time * call unique id Changed the table structure to reflect cdr.h lengths. Added some (a lot?) sanity checks, to be sure to insert

How to enable cdr_mysql.conf in Asterisk 1.6? I have installed asterisk-addons which compiled mysql support, "module show" is showing "cdr_addon_mysql.so" but cdr_mysql.conf was not created in /asterisk directory Is there any configuration file to enable mysql support? Comping cdr_mysql.conf from previous installation does not do anything, calls aren't recorded. --

Hi; I have problem inserting cdr to mysql,Asterisk has logged to asteriskcdrdb successfully.It says: Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:178 mysql_log: cdr_mysql: inserting a CDR record. Dec 6 13:36:26 DEBUG[1221985728]: cdr_addon_mysql.c:197 mysql_log: cdr_mysql: SQL command as follows: INSERT INTO cdr

I have a simple cdr configured with the default tables, here is a row of a good cdr report calldate | clid | src | dst | dcontext | channel | ect ..... ect .... 2008-08-29 10:16:49 | "C. BOUTON" <40> | 40 | XXXXXXXXXXX | phonesystems | SIP/40-08776938 | ect ..... ect .... I have replaced the number by

Hi, I configured cdr_mysql (addons 1.0.9) to write the cdr records to the mysql db. The problem is that no records are written to the db. Why? I can import the csv-file to the db. so i assume the db is setup correct. Is there any chance to get debug from cdr_mysql to find his problem? This is my cdr_mysql.conf file: [global] hostname=localhost dbname=cdr password=passw0rd user=root ;port=3306

hello, after playing with an asterisk configuration for voip for a few weeks i'm trying to get outbound dialing with voicepulse going - i've cut down the asterisk to a very minimal install (1 SIP client) to try to localize the problem. The SIP client works fine (SIP and * on the same NAT) and could access the demo from samples before i removed it, and can call itself - so i am

Hi all, I have a strange problem, regarding zap channels and cdr. I am using asterisk bristuffed version Asterisk 1.2.2-BRIstuffed-0.3.0-PRE-1i, Copyright (C) 1999 - 2006 Digium, Inc. and others. with two billion ISDN cards. I also installed asterisk addons, last stable version via cvs internal calls, or calls starting from internal sip or iax phone are recorded in the cdr all without any

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

Can anyone give me presise instructions on how to compile cdr_mysql.so? When I initially installed asterisk on the system, I didn't have mysql installed. Since then I have installed mysql, created the database and table structure for cdr_mysql and placed the appropriate settings in the cdr_mysql.conf file. However when I do a show modules at the CLI I cannot find cdr_mysql.so.

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

Hi all, I'm looking at the mysql cdr backend to record call details, but I can't find any documentation on how to set up my database. Specifically, what is the table definition for the cdr table? I saw that the dbname, user and password can be set in cdr_mysql.conf, but there's no information on what table to use. Thanks, Gijsbert

hello all, i need some help and after trying the wiki i'm even more confused than i was. i'm trying to set up call forwarding and running into problems... i want the most basic call forwarding imaginable. 1. caller dials extension (say, 154) 2. dialplan is updated to forward caller's extension (based on CALLERIDNUM) to voicemail, instead of ringing his endpoint. 3. caller is

Hi, I'm currently running CVS-HEAD 2005-09-03 I do plan to upgrade to the newest version, but need to do some testing with it first. In the mean time... does anyone know what these messages below are about? I've never seen it before, but when it happened it locked Asterisk up pretty good. Feb 10 10:16:51 DEBUG[14917] chan_zap.c: Echo cancellation already on Feb 10 10:16:57

I'm trying to compile the cdr_mysql module, but I am receiving error messages. I have installed mysql-devel. Here is the output of make cdr_mysql: cc -fPIC -I/usr/local/mysql/include -I/usr/include/mysql -c -o cdr_mysql.o cdr_mysql.c cdr_mysql.c:30:26: mysql/errmsg.h: No such file or directory cdr_mysql.c: In function `mysql_log': cdr_mysql.c:74: `CR_SERVER_GONE_ERROR'

Hi everybody, Firstly I'm going to describe the scenario where I'm working. I use a E400P with Asterisk CVS-05/22/03-11:14:50, and I'm working with asterisk trow AGI scripts (Perl). The configuration of extension.conf is: exten =>_s,1,Answer exten =>_s,2,AGI,script.agi Inside the AGI script is call Dial application as follows: print "EXEC Dial

I used the "FreePBX on Debian" HowTo at http://powerontech.com/freepbx-on-debian.htm to install. I use callfiles to initiate calls to my SIP carrier. They get my registration, but they see that my call is interrupted before they can complete the connection. My Asterisk log shows that the call times out after the time (45s) specified in my dialplan Dial() command. What is wrong? [from