Easy project, really just and SQL, but damn $75, I spend more on Taxi each day...
-----Original Message----- From: [EMAIL PROTECTED] .org [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html