Hey Marcelo, It’s possible to use a SQL DB (Mysql,MSSQL,Oracle,PostgreSQL…) and a programming language to put the rules outside of squid.conf. It could be a combination of external acl helpers with DB backend and a configuration (squid.conf) generator based on a DB. However, you first need to do some homework and make sure it will be good enough for your use case. As Alex mentioned there are fast and slow ACLs but for your use case depends on your service size it’s possible you can use simple text files and simple external acl helpers. To be able to answer your question in detail you need to prepare a technical spec that will try summarize your use case. I am working on a series of Zoom meetings that I hope will start next week on Thursday evening IST. I need to prepare the slides and environment for this meeting and it will be the first of: Squid 0 to hero So the first meetings will not touch your use case specifically but I will discuss with the participants their aera so we can talk and give demos for specific use cases somewhere in these meetings. I will try to post about these meetings in the coming week with hope that you will be able to participate. I believe that for your use case it’s better that you will not use PHP to write your helper despite to that fact that the latest versions of PHP which I have tested are stable and won’t stop working even after a very very long run time (what I was informed that should be tested in these PHP versions). In my production environment I am using many RUBY helpers that eventually worth their memory consumption. (Kinkie it took me a while to grasp that the memory usage differences between languages doesn’t worth considering) I am working on couple examples but I am pretty sure it’s not your use case. All The Bests, Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: <mailto:ngtech1...@gmail.com> ngtech1...@gmail.com Web: <https://ngtech.co.il/> https://ngtech.co.il/ My-Tube: <https://tube.ngtech.co.il/> https://tube.ngtech.co.il/ From: squid-users <squid-users-boun...@lists.squid-cache.org> On Behalf Of Marcelo Sent: Sunday, 10 July 2022 0:08 To: squid-users@lists.squid-cache.org Subject: [squid-users] Squid.conf in a DB Mysql Hello, Is it possible to use MySQL and PHP programming to put squid rules outside of squid.conf? I heard about it using external acl, but can find any documentation or good example of it. I would like to “transfer” parameters as ACLs, HTTP_ACCESS, HTTP_PORT, and TCP_OUTGOING_ADDRESS from squid.conf to a DB+PHP solution. Marcelo
_______________________________________________ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
