similar to: cdr_mysql losing logs

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

hi all, does anyone know what time variables are fed to to the "calldate" field in cdr_mysql? I have my system time set to israel time zone, have restarted mysql and a show variables shows timzone as "IST" which means now() should return israel time, but the calldate field keeps getting the system clock. I don't have the source for asterisk-addons handy so i can't

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

Due to management concerns our asterisk system has been setup to record all phone calls for some time now (before the 1.0 release). Everything was working fine until we upgraded 1.0.5 where all calls are recorded except those that pass through a queue (we are not using the queue record functionality because there are some minor issues with using it in our scenario). Specifically, the

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

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

Hey, Have i done something wrong or is there something wrong with latest CVS and cdr_mysql, cause after checking out latest CVS today, I got warning: [cdr_mysql.so]WARNING[1074424544]: File loader.c, Line 226 (ast_load_resource): /usr/lib/asterisk/modules/cdr_mysql.so: undefined symbol: uncompress WARNING[1074424544]: File loader.c, Line 345 (load_modules): Loading module cdr_mysql.so failed!

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

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.

I don't know if I have something screwed up with my MYSQL installation/Asterisk install or a bad configuration. I have imported the tables into a MYSQL database residing on localhost. I have check permissions on the user as well as the password and I have the same error comin up. I have succesfully connected to the database remotely and with MYPHPAdmin with the same setting below is a copy

Considering that I had a failure with compiling the latest version of asterisk because of cdr_mysql, I am going to assume that I need to have a copy of the mysql headers on the system in order to compile cdr_mysql.so. Does that sound correct? Kim C. Callis -------------- next part -------------- An HTML attachment was scrubbed... URL:

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'

I'm reading voip-info.org http://www.voip-info.org/wiki-Asterisk+cdr+mysql Sorry if this is a dumb question, but: It says I need mysql and mysql-devel to compile cdr_mysql, but I don't want mysql on my asterisk box I want to connect to a remote mysql server. Can I use mysqlclient and mysqlclient-devel? Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network Engineer Safe Data, Inc. (910)

I need to install cdr_mysql.so module for logging call to mysql. I have the source file cdr_mysql.c only. Can someone explain the steps needed to get this module compiled and working in Asterisk 1.8.22.0 on CentOS. Thanks. Nick -------------- next part -------------- An HTML attachment was scrubbed... URL:

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'm using the "accountcode" field in cdr table to store some temporary information used by my perl scripts. I'm finding that the field seems to be truncated to 19 characters, even though the allocated field in the table is larger (varchar(45)). Anyone familiar with the asterisk sources know where I can make a change to keep this from happening? ie: to allow more

Most of my outbound calls are handled by macro contexts: [macro-pstn] exten => s,1,Wait(.5) exten => s,2,PlayBack(beep) exten => s,3,PlayBack(silence/1) exten => s,4,Dial(${ARG1}/${ARG2}${ARG3}) exten => s,5,Playtones(Congestion) exten => s,6,Wait(3) exten => s,7,Hangup which is called like exten => _920[1289]XXXX,1,Macro(pstn,Zap/g1,9,${EXTEN:${TRUNKMSD}}) Because of

I just upgraded from ver. 0.9 to 1.0.5 on Gentoo (from portage) and when I try to reload my settings I get: == Unregistered 'mysql' CDR backend == Parsing '/etc/asterisk/cdr_mysql.conf': Not found (No such file or directory) My phone or SPA-3000 will not register with asterisk either. I've copied the Sip.conf; extenson.conf and iax.conf from old version to 1.0.5 -- #Joseph