<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=iso-8859-1">
<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;}
span.Shkpostityyli17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.Shkpostityyli18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.Shkpostityyli19
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.Shkpostityyli20
{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 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 [mailto:mapserver-users-bounces@lists.osgeo.org]
<b>Puolesta </b>Sebastiano Laini<br>
<b>Lähetetty:</b> 17. lokakuuta 2018 12:16<br>
<b>Vastaanottaja:</b> 'mapserver-users@lists.osgeo.org' <mapserver-users@lists.osgeo.org><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>