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
What version of asterisk are you installing?
Thanks,
--Warren Selby
On Mon, Nov 2, 2009 at 5:59 AM, Dan Journo d...@keshercommunications.comwrote:
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
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 Wed,
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 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 Lesher
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 properly
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 Mysql
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.6.2.0-rc3
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.conf I
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 field in
: [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 another reposiitory for that package for asterisk
1.0.11. Or could
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
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_mysql.conf
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
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 ?
___
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 ?
___
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
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
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'm
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
/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',
: 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,
uniqueid)
('2004-12-06 13:36:17',
'\Mohammad
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
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
- 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 mysql cdr module installed and running:
asterisk-pit*CLI cdr
: 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 be located at
/var/log
- 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 Shilliday
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
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
Sounds like an error in your config file. Want to paste the contents
in? Thanks...
Sorry:
;[global]
;hostname=localhost
dbname=asterisk
password=password
user=asterisk
;port=3306
sock=/tmp/mysql.sock
userfield=1
--
jeremy bogan[ [EMAIL PROTECTED] ]
segment publishing - design.develop.host
;[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]
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=password
user=asterisk
;port=3306
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:02, Mireia Munoz de jesus wrote
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.so and the cdr_addon_mysql.so
are loaded
It is necessary to unload
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
]
[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 modules i see
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 the box
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
hello all,
I am using the msql cdr module to store cdr in db,
I realised thatit does't capture the start and end time af a particular
call record.
Therefore I dive into the source code toadd
the start and end timeinto the query (add something like cdr-start,
cdr-end), but end up getting
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 thatit does't capture the start and end time af a
particular call record
40 matches
Mail list logo
