similar to: mysql debug

Hi All, I found app_radius and cdr_radius, but I'm not sure how to use them. They are poorly documented. There are a few open source billing systems (trabas) out there that use radius as the cdr method and I'm wondering how this can be integrated with *. Just adding cdr_radius, like cdr_mysql doesn't work.. Does anyone have any ideas? Anyone know of a billing system that can just use

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 all, I think I've run out of options in terms of what I know about this. I have created a user called asteriskuser and granted all privileges to the asteriskcdrdb database. Then I created the table via the cdr_mysql.txt file. I have edited the cdr_mysql.conf file to reflect this, and added load => cdr_addon_mysql.so after compiling it from the latest CVS. If I check the

hi there :) i get this error in the asterisk CLI: Sep 21 20:31:49 ERROR[3774]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away when I run 'cdr mysql status' i get: Connected to voiceone at localhost, port 3306 using table cdr for 18 minutes, 24 seconds. Wrote 8 records since last restart and 1 records since last reconnect. I

Hi all, I've just realized that my asterisk isn't storing cdr inputs in mysql. cdr_mysql.conf is well configured and I don't know what else should i configure. I'm using Xorcom's packages, "cdr status" shows: voip*CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend: csv CDR registered backend: cdr_manager CDR registered backend:

At approximately 3:15pm I shut down the office MySQL server to change out some hardware. Shortly after I received a call from one of two customers whose asterisk servers output CDR data to that server. They could not place or receive calls. Shortly after that I received a call from the other customer. I'm below providing output from the message log (At debug level). I don't see much

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

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:

Hi, Need help on mysql cdr, i keep on seeing this log on the console. but my db is up and i see the calls being logged on the cdr table. is there a timeout when there is no activity? can i remove the timeout if there is any? thanks [Nov 25 13:22:37] ERROR[21026]: cdr_addon_mysql.c:171 mysql_log: cdr_mysql: Server has gone away. Attempting to reconnect. [Nov 25 14:20:32] ERROR[21061]:

Hello all, I'm trying to activate (on Asterisk 1.6.0.13) the cdr_mysql addon, but without success. Is there a proper online manual that describes all the steps to follow and debugging/monitoring information? When I type in the CLI "module show", cdr_addon_mysql.so is not listed, although in modules.conf, I added the line "load => cdr_addon_mysql.so". I also tried

Hi all, I have been looking at some billing solutions for asterisk. I saw there is Trabas VoIP Billing which apparently is working through radius cdr records, and also astPP which was recently released, and CDRTool. Has anyone been able to succeffully use radius with asterisk for CDR records? I tried app_radius with freerdius according to the wiki docs, but the Radius(CPP) keeps playing a

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

How can I download the asterisk-addons and setup CDR support for mysql? I reviewed the wiki but did not find instructions on dowloading. Just a sample of the cdr_mysql.conf file. DaL -- David A. Lauer Network Engineer Tristar Communications dalauer@tristarcorp.net 954.977.8081 ext. 21

Hi, there are something that is using mysql instead postresql? If I modify the modules.conf, and write load => cdr_mysql.so get this error: loader.c:240 ast_load_resource: /usr/lib/asterisk/modules/cdr_mysql.so: cannot open shared object file: No such file or directory loader.c:359 load_modules: Loading module cdr_mysql.so failed! Ok, there is no cdr_mysql.so, anybody it's using * with

For the information of others (and Google) this is the table structure I used to get cdr_mysql working: CREATE TABLE cdr ( calldate varchar(255) NOT NULL default '', clid varchar(255) NOT NULL default '', src varchar(255) NOT NULL default '', dst varchar(255) NOT NULL default '', dcontext varchar(255) NOT NULL default '', channel varchar(255)

Hi guys, I would llike to ask for your help on a problem I'm having with the cdr functionality. I installed asterisk 1.0.4, and asterisk-addons-1.0.4 and followed the procedures for installation and mysql configuration. Everything seems fina. The cdr_mysql module is loaded, and I get no error messages. But the cdr's are not going to the mysql database, they are going to a csv file in

Here is a log from a recent call made out on a ZAP channel from a SIP phone inside my network. For some reason, CDR is billing time even though the "busy tone" was detected. It's also logging the call as ANSWERED. Is this normal behavior? Seems a little odd to me. I have this as the first 3 lines of my zapata.conf [channels] busydetect=1 busycount=3 CVS HEAD updated late

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, I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call record. Therefore I dive into the source code to add the start and end time into the query (add something like cdr->start, cdr->end), but end up getting segfault. the original version of cdr_mysql.so works fine but I need the start time and end