<div dir="ltr">Are you creating the database as root or the squid user.....try as the squid user<br></div><div class="gmail_extra"><br><div class="gmail_quote">On 3 March 2017 at 08:46, <span dir="ltr"><<a href="mailto:squid-users-request@lists.squid-cache.org" target="_blank">squid-users-request@lists.squid-cache.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Send squid-users mailing list submissions to<br>
<a href="mailto:squid-users@lists.squid-cache.org">squid-users@lists.squid-cache.<wbr>org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.squid-cache.org/listinfo/squid-users" rel="noreferrer" target="_blank">http://lists.squid-cache.org/<wbr>listinfo/squid-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:squid-users-request@lists.squid-cache.org">squid-users-request@lists.<wbr>squid-cache.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:squid-users-owner@lists.squid-cache.org">squid-users-owner@lists.squid-<wbr>cache.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of squid-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Re: squid 3.5.2==> HTTPS FATAL: The ssl_crtd helpers are<br>
crashing too rapidly, need help! (Yuri Voinov)<br>
<br>
<br>
------------------------------<wbr>------------------------------<wbr>----------<br>
<br>
Message: 1<br>
Date: Fri, 3 Mar 2017 03:46:10 +0600<br>
From: Yuri Voinov <<a href="mailto:yvoinov@gmail.com">yvoinov@gmail.com</a>><br>
To: <a href="mailto:squid-users@lists.squid-cache.org">squid-users@lists.squid-cache.<wbr>org</a><br>
Subject: Re: [squid-users] squid 3.5.2==> HTTPS FATAL: The ssl_crtd<br>
helpers are crashing too rapidly, need help!<br>
Message-ID: <<a href="mailto:714528e5-a6d5-e72a-2bc7-9950a8eecb73@gmail.com">714528e5-a6d5-e72a-2bc7-<wbr>9950a8eecb73@gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
This problem, in principle, is common to all versions of ssl-bumped<br>
Squid from version 3.4 and 5.0, inclusive, and occurs when the stored<br>
certificate is damaged for any reason. The only thing vorkeraund that I<br>
could find - a monitor kesh.log and initialize the certificate database<br>
again with squid restart automatically.<br>
<br>
In some installations, this problem does not occur over the years. In<br>
other - almost daily. I have no desire to find out why this is happening<br>
exactly. For me it was easier to make the watchdog, which will follow up<br>
on this.<br>
<br>
03.03.2017 3:40, Yuri Voinov пишет:<br>
><br>
> One hint finally:<br>
><br>
> '([^ ]*) helper database ([^ ]*) failed: The SSL certificate database<br>
> ([^ ]*) is corrupted. Please rebuild' - - - 0 exec<br>
> "/usr/local/bin/crtd_create.sh -r >/dev/null 2>&1"<br>
> 'FATAL: ([^ ]*) helpers are crashing too rapidly, need help!' - - -<br>
> 0 exec "/usr/local/bin/crtd_create.sh -r >/dev/null 2>&1"<br>
> 'Cannot add certificate to db.' - - - 0 exec<br>
> "/usr/local/bin/crtd_create.sh -r >/dev/null 2>&1"<br>
><br>
> PS. This is from logsurfer.conf.<br>
><br>
><br>
> 03.03.2017 3:34, Yuri Voinov пишет:<br>
>><br>
>> This error is usually preceded by another error in cache.log<br>
>> associated with the certificates.<br>
>><br>
>> I will show you the direction. Then go himself.<br>
>><br>
>> This software will useful for you to solve:<br>
>><br>
>> <a href="http://www.crypt.gen.nz/logsurfer/" rel="noreferrer" target="_blank">http://www.crypt.gen.nz/<wbr>logsurfer/</a><br>
>><br>
>> HTH, Yuri<br>
>><br>
>><br>
>> 03.03.2017 2:47, --Ahmad-- пишет:<br>
>>> hey folks .<br>
>>> i have a problem with squid it get crashed after i enabled https !<br>
>>> cache log error => FATAL: The ssl_crtd helpers are crashing too<br>
>>> rapidly, need help!<br>
>>><br>
>>> i googled many topics and relevant pages and couldnt find a<br>
>>> clear solution .<br>
>>><br>
>>> the quick solution i made was i removed the certs in file :<br>
>>> *rm -rfv /var/lib/ssl_db/*<br>
>>> *<br>
>>> *<br>
>>> *then reinitiated the DB using cmd below :*<br>
>>> /lib/squid/ssl_crtd -c -s /var/lib/ssl_db<br>
>>> chown -R squid.squid /var/lib/ssl_db<br>
>>> chown-R squid.squid /var/lib/ssl_db<br>
>>><br>
>>> the restarted squid .<br>
>>><br>
>>> but this is not a solution becuase squid get crashed again after<br>
>>> certain time and i don’t know why !<br>
>>> my version is 3.5.2<br>
>>><br>
>>> here is squid.conf :<br>
>>> /etc/squid/squid.conf<br>
>>> visible_hostname pcloud<br>
>>> acl ip1 myip 10.1.0.1<br>
>>> acl ip2 myip 192.168.10.210<br>
>>> tcp_outgoing_address 192.168.10.210 ip1<br>
>>> tcp_outgoing_address 192.168.10.210 ip2<br>
>>> #<br>
>>> # Recommended minimum configuration:<br>
>>> #<br>
>>><br>
>>> # Example rule allowing access from your local networks.<br>
>>> # Adapt to list your (internal) IP networks from where browsing<br>
>>> # should be allowed<br>
>>> acl localnet src <a href="http://10.0.0.0/8" rel="noreferrer" target="_blank">10.0.0.0/8</a> # RFC1918 possible internal network<br>
>>> acl localnet src <a href="http://172.16.0.0/12" rel="noreferrer" target="_blank">172.16.0.0/12</a> # RFC1918 possible internal network<br>
>>> acl localnet src <a href="http://192.168.0.0/16" rel="noreferrer" target="_blank">192.168.0.0/16</a> # RFC1918 possible internal network<br>
>>> acl localnet src fc00::/7 # RFC 4193 local private network range<br>
>>> acl localnet src fe80::/10 # RFC 4291 link-local (directly<br>
>>> plugged) machines<br>
>>><br>
>>> acl SSL_ports port 443<br>
>>> acl Safe_ports port 80 # http<br>
>>> acl Safe_ports port 21 # ftp<br>
>>> acl Safe_ports port 443 # https<br>
>>> acl Safe_ports port 70 # gopher<br>
>>> acl Safe_ports port 210 # wais<br>
>>> acl Safe_ports port 1025-65535 # unregistered ports<br>
>>> acl Safe_ports port 280 # http-mgmt<br>
>>> acl Safe_ports port 488 # gss-http<br>
>>> acl Safe_ports port 591 # filemaker<br>
>>> acl Safe_ports port 777 # multiling http<br>
>>> acl CONNECT method CONNECT<br>
>>><br>
>>> #<br>
>>> # Recommended minimum Access Permission configuration:<br>
>>> #<br>
>>> # Deny requests to certain unsafe ports<br>
>>> http_access deny !Safe_ports<br>
>>><br>
>>> # Deny CONNECT to other than secure SSL ports<br>
>>> http_access deny CONNECT !SSL_ports<br>
>>> http_access allow CONNECT<br>
>>> # Only allow cachemgr access from localhost<br>
>>> http_access allow localhost manager<br>
>>> http_access deny manager<br>
>>><br>
>>> # We strongly recommend the following be uncommented to protect innocent<br>
<br>
>>> # web applications running on the proxy server who think the only<br>
>>> # one who can access services on "localhost" is a local user<br>
>>> #http_access deny to_localhost<br>
>>><br>
>>> #<br>
>>> # INSERT YOUR OWN RULE(S) HERE TO ALLOW ACCESS FROM YOUR CLIENTS<br>
>>> #<br>
>>><br>
>>> # Example rule allowing access from your local networks.<br>
>>> # Adapt localnet in the ACL section to list your (internal) IP networks<br>
>>> # from where browsing should be allowed<br>
>>> http_access allow localnet<br>
>>> http_access allow localhost<br>
>>><br>
>>> # And finally deny all other access to this proxy<br>
>>> http_access deny all<br>
>>><br>
>>> # Squid normally listens to port 3128<br>
>>> http_port 3128<br>
>>><br>
>>> # Uncomment and adjust the following to add a disk cache directory.<br>
>>> #cache_dir ufs /var/cache/squid 100 16 256<br>
>>><br>
>>> # Leave coredumps in the first cache dir<br>
>>> #coredump_dir /var/cache/squid<br>
>>><br>
>>> #<br>
>>> # Add any of your own refresh_pattern entries above these.<br>
>>> #<br>
>>> #<br>
>>><br>
>>> http_port 3126<br>
>>> #http_port 3128<br>
>>> ##############################<wbr>#########<br>
>>> #cache_swap_low 90<br>
>>> #cache_swap_high 95<br>
>>> ############################<br>
>>> cache_effective_user squid<br>
>>> cache_effective_group squid<br>
>>> memory_replacement_policy lru<br>
>>> cache_replacement_policy heap LFUDA<br>
>>> ########################<br>
>>> maximum_object_size 10000 MB<br>
>>> #cache_mem 5000 MB<br>
>>> maximum_object_size_in_memory 10 MB<br>
>>> #########################<br>
>>> logfile_rotate 2<br>
>>> max_filedescriptors 131072<br>
>>> ##############################<wbr>#<br>
>>> ############<br>
>>> cache_dir aufs /var/cache/squid 600000 64 128<br>
>>> ##############################<wbr>#########<br>
>>> https_port 3129 intercept ssl-bump generate-host-certificates=on<br>
>>> dynamic_cert_mem_cache_size=<wbr>4MB<br>
>>> cert=/usr/local/squid/ssl_<wbr>cert/myca.pem<br>
>>> key=/usr/local/squid/ssl_cert/<wbr>myca.pem<br>
>>> ssl_bump server-first all<br>
>>> sslcrtd_program /lib/squid/ssl_crtd -s /var/lib/ssl_db -M 4MB<br>
>>> sslcrtd_children 1000 startup=1 idle=1<br>
>>> ###<br>
>>> minimum_object_size 0 bytes<br>
>>> #refresh patterns for caching static files<br>
>>> refresh_pattern ^ftp: 1440 20% 10080<br>
>>> refresh_pattern ^gopher: 1440 0% 1440<br>
>>> refresh_pattern -i .(gif|png|jpg|jpeg|ico)$ 10080 90% 43200<br>
>>> override-expire ignore-no-cache ignore-no-store ignore-private<br>
>>> refresh_pattern -i .(iso|avi|wav|mp3|mp4|mpeg|<wbr>swf|flv|x-flv)$ 43200<br>
>>> 90% 432000 override-expire ignore-no-cache ignore-no-store<br>
>>> ignore-private<br>
>>> refresh_pattern -i<br>
>>> .(deb|rpm|exe|zip|tar|tgz|ram|<wbr>rar|bin|ppt|doc|tiff)$ 10080 90% 43200<br>
>>> override-expire ignore-no-cache ignore-no-store ignore-private<br>
>>> refresh_pattern -i .index.(html|htm)$ 0 40% 10080<br>
>>> refresh_pattern -i .(html|htm|css|js)$ 1440 40% 40320<br>
>>> refresh_pattern . 0 40% 40320<br>
>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>> any Joy Guys ?<br>
>>><br>
>>> should i update squid ? or downgrade squid ?<br>
>>><br>
>>> kind regards<br>
>>><br>
>>><br>
>>><br>
>>> ______________________________<wbr>_________________<br>
>>> squid-users mailing list<br>
>>> <a href="mailto:squid-users@lists.squid-cache.org">squid-users@lists.squid-cache.<wbr>org</a><br>
>>> <a href="http://lists.squid-cache.org/listinfo/squid-users" rel="noreferrer" target="_blank">http://lists.squid-cache.org/<wbr>listinfo/squid-users</a><br>
>><br>
>> --<br>
>> Bugs to the Future<br>
><br>
> --<br>
> Bugs to the Future<br>
<br>
--<br>
Bugs to the Future<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.squid-cache.org/pipermail/squid-users/attachments/20170303/f5499462/attachment.html" rel="noreferrer" target="_blank">http://lists.squid-cache.org/<wbr>pipermail/squid-users/<wbr>attachments/20170303/f5499462/<wbr>attachment.html</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: 0x613DEC46.asc<br>
Type: application/pgp-keys<br>
Size: 2437 bytes<br>
Desc: not available<br>
URL: <<a href="http://lists.squid-cache.org/pipermail/squid-users/attachments/20170303/f5499462/attachment.key" rel="noreferrer" target="_blank">http://lists.squid-cache.org/<wbr>pipermail/squid-users/<wbr>attachments/20170303/f5499462/<wbr>attachment.key</a>><br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: signature.asc<br>
Type: application/pgp-signature<br>
Size: 473 bytes<br>
Desc: OpenPGP digital signature<br>
URL: <<a href="http://lists.squid-cache.org/pipermail/squid-users/attachments/20170303/f5499462/attachment.sig" rel="noreferrer" target="_blank">http://lists.squid-cache.org/<wbr>pipermail/squid-users/<wbr>attachments/20170303/f5499462/<wbr>attachment.sig</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
______________________________<wbr>_________________<br>
squid-users mailing list<br>
<a href="mailto:squid-users@lists.squid-cache.org">squid-users@lists.squid-cache.<wbr>org</a><br>
<a href="http://lists.squid-cache.org/listinfo/squid-users" rel="noreferrer" target="_blank">http://lists.squid-cache.org/<wbr>listinfo/squid-users</a><br>
<br>
<br>
------------------------------<br>
<br>
End of squid-users Digest, Vol 31, Issue 9<br>
******************************<wbr>************<br>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">I hate to advocate <span style="color:rgb(255,153,0)"><b>drugs</b></span>, <span style="color:rgb(255,153,0)"><b>alcohol</b></span>,<b> <span style="color:rgb(255,153,0)">violence</span> </b><span style="background-color:rgb(255,255,255)"><span style="color:rgb(255,153,0)"></span></span>or <br><span style="color:rgb(255,153,0)"><b>insanity</b></span> to anyone,<span style="color:rgb(255,153,0)"> <b>but</b></span> they've <b><span style="color:rgb(255,153,0)">always</span></b> worked for<b> <span style="color:rgb(255,153,0)">me</span></b><span style="background-color:rgb(255,153,0)"></span><br><br>- Hunter S. Thompson<br></div></div>
</div>