similar to: cdr mysql problem

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'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 everyone, I want to have a group and dial multiple phones/lines simultaneously. If I use this Dial command: exten => 222,2,Dial(${TRUNKBP}/246&SIP/258&${TRUNKBP}/243,20,tTr) ... all phones ring just once, after that only the first one continues ringing and only that one can answer. Can anyone tell me why? thanks! Tomica -------------- next part -------------- An HTML

Dear Tariq; About elastix.org, this can be use with Asterisk or it is coming as a complete IP Telephony, Call Center, IVR and Reporting? Because, I do not need to install another IP Telephony on the server which already has asterisk which is an IP Telephony, this will cause a problem in the service (for example, when listening for SIP port of 5060).

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

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session

Hi everyone! Here is my configuration and messages taken from Asterisk startup. The E1 PRI trunk is connected to our national telecom company here in Croatia. When I call from outside over this trunk to my company I get 'error in connection' respnse. In the same moment I can't see anything in Asterisk, nothing that will tell me that the call reached Asterisk. I think there is a

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

has anyone seen this? -- Starting Skinny session from 192.168.13.102 -- Starting Skinny session from 192.168.13.102 triton*CLI> Oct 15 13:44:05 WARNING[213019]: File chan_skinny.c, Line 2243 (get_input): Skinny Client sent less data than expected. Oct 15 13:44:05 NOTICE[213019]: File chan_skinny.c, Line 2301 (skinny_session): Skinny Session returned: Success Oct 15 13:44:05

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 everyone, Maybe someone could help me. I have Asterisk in production with TE410P connected to PSTN. When I call from internal phones, either voip or connected via other PRI trunk, to PSTN and if the called phone is busy I don't hear anything!?! I should hear tone indicating that called number is busy. I have played with busydetect and callprogress in zapata.conf, but I didn't find

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

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, 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 everyone, Has anyone experience with xten.net's X-Lite SIP softphone and asterisk? I have a problem and I think X-Lite is not even trying to contact SIP proxy while dialing. Tomica ---- This mail was sent thru ZGWireless free network - www.zgwireless.net, Internet connection sponsored by Iskon Internet d.o.o. - www.iskon.hr

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

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