similar to: storing CDR records in a MySQL database

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

Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Thanks!

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

Hi, I have installed asterisk-1.4.4 and asterisk-addon-1.4.1. I followed every step to configure RealTime but something is not working properly; the warning that I am geting is: WARNING[32709]: config.c:1229 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available WARNING[1359]: config.c:1229 find_engine: Realtime mapping for

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 have Fedora Core 2 running with a T1 card. I try to put the log on db but I get the error: Aug 20 15:17:47 ERROR[262160]: cdr_addon_mysql.c:378 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database exists and I try with "mysqlaccess localhost asteriskcdrdb" and I get: Access-rights for USER 'localhost', from HOST

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@H 2.1, running * 1.2.1. I am trying to put information into the userfield with SetCDRUserField and AppendCDRUserField. However, the field is never populated in the cdr - I've checked the csv files and the MySQL asteriskcdrdb table. The field is defined in the MySQL table, but is always empty. The csv files that get created don't have a userfield at all, that is, there

i am getting 403 Forbidden message from asterisk when it try to register my user agent. i am basically useing mysql through ODBC. i hvae checked ODBC connecteion with 'ODBC Show' command. ------------------------------------------------------ *CLI> odbc show Name: mysql1 DSN: asteriskdsn Connected: yes *CLI> ------------------------------------------------------ and user is added to

I'm testing Teliax tall free number line and I'm experiencing long delay about 1sec. during conversation. When I call myself over FWD the response is normal no delay or cut messages. When I call my number over FWD the is a long delay, welcome message usually cuts off few first words and during conversation my voice arrives after about 1sec. delay. Since, the 800-number is only accessible

Hi, I would like to see the DNID in my MySQL CDR logs. I have read one big thread in the Asterisk Developer List, but I could not figure out how to implement it ? Is there a simple step-by-step. Thx in advance. Vai

I have asterisk 13.5 configured with a simple dial plan, 3 SIP clients two Laptops and smartphone with softphones installed. Now I am trying to store cdr into a database but not able to make a connection of ODBC drivers to MySQL is there an option or anything. Thanks in advance My configuration:: *sip.conf* [general] trasport=udp ;Data format | sample commennt [template01](!) type=friend

Hi Guys I am just looking around for a small billing program but can't really find what I am looking for. It needs to bill straight off the CDR. It should grab all the CDR records from the asteriskcdrdb mysql database then have a rates table to that it calculate a bill from. Is there any open source packages or commercial packages that will account for billing say only 5 extensions?

I have a bunch of CDR records in the mysql database "asteriskcdrdb" on a FreePBX system. There is a DAHDI trunk defined in FreePBX which uses the "gN" identifier to make calls. So in this setup the trunk is roughly equivalent to a DAHDI logical group. I want to know, given a CDR, which logical group (and therefore, trunk) was used to place the call, or was used to receive the

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

> On 2020-06-06 10:38, Antony Stone wrote: > On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote: > >> In a situation when I start asterisk, and the remote database is >> unreachable, asterisk waits for several minutes before it actually >> starts (before it loads sip module, etc). >> >> And when database is unreachable during operation, when call

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