Re: [smartBridges] OT: WISP Admin Database?

[Mark Radabaugh]

The big question is why are you reinventing the wheel?  There are several billing systems that are written for ISP billing - Optigold, ISPPower, Freeside, Rodopi.   Most of them can be extended to do everything you want without all that much trouble.  We use ISPPower - it's stable and easily expandable.   It bills automatically, builds and pushes the RADIUS authentication files, pushes mail usernames/passwords to the mail server, keeps track of what equipment the customer has, usage, etc.   Used to use Rodopi but didn't care for it overall.  Never tried Optigold but a lot of ISP's swear by it.     If we wanted ISPPower to create the MRTG files it would be easy to write a script to pull that from the database and send it to the collector - just too lazy so far to get around to writing it.   I guess the part that puzzles me most is why WISP's in general keep trying to reinvent things.   Other than the last mile there isn't much of the needs of a WISP that a traditional ISP hasn't had to deal with for the last 6 years.   99% of the backend stuff is already available, most of it free if your willing to learn a little about Unix.   If your serious about this business you'll end up learning Unix anyway in the long run.  Please don't think I'm trying to start an OS war (or even interested in discussing it) - I'm not.     Mark Radabaugh Amplex (419) 720-3635 ----- Original Message ----- From: Kevin Summers To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 7:37 PM Subject: RE: [smartBridges] OT: WISP Admin Database? I'm actually working on something similar to that. But it's quite a ways from completion. I'm using MS SQL Server 2000, NT Radius on an NT4 box that uses SQL server for auth, and everything is managed through a web interface written in VBScript. Kevin Summers KISTech Internet Services Inc. www.kistech.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of The Wirefree Network Sent: Thursday, September 25, 2003 3:57 PM To: [EMAIL PROTECTED] Subject: RE: [smartBridges] OT: WISP Admin Database? I am definitely looking for something that ties into the network�actually, that is the whole point.  But�billing I do auto thru PAYPAL.  NO BILLING FOR ME WHATSOEVER!   I am looking for a customer/inventory/network database.  Something I can enter my inventory/supplier info into, then when I sign up a new client, I can use a drop-down to select the next equipment in line, and auto assign the next unused IP.  Then setup a form which will be printed to give to each client for their settings, email and contact info.   I would also like the MAC address for each device to automatically be written to my text file for the appropriate AP (which I will upload for internal MAC).  I would eventually, like the database to write the MAC address to my radius server (once I get one setup).   Hmmm�.guess that is about it.   Unless I can also get it to automatically append to my MRTG config file and update my webpage with this client�s MRTG graphs.   Is that too much to ask??   Hahahah   Sully   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Email Sent: Thursday, September 25, 2003 3:34 PM To: [EMAIL PROTECTED] Subject: RE: [smartBridges] OT: WISP Admin Database?   Sevak I have a database in Access Mine needs fine tuning as well, I would like to have something that ties into managing the network and maybe automatic billing What is your email address   Joe K [EMAIL PROTECTED]   [Joe Email] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Sevak Avakians Sent: Thursday, September 25, 2003 4:30 PM To: [EMAIL PROTECTED] Subject: Re: [smartBridges] OT: WISP Admin Database? Hi Sully, I'm using (actually just stopped using) Lotus Database.  If the templates are compatible, I can give you my template.  (I stopped using it because it was too time consuming for what I need to do and my sales/marketing person has her own program to keep track of customers.) Kind regards, Sevak On Thu, 2003-09-25 at 17:09, The Wirefree Network wrote: I am at the point now where I need to pay someone to complete/polish my Access Database that I created about a year ago.  It is a bit rough.   Before I do that, I was wondering if there are any freeware WISP databases (templates) or possibly if someone wants to let loose of there "proud baby"?!?!  (:   I currently do ALL my admin stuff on a Windows XP box, so that is all I am interested in for now (my fianc� is taking over the books and that is all she knows).   I really appreciate it!!   Sully   ----------ANNOUNCEMENT---------- Don't forget to register for WISPCON IV http://www.wispcon.info/us/wispcon-iv/wispcon-iv.htm   The PART-15.ORG smartBridges Discussion List To Join: mailto:[EMAIL PROTECTED] (in the body type subscribe smartBridges <yournickname> To Remove: mailto:[EMAIL PROTECTED] (in the body type unsubscribe smartBridges) Archives: http://archives.part-15.org