I have an mysql backend from my accounting program that contains all my user details. I need a php script that I can run from cron that will Import all new users into freeradius that aren't already in its mysql db If the user is already in the freeradius db then see if any information is changed and update it. If the user is no longer in my mysql accounting system then also either remove it from freeradius or expire the user. I have the sql select statement for my mysql accounting system with the relevant information. Anyone able to do this at a reasonable price then drop me an email. thanks
Sorry, Cory, I just realized you were in .au. I'm not able to make an international call from my current location. Please see inline comments below, however, as I want to make sure I am understanding things correctly. On 1/8/07, Cory Robson <cory@cmi.net.au> wrote:
I have an mysql backend from my accounting program that contains all my user details.
This is a "home-grown" system that is completely independent of the FreeRADIUS database, correct? I'm assuming that your users are added to this database either manually by you (or others) or automatically by your "sign-up" system. This database should also contains all the information that I would need to get the users added into FreeRADIUS successfully (e.g. username/password details, etc.).
I need a php script that I can run from cron that will
Import all new users into freeradius that aren't already in its mysql db If the user is already in the freeradius db then see if any information is changed and update it. If the user is no longer in my mysql accounting system then also either remove it from freeradius or expire the user.
You want to keep the databases "in synch" in both directions, correct?
I have the sql select statement for my mysql accounting system with the relevant information.
Anyone able to do this at a reasonable price then drop me an email. thanks
This should be relatively straightforward and could be knocked out pretty easily. There are a few things I would need from you in order to complete this project: the schema of the database of your accounting system; an example row from this database; and the schema of the FreeRADIUS *if* you've modified it any from the default schema. As for price, assuming the complete scope of the project is as described above, I am offering to complete this project for you for $75.00 USD and can commit to having it completed by the end of this Friday -- it would likely be much sooner, but I prefer to allow myself plenty of time as often times "other things seem to magically come up". Please let me know if you're interested or would like to discuss further. Thanks, -j -- Jeremy L. Gaddis, MCP, GCWN http://www.linuxwiz.net/
Easy project, really just and SQL, but damn $75, I spend more on Taxi each day... -----Original Message----- From: freeradius-users-bounces+radiussupport=lrcommunications.net@lists.freeradius .org [mailto:freeradius-users-bounces+radiussupport=lrcommunications.net@lists.fr eeradius.org] On Behalf Of Gaddis, Jeremy L. Sent: Monday, January 08, 2007 2:03 AM To: FreeRadius users mailing list Subject: Re: PHP coding request - give me a price Sorry, Cory, I just realized you were in .au. I'm not able to make an international call from my current location. Please see inline comments below, however, as I want to make sure I am understanding things correctly. On 1/8/07, Cory Robson <cory@cmi.net.au> wrote:
I have an mysql backend from my accounting program that contains all my user details.
This is a "home-grown" system that is completely independent of the FreeRADIUS database, correct? I'm assuming that your users are added to this database either manually by you (or others) or automatically by your "sign-up" system. This database should also contains all the information that I would need to get the users added into FreeRADIUS successfully (e.g. username/password details, etc.).
I need a php script that I can run from cron that will
Import all new users into freeradius that aren't already in its mysql db If the user is already in the freeradius db then see if any information is changed and update it. If the user is no longer in my mysql accounting system then also either remove it from freeradius or expire the user.
You want to keep the databases "in synch" in both directions, correct?
I have the sql select statement for my mysql accounting system with the relevant information.
Anyone able to do this at a reasonable price then drop me an email. thanks
This should be relatively straightforward and could be knocked out pretty easily. There are a few things I would need from you in order to complete this project: the schema of the database of your accounting system; an example row from this database; and the schema of the FreeRADIUS *if* you've modified it any from the default schema. As for price, assuming the complete scope of the project is as described above, I am offering to complete this project for you for $75.00 USD and can commit to having it completed by the end of this Friday -- it would likely be much sooner, but I prefer to allow myself plenty of time as often times "other things seem to magically come up". Please let me know if you're interested or would like to discuss further. Thanks, -j -- Jeremy L. Gaddis, MCP, GCWN http://www.linuxwiz.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 1/8/07, Alex M <radiussupport@lrcommunications.net> wrote:
Easy project, really just and SQL, but damn $75, I spend more on Taxi each day...
Apologies, I didn't intend for my replies to Cory to go to the list as well. -- Jeremy L. Gaddis, MCP, GCWN http://www.linuxwiz.net/
Cory Robson wrote:
I have an mysql backend from my accounting program that contains all my user details.
I need a php script that I can run from cron that will
Import all new users into freeradius that aren't already in its mysql db If the user is already in the freeradius db then see if any information is changed and update it. If the user is no longer in my mysql accounting system then also either remove it from freeradius or expire the user.
I have the sql select statement for my mysql accounting system with the relevant information.
Anyone able to do this at a reasonable price then drop me an email. thanks
Hi Cory, No doubt you will have already received a number of replies to your email, but on the off chance that you haven't found someone to help you yet, I have a few questions: Does it have to be PHP? How often will it run? Does it have to run out of cron? Have you considered using database triggers for near real-time updates to the freeradius DB? What is the approximate size of the user base? ie how big is the database? What platform will it run on? And finally, what time frame are you looking to have it completed? cheers, Mike
participants (4)
-
Alex M -
Cory Robson -
Gaddis, Jeremy L. -
Michael Mitchell