Re: [asterisk-users] MySQL CDR

2009-11-02 Thread Warren Selby
What version of asterisk are you installing? Thanks, --Warren Selby On Mon, Nov 2, 2009 at 5:59 AM, Dan Journo wrote: > Hello, > > > > Does anyone know where I can get an up to date guide on installing > CDR_MSQL? > > > > VOIP-Info has old information. > > > > Many thanks > > Dan > > > > > > __

[asterisk-users] MySQL CDR

2009-11-02 Thread Dan Journo
Hello, Does anyone know where I can get an up to date guide on installing CDR_MSQL? VOIP-Info has old information. Many thanks Dan ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list T

Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-31 Thread Joseph
On 10/30/09 10:32, Carlos Chavez wrote: >On Fri, 2009-10-30 at 08:37 -0500, Tilghman Lesher wrote: >> On Thursday 29 October 2009 12:32:48 Carlos Chavez wrote: >> > On Thu, 2009-10-29 at 12:23 -0500, Tilghman Lesher wrote: >> > > On Thursday 29 October 2009 11:49:30 Carlos Chavez wrote: >> > > > On

Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-30 Thread Carlos Chavez
On Fri, 2009-10-30 at 08:37 -0500, Tilghman Lesher wrote: > On Thursday 29 October 2009 12:32:48 Carlos Chavez wrote: > > On Thu, 2009-10-29 at 12:23 -0500, Tilghman Lesher wrote: > > > On Thursday 29 October 2009 11:49:30 Carlos Chavez wrote: > > > > On Wed, 2009-10-28 at 23:36 -0500, Tilghman Les

Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-30 Thread Tilghman Lesher
On Thursday 29 October 2009 12:32:48 Carlos Chavez wrote: > On Thu, 2009-10-29 at 12:23 -0500, Tilghman Lesher wrote: > > On Thursday 29 October 2009 11:49:30 Carlos Chavez wrote: > > > On Wed, 2009-10-28 at 23:36 -0500, Tilghman Lesher wrote: > > > > On Wednesday 28 October 2009 17:57:49 Carlos Ch

Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-29 Thread Carlos Chavez
On Thu, 2009-10-29 at 12:23 -0500, Tilghman Lesher wrote: > On Thursday 29 October 2009 11:49:30 Carlos Chavez wrote: > > On Wed, 2009-10-28 at 23:36 -0500, Tilghman Lesher wrote: > > > On Wednesday 28 October 2009 17:57:49 Carlos Chavez wrote: > > > > I am having a problem with Asterisk 1.

Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-29 Thread Tilghman Lesher
On Thursday 29 October 2009 11:49:30 Carlos Chavez wrote: > On Wed, 2009-10-28 at 23:36 -0500, Tilghman Lesher wrote: > > On Wednesday 28 October 2009 17:57:49 Carlos Chavez wrote: > > > I am having a problem with Asterisk 1.6.2.0-rc3 and Asterisk-Addons > > > 1.6.2.0-rc1 when recording CDR to a

Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-29 Thread Carlos Chavez
On Wed, 2009-10-28 at 23:36 -0500, Tilghman Lesher wrote: > On Wednesday 28 October 2009 17:57:49 Carlos Chavez wrote: > > I am having a problem with Asterisk 1.6.2.0-rc3 and Asterisk-Addons > > 1.6.2.0-rc1 when recording CDR to a Mysql database. All fields except > > callerid are recorded pro

Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-28 Thread Tilghman Lesher
On Wednesday 28 October 2009 17:57:49 Carlos Chavez wrote: > I am having a problem with Asterisk 1.6.2.0-rc3 and Asterisk-Addons > 1.6.2.0-rc1 when recording CDR to a Mysql database. All fields except > callerid are recorded properly after every call. I have both a "clid" > and "callerid" f

[asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID

2009-10-28 Thread Carlos Chavez
I am having a problem with Asterisk 1.6.2.0-rc3 and Asterisk-Addons 1.6.2.0-rc1 when recording CDR to a Mysql database. All fields except callerid are recorded properly after every call. I have both a "clid" and "callerid" field in the database but both fields are empty. In cdr_mysql.con

[asterisk-users] MySQL CDR

2006-08-25 Thread Diego Quintana Cruz
Hi everyone, I finished installing the Xorcom Rapid's Asterisk Packages with amportal (1.10.10), but i wasn't able to find the asterisk-mysql package. Any idea what happened there?, Is there another reposiitory for that package for asterisk 1.0.11. Or could somebody send me the cdr_addon_mysql.so

RE: [asterisk-users] MySQL CDR

2006-08-25 Thread Rushowr
s@lists.digium.com >Subject: [asterisk-users] MySQL CDR > >Hi everyone, > >I finished installing the Xorcom Rapid's Asterisk Packages >with amportal (1.10.10), but i wasn't able to find the >asterisk-mysql package. Any idea what happened there?, Is >there anothe

RES: [Asterisk-Users] Mysql CDR

2005-05-22 Thread Rodrigo Otavio de Fraga
maio de 2005 00:28 Para: Asterisk Users Mailing List - Non-Commercial Discussion Assunto: Re: [Asterisk-Users] Mysql CDR Rodrigo Otavio de Fraga wrote: > Hi, > When I finished a call, the asterisk give a message : FAILED TO INSERT > INTO DATABASE. Make sure that the details inside cdr_m

Re: [Asterisk-Users] Mysql CDR

2005-05-21 Thread Matt Riddell
Rodrigo Otavio de Fraga wrote: Hi, When I finished a call, the asterisk give a message : FAILED TO INSERT INTO DATABASE. Make sure that the details inside cdr_mysql.conf are correct. I.E. if it has username bob, password fred, host 127.0.0.1, run mysql -u bob -p Then it will ask you for a

[Asterisk-Users] Mysql CDR

2005-05-20 Thread Rodrigo Otavio de Fraga
Hi,   When I finished a call, the asterisk give a message : FAILED TO INSERT INTO DATABASE.   I changed table in data base, change de Makefile file located in asterisk-addon and nothing it functioned.   Somebody  can help me ?   ___ A

[Asterisk-Users] Mysql CDR

2005-05-20 Thread Rodrigo Otavio de Fraga
Hi,   I can´t do a registry into Mysql database. When the call finished I received :   ERROR : FAILED TO INSERT INTO DATABASE.   I change many things but I did not obtain the problem resolution.   Somebody can help me ? ___ Asterisk-

Re: [Asterisk-Users] MySQL, CDR with MySQL

2004-12-09 Thread Matthew Boehm
As far as I know, CDR is not done with RealTime. You must have all the header files for mysql as well. Matthew - Original Message - From: "Bill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 09, 2004 10:21 AM Subject: [Asterisk-Users]

Re: [Asterisk-Users] MySQL, CDR with MySQL

2004-12-09 Thread Bruce Komito
I have the same problem, and I assumed it was because MySQL voicemail support is now accomplished through the realtime facility. But, so far, I haven't had a chance to research it further. Bruce Komito High Sierra Networks, Inc. www.servers-r-us.com (775) 236-5815 On Thu, 9 Dec 2004, Bill wrote

[Asterisk-Users] MySQL, CDR with MySQL

2004-12-09 Thread Bill
I'm preparing to roll out Asterisk for the voicemail portion of my VOIP network. This week I downloaded a fresh version from CVS of Asterisk and installed the following MySQL 4.1.7 RPMs directly from Mysql.orgFor some reason after I enable MySQL for CDR and Voicemail in the cdr_mysql.conf a

Re: [Asterisk-Users] Mysql-cdr

2004-12-06 Thread Matthew Boehm
on" <[EMAIL PROTECTED]> Sent: Monday, December 06, 2004 1:25 PM Subject: RE: [Asterisk-Users] Mysql-cdr /SNIP/ INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, accountcode, un

RE: [Asterisk-Users] Mysql-cdr

2004-12-06 Thread Kanuri, Seshu (Company IT)
/SNIP/   INSERT INTO cdr (calldate, clid, src, dst, dcontext, channel, dstchannel, lastapp, lastdata, duration, billsec, disposition, amaflags, accountcode, uniqueid)   ('2004-12-06 13:36:17', '\"Mohammad\"', ' ', '9053265824', 'sip', 'SIP/3000-b4f7', 'SIP/9053265824-f4b2', 'Dial', 'SIP/9

[Asterisk-Users] Mysql-cdr

2004-12-06 Thread mohammad
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 c

[Asterisk-Users] MySQL CDR addon problem

2004-10-15 Thread Shilliday, Jim
I thought I had this resolved, but apparently not. Every call generates this: Oct 15 16:54:19 ERROR[1115579712]: cdr_addon_mysql.c:200 mysql_log: Failed to insert into database. We know from the mysql log that * is connecting to MySQL: 041015 16:14:02 12 Connect [E

RE: [Asterisk-Users] MySQL CDR -- debugging

2004-10-14 Thread Shilliday, Jim
- Non-Commercial Discussion Subject: RE: [Asterisk-Users] MySQL CDR -- debugging Thanks -- worked. I now know that the mysql database is looking for two mandatory fields -- uniqueid and userfield -- that * isn't sending. I've missed something, but what? Maybe a version problem? Jim

RE: [Asterisk-Users] MySQL CDR -- debugging

2004-10-14 Thread Shilliday, Jim
TED] Sent: Thursday, October 14, 2004 5:54 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] MySQL CDR -- debugging Check /etc/asterisk/logger.conf Make sure you have an uncommented "debug =>" line. If it is uncommented, then it should

Re: [Asterisk-Users] MySQL CDR -- debugging

2004-10-14 Thread Matthew Boehm
our. Matthew - Original Message - From: "Shilliday, Jim" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> Sent: Thursday, October 14, 2004 4:14 PM Subject: [Asterisk-Users] MySQL CDR -- debugging I have the mysq

[Asterisk-Users] MySQL CDR -- debugging

2004-10-14 Thread Shilliday, Jim
I have the mysql cdr module installed and running: asterisk-pit*CLI> cdr mysql status Connected to [EMAIL PROTECTED] with username asterisk for 18 minutes, 9 seconds. Wrote 0 records since last restart. But it's not logging any calls, e.g.: Oct 14 16:50:37 E

Re: [Asterisk-Users] MySQL CDR

2004-04-07 Thread Ryan Thrash
Remove the semi-colon in front of "[global]" HTH, Ryan Thrash On Apr 7, 2004, at 8:15 PM, Jeremy Bogan wrote: Sounds like an error in your config file. Want to paste the contents in? Thanks... Sorry: ;[global] ;hostname=localhost dbname=asterisk password= user=asterisk ;port=3306 sock=/tmp/mys

Re: [Asterisk-Users] MySQL CDR

2004-04-07 Thread Jeremy Bogan
;[global] Never mind i'm an idiot. I've commented out [global], whoops! -- jeremy bogan[ [EMAIL PROTECTED] ] segment publishing - design.develop.host ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-

Re: [Asterisk-Users] MySQL CDR

2004-04-07 Thread Jeremy Bogan
Sounds like an error in your config file. Want to paste the contents in? Thanks... Sorry: ;[global] ;hostname=localhost dbname=asterisk password= user=asterisk ;port=3306 sock=/tmp/mysql.sock userfield=1 -- jeremy bogan[ [EMAIL PROTECTED] ] segment publishing - design.develop.host __

RE: [Asterisk-Users] MySQL CDR

2004-04-07 Thread Sean Cheesman
Sounds like an error in your config file. Want to paste the contents in? Thanks... Sean -Original Message- From: Jeremy Bogan [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 8:06 PM To: [EMAIL PROTECTED] Subject: [Asterisk-Users] MySQL CDR Hi, I'm trying to ge

[Asterisk-Users] MySQL CDR

2004-04-07 Thread Jeremy Bogan
Hi, I'm trying to get CDR recording via MySQL working. I've setup my database and compiled the asterisk-addons from cvs and setup the config file, but when i start asterisk i get this: [cdr_addon_mysql.so] => (MySQL CDR Backend) == Parsing '/etc/asterisk/cdr_mysql.conf': Found Apr 8 11:03:5

Re: [Asterisk-Users] Mysql CDR

2003-12-15 Thread listas iPfone
Thanks for all! It is working now :-) Regards Miklos - Original Message - From: "Tilghman Lesher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 13, 2003 3:16 PM Subject: Re: [Asterisk-Users] Mysql CDR > On Saturday 13 December 2003 11:

Re: [Asterisk-Users] Mysql CDR

2003-12-13 Thread Tilghman Lesher
On Saturday 13 December 2003 11:02, Mireia Munoz de jesus wrote: > The line with ;sock=/tmp/mysql.sock, i think you must write it > without the ";". You need this socket to connect with mysql. You don't usually need that configuration line. It's only there if your server and client conflict about

RE: [Asterisk-Users] Mysql CDR

2003-12-13 Thread Mireia Munoz de jesus
Sent: sexta-feira, 12 de dezembro de 2003 16:47 > To: [EMAIL PROTECTED] > Subject: [Asterisk-Users] Mysql CDR > > > Hi all > > I just installed the mysql cdr support and my database is not > registering the calls :( > > using show modules i see that the cdr_csv

RE: [Asterisk-Users] Mysql CDR

2003-12-12 Thread David Gomillion
Title: Message Were it me, I would see if MySQL is creating the socket where Asterisk expects it.    -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of listas iPfoneSent: Friday, December 12, 2003 1:47 PMTo: [EMAIL PROTECTED]Subject: [Asterisk-Users

Re: [Asterisk-Users] Mysql CDR

2003-12-12 Thread Philipp von Klitzing
Hi! > I just installed the mysql cdr support and my database is not registering > the calls :( > > It is necessary to unload the cdr_csv.so? how to do it? No. > [global] > hostname=localhost > dbname=asteriskcdrdb > password=new_password > user=asteriskcdruser Make sure you can connect from

RE: [Asterisk-Users] Mysql CDR

2003-12-12 Thread Paulo Mannheimer
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of listas iPfoneSent: sexta-feira, 12 de dezembro de 2003 16:47To: [EMAIL PROTECTED]Subject: [Asterisk-Users] Mysql CDR Hi all   I just installed the mysql cdr support and my database is not registering the calls :(   using show

[Asterisk-Users] Mysql CDR

2003-12-12 Thread listas iPfone
Hi all   I just installed the mysql cdr support and my database is not registering the calls :(   using show modules i see that the cdr_csv.so and the cdr_addon_mysql.so are loaded   It is necessary to unload  the cdr_csv.so? how to do it?   in crd_mysql.conf  i have:   [global]hostname=local

RE: [Asterisk-Users] Mysql CDR

2003-08-04 Thread Erik Anderson
PROTECTED]On Behalf Of Chee FoongSent: Monday, August 04, 2003 2:24 AMTo: [EMAIL PROTECTED]Subject: [Asterisk-Users] Mysql CDR hello all,   I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call r

[Asterisk-Users] Mysql CDR

2003-08-04 Thread Chee Foong
hello all,   I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call record.   Therefore I dive into the source code to add the start and end time into the query (add something like cdr->start, cdr->end), but end up ge