<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.Shkpostityyli18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.Shkpostityyli19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.Shkpostityyli20
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.Shkpostityyli21
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.Shkpostityyli22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.Shkpostityyli23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.Shkpostityyli24
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="FI" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Sorry, MapCache documentation has link to that page as well.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Anyway, my understanding is that Apache module is the fastest alternative and cgi/fcgi exist mainly to be used with other http servers than Apache. Keywords from presentation
<a href="https://www.slideshare.net/tbonfort/modgeocache-mapcache-a-fast-tiling-solution-for-the-apache-web-server">
https://www.slideshare.net/tbonfort/modgeocache-mapcache-a-fast-tiling-solution-for-the-apache-web-server</a>. I hope that developers can confirm if I have understood right.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Apache module• Module = code run by the apache processes that treat requests• Native code• No overhead (e.g. CGI, FastCGI)• Does not require spawning an interpreter per concurrent request• Caveats: – Thread/process
synchronization – Memory management – Security<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">-Jukka- Rahkonen-</span><span lang="EN-US" style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-fareast-language:FI">Lähettäjä:</span></b><span style="mso-fareast-language:FI"> mapserver-users [mailto:mapserver-users-bounces@lists.osgeo.org]
<b>Puolesta </b>Rahkonen Jukka (MML)<br>
<b>Lähetetty:</b> 17. lokakuuta 2018 14:39<br>
<b>Vastaanottaja:</b> Sebastiano Laini <Sebastiano.Laini@BuchananComputing.co.uk>; 'mapserver-users@lists.osgeo.org' <mapserver-users@lists.osgeo.org><br>
<b>Aihe:</b> Re: [mapserver-users] mapcache fastcgi<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">That documentation is about Mapserver, Mapcache is another software. It does belong to the same Mapserver but is not the same.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">MapCache is documented here:<br>
<a href="https://mapserver.org/mapcache/index.html#mapcache">https://mapserver.org/mapcache/index.html#mapcache</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-fareast-language:FI">Lähettäjä:</span></b><span style="mso-fareast-language:FI"> Sebastiano Laini [<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk">mailto:Sebastiano.Laini@BuchananComputing.co.uk</a>]
<br>
<b>Lähetetty:</b> 17. lokakuuta 2018 14:33<br>
<b>Vastaanottaja:</b> 'mapserver-users@lists.osgeo.org' <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<b>Kopio:</b> Rahkonen Jukka (MML) <<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">jukka.rahkonen@maanmittauslaitos.fi</a>><br>
<b>Aihe:</b> RE: mapcache fastcgi<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="line-height:18.0pt;background:white"><span lang="EN-GB" style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#3E4349">Well, for what I can read in the documentation of mapserver:<o:p></o:p></span></p>
<p style="line-height:18.0pt;background:white"><span lang="EN-GB" style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#3E4349"><a href="https://mapserver.org/optimization/fastcgi.html">https://mapserver.org/optimization/fastcgi.html</a><o:p></o:p></span></p>
<p style="line-height:18.0pt;background:white"><span lang="EN-GB" style="font-size:9.5pt;font-family:"Arial",sans-serif;color:#3E4349">FastCGI is a protocol for keeping cgi-bin style web applications running as a daemon to take advantage of preserving memory
caches, and amortizing other high startup costs (like heavy database connections) over many requests.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D">It seems that using mapcache as fastCGI over apache modules it that should improve speed also.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB">Sebastiano Laini<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB">Web Developer<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB">Buchanan Computing<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:EN-GB">From:</span></b><span lang="EN-US" style="mso-fareast-language:EN-GB"> Rahkonen Jukka (MML) [<a href="mailto:jukka.rahkonen@maanmittauslaitos.fi">mailto:jukka.rahkonen@maanmittauslaitos.fi</a>]
<br>
<b>Sent:</b> 17 October 2018 12:30<br>
<b>To:</b> Sebastiano Laini <<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk">Sebastiano.Laini@BuchananComputing.co.uk</a>>; 'mapserver-users@lists.osgeo.org' <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: mapcache fastcgi<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Could you explain your plan with some more details? What I have understood is that you have experienced that SQLite cache is slower than disk cache in your environment.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">What I do not understand is what you are going to reach by running Mapcache as fastcgi instead of running it as Apache module which should be the faster option, and if this has some connection with
the SQLite cache vs. disk cache comparison. Do you guess that fastcgi woud make SQLite cache faster?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">-Jukka Rahkonen-<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-fareast-language:FI">Lähettäjä:</span></b><span style="mso-fareast-language:FI"> mapserver-users [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>]
<b>Puolesta </b>Sebastiano Laini<br>
<b>Lähetetty:</b> 17. lokakuuta 2018 12:16<br>
<b>Vastaanottaja:</b> 'mapserver-users@lists.osgeo.org' <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br>
<b>Aihe:</b> [mapserver-users] mapcache fastcgi<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-GB">Hi all,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">In the end I tried MapCache with sqlite3 cache but it’s very slow compared with the disk cache, so I want to setup MapCache with fastCGI on CentOS 7.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I don’t understand what I need to install as the fastCGI link in the documentation is broken and I don’t know if is up to date.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I already have apache fgcid installed from default in the httpd folder and I use PHP in fastCGI in all the domains, so I’m sure that fastCGI it works, though, I still need the fastCGI library? How can I install it in
CentOS 7?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">In my apache conf I’ve already added the lines to load the mapcache module and the mapcache.xml file<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">LoadModule mapcache_module modules/mod_mapcache.so<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><IfModule mapcache_module><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> <Directory /path/to/directory><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> Require all granted<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> </Directory><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> MapCacheAlias /mapcache "/path/to/directory/mapcache.xml"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"></IfModule><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">I need to leave the previous configuration and add these new lines in the conf files?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><IfModule mod_fcgid.c><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> IPCCommTimeout 120<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> MaxProcessCount 10<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> FcgidInitialEnv "MAPCACHE_CONFIG_FILE" "/path/to/mapcache/mapcache.xml"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> <Location /map.fcgi><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> Order Allow,Deny<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> Allow from all<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> SetHandler fcgid-script<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> </Location><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"> ScriptAlias /map.fcgi "/path/to/mapcache/src/mapcache"<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"></IfModule><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">And then instead of <a href="http://myserver/mapcache">
http://myserver/mapcache</a> I need to use <a href="http://myserver/fcgi-bin">http://myserver/fcgi-bin</a> to access mapcache fcgi?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB">Sebastiano Laini<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB">Web Developer<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="color:#1F497D;mso-fareast-language:EN-GB">Buchanan Computing<o:p></o:p></span></p>
</div>
</body>
</html>