similar to: cdr_mysql: cannot connect

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`

I'm trying to add cdr_odbc.so to log my CDR data to a mysql DB. I've managed to compile everything, and seem to almost be ready to head home. I've added a small debug line to cdr_odbc.c as follows: if((ODBC_res != SQL_SUCCESS) && (ODBC_res != SQL_SUCCESS_WITH_INFO)) { if(option_verbose > 10) ast_verbose(

It seems that I can never get through a phpmyadmin session w/o it hanging on "Waiting for http://....". The only way I have found to correct this is to cycle Apache. I can always get past the signon portion, but it hangs at various portions of selecting DBs or Tables. CPU is not overly active, all httpd daemons running, no myphpadmin remnants running. Can't find any problems in

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

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 previous installation does not do anything, calls aren't recorded. --

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 cannot find cdr_mysql.so.

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:

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_log': cdr_mysql.c:74: `CR_SERVER_GONE_ERROR'

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)

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. 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 lengths. Added some (a lot?) sanity checks, to be sure to insert

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

I need to install cdr_mysql.so module for logging call to mysql. I have the source file cdr_mysql.c only. Can someone explain the steps needed to get this module compiled and working in Asterisk 1.8.22.0 on CentOS. Thanks. Nick -------------- next part -------------- An HTML attachment was scrubbed... URL:

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

Hello- I'm using the "accountcode" field in cdr table to store some temporary information used by my perl scripts. I'm finding that the field seems to be truncated to 19 characters, even though the allocated field in the table is larger (varchar(45)). Anyone familiar with the asterisk sources know where I can make a change to keep this from happening? ie: to allow more

Most of my outbound calls are handled by macro contexts: [macro-pstn] exten => s,1,Wait(.5) exten => s,2,PlayBack(beep) exten => s,3,PlayBack(silence/1) exten => s,4,Dial(${ARG1}/${ARG2}${ARG3}) exten => s,5,Playtones(Congestion) exten => s,6,Wait(3) exten => s,7,Hangup which is called like exten => _920[1289]XXXX,1,Macro(pstn,Zap/g1,9,${EXTEN:${TRUNKMSD}}) Because of

I just upgraded from ver. 0.9 to 1.0.5 on Gentoo (from portage) and when I try to reload my settings I get: == Unregistered 'mysql' CDR backend == Parsing '/etc/asterisk/cdr_mysql.conf': Not found (No such file or directory) My phone or SPA-3000 will not register with asterisk either. I've copied the Sip.conf; extenson.conf and iax.conf from old version to 1.0.5 -- #Joseph

hi all, does anyone know what time variables are fed to to the "calldate" field in cdr_mysql? I have my system time set to israel time zone, have restarted mysql and a show variables shows timzone as "IST" which means now() should return israel time, but the calldate field keeps getting the system clock. I don't have the source for asterisk-addons handy so i can't

On Monday 08 June 2020 at 12:15:56, Markus wrote: > 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 Hmmm... talking to localhost over SSL... seems a bit computationally wasteful. > Right now,

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 I lose about