The manual should have all this information. Check the [SQLAcct] section part of the manual. http://www.gnugk.org/gnugk-manual-4.html 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 11:16 AM To: openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Subject: Re: billing ok, mysql accounting in real time is the solution, but I didn't find any how-to or document saying about this !! On Mon, 24 Jan 2005 10:47:35 -0500, Freddy Parra <fparra@xxxxxxxxxx> wrote: > 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/ > -- =================================== 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/
