search for: cdr_mysql

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

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

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: [glo...

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

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: http://lists.digium.com/pipermail/asterisk-users/attachme...

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

...ersion of asterisk. So I downloaded 1.8.5, extracted the tar, ran configure, make, make install ... Everything looks fine (no obvious compile/link errors). But as soon as I start asterisk, it dies with a segfault. I executed asterisk within strace and last action before the segfault was reading cdr_mysql.conf in. I deleted cdr_mysql.conf and asterisk starts normally. I copied cdr_mysql.conf.sample to /etc/asterisk and asterisk starts normally Then I just uncommented the "hostname=" line and asterisk segfaults during startup. So what could be wrong here? I have packages "libmysqlc...

...guration. 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 of my cdr_mysql.conf [global] hostname=192.168.2.9 dbname=asteriskcdr user=asteriskcdr password=<password> port=3306 sock=/tmp/mysql.sock The error I am getting is: ERROR[1209214400]: File cdr_mysql.c, Line 71 (mysql_log): cdr_mysql: cannot connect to database server localhost. Call will not be logged....

Hi list! I'm getting this error frequently: ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to database server localhost: (2026) SSL connection error: SSL_CTX_set_default_verify_paths failed Right now, as a workaround, I reload Asterisk via cron once an hour, and after the reload everything is fine again _for a while_. Still, over the course of a month...

...e 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 of use and would greatly appreciate any help that could be given. Andrew Jun 9 15:16:05 ERROR[29101] cdr_addon_mysql.c: cdr_mysql: Unknown connection error: (2013) Lost connection to MySQL server during query Jun 9 15:29:49 ERROR[29382] cdr_addon_mysql.c: cdr_mysql: Unknown connection error: (2013) Lost connection to MySQL server during query Jun 9 15:31:51 WARNING[4918] channel.c: Avoided initial deadlock for '0x2aaab3...

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

I did an upgrade to the SVN trunk on the 12/9 and when I looked in my mysql table for CDR's today there are no entries since the update. I have rebuilt and re-installed and re-started asterisk still no CDR's flowing to mysql. I did not change any configs. I checked to make sure that the cdr_mysql option was selected under the make menu options. The module shows it is there when I do a modules show. I don't get any errors saying it can't write to the table. My voicemail settings are pulling from the same server. Any ideas on what I could try to fix this or how I could test to s...

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

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) 285-7200 david@safedatausa.com

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

...DEBUG[2661]: Stopping retransmission on '366b24810a0bb91355fbb4ba7d9a27ef@127.0.0.1' of Request 103: Found Dec 10 01:33:23 DEBUG[2661]: Registration successful Dec 10 01:33:23 DEBUG[2661]: Cancelling timeout 1 Dec 10 01:33:23 DEBUG[2661]: Setting NAT on RTP to 4 Dec 10 01:33:23 DEBUG[2649]: cdr_mysql: got hostname of localhost Dec 10 01:33:23 DEBUG[2649]: cdr_mysql: got port of 3306 Dec 10 01:33:23 DEBUG[2649]: cdr_mysql: got sock file of /var/lib/mysql/mysql.sock Dec 10 01:33:23 DEBUG[2649]: cdr_mysql: got user of XXXXXXX Dec 10 01:33:23 DEBUG[2649]: cdr_mysql: got dbname of XXXXXX Dec 10 01:3...

<P>hi,</P> <P>Can anybody pls tell me how to activate loggin CDR on mysql db. I tried&nbsp;editing the /etc/asterisk/cdr_mysql.conf file and recompiling asterisk, it didn't work. Normal loggin on Master.csv file works fine.</P> <P>Thank you inadvance,</P> <P>Surajee</P> <P>&nbsp;</P><br> --------------This mail sent through OmniBIS.com--------------

Hi, I intend to change the cdr_mysql-field "uniqueid", which seems not to be used so far, to an (not unique) indexed field and use it later for my own hints and infos. I don't have very much traffic so far, and I wonder, if there will appear problems when asterisk is under high load (100 simultanious calls) and the log...

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 => s,n,Set(RECORDFILE=/var/s...

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! Tomica Crnek -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20040202/49c83d04/attachment.htm