A RADIUS system I am working on

RouterOS General
1

Hi everyone,

I have been working on a RADIUS system and its almost complete. Based on Freeradius.
Below are the features which are complete and are running in a production environment for an ISP of about 3000 customers.

  1. Server Management
    a. Add / Remove / Edit Mikrotik Routers from web interface
    b. Check service status for related services (radius, http and mysql)
    c. Check if any table in mysql database is crashed, if found crashed a repair button will show on web-interface.

  2. User Management
    a. Add / Remove / Edit users from web-interface
    b. Show online users (can kick / remove any online user from the list)
    c. Show user statistics
    d. Disable / Enable user
    e. Change password

  3. Card Management
    a. Scratch card generation based on profiles
    b. Export card list in Excel and PDF format
    c. Scratch cards can be assigned to any Dealer / Re-Seller as they are generated

  4. Support Management
    a. Show all online users
    b. Show online users for individual areas / group
    c. Change user password
    d. Can kill stale / hang sessions
    f. View / Reply / Resolve support tickets

  5. Re-Seller Area
    Re-Seller is the entity which can be given an area to manage, under which there can be dealers, sub-dealers or users
    a. Re-Seller can add Dealer. While adding Dealers, Re-Seller has to assign profiles to Dealers with the amount at which they agree
    b. Re-Seller will be assigned a number of cards which Re-Seller can assign to their Dealers.
    c. Re-Seller has a billing section to generate monthly invoices for Dealers based on the rates which Dealer and Re-Sellers agreed
    e. Re-Seller can generate a support tickets

  6. Dealer Area
    Dear is the entity which will come under a Re-Seller or Admin. Dealer can has sub-dealers and users
    a. Dealer can Add / Edit / Remove users
    b. Dealer can Add / Edit / Remove Sub-Dealers
    c. Dealer can perform User Management Tasks on their or their sub-dealers users
    d. Dealer can kill stale / hang sessions for their or their sub-dealers users
    e. Can Re-charge scratch cards on their or their sub-dealers users
    f. Can generate support related tickets

  7. Sub-Dealer Area
    Sub-Dealer is the entity which comes under Dealer and can only has Users.
    a. Can perform User Management Tasks only on their own users
    b. Can Re-charge scratch cards only on their own users
    c. Can generate support related tickets

  8. User Area
    a. Can check their own statistics
    b. Can change passwords
    c. Can re-charge their own accounts
    d. Can generate support related tickets

  9. Billing Area
    This belongs to accounts section. When adding Dealer or Re-Seller, admin specifies the rate on which they agree.
    Based on those rates billing is performed.
    a. Generate invoice for Dealers or Re-Sellers on monthly basis
    b. Invoice contains details list of scratch cards provided by admin to respective entity with date and serial numbers
    c. Payments can be made anytime
    d. When making payment, one can either specify particular invoice to clear from or from the total amount

  10. Admin Area
    a. Server Management
    b. Card Management
    c. Support Management
    d. Global Settings


    There are some cronjobs running on system which are checking
    → Stale sessions
    → Daily user sessions
    → Scratch cards expired on daily basis
    Customized script to check simultaneous session in multi-router environment using SNMP.

Currently this system has only been tested with PPP section and not with HotSpot. Once everything is 100% complete, I will add HotSpot section.

I will be attaching screenshots very soon.
Feedback from you guys will be appreciated.

2

sending email or SMS to notifying the user before 3 days of the expiration date or when he reach the quota..

3

Hi,

Thanks for the feedback.
Actually that feature is there, I forgot to mention.

A cronjob runs on daily basis and send email to the User and to the entity (Dealer, Sub-Dealer) that user belongs to.

4

When will it be available for release, id like to play with it in my test lab which consists of
RB2011-UAS-2HnD-LIN
RB751G
RB750
RB750UP
RB951-2Hn
And a alix 800 running RouterOS level 4


Kevigizmo

5
  1. Notification should be sent to ACTIVE users only. It should not send sms to already expired/disabled users.
  2. Adding user usage graph in there panel would be highly supportive. :slight_smile:
  3. Top Users accounts report for Admin.
  4. Send SMS to all Active Accounts.
  5. Send EMAIL to all Active Accounts, (with GMAIL support)

Its nice to hear from you :slight_smile:

6

we have already developed similar thing and is being used by many providers around the world

7

again i ask when will it be available for release

8

**Good job, Mudasir!
Please add to you system next area.

  1. Devices in area. (Section, city, region, where device is installed)
  2. Device type. (IPDSLAM, L2 Switch, access point, which of type device is installed)
  3. Device status. (Port status, Used port, Free ports)
  4. Users on devices. (In which of devices, users is connected)
  5. Add IP Pool - External or Internal (8.8.x.x or 172.16.xx.xx)
  6. Users IP Pool External/Internal (Users used ip address from external (8.8.x.x) or internal(172.16.xx.xx) network.)
  7. User monitoring/sessions. (When user connected or disconnected, traffic used in sessions, total user traffic, total user session time)
  8. Add local servers. (Game server, File Server, Local Video Portal, Update Server …)
  9. Queues. (Configure queues between users and local server and INTRANET)
    I think it’s very important details most of us, for network/sysadmins.**