<div dir="ltr"><div>Here a short tuto from my personal notes:</div><div><br></div><div>1. create a cache entry in your mapcache file<br></div><div><pre><code> <cache name="mbtiles" type="<span class="gmail-s">sqlite3</span>">
<dbfile>/var/www/osm_google.db</dbfile>
</cache> </code></pre></div><div>2. create a empty sqlite file<br></div><div>- run sqlite3</div><div>- run this commande inside sqlite3: ".save filename.db" (without ")</div><div>3. use this cache in your settings</div><div><br></div><div>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:/....<br></div><div><br></div><div>Y.<br></div><div><br></div><div class="gmail_quote"><div dir="ltr">Le jeu. 20 sept. 2018 à 13:07, 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 link="#0563C1" vlink="#954F72" lang="EN-GB">
<div class="m_2254958874008323433WordSection1">
<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"><u></u> <u></u></span></p>
</div>
</div>
_______________________________________________<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" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a></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></div>