Search squid archive

Re: Squid.conf in a DB Mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: ngtech1ltd@xxxxxxxxx

Web: https://ngtech.co.il/

My-Tube: https://tube.ngtech.co.il/

 

From: squid-users <squid-users-bounces@xxxxxxxxxxxxxxxxxxxxx> On Behalf Of Marcelo
Sent: Sunday, 10 July 2022 0:08
To: squid-users@xxxxxxxxxxxxxxxxxxxxx
Subject: 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@xxxxxxxxxxxxxxxxxxxxx
http://lists.squid-cache.org/listinfo/squid-users

[Index of Archives]     [Linux Audio Users]     [Samba]     [Big List of Linux Books]     [Linux USB]     [Yosemite News]

  Powered by Linux