Hi,
Am 08.06.2020 um 12:25 schrieb Antony Stone:
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:
On Mon, 8 Jun 2020 at 05:18, 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
>
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
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
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
--
How about
http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/asterisk-DB.html
?
jg
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory
On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman brya...@zktech.com wrote:
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
You can also enter into the CLI in order to see if you can spot any
error regarding cdr_mysql, or 'duplicated value for key...' after hangin
up a call.
There might be a corruption in the 'cdr' table (I've seen this
sometimes). You could try a 'repair table cdr' from the MySQL CLI.
Note:
dbackeb...@gmail.com
Sent: Thursday, December 23, 2010 10:59 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] cdr_mysql stopped working
On Mon, Dec 20, 2010 at 5:02 PM, Bryant Zimmerman brya...@zktech.com
wrote:
I did
, December 23, 2010 12:19 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] cdr_mysql stopped working
You can also enter into the CLI in order to see if you can spot any
error regarding cdr_mysql, or 'duplicated value for key
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
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 '-00-00 00:00:00',
clid varchar(80) NOT NULL default '',
src varchar(80) NOT NULL default '',
dst varchar(80) NOT NULL default
On Wednesday 30 December 2009 10:52:48 Robert Broyles wrote:
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 '-00-00 00:00:00',
clid varchar(80) NOT NULL default '',
src
Tilghman Lesher wrote:
On Wednesday 30 December 2009 10:52:48 Robert Broyles wrote:
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 '-00-00 00:00:00',
clid varchar(80)
Wednesday, December 30, 2009, 6:48:37 PM, Robert wrote:
Tilghman Lesher wrote:
On Wednesday 30 December 2009 10:52:48 Robert Broyles wrote:
Just curious if anyone has successfully patched cdr_addon_mysql to use
accept the latest cdr fields from 1.4 ... namely: 'start', 'answer', 'end'?
On Wednesday 30 December 2009 11:48:37 Robert Broyles wrote:
So my next question is could I take the cdr_mysql from 1.6's addons and
use it in 1.4?
No. The APIs are significantly different enough that a backport would
require a good amount of modification. However, there is a backport of
*
*
*
Hi there
I am using the cdr_mysql addon – I have set userfield = 1 and if i set a
Variable “Userfield” it gets to the database. Everything there is working as
expected.
My Query is... If i set a custom Variable EG
exten =
On Friday 01 May 2009 01:26:25 Kev Szaszvari wrote:
I am using the cdr_mysql addon – I have set userfield = 1 and if i set a
Variable “Userfield” it gets to the database. Everything there is working
as expected.
My Query is... If i set a custom Variable EG
exten =
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
:56 PM
To: 'Asterisk Users Mailing List - Non-Commercial Discussion'
Subject: [asterisk-users] Cdr_mysql compile question
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
Matthew Boehm a écrit :
sylvain garcia wrote:
Kib Eki a écrit :
Asterisk don't use directly mysql database for cdr, astersisk use
odbc and odbc connect to mysql.
So you must configure odbc corectly wiyt libmyodbc (on debian)
the config file are here:
Wrong. Asterisk can and does
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
Dear Kib,
As I believe the Realtime options concerning the mysql database can
only be used with the Asterisk CVS-HEADversion it's still not implemented
on Asterisk v 1.0.* .
Thx
MAG
Kib Eki wrote:
Hi,
I configured cdr_mysql (addons 1.0.9) to write the cdr records to the
mysql db.
The problem is
Kib Eki a crit:
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
: [Asterisk-Users] cdr_mysql does not write to mysql db
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
sylvain garcia wrote:
Kib Eki a écrit :
Asterisk don't use directly mysql database for cdr, astersisk use odbc
and odbc connect to mysql.
So you must configure odbc corectly wiyt libmyodbc (on debian)
the config file are here:
Wrong. Asterisk can and does connect to MySQL directly.
(Where
:44 AM
Subject: [Asterisk-Users] cdr_mysql does not write to mysql db
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
Mohamed A. Gombolaty wrote:
Dear Kib,
As I believe the Realtime options concerning the mysql database can only
be used with the Asterisk CVS-HEAD version it's still not implemented on
Asterisk v 1.0.* .
Thx
MAG
Wrong. He's not using RealTime. No where in his original post did he
mention
Kib Eki wrote:
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?
Do you have the module installed?
Is the module loaded?
What happens when you type cdr mysql status on asterisk command line?
You
- Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Wednesday, July 27, 2005 9:44 AM
Subject: [Asterisk-Users] cdr_mysql does not write to mysql db
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
On Wed, 2005-07-27 at 09:44 +0200, Kib Eki wrote:
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
Neal Lawson wrote:
using localhost in you mysql conf should work, make sure you linux box
and the loopback interface up and has a a entry in your /etc/ hosts for
localhost and that your firewall (if you have one setup on your
localbox) allows traffic from 172.0.0.1 to 172.0.0.1
Don't you
Hi,
Something seamless has become rather painful lately:
cc -fPIC -I../asterisk -D_GNU_SOURCE -I/usr/include/mysql -c -o
app_addon_sql_mysql.o app_addon_sql_mysql.c
app_addon_sql_mysql.c:162:77: macro AST_LIST_REMOVE passed 4
arguments, but takes just 3
app_addon_sql_mysql.c: In function
On Tue, Jul 05, 2005 at 09:24:13AM +, Sahil Gupta wrote:
Hi,
Something seamless has become rather painful lately:
A search on google says to use an older release, done that, no help.. any
ideas guys?
Tell us something about what you try to build:
* asterisk version/cvs date
* linux
I noticed a problem this morning with our cdr logging. We have a cron
job that places a call file into the spool directory having asterisk
call itself to check to make sure its still handling incoming calls
correctly, then queries the CDR database in mysql and makes sure that
appropriate
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:
Usually we get this error cdr_mysql: Unknown connection error early in
the morning when the first call tries to get logged into the database.
The result of course is that the call does not get logged. But all
calls after that get logged fine for the rest of the day. This happens
on ALL our
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
to a
separate server.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Roger
Schreiter
Sent: Wednesday, May 12, 2004 9:13 AM
To: [EMAIL PROTECTED]
Subject: [Asterisk-Users] cdr_mysql - would index slow down?
Hi,
I intend to change the cdr_mysql-field uniqueid
Jay Milk schrieb:
...
note, you probably wouldn't re-use existing fields (whether they're used
or not) but rather add new fields if needed. In order to keep
...
I assume, I may not add nor change fields to the cdr table,
which cdr_mysql uses. Maybe I should consider patching
the source code in
Of Roger
Schreiter
Sent: Wednesday, May 12, 2004 3:10 PM
To: [EMAIL PROTECTED]
Subject: Re: [Asterisk-Users] cdr_mysql - would index slow down?
Jay Milk schrieb:
...
note, you probably wouldn't re-use existing fields (whether they're
used or not) but rather add new fields if needed. In order
Can I use Asterisk with MySQL Voicemail or do I need VoiceMail2?
Uriel
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
On Sunday 14 September 2003 20:36, [EMAIL PROTECTED] wrote:
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
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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 08 September 2003 11:10, Scott Stingel wrote:
Anyone familiar with the asterisk sources know where I can make a change to
keep this from happening? ie: to allow more characters to be stored here.
I could not see where this is limited in
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Tais M. Hansen
Sent: Monday, September 08, 2003 11:49 AM
To: [EMAIL PROTECTED]
Subject: Re: [Asterisk-Users] cdr_mysql question: accountcode
On Monday 08 September 2003 11:10, Scott Stingel
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 21 August 2003 07:02, Manoj K Gupta wrote:
you can also try setting AMAflag=billing in oh323.conf if it helps.
Already tried that. Didn't make a difference. I'll test again with the latest
oh323 (0.5.5).
- --
Regards,
Tais M. Hansen
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 19 August 2003 19:21, Michael Manousos wrote:
Looks like mysql_log() is not actually getting called. Try a pure
Zap bridged call or an IAX2 call (both of which I've tested) and see
if it still doesn't work for you. Are you getting a
you can also try setting AMAflag=billing in oh323.conf if it helps.
Rgds
Manoj K Gupta
- Original Message -
From: Tais M. Hansen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 18, 2003 11:42 PM
Subject: Re: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE-
Hash
Tais M. Hansen wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 19:47, Tilghman Lesher wrote:
That's what I found. I've attached a log of a call from init to
hangup. Note that I removed pri dchannel debug and hid phone and
ipnumbers.
Looks like mysql_log() is not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Is cdr_mysql broken in latest CVS? It builds and loads fine but it doesn't
insert cdrs in the database and there's no debug output at all.
- --
Regards,
Tais M. Hansen
ComX Networks
Tel: +45-70257474
Fax: +45-70257374
-BEGIN PGP
PROTECTED]
Subject: [Asterisk-Users] cdr_mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Is cdr_mysql broken in latest CVS? It builds and loads fine
but it doesn't
insert cdrs in the database and there's no debug output at all.
- --
Regards,
Tais M. Hansen
ComX
On Monday 18 August 2003 11:08 am, Tais M. Hansen wrote:
Is cdr_mysql broken in latest CVS? It builds and loads fine but it
doesn't insert cdrs in the database and there's no debug output at
all.
No, it should be just fine (works for me!). Turn on debugging output
and post what you get.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 18:19, Tilghman Lesher wrote:
On Monday 18 August 2003 11:08 am, Tais M. Hansen wrote:
Is cdr_mysql broken in latest CVS? It builds and loads fine but it
doesn't insert cdrs in the database and there's no debug output at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 18:19, Low, Adam wrote:
I'm not running the latest CVS release but found a couple of days ago that
CDR's were not being inserted into my MySQL tables, I restarted Asterisk
and it worked fine again ...
That's not an option.
On Monday 18 August 2003 11:34 am, Tais M. Hansen wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 18:19, Tilghman Lesher wrote:
On Monday 18 August 2003 11:08 am, Tais M. Hansen wrote:
Is cdr_mysql broken in latest CVS? It builds and loads fine but
it
Did you actually turn on debug output in /etc/asterisk/logger.conf? If not
you won't see any debug output anywhere.
Also, what does your cdr_mysql.conf look like? Does it have a [global] just
before the configuration statements? Compare it to the (updated)
cdr_mysql.conf.sample that you got
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 18:58, Thorsten Lockert wrote:
Did you actually turn on debug output in /etc/asterisk/logger.conf? If not
you won't see any debug output anywhere.
Ahh... Found it. I let Asterisk put the debug output in a seperate file a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 18:55, Tilghman Lesher wrote:
There's nothing cdr_mysql related debug output.
$ asterisk -vgcdf
Turn on debugging in /etc/asterisk/logger.conf
Yes. Forgot debug was put into a different file. Sorry.
Aug 18 19:13:39
On Monday 18 August 2003 12:24 pm, Tais M. Hansen wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 18:58, Thorsten Lockert wrote:
Did you actually turn on debug output in
/etc/asterisk/logger.conf? If not you won't see any debug output
anywhere.
Ahh...
On Monday 18 August 2003 12:33 pm, Tais M. Hansen wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 18:55, Tilghman Lesher wrote:
There's nothing cdr_mysql related debug output.
$ asterisk -vgcdf
Turn on debugging in /etc/asterisk/logger.conf
Yes.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 August 2003 19:47, Tilghman Lesher wrote:
That's what I found. I've attached a log of a call from init to
hangup. Note that I removed pri dchannel debug and hid phone and
ipnumbers.
Looks like mysql_log() is not actually getting
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:
I recommend installing the same version of mysql and mysql-devel and then
recompiling the cdr_mysql.c
regards
Martin
On 7 Aug 2003, Johanna Kangas wrote:
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
After updating asterisk from cvs today (08/07/03). i have been unable to Asterisk to
connect to mysql. cdr_mysql.so compile with no issues.
- And yes, i have mysql running on the same box as asterisk.
- And yes, cdr_mysql worked prior to update from cvs
Has anything change from cdr_mysql.c?
66 matches
Mail list logo