On Wednesday 10 June 2020 at 16:33:53, Doug Lytle wrote:
> >>> Instead, the call still terminates if mysql cannot be reached.
>
> I just tested this, I'm using cdr_odbc, by shutting down mysql and I did
> not experience the call being dropped.
That sounds different to me.
The OP is asking
>>> Instead, the call still terminates if mysql cannot be reached.
I just tested this, I'm using cdr_odbc, by shutting down mysql and I did not
experience the call being dropped.
The console logged the mysql failure, but the call continued.
You may want to consider moving to cdr_odbc instead.
> On 2020-06-08 16:37, Sean Bright wrote:
>
> In the case of cdr_mysql, the connect timeout is configurable by putting
> the following in cdr_mysql.conf:
>
> [global]
> timeout = 5 ; Set connect timeout to 5 seconds
OK, so i changed the timeout to 2 sec, but it does not have the desired
effect. I
On 6/7/2020 2:54 AM, Fourhundred Thecat wrote:
I would still like to know where the Aterisk mysql timeout duration
comes from, and whether it can be configured.
In the case of cdr_mysql, the connect timeout is configurable by putting
the following in cdr_mysql.conf:
[global]
timeout = 5 ;
Isn't the MySQL stuff deprecated in favor of odbc? You may be barking up
the wrong tree if you plan to make source changes.
j
On Sun, Jun 7, 2020, 1:55 AM Fourhundred Thecat <400the...@gmx.ch> wrote:
> > On 2020-06-06 10:38, Antony Stone wrote:
> > On Saturday 06 June 2020 at 09:18:11,
> On 2020-06-06 10:38, Antony Stone wrote:
On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote:
In a situation when I start asterisk, and the remote database is
unreachable, asterisk waits for several minutes before it actually
starts (before it loads sip module, etc).
And when
On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote:
> In a situation when I start asterisk, and the remote database is
> unreachable, asterisk waits for several minutes before it actually
> starts (before it loads sip module, etc).
>
> And when database is unreachable during
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,
** THIS IS NOT THE RIGHT PLACE TO POST A REPLY **
On Tuesday 29 November 2011, salaheddine elharit wrote:
i use centos 5.5 if i install mysql-devel i can still use the version of
mysql installed now in my server because i use it with a database and Im
afraid to install this mysql-devel and i
:
asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
elharit
*Sent:* Monday, November 21, 2011 8:52 AM
*To:* Asterisk Users Mailing List - Non-Commercial Discussion
*Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
** **
i try to run make menuselect without configure
Of
salaheddine elharit
Sent: Monday, November 21, 2011 8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4
i try to run make menuselect without configure
, November 29, 2011 5:37 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4
Hello Danny
i try to flow your email but when i do make menuselect i didn't find add-ons
in order to check the cdr_mysql
i use asterisk 1.4
-Commercial Discussion
*Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
i try to run make menuselect without configure but he give me an error
and he tell me that i must run ./configure before launch make menuselect *
***
i'm afraid if i launch ./configure and after
-on.
** **
*From:* asterisk-users-boun...@lists.digium.com [mailto:
asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
elharit
*Sent:* Tuesday, November 29, 2011 8:45 AM
*To:* Asterisk Users Mailing List - Non-Commercial Discussion
*Subject:* Re: [asterisk-users] CDR mysql
Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4
what i have in Call Detail Recording is
[*] 1. cdr_csv
[*] 2. cdr_custom
[*] 3. cdr_manager
xxx 4. cdr_odbc
xxx 5. cdr_pgsql
xxx 6. cdr_radius
xxx 7. cdr_sqlite
xxx 8. cdr_tds
2011/11/29 Danny Nicholas da...@debsinc.com
:06 AM
*To:* Asterisk Users Mailing List - Non-Commercial Discussion
*Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
** **
what i have in “Call Detail Recording” is
[*] 1. cdr_csv
[*] 2. cdr_custom
[*] 3. cdr_manager
xxx 4. cdr_odbc
xxx 5. cdr_pgsql
xxx 6
...@lists.digium.com [mailto:
asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
elharit
*Sent:* Tuesday, November 29, 2011 9:20 AM
*To:* Asterisk Users Mailing List - Non-Commercial Discussion
*Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
** **
after
: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 9:30 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4
yes is installad
*To:* Asterisk Users Mailing List - Non-Commercial Discussion
*Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
** **
yes is installad and is running
mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql
/usr/share/man/man1/mysql.1.gz
On Tuesday 29 November 2011, salaheddine elharit wrote:
after
./configure –with-mysql=/usr
Make menuselect
** **same result but i found in module embedding the below options i check
the cdr and i get the same result
[ ] 1. apps
[*] 2. cdr
[ ] 3. channels
[ ] 4. codecs
[
In order to install MySQL support for asterisk 1.4, you'll need to download
the asterisk-addons-1.4 tarball, extract it to it's own folder. Go to that
folder, run ./configure, make menuselect, and select the cdr_addon_mysql
and the res_config_mysql options. Exit make menuselect, then run make,
i use centos 5.5 if i install mysql-devel i can still use the version of
mysql installed now in my server because i use it with a database and Im
afraid to install this mysql-devel and i lost the version of mysql reunning
actually
please advice
2011/11/29 A J Stiles asterisk_l...@earthshod.co.uk
Don't be afraid, it will not cause any problems at all. The *-devel
packages contain the libraries and header files that are needed for
developing the application and some of these are used by the asterisk
addons. It will in no way replace anything you currently have or use.
Regards
Ish
On Tue,
ok thank you so much
2011/11/29 Ishfaq Malik i...@pack-net.co.uk
Don't be afraid, it will not cause any problems at all. The *-devel
packages contain the libraries and header files that are needed for
developing the application and some of these are used by the asterisk
addons. It will in no
hello list
i have asterisk 1.4 installed and i want to use CDR mysql during the
installation i didn’t check the cdr mysql with make menuselect
my question : i want to check this option now after the installtion and
configuration of all options but he asks me to do. /configure before to
salaheddine elharit wrote:
because this server is very important for me and i can’t stop it
This is one of those schedule for after hours things then. I don't
believe you can do this without a restart of the Asterisk service. But,
down time should be minimal.
Doug
--
Ben Franklin
On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
salah.elharit...@gmail.com wrote:
hello list
i have asterisk 1.4 installed and i want to use CDR mysql during the
installation i didn’t check the cdr mysql with make menuselect
my question : i want to check this option now after the
i try to run make menuselect without configure but he give me an error and
he tell me that i must run ./configure before launch make menuselect
i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk
BTW i can restart asterisk without issue
8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4
i try to run make menuselect without configure but he give me an error and
he tell me that i must run ./configure before launch make menuselect
i'm afraid if i
:* Re: [asterisk-users] CDR mysql with asterisk 1.4
** **
i try to run make menuselect without configure but he give me an error
and he tell me that i must run ./configure before launch make menuselect *
***
i'm afraid if i launch ./configure and after make menuselet to lost all
On Monday 28 March 2011 14:23:25 Tilghman Lesher wrote:
On Monday 28 March 2011 07:57:10 Eric W. Davenport wrote:
alias start = calldate
alias callerid = clid
These are fine.
I was incorrect, here, and there's nobody to blame but myself. The
field is ACTUALLY named clid internally, so
On Thu, Mar 31, 2011 at 1:52 AM, Tilghman Lesher tilgh...@meg.abyt.eswrote:
I was incorrect, here, and there's nobody to blame but myself. The
field is ACTUALLY named clid internally, so when I, by default, set
ANOTHER field to the clid column, I shut out the default logic which
would have
On Wednesday 30 March 2011 14:34:29 Henrique Fernandes wrote:
exten = s,1,set(CDR(teste)=${CHANNEL(audioreadformat)})
And is not working, i thought the only diference it i would need the
colum teste in my cdr table right ?
Correct. Did you restart Asterisk after modifying the table? If you
I got something with this line.
exten= _X.,2,set(CDR(teste)=${CHANNEL(useragent)})
But only wen the first cal fail!
I wil setuo asterisk to show the log in the console.
[]'sf.rique
On Thu, Mar 31, 2011 at 6:17 AM, Tilghman Lesher tilgh...@meg.abyt.eswrote:
On Wednesday 30 March 2011
Good Morning,
I agree I commented the lines and now everything works.
Thanks for your quick work.
Eric
--
Eric W. Davenport
Cert-In Software Systems, Inc.
P.O. Box 346
Bakersville, NC 28705
800-873-0110
ewdavenp...@certin.com
www.certin.com
--
Found something now! i need first to set the CDR and after make the Dial
Like this.
[default]
exten= _X.,1,set(CDR(teste)=${CHANNEL(useragent)})
exten= _X.,2,Dial(SIP/${EXTEN})
Like this, this would work!!
Now i have a question, if i do not use EXTEN and add an entry for each
number like this
Do NOT copy me on replies. I do NOT need two copies of your message.
On Thursday 31 March 2011 12:08:53 Henrique Fernandes wrote:
Found something now! i need first to set the CDR and after make the Dial
Like this.
[default]
exten= _X.,1,set(CDR(teste)=${CHANNEL(useragent)})
exten=
Warren,
Thank you
Eric
--
Eric W. Davenport
Cert-In Software Systems, Inc.
P.O. Box 346
Bakersville, NC 28705
800-873-0110
ewdavenp...@certin.com
www.certin.com
--
_
-- Bandwidth and Colocation Provided by
Hello folks, i installed asterisk 1.8 from repo:
https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages
And Looked at this article about CDR in mysl.
http://www.voip-info.org/wiki/view/Asterisk+cdr+mysql
I installed asterisk-mysql pacakge from debian repo.
The cdr in mysql is working,
Thanks again Tilghman
OK now I am back to the original.
[columns]
;static value = column commented now
;aliascdrvar = columncommented now
These are bogus and should never have been uncommented.
alias start = calldate uncommented now
alias callerid = clid uncommented now
Rest are
On Tue, Mar 29, 2011 at 12:32 PM, Eric W. Davenport
ewdavenp...@certin.comwrote:
I restarted Asterisk and I still have all the fields outgoing and incoming
except for the CLID field.
Clid is populated in the CSV Simple file as well as the CSV Custom file.
Please, if you would, copy and paste
On Tue, Mar 29, 2011 at 3:52 PM, Eric W. Davenport
ewdavenp...@certin.comwrote:
Hi Warren,
Thanks for your help,
I think this is what you want
Please don't mail me (or anyone else) off the list directly without being
specifically asked to. The idea is to keep things on the mailing list
On Tue, Mar 29, 2011 at 4:03 PM, Warren Selby wcse...@selbytech.com wrote:
That information does indeed look like what I want and it appears to be
setup correctly. I will be building a comparable test system later today
(using all the same software versions as you) and I'll test to see if I
I listened to your email using DriveCarefully and will respond as soon as I can.
Download DriveCarefully for free at www.drivecarefully.com
--
Sent from my BlackBerry®
Senior Support Engineer
US Numbers: 561-886-0664
Nicaragua Mobile: +505.8488.6876
--
Thanks Tilghman for your response.
I have the following in my cdr_mysql.conf
I put it in sometime yesterday and did not have it till then.
However, it did not make any difference.
[columns]
static value = column
alias cdrvar = column
alias start = calldate
alias callerid = clid
alias src =
On Monday 28 March 2011 07:57:10 Eric W. Davenport wrote:
Thanks Tilghman for your response.
I have the following in my cdr_mysql.conf
I put it in sometime yesterday and did not have it till then.
However, it did not make any difference.
Did you reload after making the change to the
Hello,
I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and
libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built
from source.
Everything is working nicely except one small issue.
The CDR records are stored in the CSV file correctly and complete.
The MySQL
On Sunday 27 March 2011 19:36:45 Eric W. Davenport wrote:
Hello,
I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and
libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built
from source.
Everything is working nicely except one small issue.
The CDR records are
Thx Rudi. but this query results in *Empty set (0.32 sec)
src AND dst like number *seems to be the problem area.
*
*
Also, how can I get the hold time talk time as separate values OR may be
total call connect time talk time (the difference of the 2 will be hold
time).
Thx
Sans
On Wed, Aug 4,
Hi,
Can someone help me formulate MySQL Query(s) which will help me extract the
following details for a given DID (date range can be excluded for
simplicity).
Date-Time
DNID (I am recording this is `userfield`)
CLID
time-1 (when call was received)
time-2 (when call was answered by agent)
time-3
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
Increase the timeout in my.cnf in mysql.
-Jai
Buy unmetered VoIP DIDs www.didforsale.com Free Trail
On Mon, Nov 24, 2008 at 11:10 PM, Nhadie [EMAIL PROTECTED] wrote:
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
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Forrest
Beck
Sent: 07 August 2007 02:59
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR/MySQL basic config
Adrian,
What host/ip did you specify when you created the user
Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR/MySQL basic config
Adrian,
What host/ip did you specify when you created the user?
# mysql --user=root --password
#mysql use mysql;
#mysql select Host from user where User = 'asteriskcdruser'
(this line
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alessandro
Russo
Sent: 07 August 2007 14:13
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR/MySQL basic config
Hi,
first step is correct
Hmm.. This is what I get
Discussion
*Subject:* Re: [asterisk-users] CDR/MySQL basic config
Hi,
first step is correct
Hmm.. This is what I get:
[EMAIL PROTECTED] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 187143 to server version: 4.1.20
:13
*To:* Asterisk Users Mailing List - Non-Commercial Discussion
*Subject:* Re: [asterisk-users] CDR/MySQL basic config
Hi,
first step is correct
Hmm.. This is what I get:
[EMAIL PROTECTED] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end
Discussion
*Subject:* Re: [asterisk-users] CDR/MySQL basic config
Hi,
first step is correct
Hmm.. This is what I get:
[EMAIL PROTECTED] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 187143
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
Adrian,
What host/ip did you specify when you created the user?
# mysql --user=root --password
#mysql use mysql;
#mysql select Host from user where User = 'asteriskcdruser'
(this line is case sensitive)
Does it return 127.0.0.1 or localhost. Make cdr_mysql reflect that.
You should also
Joseph wrote:
On Mon, 2006-10-09 at 01:45 -0300, Hermann Wecke wrote:
On Sun, Oct 08, 2006 at 10:39:26PM -0600, Joseph wrote:
I have bind-address = 127.0.0.1 in my.cnf
the cdr was working find with asterisk 1.0.1 just after upgrade
something is not connecting.
I don't know if
I know that this is a silly suggestion but you should check to make sure
that you actually have the cdr_mysql module, because at some point (I
believe at the 1.2 release or shortly thereafter), it was moved into
asterisk-addons.
--Brian
On Tue, Oct 10, 2006 at 08:31:43AM +0200, Garth van Sittert
I just upgraded to asterisk 1.2.12 from 1.0.1 and I can not get cdr -
mysql to load
I've install asterisk-addon and have cdr_addon_mysql.so in module
directory
In modules.conf I have:
preload = cdr_addon_mysql.so
Should it be load or preload?
In cdr_mysql.conf (nothing has changed)
[global]
On Sun, Oct 08, 2006 at 10:04:51PM -0600, Joseph wrote:
What am I missing?
Maybe your /etc/mysql/my.cnf ?
# Instead of skip-networking you can listen only on
# localhost which is more compatible and is not less secure.
# bind-address = 127.0.0.1
#skip-networking
On Mon, 2006-10-09 at 01:13 -0300, Hermann Wecke wrote:
On Sun, Oct 08, 2006 at 10:04:51PM -0600, Joseph wrote:
What am I missing?
Maybe your /etc/mysql/my.cnf ?
# Instead of skip-networking you can listen only on
# localhost which is more compatible and is not less secure.
On Sun, Oct 08, 2006 at 10:39:26PM -0600, Joseph wrote:
I have bind-address = 127.0.0.1 in my.cnf
the cdr was working find with asterisk 1.0.1 just after upgrade
something is not connecting.
I don't know if asterisk will use the localhost or the network IP to
connect. Just try to comment your
On Mon, 2006-10-09 at 01:45 -0300, Hermann Wecke wrote:
On Sun, Oct 08, 2006 at 10:39:26PM -0600, Joseph wrote:
I have bind-address = 127.0.0.1 in my.cnf
the cdr was working find with asterisk 1.0.1 just after upgrade
something is not connecting.
I don't know if asterisk will use the
@lists.digium.com
Subject: RE: [Asterisk-Users] cdr mysql problem
Date: Fri, 16 Dec 2005 07:14:05 -0600
MIME-Version: 1.0
X-Originating-IP: [202.65.140.108]
X-Originating-Email: [EMAIL PROTECTED]
X-Sender: [EMAIL PROTECTED]
Received: from lists.digium.com ([69.16.138.164]) by
bay0-mc12-f6.bay0
Dear folks,
I've just compiled asterisk-addon1.2.1 after installing MySQL and
MySQl-devel packages. and adjust my cdr_mysql.conf to use the defined
database using username and password. But as soon as starting asterisk i get
error messages informing me of error, error message is as follows :
Mohammad Shokuie wrote:
error messages informing me of error, error message is as follows :
cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost
and res_config_mysql.c : Failed to connect database server on .
Im realy lost and dont know whats wrong. I've checked the
I've just compiled asterisk-addon1.2.1 after installing MySQL and
MySQl-devel packages. and adjust my cdr_mysql.conf to use the defined
database using username and password. But as soon as starting asterisk
i get error messages informing me of error, error message is as
follows :
/mysql.sock
Diyanat
From: Mohammad Shokuie [EMAIL PROTECTED]
Reply-To: Asterisk Users Mailing List - Non-Commercial
Discussionasterisk-users@lists.digium.com
To: asterisk-users@lists.digium.com
Subject: [Asterisk-Users] cdr mysql problem
Return-Path: [EMAIL PROTECTED]
Dear folks,
I've just
error messages informing me of error, error message is as follows :
cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost
and res_config_mysql.c : Failed to connect database server on .
Im realy lost and dont know whats wrong. I've checked the connection
to MySql in
don't have any choice, you already made it before you came here.
-Original Message-From: [EMAIL PROTECTED]Sent: Mon, 12 Dec 2005 21:16:23 -0500
To: asterisk-users@lists.digium.comSubject: Re: [Asterisk-Users] CDR MySQL
I believe you are missing 2 variables in your conf file:table=cdr
Thank you Traci,I put this two variables in my .conf file and it works!!!Well, It seems that this variables are not necessaries in old versions, but in newest ones.Thank you again,Juanjo
I believe you are missing 2 variables in your conf file:table=cdr(the table your cdrs should be
Dear Tomislav Colleagues,
I read your post in the Astersik-list about you can not compile the cdr_mysql on Asterisk 1.2
Well, I have a similar problem.
I compiled the cdr_mysql module, but when i start Asterisk the following error appears:
Dec 12 18:03:33 WARNING[7237]: loader.c:325
What does your /etc/asterisk/cdr_mysql.conf look like?
On 12/12/05, Juanjo Portela [EMAIL PROTECTED] wrote:
Dear Tomislav Colleagues,
I read your post in the Astersik-list about you can not compile the cdr_mysql on Asterisk 1.2
Well, I have a similar problem.
I compiled the cdr_mysql module, but
My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow
[global]
hostname=localhost
dbname=dbasterisk
password=dbpassword
user=dbuser
userfield=1
Any ideas?
Thank you in advance,
Juanjo
___
--Bandwidth and Colocation provided by
On Mon, 2005-12-12 at 22:08 -0300, Juanjo Portela wrote:
My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as
follow
[global]
hostname=localhost
dbname=dbasterisk
password=dbpassword
user=dbuser
userfield=1
Any ideas?
Any ideas about what? The weather? Specify your
On Tue, 13 Dec 2005 02:25:50 +0100
Patrick [EMAIL PROTECTED] wrote:
On Mon, 2005-12-12 at 22:08 -0300, Juanjo Portela wrote:
My cdr_mysql.conf is the same I was using for
version.1.0.9 and it is as follow
[global]
hostname=localhost
dbname=dbasterisk
password=dbpassword
user=dbuser
Is your mysql server running locally the same time your starting asterisk?On 12/12/05, Juanjo Portela [EMAIL PROTECTED]
wrote:My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow
[global]hostname=localhostdbname=dbasteriskpassword=dbpassworduser=dbuseruserfield=1Any
On Mon, 2005-12-12 at 20:33 -0500, Robert Webb wrote:
[snip]
Maybe if people weren't so quick to jump to conclusions,
they would see that some did actually ask a question
before and were now supplying the answer.
http://lists.digium.com/pipermail/asterisk-users/2005-December/138183.html
I believe you are missing 2 variables in your conf file:
table=cdr
(the table your cdrs should be stored)
sock=/var/lib/mysql/mysql.sock
(the location to your mysql.sock)
try something like this:
[global]
hostname=localhost
dbname=dbasterisk
table=cdr
password=dbpassword
user=dbuser
2005 21:16:23 -0500To: asterisk-users@lists.digium.comSubject: Re: [Asterisk-Users] CDR MySQL
I believe you are missing 2 variables in your conf file:table=cdr(the table your cdrs should be stored)sock=/var/lib/mysql/mysql.sock(the location to your mysql.sock)try something like this:[global]hostname
I do not know for sure, but in my experience, the most common cause of
this error is an application which assumes a database connection will
stay open forever.
Some MySQL installs have a timeout on idle connections. It should be
possible to set this to a very-long or infinite timeout.
Hope that
Hi Steve,
Thank you for reply! :) Do you know if anyone have been patched to solve this?
Quoting Steve Davies [EMAIL PROTECTED]:
I do not know for sure, but in my experience, the most common cause of
this error is an application which assumes a database connection will
stay open forever.
I don´t have access to MySQL administration! :(
I´m using a remote database to store...
-Mensagem original-
De: Steve Davies [mailto:[EMAIL PROTECTED]
Enviada em: quinta-feira, 6 de outubro de 2005 09:48
Para: Jozeph Brasil
Assunto: Re: [Asterisk-Users] CDR MySQL
The usual fix
original-
De: Steve Davies [mailto:[EMAIL PROTECTED]
Enviada em: quinta-feira, 6 de outubro de 2005 09:48
Para: Jozeph Brasil
Assunto: Re: [Asterisk-Users] CDR MySQL
The usual fix is to reconfigure MySQL - It is the database that is
causing the timeouts. I do not know how this is done
Yes! I´m using latest version... I see: int retries = 5;.
-Mensagem original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviada em: quinta-feira, 6 de outubro de 2005 10:27
Para: asterisk-users@lists.digium.com
Assunto: Re: RES: [Asterisk-Users] CDR MySQL
There is a recent fix
where can i found it?
thanks
- Original Message -
From: [EMAIL PROTECTED]
To: asterisk-users@lists.digium.com
Sent: Thursday, October 06, 2005 9:26 AM
Subject: Re: RES: [Asterisk-Users] CDR MySQL
There is a recent fix to cdr_addon_mysql.c that added 5 retries
and a timeout variable
You 'should' be able to go into /usr/src/asterisk-addons/
and do a 'make update'. This should only update the addons
directory... But I have been wrong before...
Brett
On 10/6/2005, Rosario Pingaro [EMAIL PROTECTED] wrote:
where can i found it?
thanks
Hi Asteriskers!
Ive enable CDR to store
data on a remote machine using MySQL. But I have a problem. Analyzing the log,
I see some ERROR messages as:
--
SIP/21-3787 is ringing
== Spawn extension
(default, 21, 1) exited non-zero on 'SIP/21-ce14'
Oct 5 13:22:54
ERROR[8576]:
Hi Asteriskers!
I've enable CDR to store data on a remote machine using MySQL. But I have a
problem. Analyzing the log, I see some ERROR messages as:
-- SIP/21-3787 is ringing
== Spawn extension (default, 21, 1) exited non-zero on 'SIP/21-ce14'
Oct 5 13:22:54 ERROR[8576]:
Hi all,
Recently I started using MySQL for CDR. I noticed that
there is no column length set, however, when data is entered
it gets truncated at 239 characters. I have verified that is not
a mysql issue as I have added data to the field beyond 239 chars
and the data is saved. I see in the
Good day all
What do i need,and need to do,from the beginig to get the cdr into a
database
I installed asteris,mysql and mysl-dev..
I got the asterisk-addons
I made a make and it said it could not find asterisk.h
so I copyed asteris.h from my installed file to /user/include
I then followed theis
- Non-Commercial Discussion
Asunto: [Asterisk-Users] cdr mysql
Good day all
What do i need,and need to do,from the beginig to get the cdr into a
database
I installed asteris,mysql and mysl-dev..
I got the asterisk-addons
I made a make and it said it could not find asterisk.h
so I copyed asteris.h
Hi everyone, I
am try to install a CDR using MySQL but I receive the follow message:
[app_db.so]
= (Database access functions for Asterisk extension logic)
== Registered
application 'DBget'
== Registered
application 'DBput'
== Registered
application 'DBdel'
== Registered
- Original Message -
From: Geraldo Fco. do Espírito Santo Jr. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 12, 2004 9:21 AM
Subject: [Asterisk-Users] CDR MySQL Problem
Hi everyone, I am try to install a CDR using MySQL but I receive the
follow
message:
[app_db.so
[mailto:[EMAIL PROTECTED]
Enviada em: sexta-feira, 12 de novembro de 2004 13:57
Para: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial
Discussion
Assunto: Re: [Asterisk-Users] CDR MySQL Problem
Come on man...I know you are smarter than this; you're using asterisk. Take
a minute
: [Asterisk-Users] CDR MySQL Problem
Hi everyone, I am try to install a CDR using MySQL but I receive the
follow
message:
[app_db.so] = (Database access functions for Asterisk extension logic)
== Registered application 'DBget'
== Registered application 'DBput'
== Registered
1 - 100 of 113 matches
Mail list logo