similar to: CDR with MySQL and Asterisk PID File

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

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:

Hello, We have finally upgraded to Asterisk 1.4, however we've run into two issues that weren't occurring before the upgrade. Issue #1: We're an outgoing call center and need to record all calls. We use the uniqueid field in the CDR to match with the recording, which we labeled with {UNIQUEID} in MixMonitor. For some reason, the uniqueid is not correct in the CDR. Here is the

Hello list, I keep on getting the error : ERROR[1707] cdr_addon_mysql.c: Cannot connect to database server 127.0.0.1: (1045) Access denied for user 'asteriskcdr'@'localhost' (using password: YES) I have a 'cdr' table in my MySQL-DB. On this table the user 'asteriskcdr' has select, insert, update privileges. GRANT SELECT , INSERT ,UPDATE ON `Asterisk`.`cdr`

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

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

I'm having problems compiling cdr_addon_mysql with MySQL 3.23.58 I get the following errors: cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o cdr_addon_mysql.o cdr_addon_mysql.c cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function

Hi there: I have successfully installed the Asterisk 1.0.9 on my Freebsd 5.4 box. When I tend to install the addon for mysql CDR billing, It always return me the following errors: SIP# gmake clean rm -f *.so *.o .depend gmake -C format_mp3 clean gmake[1]: Entering directory `/usr/home/wilson/asterisk/asterisk-addons-1.0.9/format_mp3' rm -f *.o *.so *~ gmake[1]: Leaving directory

Hi All, http://www.voip-info.org/wiki/index.php?page=Asterisk+func+cdr Under example: exten => s,2,Set(CDR(MyFavoriteBand)=Foo Fighters) exten => s,3,Set(CDR(MyFavoriteSong)=Hero) and under description: -userfield: The channel's user specified field. ""-any custom value that you wish to store."" My question is how do you setup more custom fields in the cdr and be

Hi All, I have some Asterisk 1.2 servers using the cdr_mysql addon (1.2.3) spitting cdr's over to a MySQL database on another server. All is working well except for a strange problem I ran into this morning. During some cdr database maintenance, the cdr table was locked for a few minutes, during this condition all the Asterisk servers stopped processing calls and reported this error: Jan 5

Hi Every one and Lerale Erwan I have briefly describe my problem and I have provide the steps as follows: I have intalled redhat properly and from the konsole I checked with mysql. "rpm -qa | grep mysql" and the konsole provide me the message: mysql-3.23.54a-11 mysql-server-3.23.54a-11 Then I have download the asterisk and addons: By the using of : cd /usr/src export

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

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 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 write the CDR of my Asterisk 1.2.17 server in MySQL database using cdr_addon_mysql.so. Now I'm trying to write some custom values to userfield column by the SET(CDR(USERFILED)=SOME_TEXT) sintax, but nothing gets writeen in MySQL cdr table!! Why? I'm I skeeping something or what? Taking a look at the URL:

I'm unable to set any cdr fields except userfield and accountcode using Set(CDR(lastapp)="foo") [for example]. This is 1.2.4. I'm using the cdr_addon_mysql plugin, which handles userfield, accountcode, and uniqueid fine. Is this broken in Asterisk, or the addon? The addon code looks like it's just copying what's passed in. Eric.

running make gives: cdr_addon_mysql.c:50: warning: parameter names (without types) in function declaration cdr_addon_mysql.c:50: warning: data definition has no type or storage class cdr_addon_mysql.c: In function `mysql_log': cdr_addon_mysql.c:108: error: `mysql_lock' undeclared (first use in this function) cdr_addon_mysql.c:108: error: (Each undeclared identifier is reported only

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

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!