The company I work for is replacing a server (windows 2003 server), the reason is a software that uses sql will no longer be supported on 2003 so we are upgrading to windows server 2012 also the hardware is old and not power efficient. We have all the user cals for this server which is currently running DHCP, active directory, and a single sql database about 5GB... Generally there are about 150 devices connected through DHCP we have cals for 2003 that won't transfer to 2012.
Currently only about 10 users use the sql server portion of the server. We do not want to purchase ~150 cals for all of the dhcp connections/users for the new server when we can do it on linux for free so I am going to separate dhcp from the new server, the new windows 2012 server will only run the sql server so I will only need approx 10 cals for sql and 10 user cals for server 2012. We are also going to get away from active directory (still looking into options for this or maybe dropping it entirely).
My question is: what is the best linux dhcp setup which would also allow web caching of ios updates, windows updates etc. Our network bandwidth is fairly limited 5mb up and 5mb down. We have around 150 ios devices and 98 computers, currently updates max out the connection for a few days. Caching would prevent a full week worth of ios downloads after apple releases an update.
I would also like to monitor ip traffic and web traffic if possible (I can do this on my shibby tomato router if needed).
Is there any setup linux based that is capable of doing dhcp, caching, and traffic monitoring, I can setup 2 boxes if needed. I am fairly familiar with most linux distros, I have experience with debian but might prefer ubuntu or mint. A web UI would be nice as well but not required. Currently my thoughts are debian with squid proxy or maybe use nginx... I plan on building a decent mini itx computer with 100+gb ssd drive for caching.
I am actively doing research about this subject but if anyone has already done this, maybe you can swing some ideas my way, thanks.
EDIT: I just found pfsense, anyone have experience with that and if so what are your thoughts?
Edited by zingo156, 09 June 2014 - 01:24 PM.