[mapserver-users] Mapcache instruction

[Yves Jacolin]

Here a short tuto from my personal notes:

1. create a cache entry in your mapcache file

    <cache name="mbtiles" type="sqlite3">
        <dbfile>/var/www/osm_google.db</dbfile>
    </cache>

2. create a empty sqlite file
- run sqlite3
- run this commande inside sqlite3: ".save filename.db" (without ")
3. use this cache in your settings

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:/....

Y.

Le jeu. 20 sept. 2018 à 13:07, Sebastiano Laini <
Sebastiano.Laini at buchanancomputing.co.uk> a écrit :

> Hi all,
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> Regards;
>
>
>
> Sebastiano.
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/mapserver-users



-- 
Training and support manager
Camptocamp
Bâtiment le Dauphin - 1er étage
18 rue du Lac Saint André
73382 Le Bourget-du Lac

Tel (France) : +33 4 58 48 20 43
Tel (Switzerland) : +41 21 619 10 43
Mob. : +33 6 18 75 42 21

email : yves.jacolin at camptocamp.com
http://www.camptocamp.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20180920/dcb9bc68/attachment.html>