Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Antony Stone
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 about

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Doug Lytle
>>> 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.

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-10 Thread Fourhundred Thecat
> 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

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-08 Thread Sean Bright
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 ; Se

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-07 Thread Jeff LaCoursiere
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, Fourhun

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-06 Thread Fourhundred Thecat
> 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 data

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-06 Thread Antony Stone
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 operation

[asterisk-users] CDR mysql: timeout when remote database unavailable

2020-06-06 Thread Fourhundred Thecat
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, a

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-30 Thread A J Stiles
** 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

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
ok thank you so much 2011/11/29 Ishfaq Malik > 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 any

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Ishfaq Malik
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,

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
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 > On Tuesday 29 November 201

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Warren Selby
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, ma

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread A J Stiles
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 > [ ]

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
ne > 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 and is running > > > > m

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
. From: 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 ins

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
risk-users-boun...@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 aster

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
Discussion Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4 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 [ ] 5. formats

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
lharit > *Sent:* Tuesday, November 29, 2011 9: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 > > > &g

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
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 It &qu

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
-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

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
ommercial Discussion Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4 i didn't find him in the menu i have installed the add-ons but i can not load the cd_mysql :< please advice 2011/11/29 Danny Nicholas It should at least be on the menu although the selection may have

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
t; > > > > > *From:* asterisk-users-boun...@lists.digium.com [mailto: > 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

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Danny Nicholas
esday, 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 as

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread Ishfaq Malik
> > From: asterisk-users-boun...@lists.digium.com > [mailto: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-Comm

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-29 Thread salaheddine elharit
t; ** ** > > *From:* asterisk-users-boun...@lists.digium.com [mailto: > 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: [a

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-21 Thread salaheddine elharit
, 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 but he give me an error > and he tell me that i must run ./configure be

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-21 Thread Danny Nicholas
, 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 but he give me an error and he tell me that i must run ./configure before launch make menuselect i&

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-21 Thread salaheddine elharit
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 than

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-21 Thread Ryan Wagoner
On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit 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 installtion and

Re: [asterisk-users] CDR mysql with asterisk 1.4

2011-11-21 Thread Doug Lytle
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 quo

[asterisk-users] CDR mysql with asterisk 1.4

2011-11-21 Thread salaheddine elharit
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 use

Re: [asterisk-users] CDR Mysql adaptive Colum

2011-03-31 Thread Henrique Fernandes
Sorry, just use to click on the same botton. Thanks, i guess i would figure out something now!! Thanks a lot! []'sf.rique On Thu, Mar 31, 2011 at 3:37 PM, Tilghman Lesher wrote: > Do NOT copy me on replies. I do NOT need two copies of your message. > > On Thursday 31 March 2011 12:08:53 Henr

Re: [asterisk-users] CDR Mysql adaptive Colum

2011-03-31 Thread Tilghman Lesher
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

Re: [asterisk-users] CDR Mysql adaptive Colum

2011-03-31 Thread Henrique Fernandes
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

[asterisk-users] CDR MYSQL missing field data

2011-03-31 Thread Eric W. Davenport
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 --

Re: [asterisk-users] CDR Mysql adaptive Colum

2011-03-31 Thread Henrique Fernandes
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 wrote: > On Wednesday 30 March 2011 14:34:29 Henrique Fernan

Re: [asterisk-users] CDR Mysql adaptive Colum

2011-03-31 Thread Tilghman Lesher
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

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-31 Thread Warren Selby
On Thu, Mar 31, 2011 at 1:52 AM, Tilghman Lesher wrote: > > 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 put the call

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-30 Thread Tilghman Lesher
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" interna

[asterisk-users] CDR Mysql adaptive Colum

2011-03-30 Thread Henrique Fernandes
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, bu

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-30 Thread Eric W. Davenport
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 http://www.api-digi

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-29 Thread bayardo . sanchez
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 -- _

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-29 Thread Warren Selby
On Tue, Mar 29, 2011 at 4:03 PM, Warren Selby 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 get > the same issue

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-29 Thread Warren Selby
On Tue, Mar 29, 2011 at 3:52 PM, Eric W. Davenport wrote: > 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 in order to help

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-29 Thread Warren Selby
On Tue, Mar 29, 2011 at 12:32 PM, Eric W. Davenport wrote: > 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 the output of a '

[asterisk-users] CDR MYSQL missing field data

2011-03-29 Thread Eric W. Davenport
Thanks again Tilghman OK now I am back to the original. [columns] ;static "" =>commented now ;alias => commented now These are bogus and should never have been uncommented. alias start => calldate uncommented now alias callerid => clid uncommented now Rest are all back to commen

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-28 Thread Tilghman Lesher
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 t

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-28 Thread Eric W. Davenport
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 "" => alias => alias start => calldate alias callerid => clid alias src => src alias dst => ds

Re: [asterisk-users] CDR MYSQL missing field data

2011-03-27 Thread Tilghman Lesher
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 rec

[asterisk-users] CDR MYSQL missing field data

2011-03-27 Thread Eric W. Davenport
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 stora

Re: [asterisk-users] CDR: MySQL query

2010-08-04 Thread RSCL Mumbai
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

[asterisk-users] CDR: MySQL query

2010-08-03 Thread RSCL Mumbai
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 (

Re: [asterisk-users] cdr mysql error

2008-11-24 Thread Jai Rangi
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 log

[asterisk-users] cdr mysql error

2008-11-24 Thread Nhadie
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_lo

Re: [asterisk-users] CDR/MySQL basic config

2007-08-07 Thread Alessandro Russo
t; > [Aug 7 15:14:10] WARNING[29103]: res_config_mysql.c:474 load_module: > > > MySQL RealTime: Couldn't establish connection. Check debug. > > > > > > [Aug 7 15:14:10] NOTICE[29103]: config.c:1171 > > > ast_config_engine_register: Registered Config

Re: [asterisk-users] CDR/MySQL basic config

2007-08-07 Thread Jaswinder Singh
ig Engine mysql > > > > MySQL RealTime driver loaded. > > > > res_config_mysql.so => (MySQL RealTime Configuration Driver) > > > > > > > > This box also das Cacti installed on it, which makes use of the MySql > > server as well (and all is ok there).

Re: [asterisk-users] CDR/MySQL basic config

2007-08-07 Thread Alessandro Russo
e Configuration Driver) > > > > This box also das Cacti installed on it, which makes use of the MySql > server as well (and all is ok there). > > > > > > Adrian Marsh > > > -- > > *From:* [EMAIL PROTECTED] [mailto: > [EMA

Re: [asterisk-users] CDR/MySQL basic config

2007-08-07 Thread Adrian Marsh
ll (and all is ok there). Adrian Marsh 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

Re: [asterisk-users] CDR/MySQL basic config

2007-08-07 Thread Alessandro Russo
r where User = 'asteriskcdruser' ; > ERROR 1146 (42S02): Table 'asteriskcdrdb.user' doesn't exist > mysql> > > > Adrian Marsh > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Forrest > Beck >

Re: [asterisk-users] CDR/MySQL basic config

2007-08-07 Thread Adrian Marsh
riskcdrdb.user' doesn't exist mysql> Adrian Marsh -Original 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

Re: [asterisk-users] CDR/MySQL basic config

2007-08-06 Thread Forrest Beck
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 ch

[asterisk-users] CDR/MySQL basic config

2007-08-06 Thread Adrian Marsh
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 data

Re: [asterisk-users] CDR - mysql with asterisk 1.2.12 not working

2006-10-10 Thread Brian Rogan
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

Re: [asterisk-users] CDR - mysql with asterisk 1.2.12 not working

2006-10-09 Thread Garth van Sittert
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 a

Re: [asterisk-users] CDR - mysql with asterisk 1.2.12 not working

2006-10-08 Thread Joseph
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 us

Re: [asterisk-users] CDR - mysql with asterisk 1.2.12 not working

2006-10-08 Thread Hermann Wecke
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

Re: [asterisk-users] CDR - mysql with asterisk 1.2.12 not working

2006-10-08 Thread Joseph
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 se

Re: [asterisk-users] CDR - mysql with asterisk 1.2.12 not working

2006-10-08 Thread Hermann Wecke
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 ___

[asterisk-users] CDR - mysql with asterisk 1.2.12 not working

2006-10-08 Thread Joseph
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]

RE: [Asterisk-Users] cdr mysql problem

2005-12-18 Thread Mohammad Shokuie
.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.hotmail.co

Re: [Asterisk-Users] cdr mysql problem

2005-12-16 Thread Rich Adamson
> > 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 >

RE: [Asterisk-Users] cdr mysql problem

2005-12-16 Thread Diyanat Ali
/mysql.sock Diyanat From: "Mohammad Shokuie" <[EMAIL PROTECTED]> Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] cdr mysql problem Return-Path: [EMAIL PROTECTED] Dear folks, I've just compile

Re: [Asterisk-Users] cdr mysql problem

2005-12-16 Thread Christian Victor
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 : cdr_addon_my

Re: [Asterisk-Users] cdr mysql problem

2005-12-16 Thread Doug Lytle
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 connec

[Asterisk-Users] cdr mysql problem

2005-12-16 Thread Mohammad Shokuie
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 :

Re: [Asterisk-Users] CDR MySQL

2005-12-13 Thread Juanjo Portela
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 stored)>>so

Re: [Asterisk-Users] CDR MySQL

2005-12-13 Thread tracinet
--You 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:ta

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread Innocent Evil
2 Dec 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:[g

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread tracinet
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 sock=/var/

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread Patrick
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.htm

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread KRTorio
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 id

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread Robert Webb
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 userfiel

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread Patrick
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? Specif

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread Juanjo Portela
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 Ea

Re: [Asterisk-Users] CDR MySQL

2005-12-12 Thread tracinet
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,

[Asterisk-Users] CDR MySQL

2005-12-12 Thread Juanjo Portela
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 __load_re

Re: RES: [Asterisk-Users] CDR MySQL

2005-10-06 Thread brett
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 _

Re: RES: [Asterisk-Users] CDR MySQL

2005-10-06 Thread Rosario Pingaro
where can i found it? thanks - Original Message - From: <[EMAIL PROTECTED]> To: 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 to the conf file. You

RES: RES: [Asterisk-Users] CDR MySQL

2005-10-06 Thread Jozeph Brasil
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

Re: RES: [Asterisk-Users] CDR MySQL

2005-10-06 Thread brett
mote 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" is to reconfigure MySQL - It is the d

RES: [Asterisk-Users] CDR MySQL

2005-10-06 Thread Jozeph Brasil
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&q

Re: [Asterisk-Users] CDR MySQL

2005-10-06 Thread Jozeph Brasil
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. So

Re: [Asterisk-Users] CDR MySQL

2005-10-06 Thread Steve Davies
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 h

[Asterisk-Users] CDR MySQL

2005-10-05 Thread Jozeph Brasil
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]: cdr_addon_mysql.c

[Asterisk-Users] CDR MySQL

2005-10-05 Thread Jozeph Brasil
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]: c

[Asterisk-Users] CDR mysql userfield column truncated at 239 characters

2005-04-07 Thread Troy Swaine
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

RE: [Asterisk-Users] CDR & MySQL Problem

2004-11-12 Thread Scott Stingel
t: 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] => (Database access functions for Asterisk extension logic) > > == Re

RES: [Asterisk-Users] CDR & MySQL Problem

2004-11-12 Thread Geraldo Fco . do Espírito Santo Jr .
[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

Re: [Asterisk-Users] CDR & MySQL Problem

2004-11-12 Thread Matthew Boehm
ysql.conf file. -Matthew - 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 instal

  1   2   >