Re: [asterisk-users] MySQL CDR
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 > > > > > > ___ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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, 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 after every call. >> > > > > > I have both a "clid" and "callerid" field in the database but both >> > > > > > fields are empty. In cdr_mysql.conf I have this alias in the >> > > > > > [columns] section: >> > > > > > >> > > > > > alias start => calldate >> > > > > > alias callerid => clid >> > > > > >> > > > > Get rid of this "alias callerid => clid" line. What it does is to >> > > > > tell the driver to put the CDR variable called "callerid" into the >> > > > > "clid" column in the database, overriding the builtin "clid" mapping. >> > > > > Then reload. If you want the Caller*ID information in the >> > > > > "callerid" column, then your mapping is backwards and should be >> > > > > "alias clid => callerid". Remember, the arrow points in the direction >> > > > > that the information flows: FROM the cdr TO the database. >> > > > >> > > >I already tried that with the same result. I even added a >> > > > callerid >> > > > column to my cdr table just in case. Either removing the alias line or >> > > > reversing it like you suggested will not record the callerid in either >> > > > column. >> > > >> > > Try the following commands. What is output? >> > > >> > > CLI> core set debug 1 >> > > CLI> module reload cdr_addon_mysql.so >> > >> >Just this: >> > >> > pbxoficina*CLI> core set debug 1 >> > Core debug is at least 1 >> > pbxoficina*CLI> module reload cdr_addon_mysql.so >> > -- Reloading module 'cdr_addon_mysql.so' (MySQL CDR Backend) >> > pbxoficina*CLI> >> >> Do you have debug set to go to console in logger.conf? >> > Yes: > >pbxoficina*CLI> logger show channels >Channel Type StatusConfiguration >--- --- >/var/log/asterisk/messages File Enabled- Warning Notice >Error >Console Enabled- Debug Warning Did you solved this problem? I'm having the same issue on asteriks-1.6.1.8 except in my case no records are being passed to mysql. -- Joseph ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 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 after every call. > > > > > > I have both a "clid" and "callerid" field in the database but both > > > > > > fields are empty. In cdr_mysql.conf I have this alias in the > > > > > > [columns] section: > > > > > > > > > > > > alias start => calldate > > > > > > alias callerid => clid > > > > > > > > > > Get rid of this "alias callerid => clid" line. What it does is to > > > > > tell the driver to put the CDR variable called "callerid" into the > > > > > "clid" column in the database, overriding the builtin "clid" mapping. > > > > > Then reload. If you want the Caller*ID information in the > > > > > "callerid" column, then your mapping is backwards and should be > > > > > "alias clid => callerid". Remember, the arrow points in the direction > > > > > that the information flows: FROM the cdr TO the database. > > > > > > > > I already tried that with the same result. I even added a > > > > callerid > > > > column to my cdr table just in case. Either removing the alias line or > > > > reversing it like you suggested will not record the callerid in either > > > > column. > > > > > > Try the following commands. What is output? > > > > > > CLI> core set debug 1 > > > CLI> module reload cdr_addon_mysql.so > > > > Just this: > > > > pbxoficina*CLI> core set debug 1 > > Core debug is at least 1 > > pbxoficina*CLI> module reload cdr_addon_mysql.so > > -- Reloading module 'cdr_addon_mysql.so' (MySQL CDR Backend) > > pbxoficina*CLI> > > Do you have debug set to go to console in logger.conf? > Yes: pbxoficina*CLI> logger show channels Channel Type StatusConfiguration --- --- /var/log/asterisk/messages File Enabled- Warning Notice Error Console Enabled- Debug Warning Notice Error -- Telecomunicaciones Abiertas de México S.A. de C.V. Carlos Chávez Prats Director de Tecnología +52-55-91169161 ext 2001 signature.asc Description: This is a digitally signed message part ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 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 the database but both > > > > > fields are empty. In cdr_mysql.conf I have this alias in the > > > > > [columns] section: > > > > > > > > > > alias start => calldate > > > > > alias callerid => clid > > > > > > > > Get rid of this "alias callerid => clid" line. What it does is to > > > > tell the driver to put the CDR variable called "callerid" into the > > > > "clid" column in the database, overriding the builtin "clid" mapping. > > > > Then reload. If you want the Caller*ID information in the > > > > "callerid" column, then your mapping is backwards and should be > > > > "alias clid => callerid". Remember, the arrow points in the direction > > > > that the information flows: FROM the cdr TO the database. > > > > > > I already tried that with the same result. I even added a callerid > > > column to my cdr table just in case. Either removing the alias line or > > > reversing it like you suggested will not record the callerid in either > > > column. > > > > Try the following commands. What is output? > > > > CLI> core set debug 1 > > CLI> module reload cdr_addon_mysql.so > > Just this: > > pbxoficina*CLI> core set debug 1 > Core debug is at least 1 > pbxoficina*CLI> module reload cdr_addon_mysql.so > -- Reloading module 'cdr_addon_mysql.so' (MySQL CDR Backend) > pbxoficina*CLI> Do you have debug set to go to console in logger.conf? -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 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 have this alias in the [columns] section: > > > > > > > > alias start => calldate > > > > alias callerid => clid > > > > > > Get rid of this "alias callerid => clid" line. What it does is to tell > > > the driver to put the CDR variable called "callerid" into the "clid" > > > column in the database, overriding the builtin "clid" mapping. Then > > > reload. If you want the Caller*ID information in the "callerid" column, > > > then your mapping is backwards and should be "alias clid => callerid". > > > Remember, the arrow points in the direction that the information flows: > > > FROM the cdr TO the database. > > > > I already tried that with the same result. I even added a callerid > > column to my cdr table just in case. Either removing the alias line or > > reversing it like you suggested will not record the callerid in either > > column. > > Try the following commands. What is output? > > CLI> core set debug 1 > CLI> module reload cdr_addon_mysql.so > Just this: pbxoficina*CLI> core set debug 1 Core debug is at least 1 pbxoficina*CLI> module reload cdr_addon_mysql.so -- Reloading module 'cdr_addon_mysql.so' (MySQL CDR Backend) pbxoficina*CLI> -- Telecomunicaciones Abiertas de México S.A. de C.V. Carlos Chávez Prats Director de Tecnología +52-55-91169161 ext 2001 signature.asc Description: This is a digitally signed message part ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 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 have this alias in the [columns] section: > > > > > > alias start => calldate > > > alias callerid => clid > > > > Get rid of this "alias callerid => clid" line. What it does is to tell > > the driver to put the CDR variable called "callerid" into the "clid" > > column in the database, overriding the builtin "clid" mapping. Then > > reload. If you want the Caller*ID information in the "callerid" column, > > then your mapping is backwards and should be "alias clid => callerid". > > Remember, the arrow points in the direction that the information flows: > > FROM the cdr TO the database. > > I already tried that with the same result. I even added a callerid > column to my cdr table just in case. Either removing the alias line or > reversing it like you suggested will not record the callerid in either > column. Try the following commands. What is output? CLI> core set debug 1 CLI> module reload cdr_addon_mysql.so -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 after every call. I have both a "clid" > > and "callerid" field in the database but both fields are empty. In > > cdr_mysql.conf I have this alias in the [columns] section: > > > > alias start => calldate > > alias callerid => clid > > Get rid of this "alias callerid => clid" line. What it does is to tell the > driver to put the CDR variable called "callerid" into the "clid" column in the > database, overriding the builtin "clid" mapping. Then reload. If you want > the Caller*ID information in the "callerid" column, then your mapping is > backwards and should be "alias clid => callerid". Remember, the arrow points > in the direction that the information flows: FROM the cdr TO the database. > I already tried that with the same result. I even added a callerid column to my cdr table just in case. Either removing the alias line or reversing it like you suggested will not record the callerid in either column. -- Telecomunicaciones Abiertas de México S.A. de C.V. Carlos Chávez Prats Director de Tecnología +52-55-91169161 ext 2001 signature.asc Description: This is a digitally signed message part ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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 the database but both fields are empty. In > cdr_mysql.conf I have this alias in the [columns] section: > > alias start => calldate > alias callerid => clid Get rid of this "alias callerid => clid" line. What it does is to tell the driver to put the CDR variable called "callerid" into the "clid" column in the database, overriding the builtin "clid" mapping. Then reload. If you want the Caller*ID information in the "callerid" column, then your mapping is backwards and should be "alias clid => callerid". Remember, the arrow points in the direction that the information flows: FROM the cdr TO the database. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [asterisk-users] MySQL CDR
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 >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 another reposiitory for that package for asterisk >1.0.11. Or could somebody send me the cdr_addon_mysql.so file? > >Thanks for your responses, >-- >Diego Quintana a.k.a. RouterMaN >Ingeniería de las Telecomunicaciones >PUCP >Linux Registered User #382615 - http://counter.li.org/ SIP # >1-747-633-6676 Ext. 1011 FWD # 764839 Ext. 1011 >http://routerman.blogsome.com http://planeta.debianperu.org >___ >--Bandwidth and Colocation provided by Easynews.com -- > >asterisk-users mailing list >To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
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 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 password. Type fred (or whatever your password is). Then it should connect (if the user/pass is in the db). If you then type use cdr (where cdr is the name of your cdr database) it should work. So, if you go through these steps, you should be able to find out where the problem is. (BTW: you did create the tables didn't you?) :) -- Cheers, Matt Riddell ___ http://www.sineapps.com/news.php (Daily Asterisk News - html) http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss) ___ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] MySQL, CDR with MySQL
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 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 and > voicemail.conf I don't get any MySQL functionality at all. It almost seems > as though MySQL support isn't even being compiled into Asterisk. I found > somewhere that the Z Library was required and that is already installed. > > Can someone clue me in? > > MySQL-client-4.1.7-0.i386.rpm > MySQL-devel-4.1.7-0.i386.rpm > MySQL-server-4.1.7-0.i386.rpm > MySQL-shared-4.1.7-0.i386.rpm > MySQL-shared-compat-4.1.7-0.i386.rpm > > Bill > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] MySQL, CDR with MySQL
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: > 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 and > voicemail.conf I don't get any MySQL functionality at all. It almost seems > as though MySQL support isn't even being compiled into Asterisk. I found > somewhere that the Z Library was required and that is already installed. > > Can someone clue me in? > > MySQL-client-4.1.7-0.i386.rpm > MySQL-devel-4.1.7-0.i386.rpm > MySQL-server-4.1.7-0.i386.rpm > MySQL-shared-4.1.7-0.i386.rpm > MySQL-shared-compat-4.1.7-0.i386.rpm > > Bill > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: >http://lists.digium.com/mailman/listinfo/asterisk-users > > This message has been categorized as "Legitimate" by Bayesian Analyzer. > If you do not agree, please click on the link below to train the Analyzer. > http://nospam.wpti.net/bt/a.aspx?M=C:%5Csmtpmail%5CBayesTraining%5C2004-12-09%5C7350c93c751f4f218ea4f17c983c7491&C=2 > > -- > --- > This message has been inspected by DynaComm i:mail > --- > > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Mysql-cdr
We have quotes in our CDRs and have no problems. Check the debug log. You
should see a reason on why the query failed.
-Matthew
- Original Message -
From: "Kanuri, Seshu (Company IT)" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<[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,
uniqueid)
('2004-12-06 13:36:17',
'\"Mohammad\"',
' ',
'9053265824',
'sip',
'SIP/3000-b4f7',
'SIP/9053265824-f4b2',
'Dial',
'SIP/9053265824|20| Ttr',
9,
5,
'ANSWERED',
3,
' ',
'1102358177.0'
)
Dec 6 13:36:26 ERROR[1221985728]: cdr_addon_mysql.c:200 mysql_log:
Failed to insert into database.Dec 6 13:36:26 ERROR[1221985728]:
/SNIP/
Above is the breakdown of your Insert Statement. There is a problem
with the formatting of your CLID, the second field. Try to change that
to a number or something and try again. Dont use quotes or slashes in
your name in the CLID.
Seshu kanuri
**
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
> ___
> Asterisk-Users mailing list
> [EMAIL PROTECTED]
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
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\"',
' ',
'9053265824',
'sip',
'SIP/3000-b4f7',
'SIP/9053265824-f4b2',
'Dial',
'SIP/9053265824|20| Ttr',
9,
5,
'ANSWERED',
3,
' ',
'1102358177.0'
)
Dec 6 13:36:26 ERROR[1221985728]:
cdr_addon_mysql.c:200 mysql_log: Failed to insert into database.Dec 6
13:36:26 ERROR[1221985728]:
/SNIP/
Above is the breakdown of your Insert Statement. There is a
problem with the formatting of your CLID, the second field. Try to change
that to a number or something and try again. Dont use quotes or slashes in
your name in the CLID.
Seshu kanuri
**
NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] MySQL CDR -- debugging
Aahhh, found it -- in the wiki:
http://www.voip-info.org/tiki-index.php?page=Asterisk%20cdr%20mysql
Gotta recompile it or kill the uniqueid field in MySQL.
Jim Shilliday
-Original Message-
From: Shilliday, Jim
Sent: Thursday, October 14, 2004 7:06 PM
To: Asterisk Users Mailing List - 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
-Original Message-
From: Matthew Boehm [mailto:[EMAIL PROTECTED]
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 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
- 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 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 ERROR[1115575616]: cdr_addon_mysql.c:200
mysql_log: Failed to insert into database.
I haven't been able to locate the log file -- near line 200, the source
says:
ast_log(LOG_DEBUG,"cdr_mysql: SQL command as follows
%s\n",sqlcmd);
if (mysql_real_query(&mysql,sqlcmd,strlen(sqlcmd))) {
ast_log(LOG_ERROR,"Failed to insert into
database.");
ast_mutex_unlock(&mysql_lock);
return -1;
} else {
records++;
totalrecords++;
}
}
Can someone tell me where that LOG_DEBUG info goes? Do I need to turn
on debugging somewhere? Is there a default MySQL log that will show the
error?
Thanks-
Jim Shilliday
IT Director
Equal Justice Center
1315 Walnut St. Suite 400
Philadelphia PA 19107
215-238-6970
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
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
-Original Message-
From: Matthew Boehm [mailto:[EMAIL PROTECTED]
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 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
- 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 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 ERROR[1115575616]: cdr_addon_mysql.c:200
mysql_log: Failed to insert into database.
I haven't been able to locate the log file -- near line 200, the source
says:
ast_log(LOG_DEBUG,"cdr_mysql: SQL command as follows
%s\n",sqlcmd);
if (mysql_real_query(&mysql,sqlcmd,strlen(sqlcmd))) {
ast_log(LOG_ERROR,"Failed to insert into
database.");
ast_mutex_unlock(&mysql_lock);
return -1;
} else {
records++;
totalrecords++;
}
}
Can someone tell me where that LOG_DEBUG info goes? Do I need to turn
on debugging somewhere? Is there a default MySQL log that will show the
error?
Thanks-
Jim Shilliday
IT Director
Equal Justice Center
1315 Walnut St. Suite 400
Philadelphia PA 19107
215-238-6970
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
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/asterisk/debug
If it is commented, un-comment it and restart asterisk.
Be warned, this debug log can grow by megabytes every hour.
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 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 ERROR[1115575616]: cdr_addon_mysql.c:200
mysql_log: Failed to insert into database.
I haven't been able to locate the log file -- near line 200, the source
says:
ast_log(LOG_DEBUG,"cdr_mysql: SQL command as follows
%s\n",sqlcmd);
if (mysql_real_query(&mysql,sqlcmd,strlen(sqlcmd))) {
ast_log(LOG_ERROR,"Failed to insert into
database.");
ast_mutex_unlock(&mysql_lock);
return -1;
} else {
records++;
totalrecords++;
}
}
Can someone tell me where that LOG_DEBUG info goes? Do I need to turn
on debugging somewhere? Is there a default MySQL log that will show the
error?
Thanks-
Jim Shilliday
IT Director
Equal Justice Center
1315 Walnut St. Suite 400
Philadelphia PA 19107
215-238-6970
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] MySQL CDR
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/mysql.sock userfield=1 -- jeremy bogan[ [EMAIL PROTECTED] ] segment publishing - design.develop.host ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] MySQL CDR
;[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-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] MySQL CDR
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 ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] MySQL CDR
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 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:59 WARNING[16384]: config.c:551 cfg_process: parse error: No category context for line 15 of cdr_mysql.conf Apr 8 11:03:59 WARNING[16384]: cdr_addon_mysql.c:267 my_load_module: Unable to load config for mysql CDR's: cdr_mysql.conf Does anyone know what this means? -- jeremy bogan[ [EMAIL PROTECTED] ] segment publishing - design.develop.host ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Mysql CDR
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: > > 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 the "correct" location for the sock > file. For example, the MySQL default location is /tmp/mysql.sock, but > RedHat (and others) insist on putting that in /var/lib/mysql/mysql.sock. > > -Tilghman > > ___ > Asterisk-Users mailing list > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] Mysql CDR
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 the "correct" location for the sock file. For example, the MySQL default location is /tmp/mysql.sock, but RedHat (and others) insist on putting that in /var/lib/mysql/mysql.sock. -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Mysql CDR
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 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.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=localhost > dbname=asteriskcdrdb > password=new_password > user=asteriskcdruser > ;port=3306 > ;sock=/tmp/mysql.sock > > i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be > there ..or not? > > and in modules.conf i have: > > load => cdr_addon_mysql.so > > It is correct? something more is needed? ( i created the database and > table from wiki instructions) > > How can i know if asterisk is or not trying to register the calls to the > database? > > > > Thanks! > > miklos > > > > iPFONE Telefonia IP > Rua Caio Graco 735 São Paulo SP > iPBX +55 11 3801-3702 > UK +44 870 - 3403539 > FWD 64662 > sip:[EMAIL PROTECTED] > www.ipfone.com.br > [EMAIL PROTECTED] > > ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Mysql CDR
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] 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 the cdr_csv.so? how to do it? in crd_mysql.conf i have: [global]hostname=localhostdbname=asteriskcdrdbpassword=new_password user=asteriskcdruser;port=3306;sock=/tmp/mysql.sock i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be there ..or not? and in modules.conf i have: load => cdr_addon_mysql.so It is correct? something more is needed? ( i created the database and table from wiki instructions) How can i know if asterisk is or not trying to register the calls to the database? Thanks! miklos iPFONE Telefonia IPRua Caio Graco 735 São Paulo SP iPBX +55 11 3801-3702UK +44 870 - 3403539FWD 64662sip:[EMAIL PROTECTED] www.ipfone.com.br[EMAIL PROTECTED]
Re: [Asterisk-Users] Mysql CDR
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 that runs Asterisk to mySQL: mysql -u asteriskcdruser -p then: use asteriskcdrdb then: explain cdr; If that works ok but you still cannot write to mySQL with Asterisk: use hostname= instead of hostname=localhost also uncomment the port=3306 part > i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be > there ..or not? Yep, but check the name - it is "cdr" not "crd". > How can i know if asterisk is or not trying to register the calls to the > database? Check /var/log/asterisk/messages Hint: You should probably also want to enable the UNIQUEID field Read more at http://www.voip-info.org/wiki-Asterisk+billing and click on the red "comments" tab on the top of the screen, then scroll down. Cheers, Philipp ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] Mysql CDR
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] [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 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=localhostdbname=asteriskcdrdbpassword=new_password user=asteriskcdruser;port=3306;sock=/tmp/mysql.sock i copied the crd_mysql.conf to the /etc/asterisk directory..it is to be there ..or not? and in modules.conf i have: load => cdr_addon_mysql.so It is correct? something more is needed? ( i created the database and table from wiki instructions) How can i know if asterisk is or not trying to register the calls to the database? Thanks! miklos iPFONE Telefonia IPRua Caio Graco 735 São Paulo SP iPBX +55 11 3801-3702UK +44 870 - 3403539FWD 64662sip:[EMAIL PROTECTED] www.ipfone.com.br[EMAIL PROTECTED]
RE: [Asterisk-Users] Mysql CDR
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 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 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 getting segfault. the original version of cdr_mysql.so works fine but I need the start time and end time of calling as well. I wonder what would I get with cdr->start? the start time field in my db is of type date or should i use varchar? thanks Foong cdr_mysql2.c Description: Binary data billing.sql Description: Binary data
