[asterisk-users] MySQL CDR
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
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 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 ___ -- 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 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 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 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 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 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
[asterisk-users] Mysql CDR in Addons 1.6.2.0-rc1 does not record CLID
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
Is anyone using this version of Asterisk and Addons that can confirm if
they are getting the CLID? If I do a NoOp(CLID: ${CDR(clid)}) I see the
callerid in the CLI. The CSV file also records the callerid. Maybe a
bug in cdr_addon_mysql ?
--
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
[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
RES: [Asterisk-Users] Mysql CDR
I used the exemple listed in voip-info, but this list is wrong. I run de debug and I find de correct table, the error was in INSERT mysql command. Now all is function. -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Em nome de Matt Riddell Enviada em: domingo, 22 de 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 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 ___ 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
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
[Asterisk-Users] Mysql CDR
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-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
[Asterisk-Users] Mysql CDR
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 ? ___ 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
[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
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%5C7350c93c751f4f218ea4f17c983c7491C=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 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
[Asterisk-Users] Mysql-cdr
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 command as
follows: INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid)
VALUES ('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]:
**
I tried several Asterisk-addons cvs head, including
the latest one.
Regards
Mohammad
___
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
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
[Asterisk-Users] MySQL CDR addon problem
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 [EMAIL PROTECTED] on
asteriskcdrdb
According to the MySQL log, * is trying to do this:
041015 16:54:19 12 Query INSERT INTO cdr
(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,dura
tion,billsec,disposition,amaflags,accountcode,userfield) VALUES
('2004-10-15 16:53:56','\Jim\ 7401','7401','7368','outgoing',
'SIP/Ciscoe7f578-a503','SIP/Ciscod66bbf-1-55da','Hangup','',23,3,'ANSWER
ED',3,'','')
Here's the table structure (I set those allow nulls while trying to
solve this problem):
mysql describe cdr;
+-+--+--+-+-+---
+
| Field | Type | Null | Key | Default | Extra
|
+-+--+--+-+-+---
+
| userfield | varchar(255) | YES | | NULL|
|
| accountcode | varchar(20) | YES | | NULL|
|
| src | varchar(80) | | | |
|
| dst | varchar(80) | | | |
|
| dcontext| varchar(80) | | | |
|
| clid| varchar(80) | | | |
|
| channel | varchar(80) | | | |
|
| dstchannel | varchar(80) | YES | | NULL|
|
| lastapp | varchar(80) | YES | | NULL|
|
| lastdata| varchar(80) | YES | | NULL|
|
| calldate| datetime | | | -00-00 00:00:00 |
|
| duration| int(11) | | | 0 |
|
| billsec | int(11) | | | 0 |
|
| disposition | varchar(45) | | | |
|
| amaflags| int(11) | YES | | NULL|
|
+-+--+--+-+-+---
+
15 rows in set (0.00 sec)
I'm pretty sure the permissions are right:
Mysql show grants for [EMAIL PROTECTED];
GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON
*.* TO 'asterisk'@'localhost' IDENTIFIED BY PASSWORD 'yadayada'
GRANT ALL PRIVILEGES ON `asteriskcdrdb`.`asteriskcdrdb` TO
'asterisk'@'localhost' WITH GRANT OPTION
If there's a specific error message from MySQL in response to the
INSERT, I haven't been able to locate it. Ideas anyone?
Thanks
Jim Shilliday
___
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] 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
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 -- 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
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
[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
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
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 ___ 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
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 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
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
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
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
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
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=fqdn 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 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]
[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. 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 segfault. the original version of cdr_mysql.so works fine but Ineed the start time and end time of calling as well. I wonder what would Iget with cdr-start?the start time field in my dbis of type date or should i use varchar? thanks Foong
RE: [Asterisk-Users] Mysql CDR
Chee Foong, Here isa 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 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 segfault. the original version of cdr_mysql.so works fine but Ineed the start time and end time of calling as well. I wonder what would Iget with cdr-start?the start time field in my dbis of type date or should i use varchar? thanks Foong cdr_mysql2.c Description: Binary data billing.sql Description: Binary data
