Squid ACL with SQL setup
 

Hello all

I would like to know if anyone can help me with my problem

We have setup a squid server that our network can access
At the moment we add IP's to the ACL so people can connect to our squid server. I am looking of help in replacing this from a sql database so squid checks to see if the IP address is in the list to allow access.

I have build a web based IP address update button that my clients can click on and there new ip address will be updated in the SQL. I just need a way for this to link to squid.

I would be very grateful if anyone can help me


Thank you all

putting this data into SQL really isn't going to make things any faster. You can store ACL's in an external file, but putting them in a database is not something that happens. You can pull data from anywhere using an acl helper but it just slows things down really. if it's just a list, how is an IP list not preferable? http://www.squid-cache.org/Doc/confi...rnal_acl_type/

thanks for your help
 

Hi.
maybe you can help?

What we have is a joomla website where people register to use the squid / dns server. this would be ok if people did not have a dynamic ip address so for this reason we have had to create a update ip address buttonon the website, its saves the ips in the joomla sql as a list. My question is how to we get that list on the squid to accept them the second the click update ip in the squid ACL where at the moment we are doing this by hand..

We are unsure if the sql is any good or we need to do this a different way somehow. We have now spent 3 days trying to do this so if you can answer this with easy it would be amazing

Thank you again

why don't you just use user authentication for the proxy access? IP addresses are irrelevant then.

we have done it now.. Thanks for your help