06-28-2013 08:09 AM - edited 03-07-2019 02:08 PM
Hello all
I have got my first freelancing job after passing CCNA.
The task is to setup internet connection for a college and whatever I learned in CCNA was sufficient to do that however I am stuck at one BIG thing and I need your kind help.
Their requirement is very simple:
(1) They need to create user groups( like students, accounting, admins, finance etc).
(2) They have 3 more colleges so there should be provision of connecting this college to others in future.
(3) They want "time based group level access control". For example: Students will not be able to access youtube and facebook during college hours and P2P will be allowed only for admins etc.
Here is my planning:
(1) Suggest them Cisco 2921.
(2) Create VLANs for different groups.
(3) Inter-vlan routing using "router-on-a-stick"
(4) I will use PAT for internet access.
(5) Will setup a DNS server in Windows Server 2008 to resolve local hostnames with a public DNS server as "forwarder" in it.
(6) Will use site-to-site VPN for college interconnection(in future)
All fine and good. However "time based group level access control" is killing me. Here are some options I thought of:
(1) ACL: I will do nslookup and find all IP addresses of websites to block. Create a time based access-list to block those IP addresses and apply them inbound on router sub-interface.
However I came to know that IP addresses change frequently and it will be difficult to maintain it. Also it may make the router slow because of all the processing it has to do. It may pose some other problems I am unaware of.
(2)MQC & NBAR:
This tutorial explains it:
But it has problems of its own:
--It can't filter HTTPS urls(so https://facebook.com will not be blocked while it's http version would be)
--The service-policy command could not be applied on sub-interfaces(required for VLANs) as stated here at https://supportforums.cisco.com/thread/2160438.
However another tutorial explained that it can be applied with a trick (PARENT policy-map) as explained here at http://ardenpackeer.com/tutorials/qos-voip/qos-applying-cbwfq-to-a-sub-interface.
So this also fails.
(3) Squid proxy
That also does not work with HTTPS.
I know that I have not started doing anything in real and I am doing everything in my "head". That's because I don't want them to make an investment which does not fulfill their requirment.
I hope someone must have also got this requirement and can provide some CONCRETE solution for this.
06-28-2013 08:28 AM
Akshay,
I'm looking at the entire design of this. Time based group level access can be easily overcome in a number of ways based on a number of factors. Some initial questions.
Shawn Eftink
CCNA, CCDA
06-28-2013 10:42 AM
Hello Shawn
I feel good now that atleast someone is willing to help me out.
I will give you full details.
Current infrastructure of college:
( Sorry if I sound not so technical, I am just a CCNA who has only worked on GNS3 )
There are around 500 students but at anytime there are not more than 250 users accessing the internet.(In next 3 years there may be growth of 200 students so we can say concurrent users may become 350)
There is one campus building and 2 hostel buildings.
The main aim is to provide internet to students
In the main building they have one leased line internet connection of 8 MBPS that goes to a modem (Anda Telecom G.SHDSL )and then to a Unified Security Gateway(ZyWALL 300 USG).
There is no dedicated router and this USG has 7 ports which can form 7 networks.
As far as the switched network is concerned, thet have few managable switches and few unmanaged switches (both of D'link brand) but the managable ones also not managed(not created vlans, nothing).
The students in the campus always complain that the internet is slow. Althought I believe 8 Mbps connection should be ok for browsing(not torrent etc).
Because of USG they have been able to create different networks for different user groups (like students/teachers/admins etc) by using the 7 ports.
For them the security requirements are very simple:
They need to allow/block websites during certain times of the day and for other groups there may be different websites and a different time to block/allow.
They are using AntiVirus on all machines.
What I have planned:
I have asked them to buy 1941 router(you can better suggest if its ok for them) and then create different VLANs for different user groups. The problem is that not all switches are managed.
I told them that in order to have port level group selection(VLAN) all switches (access,core and distribution) need to be managable switches. But it will be too much of investment to do this. S0 here is my plan:
I will use all unmanaged switches as access level switches and use managed switches for distrubution and core layer.
This way I will be able to provide switch level control(This access layer switch will belong to students etc) and they are OK with it.
Intervlan routing = router on a stick.
TO resolve local host names I will use a local DNS server with DNS of ISP as forwarder.
Hostel buildings connect to the main building and provide WIFI connection to students there.
Windows domain: they dont have one but we can set that in place if required.
Their budget is low because their requirements are low. The only things is that the router should have the possility to create VPN connection to other 3 colleges in future.
I have already mentioned other details in my original question.
Tell me if you need any other info.
Sorry for my bad english.
06-28-2013 12:49 PM
I'm not really sure if Cisco IOS is the right solution for this.
ISA570 should fit most of your needs, but also a fast appliance with IPFire (no license costs) would be ok.
If Cisco IOS is a must you could install a Linux proxy and to WCCP for http/s access control.
Michael
Please rate all helpful posts
06-28-2013 01:59 PM
Akshay,
Some initial thoughts and recommendations.
To be perfectly candid, I would consider this type of design a bare minimum for that size environment. I would generally add far more redundancy and implement some other components to improve security and functionality. But that design would meet the minimum requirements and put in a structure that is ready to scale when they are.
Shawn Eftink
CCNA/CCDA
Please rate all helpful posts and mark correct answers to assist others searching for solutions in the community.
06-28-2013 02:01 PM
Links to the devices I referenced.
https://www.barracuda.com/products/webfilter/features
http://www.cisco.com/en/US/prod/collateral/vpndevc/ps6032/ps6094/ps6120/data_sheet_c78-701253.html
Shawn Eftink
CCNA/CCDA
Please rate all helpful posts and mark correct answers to assist others searching for solutions in the community.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide