Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository
Yes, asterisk18-addons and asterisk18-addons-mysql are installed. The file cdr_mysql.so exists and I added it to modules.conf with load = cdr_mysql.so. But the module doesn't show loaded when I do module show like cdr. Seems like some config is missing. Which file is responsible for this type of config. Thanks On Sat, Jun 16, 2012 at 4:35 PM, isr...@gmail.com wrote: Did you install the addons Yum install asterisk18-addons-mysql -Original Message- From: Duncan Turnbull dun...@e-simple.co.nz Sender: asterisk-users-boun...@lists.digium.com Date: Sun, 17 Jun 2012 08:30:00 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository
Pinpointed the problem to do with Digium repository. When I do yum install asterisk18 system installs: asterisk18.i386 *1.8.7.0-2_centos5*asterisk-current After, when I do yum update asterisk18-* then the asterisk18-core updates: asterisk18.i386 *1.8.13.0-1_centos5 * * * I don't know if this is a bug in Digium repository or what but 1.8.7.0-2 should NOT show as asterisk-current. Problem is that upon update, not all packages update. So, when trying to do module load cdr_mysql this error prints: *loader.c: Module 'cdr_mysql.so' was not compiled with the same compile-time options as this version of Asterisk.* *loader.c: Module 'cdr_mysql.so' will not be initialized as it may cause instability.* *loader.c: Module 'cdr_mysql' could not be loaded.* * * I tried download .rpm files of asterisk18-addons.rpm, asterisk18-addons-core.rpm, and asterisk18-mysql.rpm but the asterisk18-mysql.rpm fails due to dependencies upon install. So, this seems a bit complicated but it's probably an easy fix if Digium updates the system to use all REAL current version at first install instead of needing to update right after fresh install. Any thoughts? Thanks On Sun, Jun 17, 2012 at 9:34 PM, Bruce B bruceb...@gmail.com wrote: Yes, asterisk18-addons and asterisk18-addons-mysql are installed. The file cdr_mysql.so exists and I added it to modules.conf with load = cdr_mysql.so. But the module doesn't show loaded when I do module show like cdr. Seems like some config is missing. Which file is responsible for this type of config. Thanks On Sat, Jun 16, 2012 at 4:35 PM, isr...@gmail.com wrote: Did you install the addons Yum install asterisk18-addons-mysql -Original Message- From: Duncan Turnbull dun...@e-simple.co.nz Sender: asterisk-users-boun...@lists.digium.com Date: Sun, 17 Jun 2012 08:30:00 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository
Please correct me if I'm wrong... The current version of asterisk now is 10.x Cdr_mysql is not used anymore. Now they using odbc to connect to mysql database. Why dont you try to install asterisk using source TAR.GZ ? It will make you learned where you have to do some setting... :D. Rather difficult but fun... :D From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Bruce B Sent: 18 Juni 2012 9:29 To: isr...@gmail.com; Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository Pinpointed the problem to do with Digium repository. When I do yum install asterisk18 system installs: asterisk18.i386 1.8.7.0-2_centos5asterisk-current After, when I do yum update asterisk18-* then the asterisk18-core updates: asterisk18.i386 1.8.13.0-1_centos5 I don't know if this is a bug in Digium repository or what but 1.8.7.0-2 should NOT show as asterisk-current. Problem is that upon update, not all packages update. So, when trying to do module load cdr_mysql this error prints: loader.c: Module 'cdr_mysql.so' was not compiled with the same compile-time options as this version of Asterisk. loader.c: Module 'cdr_mysql.so' will not be initialized as it may cause instability. loader.c: Module 'cdr_mysql' could not be loaded. I tried download .rpm files of asterisk18-addons.rpm, asterisk18-addons-core.rpm, and asterisk18-mysql.rpm but the asterisk18-mysql.rpm fails due to dependencies upon install. So, this seems a bit complicated but it's probably an easy fix if Digium updates the system to use all REAL current version at first install instead of needing to update right after fresh install. Any thoughts? Thanks On Sun, Jun 17, 2012 at 9:34 PM, Bruce B bruceb...@gmail.com wrote: Yes, asterisk18-addons and asterisk18-addons-mysql are installed. The file cdr_mysql.so exists and I added it to modules.conf with load = cdr_mysql.so. But the module doesn't show loaded when I do module show like cdr. Seems like some config is missing. Which file is responsible for this type of config. Thanks On Sat, Jun 16, 2012 at 4:35 PM, isr...@gmail.com wrote: Did you install the addons Yum install asterisk18-addons-mysql -Original Message- From: Duncan Turnbull dun...@e-simple.co.nz Sender: asterisk-users-boun...@lists.digium.com Date: Sun, 17 Jun 2012 08:30:00 To: Asterisk Users Mailing List - Non-Commercial Discussionasterisk-users@lists.digium.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository
This is not related to Asterisk Now but simply Asterisk as provided by Digium repositories and documented in Asterisk Wiki. Source install is one way to do this but that is not the issue in question. I hope someone at Digium fixes and update the repositories to current version. On Sun, Jun 17, 2012 at 10:59 PM, Ikka Vertika ikka.vert...@mitrakreasindo.com wrote: Please correct me if I’m wrong... ** ** The current version of asterisk now is 10.x Cdr_mysql is not used anymore. Now they using odbc to connect to mysql database. ** ** Why dont you try to install asterisk using source TAR.GZ ? It will make you learned where you have to do some setting... :D. Rather difficult but fun... :D ** ** ** ** ** ** *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *Bruce B *Sent:* 18 Juni 2012 9:29 *To:* isr...@gmail.com; Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository ** ** Pinpointed the problem to do with Digium repository. When I do yum install asterisk18 system installs: asterisk18.i386 *1.8.7.0-2_centos5*asterisk-current ** ** After, when I do yum update asterisk18-* then the asterisk18-core updates: asterisk18.i386 *1.8.13.0-1_centos5 * ** ** I don't know if this is a bug in Digium repository or what but 1.8.7.0-2 should NOT show as asterisk-current. ** ** Problem is that upon update, not all packages update. So, when trying to do module load cdr_mysql this error prints: *loader.c: Module 'cdr_mysql.so' was not compiled with the same compile-time options as this version of Asterisk.* *loader.c: Module 'cdr_mysql.so' will not be initialized as it may cause instability.* *loader.c: Module 'cdr_mysql' could not be loaded.* ** ** I tried download .rpm files of asterisk18-addons.rpm, asterisk18-addons-core.rpm, and asterisk18-mysql.rpm but the asterisk18-mysql.rpm fails due to dependencies upon install. So, this seems a bit complicated but it's probably an easy fix if Digium updates the system to use all REAL current version at first install instead of needing to update right after fresh install. ** ** Any thoughts? ** ** Thanks ** ** ** ** ** ** ** ** On Sun, Jun 17, 2012 at 9:34 PM, Bruce B bruceb...@gmail.com wrote: Yes, asterisk18-addons and asterisk18-addons-mysql are installed. The file cdr_mysql.so exists and I added it to modules.conf with load = cdr_mysql.so. But the module doesn't show loaded when I do module show like cdr. ** ** Seems like some config is missing. Which file is responsible for this type of config. ** ** Thanks ** ** ** ** ** ** ** ** On Sat, Jun 16, 2012 at 4:35 PM, isr...@gmail.com wrote: Did you install the addons Yum install asterisk18-addons-mysql -Original Message- From: Duncan Turnbull dun...@e-simple.co.nz Sender: asterisk-users-boun...@lists.digium.com Date: Sun, 17 Jun 2012 08:30:00 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http
Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository
Seems like there are new instructions for installing from RPM repository which seems to be working fine and updating to proper current version of Asterisk: https://wiki.asterisk.org/wiki/display/AST/Asterisk+Packages#AsteriskPackages-YUM%28CentOS5%2FRedHatEnterpriseLinux5%29 -Bruce On Sun, Jun 17, 2012 at 11:13 PM, Bruce B bruceb...@gmail.com wrote: This is not related to Asterisk Now but simply Asterisk as provided by Digium repositories and documented in Asterisk Wiki. Source install is one way to do this but that is not the issue in question. I hope someone at Digium fixes and update the repositories to current version. On Sun, Jun 17, 2012 at 10:59 PM, Ikka Vertika ikka.vert...@mitrakreasindo.com wrote: Please correct me if I’m wrong... ** ** The current version of asterisk now is 10.x Cdr_mysql is not used anymore. Now they using odbc to connect to mysql database. ** ** Why dont you try to install asterisk using source TAR.GZ ? It will make you learned where you have to do some setting... :D. Rather difficult but fun... :D ** ** ** ** ** ** *From:* asterisk-users-boun...@lists.digium.com [mailto: asterisk-users-boun...@lists.digium.com] *On Behalf Of *Bruce B *Sent:* 18 Juni 2012 9:29 *To:* isr...@gmail.com; Asterisk Users Mailing List - Non-Commercial Discussion *Subject:* Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository ** ** Pinpointed the problem to do with Digium repository. When I do yum install asterisk18 system installs: asterisk18.i386 *1.8.7.0-2_centos5*asterisk-current ** ** After, when I do yum update asterisk18-* then the asterisk18-core updates: asterisk18.i386 *1.8.13.0-1_centos5 * ** ** I don't know if this is a bug in Digium repository or what but 1.8.7.0-2 should NOT show as asterisk-current. ** ** Problem is that upon update, not all packages update. So, when trying to do module load cdr_mysql this error prints: *loader.c: Module 'cdr_mysql.so' was not compiled with the same compile-time options as this version of Asterisk.* *loader.c: Module 'cdr_mysql.so' will not be initialized as it may cause instability.* *loader.c: Module 'cdr_mysql' could not be loaded.* ** ** I tried download .rpm files of asterisk18-addons.rpm, asterisk18-addons-core.rpm, and asterisk18-mysql.rpm but the asterisk18-mysql.rpm fails due to dependencies upon install. So, this seems a bit complicated but it's probably an easy fix if Digium updates the system to use all REAL current version at first install instead of needing to update right after fresh install. ** ** Any thoughts? ** ** Thanks ** ** ** ** ** ** ** ** On Sun, Jun 17, 2012 at 9:34 PM, Bruce B bruceb...@gmail.com wrote: Yes, asterisk18-addons and asterisk18-addons-mysql are installed. The file cdr_mysql.so exists and I added it to modules.conf with load = cdr_mysql.so. But the module doesn't show loaded when I do module show like cdr. ** ** Seems like some config is missing. Which file is responsible for this type of config. ** ** Thanks ** ** ** ** ** ** ** ** On Sat, Jun 16, 2012 at 4:35 PM, isr...@gmail.com wrote: Did you install the addons Yum install asterisk18-addons-mysql -Original Message- From: Duncan Turnbull dun...@e-simple.co.nz Sender: asterisk-users-boun...@lists.digium.com Date: Sun, 17 Jun 2012 08:30:00 To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman
Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository
Not sure about yum installs but in 1.8 I have had to move to using odbc as the method to populate the mysql database http://www.voip-info.org/wiki/view/Asterisk+cdr+odbc Cheers Duncan On 17/06/2012, at 4:22 AM, Bruce B wrote: Hello, I have done yum install asterisk18 freepbx and it has installed Asterisk and FreePBX just fine. However, none of the CDR get recorded in asteriskcdrdb table in MySQL. They are available in /var/log/asterisk/cdr-csv/Master.csv. What configuration file sets the setting for writing these CDRs to MySQL? Thanks -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository
Did you install the addons Yum install asterisk18-addons-mysql -Original Message- From: Duncan Turnbull dun...@e-simple.co.nz Sender: asterisk-users-boun...@lists.digium.com Date: Sun, 17 Jun 2012 08:30:00 To: Asterisk Users Mailing List - Non-Commercial Discussionasterisk-users@lists.digium.com Reply-To: Asterisk Users Mailing List - Non-Commercial Discussion asterisk-users@lists.digium.com Subject: Re: [asterisk-users] CDRs do not record in asteriskcdrdb using Digium repository -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs on multiple servers.
cdr_odbc works fine but I have trouble using cdr_adaptive_odbc. asterisk fails to start when I uncomment 'first' and 'second' groups. Here is the error: WARNING[22722] cdr_adaptive_odbc.c: No such connection 'MySQL1' in the 'first' section of cdr_adaptive_odbc.conf. Check res_odbc.conf. WARNING[22722] cdr_adaptive_odbc.c: No such connection 'MySQL2' in the 'second' section of cdr_adaptive_odbc.conf. Check res_odbc.conf. and WARNING[22823] loader.c: Error loading module 'res_config_odbc.so': /usr/lib/asterisk/modules/res_config_odbc.so: undefined symbol: ast_odbc_clear_cache On Wed, Jun 6, 2012 at 8:34 PM, Benny Amorsen benny+use...@amorsen.dkwrote: Owais Ahmad millennium@gmail.com writes: Hello guys, I need to be able to throw cdrs on more than one servers at a time. Please let me know how this can be done. cdr_adaptive_odbc handles multiple servers. Just define several with [foo] and [bar] and it Just Works. /Benny -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs on multiple servers.
Owais Ahmad millennium@gmail.com writes: Hello guys, I need to be able to throw cdrs on more than one servers at a time. Please let me know how this can be done. cdr_adaptive_odbc handles multiple servers. Just define several with [foo] and [bar] and it Just Works. /Benny -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs on multiple servers.
The easiest way for you to use MySQL-Relay or MySQL-Proxy with ODBC. Regards, Faisal Hanif -Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Owais Ahmad Sent: Tuesday, June 05, 2012 7:54 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] CDRs on multiple servers. Hello guys, I need to be able to throw cdrs on more than one servers at a time. Please let me know how this can be done. Thanks -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello 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 -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs on multiple servers.
On Tue, 5 Jun 2012, Owais Ahmad wrote: I need to be able to throw cdrs on more than one servers at a time. Do you mean: 1) I need to collect the CDRs from multiple servers in one place so I can report on them. Or 2) I need to distribute the CDRs to multiple servers so I won't lose [m]any in case a host smokes. I like storing CDRs in a database (MySQL is my choice) so '1' is easy and '2' may be handled with database replication. -- Thanks in advance, - Steve Edwards sedwa...@sedwards.com Voice: +1-760-468-3867 PST Newline Fax: +1-760-731-3000 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs
Trying to create and populate arbitrary column in cdr table in mysql database. I created column ‘hangupcause’ in cdr table and setting CDR(hangupcause) variable on h extension, but database column in not getting populated. It is showing below in logs though: Executing [h@from-pstn:2] Set(SIP/abc, CDR(hangupcause)=16) in new stack Any idea why is that? On 12 July 2011 16:33, deeps backup backup.de...@gmail.com wrote: Hi Like we can define cdr field format for csv, is it possible to define if cdrs are stored in a database? Also, what will be size limit for database CDR storage ? -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs
From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of deeps backup Sent: Tuesday, July 12, 2011 10:34 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] CDRs Hi Like we can define cdr field format for csv, is it possible to define if cdrs are stored in a database? Also, what will be size limit for database CDR storage ? The code is on your machine. You can do whatever you want to with it. Caveat Emptor! -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs
Read the wiki / manuals From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of deeps backup Sent: Tuesday, July 12, 2011 11:34 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] CDRs Hi Like we can define cdr field format for csv, is it possible to define if cdrs are stored in a database? Also, what will be size limit for database CDR storage ? -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs in 1.8
I'm using ISDN30 for a bridged application in all the old versions of asterisk the time slot number is shown in the channels and dstchannel fields of the cdr I understand this has chaned in 1.8,is there a way of getting the time slot information stored somewhere at the end of the call so this can be interigated? Check the ChangeLog of your release to see if the fix to add CHANNEL(dahdi_channel) is present. The fix also added a new AMI DAHDIChannel event. Richard -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs not getting generated on Free PBX
Cdr status shows: CDR logging: enabled CDR mode: simple CDR output unanswered calls: no It is not showing 'CDR registered backend' Thanks, Deepika From: Deepika Nijhawan [mailto:deepika.nijha...@oxygen8.com] Sent: 18 June 2010 09:37 To: 'asterisk-users@lists.digium.com' Subject: CDRs not getting generated on Free PBX Hi, We have free pbx installed on asterisk 1.4.25.1. Mysql is installed and asterisk is connecting to it. CDR modules are all loaded as well. For some reason, it is not creating master.csv and no cdrs are generated. Can anyone help please. --- Kind Regards, Deepika Nijhawan VoIP Engineer Oxygen8 Communications T: +44(0) 871 434 9151 +44(0) 121 620 9151 Email: deepika.nijha...@oxygen8.com Skype: deepika-nijhawan W: www.oxygen8.com http://www.oxygen8.com/ This communication contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient/s. If you are not the intended recipient/s please note that any distribution, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error please notify us by email or by telephone (08082060808) and then delete the email and any copies of it. This communication is from Oxygen8 Communications UK Ltd - Company Number 03383285. Registered Address; 12th Floor, Lyndon House, 58-62 Hagley Road, Birmingham, B16 8PE. VAT Registration Number: 792 4494 89 -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs not getting generated on Free PBX
On 18 June 2010 10:38, Deepika Nijhawan deepika.nijha...@oxygen8.comwrote: Cdr status shows: CDR logging: enabled CDR mode: simple CDR output unanswered calls: no It is not showing ‘CDR registered backend’ Thanks, Deepika Have you compiled asterisk-addons and selected to compile and install cdr_addon_mysql ? Stephen -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs on call forward
Hi r u forwarding call using Originate action.. Which version of asterisk u used. On Thu, Sep 24, 2009 at 12:44 PM, John Fawcett john...@erba.tv wrote: In some circumstances I am transferring incoming calls to an external number (cell phone). Whenever this happens at the end of the call I get a single CDR representing the outgoing leg. There is no CDR for the incoming leg and no trace of incoming caller id in the CDR for outgoing leg. Is this expected behaviour? Is there a way to generate two CDRs one for the incoming and for the outgoing leg of forwarded calls? thanks John ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- Regards, Chandrakant Solanki ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] CDRs on call forward
Chandrakant Solanki wrote: Hi r u forwarding call using Originate action.. Which version of asterisk u used. Hi asterisk 1.6.2.0 I'm using freepbx, but I looked into the generated files: if I read it correctly it ends up using Dial cmd. thanks, John ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] CDRs and billing
Joao Pereira wrote: Hello I configured Asterisk to put CDRs in the database like it was explained in: www.voip-info.org/wiki/view/Asterisk+cdr+pgsql What I want to know is how do the billing solutions (like Asterisk2Billing) work with Asterisk. The billing system just use the information that Asterisk puts in the CDR table? Or they connect directly to Asterisk? Or is Asterisk that has, before the Dial command, to put the information on the Asterisk2Billing tables? Asterisk2Billing requires you route the calls to its AGI, and it keeps its own database, so what you did is of no use for billing. I haven't found an application that bills from the CDRs, everything I found wanted to create the database entries. I think ASTPP can read your CDR, though. -- Chris Mason NetConcepts (264) 497-5670 Fax: (264) 497-8463 Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271 Cell: 264-235-5670 Yahoo IM: [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ --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] CDRs and billing
Ok, no problem, Ill do it with the AGI. Do I need to re-compile asterisk to support the AGI writing? or it goes by default? Thank you Joao Pereira Chris Mason (Lists) wrote: Joao Pereira wrote: Hello I configured Asterisk to put CDRs in the database like it was explained in: www.voip-info.org/wiki/view/Asterisk+cdr+pgsql What I want to know is how do the billing solutions (like Asterisk2Billing) work with Asterisk. The billing system just use the information that Asterisk puts in the CDR table? Or they connect directly to Asterisk? Or is Asterisk that has, before the Dial command, to put the information on the Asterisk2Billing tables? Asterisk2Billing requires you route the calls to its AGI, and it keeps its own database, so what you did is of no use for billing. I haven't found an application that bills from the CDRs, everything I found wanted to create the database entries. I think ASTPP can read your CDR, though. ___ --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] CDRs and billing
One billing solution that Works with your CDRs is AsterBill (www.cybexdev.com) for postpaid. (not opensource, you have to buy) It runs a cronjob to get the latest CDRs and bill each accountcode. For prepaid of course it does it with AGI. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Chris Mason (Lists) Enviado el: Thursday, April 20, 2006 5:54 AM Para: [EMAIL PROTECTED]; Asterisk Users Mailing List - Non-Commercial Discussion Asunto: Re: [Asterisk-Users] CDRs and billing Joao Pereira wrote: Hello I configured Asterisk to put CDRs in the database like it was explained in: www.voip-info.org/wiki/view/Asterisk+cdr+pgsql What I want to know is how do the billing solutions (like Asterisk2Billing) work with Asterisk. The billing system just use the information that Asterisk puts in the CDR table? Or they connect directly to Asterisk? Or is Asterisk that has, before the Dial command, to put the information on the Asterisk2Billing tables? Asterisk2Billing requires you route the calls to its AGI, and it keeps its own database, so what you did is of no use for billing. I haven't found an application that bills from the CDRs, everything I found wanted to create the database entries. I think ASTPP can read your CDR, though. -- Chris Mason NetConcepts (264) 497-5670 Fax: (264) 497-8463 Int: (305) 704-7249 Fax: (815)301-9759 UK 44.207.183.0271 Cell: 264-235-5670 Yahoo IM: [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ --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] CDRs, Conferencing, and MeetMe
Jeff Workman wrote: O --On Wednesday, June 23, 2004 4:26 PM -0400 Roger Gulbranson [EMAIL PROTECTED] wrote: On Wed, 2004-06-23 at 15:39, Jeff Workman wrote: We are developing an on-demand teleconferencing solution. We will be billing per-minute/per-user. I've successfully gotten Asterisk to write CDR data to a postgres database, but with the way I've got things setup right now the CDR does not have the dialed conference number. We need this information in order to be able to bill. As teleconferencing is the only application of the Asterisk box, I have the dialplan setup to immediately launch into the MeetMe application and prompt the user for conference number/PIN upon answering. It appears that the MeetMe module isn't interested in passing the conference number back to Asterisk when the user disconnects so that Asterisk can include that information in the CDR. Any suggestions on how to do this? Use Read() to collect conference number. Invoke MeetMe() with said number. Use as well for CDR. k, this works. However, I'm having difficulty with getting asterisk to properly handle a user inputting an invalid conference number. My extensions look like this: exten = s,1,BackGround(conf-getconfno) exten = s,2,Read(CONF) exten = s,3,AbsoluteTimeout(7200) exten = s,4,MeetMe(${CONF}) exten = s,5,Goto(s,2) exten = s,6,Hangup() exten = T,1,Hangup() s,5 never executes because MeetMe exits non-zero whenever somebody dials an invalid conference number. How do I work around this? -J Well... I have conferences created ann its properties written into database: Conference no, conf name, max users, moderator etc. Also, I do not use exten = s,priority,application... but a proper extension number or _X, . Result, every users call to any of the conferences is saved in the CDR. Hope that helps... Ta Senad ___ 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] CDRs, Conferencing, and MeetMe
On Mon, 2004-06-28 at 12:57, Jeff Workman wrote: O --On Wednesday, June 23, 2004 4:26 PM -0400 Roger Gulbranson [EMAIL PROTECTED] wrote: On Wed, 2004-06-23 at 15:39, Jeff Workman wrote: We are developing an on-demand teleconferencing solution. We will be billing per-minute/per-user. I've successfully gotten Asterisk to write CDR data to a postgres database, but with the way I've got things setup right now the CDR does not have the dialed conference number. We need this information in order to be able to bill. As teleconferencing is the only application of the Asterisk box, I have the dialplan setup to immediately launch into the MeetMe application and prompt the user for conference number/PIN upon answering. It appears that the MeetMe module isn't interested in passing the conference number back to Asterisk when the user disconnects so that Asterisk can include that information in the CDR. Any suggestions on how to do this? Use Read() to collect conference number. Invoke MeetMe() with said number. Use as well for CDR. k, this works. However, I'm having difficulty with getting asterisk to properly handle a user inputting an invalid conference number. My extensions look like this: exten = s,1,BackGround(conf-getconfno) exten = s,2,Read(CONF) exten = s,3,AbsoluteTimeout(7200) exten = s,4,MeetMe(${CONF}) exten = s,5,Goto(s,2) exten = s,6,Hangup() exten = T,1,Hangup() s,5 never executes because MeetMe exits non-zero whenever somebody dials an invalid conference number. How do I work around this? My first temptation is to create an app called MeetMeExists to check for the existence of a conference. It would be pretty easy to hack the MeetMeCount code to do this. ___ 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] CDRs, Conferencing, and MeetMe
Roger Gulbranson wrote: On Mon, 2004-06-28 at 12:57, Jeff Workman wrote: O --On Wednesday, June 23, 2004 4:26 PM -0400 Roger Gulbranson [EMAIL PROTECTED] wrote: On Wed, 2004-06-23 at 15:39, Jeff Workman wrote: We are developing an on-demand teleconferencing solution. We will be billing per-minute/per-user. I've successfully gotten Asterisk to write CDR data to a postgres database, but with the way I've got things setup right now the CDR does not have the dialed conference number. We need this information in order to be able to bill. As teleconferencing is the only application of the Asterisk box, I have the dialplan setup to immediately launch into the MeetMe application and prompt the user for conference number/PIN upon answering. It appears that the MeetMe module isn't interested in passing the conference number back to Asterisk when the user disconnects so that Asterisk can include that information in the CDR. Any suggestions on how to do this? Use Read() to collect conference number. Invoke MeetMe() with said number. Use as well for CDR. k, this works. However, I'm having difficulty with getting asterisk to properly handle a user inputting an invalid conference number. My extensions look like this: exten = s,1,BackGround(conf-getconfno) exten = s,2,Read(CONF) exten = s,3,AbsoluteTimeout(7200) exten = s,4,MeetMe(${CONF}) exten = s,5,Goto(s,2) exten = s,6,Hangup() exten = T,1,Hangup() s,5 never executes because MeetMe exits non-zero whenever somebody dials an invalid conference number. How do I work around this? My first temptation is to create an app called MeetMeExists to check for the existence of a conference. Do you mean if conference is active or is it created in meetme.conf? ___ 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] CDRs, Conferencing, and MeetMe
Hi, -Original Message- As teleconferencing is the only application of the Asterisk box, I have the dialplan setup to immediately launch into the MeetMe application and prompt the user for conference number/PIN upon answering. It appears that the MeetMe module isn't interested in passing the conference number back to Asterisk when the user disconnects so that Asterisk can include that information in the CDR. Any suggestions on how to do this? How about not dropping them straight into the Meetme, but give Meetme parameters based on what the user enters in an Authenticate. If you add the 'a' parameter the password (conference room) is stored in the accountcode (which is in CDR). Florian ___ 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] CDRs, Conferencing, and MeetMe
I started to think about such a system for internal use at work. I never got past the brainstorming phase, but I'd suggest having an AGI script answer the call, query and verify the conference/pin numbers and then transfer the call to the appropriate Meetme. Dan -Original Message- From: Jeff Workman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 12:40 PM To: [EMAIL PROTECTED] Subject: [Asterisk-Users] CDRs, Conferencing, and MeetMe We are developing an on-demand teleconferencing solution. We will be billing per-minute/per-user. I've successfully gotten Asterisk to write CDR data to a postgres database, but with the way I've got things setup right now the CDR does not have the dialed conference number. We need this information in order to be able to bill. As teleconferencing is the only application of the Asterisk box, I have the dialplan setup to immediately launch into the MeetMe application and prompt the user for conference number/PIN upon answering. It appears that the MeetMe module isn't interested in passing the conference number back to Asterisk when the user disconnects so that Asterisk can include that information in the CDR. Any suggestions on how to do this? -J -- Jeff Workman | [EMAIL PROTECTED] | http://www.pimpworks.org ___ 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] CDRs, Conferencing, and MeetMe
On 07:42 PM 6/23/2004, Dan Austin wrote: I started to think about such a system for internal use at work. I never got past the brainstorming phase, but I'd suggest having an AGI script answer the call, query and verify the conference/pin numbers and then transfer the call to the appropriate Meetme. Dan -Original Message- From: Jeff Workman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 12:40 PM To: [EMAIL PROTECTED] Subject: [Asterisk-Users] CDRs, Conferencing, and MeetMe We are developing an on-demand teleconferencing solution. We will be billing per-minute/per-user. I've successfully gotten Asterisk to write CDR data to a postgres database, but with the way I've got things setup right now the CDR does not have the dialed conference number. We need this information in order to be able to bill. It would be nice to see a couple additions to meetme. If I could, I'd do them myself, but alas, my skills are not up to the task. Outputting the meetme room number to CDR is one Allowing the dynamic meetme room generator to take an optional passcode to start it, so that remaining participants would be required to enter passcode I had a couple more things in my tired brain but I've seemed to misplace the ideas. -Chris ___ 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