Hey Paul, On Nov 15, 2007 4:29 PM, Paul Yasi <[EMAIL PROTECTED]> wrote: > Hi Liran, I think I got a message from you a bit ago, sorry I never > got back to you about freeradius. I've been busy implementing > CitrusDB for my employer's new wi-fi offering.
Thanks for your reply and your positive intentions to extend CitrusDB to integrate with other applications. Goodluck with that new wi-fi offering implementation :) > Generally CitrusDB could talk to a radius server or other account > authentication system via the Account Activation script, or run that > script nightly in cron using the php cmd line. Okey so here's the story about the FreeRADIUS integration. FreeRADIUS itself has no such provisioning system in the terms of sending it some packet and it would add a user to database or alter it's state but rather it works in such a way that it relies on a backend database which it connects to (can be many of the available: mysql, sqlite, pgsql, etc or even on flat text files though that really doesn't suit any large setup so we can discard that). So basically what most of the people do is setup a mysql radius database with the schema they provide and configure freeradius's sql config file with access to the database and configure the main freeradius's daemon config file to authorize, authenticate and perform accounting based on the mysql database module that they have. So here is what I am thinking. I have installed CitrusDB to play with it a little but haven't found the time to actually go through all of the options there so if you say that there's an Account Activation script thing then we can create a perl script which would use a database abstraction layer so that it is portable for other databases than just mysql and when an account is created on citrusdb it will also create the user profile for the radius system on the radius database. >Then there would need > to be something that would process that output of ADD, ENABLE, > DISABLE, and DELETE requests to actually do something for each account > type in radius or whatnot. If I understand correctly, the Account Activation script is only for when a new account is created. Definitely it is required to also have such a script for other account changes like a DELETion of an account and so on. Anyway, what I'm currently wondering is also that some people may create radius users through daloRADIUS (the radius web management) and also daloRADIUS would have to have the same scripting capabilities to add the user to CitrusDB database. This definitely requires more thinking... > > I would be open to including something that talks to freeradius or any > account authentication system. Thanks, I'm looking forward for a good billing integration that would make both of our solutions ideal for everyone. Regards, Liran. > On Nov 15, 2007 6:37 AM, liran tal <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Perhaps the citrusdb-users mailing list is not the best place to bring > > this issue up although I am also wondering if other users will find it > > useful for citrusdb to integrate with a freeradius management application > > for different types of billing purposes and provides provisioning support. > > > > On the same note, I'd like to know if any of the developers > > is willing to make progress on this issue... > > > > > > Regards, > > Liran. > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Splunk Inc. > > Still grepping through log files to find problems? Stop. > > Now Search log events and configuration files using AJAX and a browser. > > Download your FREE copy of Splunk now >> http://get.splunk.com/ > > _______________________________________________ > > Citrusdb-users mailing list > > Citrusdb-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > > > > > > -- > The CitrusDB Project | http://www.citrusdb.org > Open Source Customer Care & Billing System > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users