Ohh, thanks!!!! libdbd-mysql-perl was not installed. Work like a charm!!! El sáb., 4 de mar. de 2023 7:43 a.m., < squid-users-requ...@lists.squid-cache.org> escribió:
> Send squid-users mailing list submissions to > squid-users@lists.squid-cache.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.squid-cache.org/listinfo/squid-users > or, via email, send a message with subject or body 'help' to > squid-users-requ...@lists.squid-cache.org > > You can reach the person managing the list at > squid-users-ow...@lists.squid-cache.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of squid-users digest..." > > > Today's Topics: > > 1. Re: Missing translation directories und 'errors' in squid 5.8 > (Amos Jeffries) > 2. Re: Missing translation directories und 'errors' in squid 5.8 > (Amos Jeffries) > 3. Re: Can't store log in mysql 8.0 database (Amos Jeffries) > 4. Re: Missing translation directories und 'errors' in squid 5.8 > (Matthias Fischer) > 5. Re: Understanding maximum outgoing HTTP CONNECT requests? > (divan.whelk...@icloud.com) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 5 Mar 2023 01:15:48 +1300 > From: Amos Jeffries <squ...@treenet.co.nz> > To: squid-users@lists.squid-cache.org > Subject: Re: [squid-users] Missing translation directories und > 'errors' in squid 5.8 > Message-ID: <c84158f3-159d-6fe8-d947-9aea9f63e...@treenet.co.nz> > Content-Type: text/plain; charset=UTF-8; format=flowed > > > FYI, The missing files from 5.8 can be downloaded from here as a > stand-alone package: > ? <http://www.squid-cache.org/Versions/langpack/> > > Cheers > Amos > > On 3/03/2023 7:22 pm, Avram-Teodor Berindeie wrote: > > A solution if the error messages in English are OK is to set this > > directive in squid.conf: > > error_directory /<path to>/squid/share/errors/templates > > For error messages in other languages, information in this link > > <https://wiki.squid-cache.org/Translations>. > > This configuration options can also be used: > > *--enable*/disable*-translation* > > By default, Squid tries to present error and manual pages in a local > > language. If we don't want this to happen, then we can use this option. > > *--enable*/disable*-auto-locale* > > Based on a client's request headers, Squid tries to automatically > > provide localized error pages. We can use this option to disable > > automatic localization. The error_directory tag in the Squid > > configuration file must be configured if we use this option. > > > > > > _______________________________________________ > > squid-users mailing list > > squid-users@lists.squid-cache.org > > http://lists.squid-cache.org/listinfo/squid-users > > > > ------------------------------ > > Message: 2 > Date: Sun, 5 Mar 2023 01:16:08 +1300 > From: Amos Jeffries <squ...@treenet.co.nz> > To: squid-users@lists.squid-cache.org > Subject: Re: [squid-users] Missing translation directories und > 'errors' in squid 5.8 > Message-ID: <3e134177-1ed1-431e-bfc0-fe2ba1d8b...@treenet.co.nz> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Ouch, sorry about that. > > > FYI, The missing files from 5.8 can be downloaded from here as a > stand-alone package: > ? <http://www.squid-cache.org/Versions/langpack/> > > Cheers > Amos > > > On 3/03/2023 6:40 am, Matthias Fischer wrote: > > Hello, > > > > I'm a bit puzzled - sorry if I just overlooked something, but...: > > > > Since 'squid 5.8' there are no "translation directories" in the source > > code anymore, only 'templates' and the usual scripts. > > > > No 'errors/af', 'errors/ar', 'errors/az' containing > > '\squid-5.8\errors\af\ERR_ACCESS_DENIED' (e.g.). > > > > The TRANSLATORS are still listed but none of their files... > > > > Did I miss something? > > > > Regards, > > > > Matthias > > _______________________________________________ > > squid-users mailing list > > squid-users@lists.squid-cache.org > > http://lists.squid-cache.org/listinfo/squid-users > > > > ------------------------------ > > Message: 3 > Date: Sun, 5 Mar 2023 01:23:54 +1300 > From: Amos Jeffries <squ...@treenet.co.nz> > To: squid-users@lists.squid-cache.org > Subject: Re: [squid-users] Can't store log in mysql 8.0 database > Message-ID: <3a1726b6-4ca7-bf33-bedc-fe32e3a94...@treenet.co.nz> > Content-Type: text/plain; charset=UTF-8; format=flowed > > On 4/03/2023 8:22 am, Francisco wrote: > > Hi, I\m trying to store logs in a mysql server 8.0 database from squid > > 5.7 in Debian 11. > > > > My idea is store all logs in /var/log/squid/ dir, and logs from > > specifics urls, domains and sites store in mysql database > > ('access_log_internet' table) to restrict those users that overcuote > > an specific amount of MB. > > > > > > *The config:* > > /access_log /var/log/squid/nav_basica-access.log squid dominios/ > > /access_log /var/log/squid/nav_basica-access.log squid dominios_parciales > > / > > /access_log /var/log/squid/nav_basica-access.log squid sitios > > / > > /access_log /var/log/squid/nav_basica-access.log squid dominio_cu/ > > /access_log /var/log/squid/internet-access.log squid !dominios > > !dominios_parciales !sitios !dominio_cu/ > > > > /logfile_daemon /usr/lib/squid/log_db_daemon/ > > /access_log > > daemon:/ > 192.168.56.2:3306/squidmgr/access_log_internet/squidmgr/squidmgrsquid > > < > http://192.168.56.2:3306/squidmgr/access_log_internet/squidmgr/squidmgrsquid> > > > !dominios !dominios_parciales !sitios !dominio_cu/ > > > > when try start squid, it's fail: > > > > /Dec 31 19:00:00 1969Use of uninitialized value $DBI::errstr in > > concatenation (.) or string at /usr/lib/squid/log_db_daemon line 403. > > Dec 31 19:00:00 1969Cannot connect to database: ?at > > /usr/lib/squid/log_db_daemon line 403. > > / > > What version of Perl do you have on this machine? > > Do you have both libdbd-mysql-perl and libdbi-perl packages installed? > > > Cheers > Amos > > > ------------------------------ > > Message: 4 > Date: Sat, 4 Mar 2023 13:34:23 +0100 > From: Matthias Fischer <matthias.fisc...@ipfire.org> > To: Amos Jeffries <squ...@treenet.co.nz>, > squid-users@lists.squid-cache.org > Subject: Re: [squid-users] Missing translation directories und > 'errors' in squid 5.8 > Message-ID: <e903ea55-88eb-ee66-70d1-9220d9d90...@ipfire.org> > Content-Type: text/plain; charset=UTF-8 > > Hello, > > On 04.03.2023 13:15, Amos Jeffries wrote: > > FYI, The missing files from 5.8 can be downloaded from here as a > > stand-alone package: > > ? <http://www.squid-cache.org/Versions/langpack/> > > Yep. In the meantime ( ;-) ) I've found them. I was just a bit puzzled, > in 5.7 these files were still included in the source code. > > > Cheers > > Amos > > Many thanks! > > Best, > Matthias > > > > ------------------------------ > > Message: 5 > Date: Sat, 4 Mar 2023 12:42:53 +0000 > From: divan.whelk...@icloud.com > To: squid-users@lists.squid-cache.org > Subject: Re: [squid-users] Understanding maximum outgoing HTTP CONNECT > requests? > Message-ID: <9c815592-a998-4908-842a-a98412d66...@kontos-home.com> > Content-Type: text/plain; charset="utf-8" > > > Thank you for the prompt reply! > > > - Squid can be configured to receive on up to 64 ports. > > Thus dst-port on **inbound** is 2^6. > > > outbound = N * 2^6 * 2^128 * 2^16 = N * 2^150 > > Would that be 2^6 dst-port on outbound, rather than inbound (ignoring > Alt-Svc)? Or am misunderstand the theoretical limit formulae after? > > > Thus total theoretical limit of simultaneous connections Squid can be > juggling is N * 2^151. > > So, for example a single box HTTP CONNECT proxy might be listening on one > IPv4 address and one IPv6 address, which would be making the outbound > connections (and opening the TCP tunnel) and only able to make outbound > connections to either port 80 or 443 (2^16 for each respective port, > ignoring Alt-Svc). > > Whereas for incoming, listening on dst-port (3128) (2^16 incoming), with a > theoretical limit of 2^32 IPv4 addresses or 2^128 IPv6 addresses (or do you > use 2^128 including IPv4)? > > > Reality can be significantly different for any given installation, but > is imposed by configuration choices and thus can be altered as needed. > > Understood, thanks! I think I?ve got a good idea now, with the > clarifications. > > Alex > > > On 17 Feb 2023, at 20:18, Amos Jeffries <squ...@treenet.co.nz> wrote: > > > > On 18/02/2023 12:14 am, divan.whelk.0u wrote: > >> Hi there! > >> > >> I?m trying to understand what would the ?theoretical? maximum amount of > outgoing connections with squid setup as a HTTP CONNECT forward proxy would > be (hardware permitting)? > > > > As you likely know, each TCP/IP connection uses a 4-tuple identifier > {src-IP, src-port, dst-IP, dst-port}. > > > > So at face value there is a protocol imposed cap of (2^128 * 2^16 * > 2^128 * 2^16) = 2^288 connections. > > > > Being theoretical we have: > > * ignored reserved IP ranges, > > * ignored OS-specific ephemeral port reservations, > > * assumed IPv6 availability, and > > * assumed no access restrictions in Squid, network routing, nor > firewall. > > > > The factors to consider are: > > > > - Squid machine can be assigned multiple IP's. > > Thus src-IP on outbound and dst-IP on inbound are that N. > > > > - Squid can be configured to receive on up to 64 ports. > > Thus dst-port on inbound is 2^6. > > > > - DNS can provide any number of IPs for any given server name. > > Thus outbound dst-IP can be any 2^128 value. > > > > - modern websites use use Alt-Svc to spread across ports. > > Thus outbound dst-port can be any 2^16 value. > > > > So for theoretical limit the math is: > > > > inbound = 2^128 * 2^16 * N * 2^16 = N * 2^160 > > > > outbound = N * 2^6 * 2^128 * 2^16 = N * 2^150 > > > > Inbound and outbound are normally independent, but CONNECT is a special > case where they are pinned 1:1. > > > > Thus total theoretical limit of simultaneous connections Squid can be > juggling is N * 2^151. > > > > Reality can be significantly different for any given installation, but > is imposed by configuration choices and thus can be altered as needed. > > > > > >> From the [squid-users] About bottlenecks (Max number of connections, > etc.) thread, I saw mention of the following: > >> > >>> * The limit on number of connections any Squid can have attached is > only limited by your configured FD limits and available server RAM. Squid > uses ~64 KB per network socket for traffic state - which equates to around > 2 GB of RAM just for I/O buffers at 20,000 concurrent client connections. > >> I assume the same would not apply on outgoing connections, and that > there would be a limit of 65,536 connections to a single IP, port pair? For > example, if we had 1 million users making requests via HTTP CONNECT, only > 65K of them would be able to access the same website at any one time? > > > > IIRC that quoted thread was discussing a Squid with more normal > multiple-destination case hitting FD limits. The 64K port limitation you > refer to is a special case contingent on the "single destination with > single IP:port" criteria - which itself is rarely true for a popular > website. It assumes configuration restriction imposing that criteria > somehow. > > > > > > Cheers > > Amos > > > > _______________________________________________ > > squid-users mailing list > > squid-users@lists.squid-cache.org > > http://lists.squid-cache.org/listinfo/squid-users > > > ------------------------------ > > Subject: Digest Footer > > _______________________________________________ > squid-users mailing list > squid-users@lists.squid-cache.org > http://lists.squid-cache.org/listinfo/squid-users > > > ------------------------------ > > End of squid-users Digest, Vol 103, Issue 6 > ******************************************* >
_______________________________________________ squid-users mailing list squid-users@lists.squid-cache.org http://lists.squid-cache.org/listinfo/squid-users
