*This message was transferred with a trial version of CommuniGate(tm) Pro* Hey all, I've just done a quick (but functional) web front end for searching the CDRs in a MySQL database. Anyone interested in trying it out? I'm wondering what to add to it next. So far you can seach using source, destination, CLI, channel and date ranges. It also displays ALL fields in the database table. If interested, email me on geek@jazz-inc.net. Do not reply directly to this email, it will bounce. Depending on the level of interest, I may post this somewhere for your free downloading pleasure. Regards, Jamie Carl Jazz Inc. http://www.jazz-inc.net Email: geek@jazz-inc.net JID: jazz@netmindz.net Phone: +61-414-365466
Ok, wow. Didn't expect as many responses as I got. Didn't think this would spark so much interest. Anywayz. Some of the questions asked will be answered here, rather than emailing everyone individually with the same answers. Currently, the backend is written in Python2 with the MySQLdb module. However, due to some interest I will be porting it to PHP. Also, if you want to see it in action, you can look at http://asterisk.jazz-inc.net to see my working (but still under development) version. I am going to put links on this page to packaged source for free download. Just have to sort out disclaimers and all that so you all cant sue me. :) Thanx guyz, J On Fri, 26 Sep 2003 03:22:45 +1000 "Jamie Carl" <geek@jazz-inc.net> wrote:> >Hey all, > >I've just done a quick (but functional) web front end for >searching the >CDRs in a MySQL database. Anyone interested in trying it >out? I'm >wondering what to add to it next. > >So far you can seach using source, destination, CLI, >channel and date >ranges. It also displays ALL fields in the database >table. > >If interested, email me on geek@jazz-inc.net. Do not >reply directly to >this email, it will bounce. Depending on the level of >interest, I may >post this somewhere for your free downloading pleasure. > >Regards, > >Jamie Carl >Jazz Inc. >http://www.jazz-inc.net >Email: geek@jazz-inc.net >JID: jazz@netmindz.net >Phone: +61-414-365466 > > > >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-usersRegards, Jamie Carl Jazz Inc. Email: me@jazz-inc.net Web: www.jazz-inc.net Phone: +61-414-365-466 Jabber: jazz@netmindz.net
Hi Carl i see web frontend i action is very good!! The total time at end is good thing. Thanks for great work. Can you put the script in some place to download. Dimitri> *This message was transferred with a trial version of CommuniGate(tm) Pro* > > Hey all, > > I've just done a quick (but functional) web front end for searching the > CDRs in a MySQL database. Anyone interested in trying it out? I'm > wondering what to add to it next. > > So far you can seach using source, destination, CLI, channel and date > ranges. It also displays ALL fields in the database table. > > If interested, email me on geek@jazz-inc.net. Do not reply directly to > this email, it will bounce. Depending on the level of interest, I may > post this somewhere for your free downloading pleasure. > > Regards, > > Jamie Carl > Jazz Inc. > http://www.jazz-inc.net > Email: geek@jazz-inc.net > JID: jazz@netmindz.net > Phone: +61-414-365466 > > > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users
>I was thinking of using > >http://developer.berlios.de/ > >As SF has had many problems recently :( > >Regards > >Mark > > >Yea, I have noticed Sourceforge has been a little flaky lately.. Thought they would have been on top of it quicker.. Later..
On Mon, Sep 29, 2003 at 11:09:06AM +0100, WipeOut wrote:> > >I was thinking of using > > > >http://developer.berlios.de/ > > > >As SF has had many problems recently :( > > > >Regards > > > >Mark > > > > > > > Yea, I have noticed Sourceforge has been a little flaky lately.. Thought > they would have been on top of it quicker..http://developer.berlios.de/ seems to be down for me in the US at this time: * Connection Failed The remote host or network may be down. Please try the request again. Generated Mon, 29 Sep 2003 12:51:36 GMT...
Oi Adriane! Minha m?e foi internada hoje de madrugada no 9 de julho por causa de um problema de estomago.. J? viu que n?o vou conseguir ir hoje tb. J? estou de p? desde ontem a noite. arrumei um micro aqui no hospital para te escrever. esqueci meu celular em casa. Amanh? ainda d? tempo n?? eu n?o vou deixar a sua chefinha quebrar o seu pescocinho t?? um beijo claudio ----- Original Message ----- From: "PJ Welsh" <pj@cassens.com> To: <asterisk-users@lists.digium.com> Sent: Monday, September 29, 2003 9:52 AM Subject: Re: [Asterisk-Users] CDR Web Search Frontend> On Mon, Sep 29, 2003 at 11:09:06AM +0100, WipeOut wrote: > > > > >I was thinking of using > > > > > >http://developer.berlios.de/ > > > > > >As SF has had many problems recently :( > > > > > >Regards > > > > > >Mark > > > > > > > > > > > Yea, I have noticed Sourceforge has been a little flaky lately.. Thought > > they would have been on top of it quicker.. > > http://developer.berlios.de/ > > seems to be down for me in the US at this time: > > * Connection Failed > The remote host or network may be down. Please try the request again. > Generated Mon, 29 Sep 2003 12:51:36 GMT... > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users >
I have commit access to the phpconfig cvs on digiums site... Mark and team have been great to work with. I would be happy to work on changes to the phpconfig to add cdr work or anything. its just a framework that needs wizzards, reports etc to be finished Dave p0lar>>> troy@psknet.com 9/29/2003 8:33:57 AM >>>After reading this thread, I wonder if we couldn't create an abstract RDBMS interface in the core, then in the addons repository, create modules for MySQL, MSQL, MSSQL, Oracle, Sybase, PGSQL, or whatever. The abstraction layer would simply use whichever addon module it was configured to use. This would eliminate the licensing issues Digium may have when granting a non-GPL license to a 3rd party, while allowing creating a very flexible product. Additional functionality could be added with some simple hooks in the core. For example, if you want your configurations to come directly from a SQL database in real time, add hooks into the code to cause * to read from the abstraction layer instead of it's internal database. It would be simple enough to do, and as a build-time and/or run-time configuration option, I believe it can be done without causing issues to the stability of the core. Another example is CDR, which would do what it does now by writing a csv, but could have a hook added to it to also send accounting data to a SQL server or even a Radius accounting server or something else entirely. To do this right would probably force a major architectural change to *, which I'm sure that Mark would be reluctant to do, but if someone could build the framework, get some folks to test it (in small, medium, and large deployments), I'll bet Mark will accept it. Also, with the advent of the addons repository, has anyone asked Mark if he would be willing to grant commit privileges to more people? It doesn't make much sense to create a new repository for this when Digium already has the facilities available and a new repository for non-core items. BTW, I'm not a coder, I'm just an idea man. -- Troy Settle Pulaski Networks http://www.psknet.com 540.994.4254 ~ 866.477.5638 Pulaski Chamber 2002 Small Business Of The Year> -----Original Message----- > From: asterisk-users-admin@lists.digium.com > [mailto:asterisk-users-admin@lists.digium.com] On Behalf Of Mark Evans > Sent: Monday, September 29, 2003 5:37 AM > To: asterisk-users@lists.digium.com > Subject: RE: [Asterisk-Users] CDR Web Search Frontend > > > > Or do something really smart like the Perl guys and have a > > backend-mostly-independent DB infrastructure. Hell I think > that PHP > > finally smartened up and went this way, too. > > > > Hi Guys > > I am happy to do this and send the code back. Database independence > isn't to hard to achieve. It would be nice if a group of us could get > together and discuss how we can make this great app even better and > possibly look at getting a small team together to merge this and > phpconfig into a single application. Will possible access to > cvs for the > developers. > > Thoughts? > > Mark Evans > SiteTel > > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > 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
> I have found the CDR in general to be a problem, We use a system that > allows a user to simply click a phone number in a web page and then PHP > drops a call file into the /outgoing directory.. These calls are not > logged at all.. not in the text file or the MySQL..Can I make calls thru your system please? Sounds like a major issue that needs to be fixed ASAP.... mmmkay!
I can add stuff to the phpconfig CVS dirs if anyone wants to contrib stuff. keep it all in one dir etc.... phpconfig can run SSL and yes its a easy way to "vi" the files directly but it does give your options that "vi" does not.... like click on a context and see extensions within that context. jump from config to config etc.... its a framework to get people thinking about abbing a web interface to *. Dave aka p0lar Dave Packham University of Utah NetCom Manager R&D D.S.O. University Incident Response Team c. 712.0364@801 w. 587.0907@801 FWD. 20223 Dave.Packham@Utah.edu ICQ#:45818442 Current ICQ status: 45818442@pager.icq.com SMS: (Send an SMS message to my ICQ): +278314245818442 FWD is http://fwd.pulver.com More ways to contact me: http://wwp.icq.com/45818442 Our Groups Website http://rads.netcom.utah.edu Directions to our Building http://www.map.utah.edu/umaplink/0893.html>>> pj@cassens.com 9/30/2003 7:50:55 AM >>>Comments inline: On Tue, Sep 30, 2003 at 07:38:07AM +0100, WipeOut wrote:> Mark Evans wrote: > > >>I think we're getting away from the original purpose of this program. > >>Are people really that desparate for a full, web-based admin/user > >>interface? > >> > >> > > > >I sure am, I want to give as much control as I can for basic tasks > >to my customer who may not even know what Linux is :) > > > >Regards > > > >Mark > > > > > > > So it sounds like we need to combine everyones thoughts into a feature > list of some sort.. > > To me it sounds like we have talked about the following.. > > * PHP based > * Database Independent (Initially MySQL and PGSQL) > * CDR Viewing (real time view of last 20 (filterable by > src/dst/accountcode etc..) CDR entries) > * CDR Reporting (per user/company/line, Somthing like the itemised > billing from a telco, User Accessable)Do you want everyone to know where everyone is calling? I could see mgmt/owners having an issue with this in a normal business environment! Look Mr. Gate$ at extention 666 made 500 calls to Mr Devil last week, I wonder what deals they are making ;)> * Asterisk Management (initially based on PHPconfig)Doesn't this just display the config files for editing? I wouldn't want to put this as an internet reachable service without https. Heck if I'm just editing a file, why not just vi/vim/emacs/your-fav-editor from an ssh session ( lots of java ssh applets for this/ ssh clients )? User Self Service would seem to mean replacing the PHPconfig anyway...> * User Self Service (Ability to change VM password, Maybe even SIP > password, Advanded features in the future could be things like call > forwarding setup or a facility where the user could sit down in front of > any phone and "map" his extension to the phone on the desk in front of > him like hot desks in an office)Make sure to think about limits for call forwarding. Should I be able to forward to a number in some other country? Authentication/Authorization is a tough slippery slope... LDAP, NIS, NIS+, flatfile, database you get the picture. You may want to think about Webadmin as a control frontend and build with that in mind... Maybe CDR exports from the GUI (csv)? In GUI Archiving mechanism for "old" records? ( record retention policy )> > Feel free to add you ideas.. > > Later.. > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > 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 -------------- next part -------------- BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Dave Packham TEL;WORK:801 587-0907 ORG:;Netcom Research and Development TEL;PREF;FAX:801 585-3704 EMAIL;WORK;PREF;NGW:Dave.Packham@netcom.utah.edu N:Packham;Dave TITLE:Manager R&D END:VCARD
cvs update Jeremy McNamara Michael T Farnworth wrote:>Got 3 core dumps from asterisk in a very short period of time, not sure >what was going on, but I am posting these in case anybody wants to see >them, if you want to see more info I can provide it on request. > >I am using the asterisk 0.5.0 download. > >(gdb) bt >#0 ast_translator_free_path (p=0x10) at translate.c:83 >#1 0x0805b2b9 in ast_set_read_format (chan=0x8109b90, fmts=135250888) > at channel.c:1482 >#2 0x40575b70 in socket_read (id=0x80e98f8, fd=17, events=1, cbdata=0x0) > at chan_iax2.c:3956 >#3 0x0805113c in ast_io_wait (ioc=0x80e7ea8, howlong=1000) at io.c:268 >#4 0x4056f3a4 in network_thread (ignore=0x0) at chan_iax2.c:4763 >#5 0x400296de in pthread_start_thread () from /lib/libpthread.so.0 > > >(gdb) bt >#0 0x62696c2f in ?? () >#1 0x0805b2b9 in ast_set_read_format (chan=0x10, fmts=135063712) > at channel.c:1482 >#2 0x40575b70 in socket_read (id=0x80e98f8, fd=17, events=1, cbdata=0x0) > at chan_iax2.c:3956 >#3 0x0805113c in ast_io_wait (ioc=0x80e7ea8, howlong=1000) at io.c:268 >#4 0x4056f3a4 in network_thread (ignore=0x0) at chan_iax2.c:4763 >#5 0x400296de in pthread_start_thread () from /lib/libpthread.so.0 > > >(gdb) bt >#0 0x0805befe in ast_translator_free_path (p=0x80ce728) at translate.c:84 >#1 0x0805b2b9 in ast_set_read_format (chan=0x810aa58, fmts=135070088) > at channel.c:1482 >#2 0x40575b70 in socket_read (id=0x80e8a88, fd=17, events=1, cbdata=0x0) > at chan_iax2.c:3956 >#3 0x0805113c in ast_io_wait (ioc=0x80e7c68, howlong=1000) at io.c:268 >#4 0x4056f3a4 in network_thread (ignore=0x0) at chan_iax2.c:4763 >#5 0x400296de in pthread_start_thread () from /lib/libpthread.so.0 > >Michael > >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users > >
>cvs update >>Got 3 core dumps from asterisk in a very short period of time, not sure >>what was going on, but I am posting these in case anybody wants to see >>them, if you want to see more info I can provide it on request. >> >>I am using the asterisk 0.5.0 download.he mentioned he was using the asterisk 0.5.0 download though. surely this means we should update the 0.5.0 release to solve these problems? can you confirm that it was the asterisk-0.5.0.tar.gz file install that caused these segfaults? duncan
Are the SIP phones behind a NAT/Router? is * behind a NAT or Firewall? can we see your sip.conf file? Regards, Uriel -----Original Message----- From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com]On Behalf Of Kevin Sent: Tuesday, September 30, 2003 8:05 PM To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] Grandstream Phone Issue When I dial with my Grandstream 101 telephone to another sip phone or Zap FXS, the call rings, but no audio is passed. Eventually the call gets disconnected. The same thing happens if I dial the Grandstream. Any Suggestions? _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users
Kevin wrote:>When I dial with my Grandstream 101 telephone to another sip phone or >Zap FXS, the call rings, but no audio is passed. Eventually the call >gets disconnected. The same thing happens if I dial the Grandstream. > >Any Suggestions? > > >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users > > > >When last did you build from CVS?
Do we have any Visual Basic or .NET programmers out there? The reason I say that is this. I would suggest that a program or application be put together with Visual basic or .NET that will generate the config files for you by translating what you want to do in telephony terms/jargon to asterisk cofiguration terms/jargon. Maybe an FTP application be included as a module to the application. Maybe even a test bed module that will emulate your results without having to put the config files on the asterisk box itself, lowering the risk of any complications that may occur when making changes. How it would work is like this: 1. Windows application started. 2. User defines the variables within the application that pertains to his/her telephone service environment. 3. Any incomplete variables do not get written to the config file that will be generated. 4. When completed setting up all available variables, the user can run an asterisk emulation test to verify that the configuration is bolean. 5. Upon verification of a bolean setup, the user can create the config files by pushing a "generate configurations" button. 6. Files could be written/generated to a directory specifically related to the application that generated them. 7. Using the FTP module within the application, the user can migrate the config files to * box. (Application can have a dropdown menu of possible * boxes to migrate the config files to.) 8. Once the user has verified the correct configuration files in place, the * box can be reloaded and physically tested. Just my thoughts, Steve Lane
steve.lane@covad.net wrote:>Do we have any Visual Basic or .NET programmers out there? The reason I >say that is this. I would suggest that a program or application be put >together with Visual basic or .NET that will generate the config files for >you by translating what you want to do in telephony terms/jargon to >asterisk cofiguration terms/jargon. Maybe an FTP application be included >as a module to the application. Maybe even a test bed module that will >emulate your results without having to put the config files on the >asterisk box itself, lowering the risk of any complications that may occur >when making changes. How it would work is like this: >1. Windows application started. >2. User defines the variables within the application that pertains to >his/her telephone service environment. >3. Any incomplete variables do not get written to the config file that >will be generated. >4. When completed setting up all available variables, the user can run an >asterisk emulation test to verify that the configuration is bolean. >5. Upon verification of a bolean setup, the user can create the config >files by pushing a "generate configurations" button. >6. Files could be written/generated to a directory specifically related to >the application that generated them. >7. Using the FTP module within the application, the user can migrate the >config files to * box. (Application can have a dropdown menu of possible * >boxes to migrate the config files to.) >8. Once the user has verified the correct configuration files in place, >the * box can be reloaded and physically tested. > >Just my thoughts, > >Steve Lane > > > > >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users > > > >Why do all this in VB or .NET and tie it into an M$ only system?? Take your ideas and build them in a PHP or similar language and then they will be OS independent and everyone will be able to take advantage of it.. Later..
How about doing it in Java with Java web services(for conf file generation and user authentication,e t c) so that way other developers can write in other languages such as PHP or perl different front-ends but consume the web services over http. Well this is the way I plan on doing it so the code is more reusable by others in the future. John -----Original Message----- From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-admin@lists.digium.com]On Behalf Of WipeOut Sent: Wednesday, October 01, 2003 4:57 PM To: asterisk-users@lists.digium.com Subject: Re: [Asterisk-Users] CDR Web Search Frontend steve.lane@covad.net wrote:>Do we have any Visual Basic or .NET programmers out there? The reason I >say that is this. I would suggest that a program or application be put >together with Visual basic or .NET that will generate the config files for >you by translating what you want to do in telephony terms/jargon to >asterisk cofiguration terms/jargon. Maybe an FTP application be included >as a module to the application. Maybe even a test bed module that will >emulate your results without having to put the config files on the >asterisk box itself, lowering the risk of any complications that may occur >when making changes. How it would work is like this: >1. Windows application started. >2. User defines the variables within the application that pertains to >his/her telephone service environment. >3. Any incomplete variables do not get written to the config file that >will be generated. >4. When completed setting up all available variables, the user can run an >asterisk emulation test to verify that the configuration is bolean. >5. Upon verification of a bolean setup, the user can create the config >files by pushing a "generate configurations" button. >6. Files could be written/generated to a directory specifically related to >the application that generated them. >7. Using the FTP module within the application, the user can migrate the >config files to * box. (Application can have a dropdown menu of possible * >boxes to migrate the config files to.) >8. Once the user has verified the correct configuration files in place, >the * box can be reloaded and physically tested. > >Just my thoughts, > >Steve Lane > > > > >_______________________________________________ >Asterisk-Users mailing list >Asterisk-Users@lists.digium.com >http://lists.digium.com/mailman/listinfo/asterisk-users > > > >Why do all this in VB or .NET and tie it into an M$ only system?? Take your ideas and build them in a PHP or similar language and then they will be OS independent and everyone will be able to take advantage of it.. Later.. _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 9/1/2003