In Progress

Minor modifications to FreeRadius logic

We have FreeRadius, which is used to authorize PPPoE sessions on Cisco NAS. User database is stored in Postgres database.

We are migrating to a new billing system, and therefore we have to alter FreeRadius logic, so it can get required data from the new sql structure. This kind of alteration can't be done via config, therefore we need minor modifications to postgresql module of free radius.

New structure is very simple:

We have a view called "radius_view", which consists of 10 columns:

login

password

framed_ip

blocked (this one is boolean)

avpair1

avpair2

avpair3

avpair4

avpair5

avpair6

We need FreeRadius to perform one single query per Access-Request packet.

If zero result set returned Access-Reject should be generated.

If result set is not zero, then first it should check for blocked boolean, if it's true, then Access-Accept from template is issued.

Otherwise it should form Access-Accept response with Framed-IP-Address from framed_ip column (if it's not NULL) and with up to 6 Cisco-AVPair attributes from corresponding columns.

You will be provided with SSH access to the existing test installation to perform work. We will need compiled module and also diff file for future installations.

Skills: Database Administration, Engineering, Linux, Project Management, Software Architecture, Software Testing, System Admin

See more: nas test, postgres, module for freeradius, cisco config, free radius cisco, sql packet, free radius linux, billing system sql, login postgres, admin cisco, access database modifications, billing system access simple, billing cisco , modifications access database, linux radius billing, billing data access, login radius, postgresql sql, sql postgres, postgresql check check, billing system sql database, need access modifications, billing access template, minor modifications, sql query access database

About the Employer:
( 4 reviews ) Chiang Mai, Thailand

Project ID: #3467842

Awarded to:

kobor

See private message.

$127.5 USD in 14 days
(83 Reviews)
5.1

2 freelancers are bidding on average $213 for this job

alienaffili

See private message.

$297.5 USD in 14 days
(0 Reviews)
0.0