PHP coding request - give me a price

[Alex M]

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 at lists.freeradius
.org
[mailto:freeradius-users-bounces+radiussupport=lrcommunications.net at 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 at 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