similar to: cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed

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,

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 don't know if I have something screwed up with my MYSQL installation/Asterisk install or a bad configuration. 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

Hey all, I just got around to trying out CentOS 7. And for some reason when I attempt to install mysql-server, instead I'm offered mariadb? I'm using epel and remi as my repos. [root at web1:/etc/yum.repos.d] #cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.0 (Maipo) [root at web1:/etc/yum.repos.d] #yum repolist Loaded plugins: amazon-id, rhui-lb repo id

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 there :) i get this error in the asterisk CLI: Sep 21 20:31:49 ERROR[3774]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away when I run 'cdr mysql status' i get: Connected to voiceone at localhost, port 3306 using table cdr for 18 minutes, 24 seconds. Wrote 8 records since last restart and 1 records since last reconnect. I

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 get the following after a call has finished: ERROR[6862]:mysql_log: cdr_mysql: Unknown connection error: (2006) MySQL server has gone away Does this error message only appear when asterisk makes a new connection to mysql, because the old connection was stale (and dropped) ? If so, is there a way to get asterisk to stop reporting this as an error seeing it seems to write the CDR to

I am trying to compile current cvs asterisk-addons for mysql cdr but I get the following error. Iam running mysql 4.0.20 and cvs v1 stable version of asterisk. cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/local/mysql/include -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

Hi i have an issue getting agentLogin working /etc/asterisk/queues.conf member => Agent/1001 member => Agent/1002 extension.conf exten => 110,1,Wait,1 exten => 110,2,AgentLogin() now, i call 110 by a firefly client, trying to login in as 1001 agent: Aug 12 16:31:36 DEBUG[1103408048]: chan_sip.c:4423 build_route: build_route: Contact hop: <sip:sip3@192.168.1.151:5060> --

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 recently installed mariadb-server 10.1 by adding the following repository: baseurl = http://yum.mariadb.org/10.1/centos7-amd64 ...all was well until we had a power failure and upon rebooting unixodbc was segfaulting. Once I did a yum undo, the mysql odbc driver was functional. I traced it to the following: [root at ec-ast yum.repos.d]# ldd /usr/lib64/libmyodbc5w.so | grep -iE

Hi, I would like estimate a model for function of production's Coob-Douglas using maximum likelihood. The model is log(Y)= beta[1]+beta[2]*log(L)+beta[3]*log(K). I tried estimate this model using the tools nlm ( ) and optim ( ) using the log-likelihood function below: > mloglik <- function (beta, Y, L, K) { + n <- length(Y) + sum ( (log(Y)-

Hi, I apologize for a portuguese message at this group, but I am trying to reach brazilians who read this great group. It''s about the release of the first Ruby on Rails book for the brazilian audience. Here it goes: Galera, finalmente terminei de escrever o livro e entreguei o material para a editora esta semana, agora resta esperar at? que eles nos digam quando ser? a data do

Bom dia galera! Venho aqui divulgar e buscar feedback de vocês sobre o lançamento de um novo site. Chama-se http://www.taxei.com.br um novo modelo de compras na internet. Desenvolvido em: Ruby On Rails + MongoDB Você diz quanto quer pagar por um produto, e os lojistas recebem todas as ofertas que os usuários estão criando. Se interessar ao lojista "cobrir" aquela oferta, ele aceita e

What's going on here? 555* seems to indicate that the number is being passed as the callerID because NoOp says the phone number. I'm trying to emulate cell phone voicemail where you call your own number to check your voicemail. -- Accepting AUTHENTICATED call from 65.182.165.XXX: > requested format = gsm, > requested prefs = (), > actual format

Hello, I am using CDR mysql to log to remote server: in modules.conf, I preload the modules: [modules] preload => cdr_mysql.so preload => app_mysql.so and in cdr_mysql.conf, I have all the details defined (hostname, dbname, table, password, user, port). In a situation when I start asterisk, and the remote database in unreachable, asterisk waits for several minutes before it actually

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

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