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

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

RE: [asterisk-users] MySQL CDR

2006-08-25 Thread Rushowr
Download the asterisk-addons package. It contains several addons, including all the mysql additions. >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Diego Quintana Cruz >Sent: Thursday, August 24, 2006 4:06 PM >To: asterisk-users@lists.digium.com >S

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

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] MySQL, CDR with MySQL > I

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

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

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
Check /etc/asterisk/logger.conf Make sure you have an uncommented "debug =>" line. If it is uncommented, then it should be located at /var/log/asterisk/debug If it is commented, un-comment it and restart asterisk. Be warned, this debug log can grow by megabytes every hour. Matthew - Ori

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 get CDR recordi

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
Hi! The line with ;sock=/tmp/mysql.sock, i think you must write it without the ";". You need this socket to connect with mysql. Best regards, Mireia > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of listas > iPfone > Sent: sexta-feira, 12 de dezem

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
Title: Message Hi Miklos,   try starting * with -vvvc and see if there is any warning   also, try connecting to your mysql server by issuing >mysql asteriskcdrdb then   > show tables; > select * from cdr;   best,   PHM -Original Message-From: [EMAIL PROTECTED]

RE: [Asterisk-Users] Mysql CDR

2003-08-04 Thread Erik Anderson
Chee Foong,   Here is a cdr_mysql2.c I rewrote.  It captures all the billing information you will need.   You will need to change the Makefile to compile it.   Also attached is a script to create the database.   Erik -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL