116684 Admin and User Portal

Ruralwave is a Wireless Internet provider. We currently operate 3 radius server and 1 web/mail server. We require an independent web portal that allows for secure access for users to add 2 additional email address to our postfix server at a remote location (VPN access available) and the ability to change passwords for email and web access (MySQL database on radius server. This site should have administrators access to setup the users (basic site template already available and being used) in addition to the current template we wish to increase the security and flexibility of the admin access to include the addition of email address to the email server along with web space. Administrators should have ability to access further information such as raw sql info using phpadmin lunched only from the admin page and proper authentication. Current status view of the each of the radius servers should be able to be viewed from the admin pages. This server can be run in a screen session of the linux FC5 servers. We currently have a backup system running but an immdate backup of sql data should be available to be completed to flash RAM at a specific location if the admin staff have updates to complete. Overall the admin pages should allow the admin staff to edit, delete, or add customers to our email/web and radius database. The user/customer should be able to add additional email address based on the package they are been setup with 1 - 5 emails. Setup webspace, change login passwords for email address 2 - 5 and radius user password. They should also have access to FAQ's, and weather/news, and in the future web cam shots of the tower locations or specific sites. We also require the ability to add more features to the site at a later date. Please see the current project notes below.... There is a PHP interface actively adding users to the radius SQL interface. We would like to update this page to email, user, info and other Colubris AV pairs can be activated by the administration team to make the admin pages more flexible. We have minimal MAC editing available and this page needs to be revamped to add the additional MAC edit functions for the user. We will also like to activate the biz customers functions with the addition of more AV-pairs being added to control the BIZ customers. In addition to the current available template, field admin should be able to view the RAW radius information using myPHPadmin using a secure web access system. MyPHPadmin is installed on the radius servers to view the database in RAW format. Additionally this admin interface should contain a current output of the status of each radius server available. The admin page should also have ability to backup the radius database and remote webpages to a backup server storage location in case of planning database/server updates. Phase 1 Colubris max-input max-output added to customer, STATIC mac auth added. Username and other user details added into database. Usable interface active Phase 2 To go up for bid in DEC Clean up of pages for smooth operation with out errors. STATIC mac auth and editing available to all usernames phase 1 allowed addition of MAC for customer but no ability to edit, all items should be able to edit in next phase. A search feature should be added to look up customer by name number MAC username or customer number. Phase two will add an interface to our mail server at ________________ and add customers email address based on package 1 for ripple 3 for wave/BIZ 5 for monsoon/TOTALWAVE. AV PAIR bandwidth level should be available to add to BIZ customer and checkbox currently does not add the AV PAIR. Bandwidth levels are Ripple = 256k Wave/BIZ = 512k Monsoon/BIZ elite = 1024k Totalwave = 2048k Totalwave Elite 4096k Additional pages should be added to allow administrators to view PHPadmin from link Backup SQL database to local computer and to backup system located at [login to view URL] Backup Webpages from [login to view URL] and [login to view URL] public pages for all customers and user webpages to 10.10.20.15. Admin pages should also be able to view radius1 radius2 radius3 data from freeradius displays. Additional database search/edit/ and management for logging customer on specific tower etc should be added. Further information can be provided upon request.