Hi Glaucius, I'm not sure if it's easier to do but I think is more reliable since Gnugk seems to have very accurate file accounting from my experience in using it. But if your concern about customers exceeding amount of mins then I don't think this would be an ideal solution. You would probably be looking for something more on the real time side such as Mysql Accouting(from gnugk directly) or Radius Accouting. I haven't come across any programs that read in the cdr files, parses them, and stores into a db, but it should be very feasible to do. You should be able to do this in PHP. Maybe have a cron job that runs some php code every x mins which opens up the cdr file and parses into DB. Others use Radius for accounting, but I've never tested radius with Gnugk so I'm not sure how accurate or reliable it is with Gnugk. Another way is to have a program listening on Gnugk's status port for cdrs, which it then parses and stores into a database. I believe there are like 1 or 2 programs out there that do this. But I think this in my opinion would be the least reliable. Freddy -----Original Message----- From: openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx [mailto:openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Glaucius Djalma Pereira Junior Sent: Monday, January 24, 2005 10:19 AM To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: billing Freddy, Yu sure, it can be easier, because I don't need to change my gnugk configuration, but, where can I found some software to catch info from cdr log files and put into a database mysql ? the frontend to extract information from mysql I can make using PHP and later distribute under GPL. best regards !! On Mon, 24 Jan 2005 09:38:07 -0500, Freddy Parra <fparra@xxxxxxxxxx> wrote: > Unless one is not looking for real time billing one can create some sort > of parsing program that reads in the cdr files and dumps them into a > database every x min or so. And just use the mysql for real time > monitoring reports. > I think this would probably be the most accurate and reliable. > > Also I've been using mysql accounting for a while and haven't had any > problems, to me it seems very accurate, but again mysql hasn't crashed > on me yet. :) > > Freddy > > -----Original Message----- > From: openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx > [mailto:openh323gk-users-admin@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of > Zygmuntowicz Michal > Sent: Monday, January 24, 2005 8:54 AM > To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > Subject: Re: billing > > Because it lacks many basic features, like transactions, stored > procedures, > flexible timestamp handling, and it is not reliable in some situations. > > ----- Original Message ----- > From: "Pavel Shurubura" <pvs@xxxxxxxx> > Sent: Monday, January 24, 2005 2:44 PM > > > On Mon, 24 Jan 2005 14:14:16 +0100 > > "Zygmuntowicz Michal" <m.zygmuntowicz@xxxxxxx> wrote: > > > >> I would not recommend using MySQL for billing. > > > > Why ? > > > > -- > > With kindest regards, pvs. > > ------------------------------------------------------- > This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting > Tool for open source databases. Create drag-&-drop reports. Save time > by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. > Download a FREE copy at http://www.intelliview.com/go/osdn_nl > > _______________________________________________________ > > List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 > Homepage: http://www.gnugk.org/ > > ------------------------------------------------------- > This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting > Tool for open source databases. Create drag-&-drop reports. Save time > by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. > Download a FREE copy at http://www.intelliview.com/go/osdn_nl > > _______________________________________________________ > > List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx > Archive: http://sourceforge.net/mailarchive/forum.php?forum_id...49 > Homepage: http://www.gnugk.org/ > -- =================================== Glaucius Djalma Pereira Junior glaucius@xxxxxxxxx http://glaucius.intnet.com.br =================================== "If idiots could fly, IRC would be an airport" ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id49 Homepage: http://www.gnugk.org/ ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________________ List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id?49 Homepage: http://www.gnugk.org/
