Date: Thu, 29 Jan 1998 09:07:07 -0600 (CST) From: "Jeffrey D. Lacoursiere" <lacoursj@fastlane.net> To: Andreas Klemm <andreas@klemm.gtn.com> Cc: isp@FreeBSD.ORG Subject: Re: Need Unix/FreeBSD based accounting/billing software with Radius server and sql database Message-ID: <Pine.BSF.3.96.980129083226.6027F-100000@fastlane.net> In-Reply-To: <19980128182110.02328@klemm.gtn.com>
next in thread | previous in thread | raw e-mail | index | archive | help
We have just what you are looking for. We call it FLAMS (FastLane Account Management System). It is web based, runs on FreeBSD (using Apache, MySQL, and a proprietary form engine developed in house), and will read (currently) Ascend and Livingston Radius accounting logs in real time. The report engine that works against the radius data allows you to view call logs by user, date, or IP address (catch those spammers), with optional limits on the number of records returned and an optional summary showing total time online, average up and downlink connect speeds, average call length, and several other stats. The report engine is VERY fast. Our development version currently holds 1.7 Million call records and most reports (those not attempting to select several thousand calls, for example, where the browser slows things down) are returned in 2 or 3 seconds. Nightly processing turns accounts off as they expire, suspends accounts that have exceeded dialup limits or have overdue balances, emails warnings as users approach dialup limits, and generates statistics of the days activities, producing historical graphs of account additions, suspensions, and deletions, calls received during the day, call tickets opened and closed, etc. It manages all billing aspects with a very flexible service definition interface, allowing you to charge for services with differing price structures, setup fees, and durations. An interface for manually charging accounts for misc items (hats, T-shirts, etc), manually accepting payments (cash, check, etc), voiding transactions, and doling out refunds is provided. Credit card batches are produced each night, and we are working on integrating with several of the Internet based card processing agencies so your credit card processing will be completely automatic. Currently you must send the batches by hand with ICVerify type card processing software, then ask FLAMS to read the result file and post payments (and send warnings to users whose cards were declined). It seamlessly handles multi-service, multi-user accounts with options to invoice by email, paper, and fax. Multiple tax regions are supported for ISP's that run multiple POPs. Normal business reports are provided for accounts receivable, salestax, and sales. It is a full fledged call ticket system allowing your technicians to manage the calls they take, and allowing your support supervisor to keep track of open tickets and ongoing problems. It manages employee time tracking (no more filling out time sheets!). It has several levels of authentication to seperate billing tasks from tech support tasks. A full C API with documentation comes with FLAMS if you are interested in writing custom reports against the SQL database back end. MySQL comes with a C and a Perl API, so you can write custom reports in Perl as well. Best of all, the form engine works against HTML template files that you may customize to your heart's desire, making FLAMS look however you like. MySQL itself has a SQL monitor interface which you are welcome to use to run SQL commands directly against the FLAMS database (the use of DELETE..WHERE.. is not suggested :) . The full schema is provided with the product documentation. FLAMS will NOT be sold based on the number of users your ISP supports. There will be a fixed price for the product with an optional support contract. A FastLane engineer will spend time on site with your staff to install, integrate, train, and, optionally, customize. FLAMS is currently in beta at two ISP's in the Dallas/Ft. Worth metroplex. Send email if you are interested in participating in the beta. Beta participants will receive a substantial price break when the product is released. We anticipate the first release to occur in March. A demo will be available on the web soon. Thanks! Jeff LaCoursiere President FastLane Communications, Inc. www.fastlane.net On Wed, 28 Jan 1998, Andreas Klemm wrote: > Hi ! > > My collegue wanted me to use a NT based software, since he > didn't find another one... But I don't want to do that and > am now urgently looking for something Unix based. > > Please, is there another software available for Sun or FreeBSD, > which has a radius server with connectivity to a sql database. > > We want to offer internet services and need a very flexible > software, that keeps track of logins and does billing and > the possibility to make sure, that an internet account is > used only by one person at a time. > > Thanks a lot > > Andreas /// > > -- > Andreas Klemm > powered by ,,symmetric multiprocessor FreeBSD'' > >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.96.980129083226.6027F-100000>