[squid-users] Squid.conf in a DB Mysql

[ngtech1ltd at gmail.com]

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:ngtech1ltd at gmail.com> ngtech1ltd at 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-bounces at lists.squid-cache.org> On Behalf Of Marcelo
Sent: Sunday, 10 July 2022 0:08
To: squid-users at 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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.squid-cache.org/pipermail/squid-users/attachments/20220710/ce7b8125/attachment-0001.htm>