<div dir="ltr"><div dir="ltr"><div dir="ltr"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span class="gmail-im"><pre><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"></span></span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span class="gmail-im"><pre><code></code><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"></span></span></pre></span></span></span></span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><span class="gmail-im"></span></span></span></span><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><cache>disk</cache> should also be changed to <cache>mbtiles</cache> in your example. Note that "mbtiles" is not the best name (I copy pasted my example)! You can find a better name :)<br><br></span></pre><pre><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">And yes except that you need to create the db file (as you should create a database postgresql before to use it) all other command are similar.<br><br></span></pre><pre><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">Y.<br></span></pre><pre><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)">PS : please keep reply to the list :)<br></span></pre><pre><span style="font-size:11pt;font-family:"Calibri",sans-serif;color:rgb(31,73,125)"><br></span></pre></span></span></span></div></div></div><br><div class="gmail_quote"><div dir="ltr">Le jeu. 20 sept. 2018 à 13:44, Sebastiano Laini <<a href="mailto:Sebastiano.Laini@buchanancomputing.co.uk">Sebastiano.Laini@buchanancomputing.co.uk</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-GB" link="blue" vlink="purple">
<div class="m_-7390613133656986161WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I see, so I just need to replace this code:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <cache name="disk" type="disk"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <base>/var/www/vhosts/<a href="http://buchananmapping.co.uk/httpdocs/maps/cache" target="_blank">buchananmapping.co.uk/httpdocs/maps/cache</a></base><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <symlink_blank/><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </cache><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Whith this:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<pre><code> <cache name="mbtiles" type="</code><span class="m_-7390613133656986161gmail-s">sqlite3</span><code>"><u></u><u></u></code></pre>
<pre><code> <dbfile>/var/www/osm_google.db</dbfile><u></u><u></u></code></pre>
<pre><code> </cache> </code><u></u><u></u></pre>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></b></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">And then used my code as usual? (changing the cache that I call in the tileset)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <source name="Mymaps" type="wms"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <getmap><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <params><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <FORMAT>image/jpeg</FORMAT><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <LAYERS>miniscale</LAYERS><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <MAP>/var/www/vhosts/DOMAIN/maps.map</MAP><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </params><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </getmap><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <http><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <url>URL/cgi-bin/mapserv?</url><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </http><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </source><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <tileset name="Mycache"><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><source>Mymaps</source><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><cache>disk</cache><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><grid>Mygrid</grid><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><format>JPEG</format><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><metatile>4 4</metatile><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <metabuffer>0</metabuffer><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <expires>31536000</expires><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </tileset><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <grid name="Mygrid"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <metadata><u></u><u></u></span></p>
<p class="MsoNormal" style="margin-left:36.0pt;text-indent:36.0pt"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><title>this is a custom grid</title><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </metadata><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <srs>EPSG:27700</srs><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <size>128 128</size><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <extent>0 0 700000 1250000</extent><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> <resolutions>70 28 14 7 6.16 2.8 1.4 0.7 0.28 0.14 0.07</resolutions><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"></grid><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">The request is going to be the same or is changing?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">An example of my actual request is this one:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">URL/mapcache/?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetMap&FORMAT=image%2Fpng&TRANSPARENT=true&LAYERS=Mycache&TILED=true&WIDTH=128&HEIGHT=128&CRS=EPSG%3A27700&STYLES=&BBOX=465920%2C174800%2C501760%2C210640<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Is created through OpenLayers 4, I sent the cords “BBOX” and the cache name “LAYERS=Mycache”<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Sebastiano.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Yves Jacolin [mailto:<a href="mailto:yves.jacolin@camptocamp.com" target="_blank">yves.jacolin@camptocamp.com</a>]
<br>
<b>Sent:</b> 20 September 2018 12:24<br>
<b>To:</b> Sebastiano Laini <<a href="mailto:Sebastiano.Laini@BuchananComputing.co.uk" target="_blank">Sebastiano.Laini@BuchananComputing.co.uk</a>><br>
<b>Cc:</b> mapserver-users <<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>><br>
<b>Subject:</b> Re: [mapserver-users] Mapcache instruction<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Here a short tuto from my personal notes:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">1. create a cache entry in your mapcache file<u></u><u></u></p>
</div>
<div>
<pre><code> <cache name="mbtiles" type="</code><span class="m_-7390613133656986161gmail-s">sqlite3</span><code>"><u></u><u></u></code></pre>
<pre><code> <dbfile>/var/www/osm_google.db</dbfile><u></u><u></u></code></pre>
<pre><code> </cache> </code><u></u><u></u></pre>
</div>
<div>
<p class="MsoNormal">2. create a empty sqlite file<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- run sqlite3<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">- run this commande inside sqlite3: ".save filename.db" (without ")<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">3. use this cache in your settings<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">You don't need MySQL or PostgreSQL, only sqlite3 and its dependencies. Path used in my example for cache block are for Unix like system, you should adapt it for Windows : c:/....<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Y.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<div>
<p class="MsoNormal">Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini <<a href="mailto:Sebastiano.Laini@buchanancomputing.co.uk" target="_blank">Sebastiano.Laini@buchanancomputing.co.uk</a>> a écrit :<u></u><u></u></p>
</div>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div>
<p class="MsoNormal">Hi all,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">We have a MapCache setup with “disk_cache” but we are running out of Inodes when I try to seed the whole UK with projection 27700.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I was thinking to propose to my supervisor to use the “SQLite Caches” but I don’t know how it works. Can someone guide me through the process of setup MapCache with this type of
cache? And if I need some dependency, we use PostgreSQL in our server so I assume I need to install also MySQL.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I’ve already read the documentation but still I have doubt about the db part, how to create the db and locate it. I never use SQLite, just PostgreSQL.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Regards;<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Sebastiano.<u></u><u></u></p>
<p class="MsoNormal"><span style="color:#1f497d"> </span><u></u><u></u></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<br>
-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Training and support manager<br>
Camptocamp<br>
Bâtiment le Dauphin - 1er étage<br>
18 rue du Lac Saint André<br>
73382 Le Bourget-du Lac<br>
<br>
Tel (France) : +33 4 58 48 20 43<br>
Tel (Switzerland) : +41 21 619 10 43<br>
Mob. : +33 6 18 75 42 21<br>
<br>
email : <a href="mailto:yves.jacolin@camptocamp.com" target="_blank">yves.jacolin@camptocamp.com</a><br>
<a href="http://www.camptocamp.com" target="_blank">http://www.camptocamp.com</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Training and support manager<br>Camptocamp<br>Bâtiment le Dauphin - 1er étage<br>18 rue du Lac Saint André<br>73382 Le Bourget-du Lac<br><br>Tel (France) : +33 4 58 48 20 43<br>Tel (Switzerland) : +41 21 619 10 43<br>Mob. : +33 6 18 75 42 21<br><br>email : <a href="mailto:yves.jacolin@camptocamp.com" target="_blank">yves.jacolin@camptocamp.com</a><br><a href="http://www.camptocamp.com" target="_blank">http://www.camptocamp.com</a></div></div></div></div></div></div></div></div></div></div></div>