[Tile-serving] [openstreetmap/mod_tile] [centos7 container image] mod_tile gives "no datasource plugin directories have been successfully registered" (Issue #433)

[Muhammad Edwin]

hi @hummeltech 
thanks for the information

apparently i need to define a different `plugins_dir` when using centos 7 
```
[mapnik]
plugins_dir=/usr/lib64/mapnik/input
font_dir=/usr/share/fonts/truetype
font_dir_recurse=true
```

setting `INPUT_PLUGINS` into `all` will generate everything i needed, including `postgis.input` which i assume is the driver needed to connect to `postgresql` database
https://github.com/openstreetmap/mod_tile/blob/c3453bc1e19247c145b0e87742710d5e076e338e/docker/centos/7/Dockerfile#L58-L72

and use this for external database connection
```xml
  <Layer name="layer01" srs="+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0.0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over">
    <StyleName><![CDATA[layer01-outline]]></StyleName>
    <StyleName><![CDATA[layer01-something]]></StyleName>
    <Datasource>
      <Parameter name="type"><![CDATA[postgis]]></Parameter>
      <Parameter name="table"><![CDATA[(select * from xxx as xxxx) as _subquery]]></Parameter>
      <Parameter name="key_field"><![CDATA[gid]]></Parameter>
      <Parameter name="geometry_field"><![CDATA[geom]]></Parameter>
      <Parameter name="extent_cache"><![CDATA[auto]]></Parameter>
      <Parameter name="extent"><![CDATA[10572229.3154,-1232970.4197999984,15698279.243600003,646048.5146999992]]></Parameter>

       <Parameter name="dbname"><![CDATA[db_xxxx]]></Parameter>
      <Parameter name="host"><![CDATA[192.168.x.x]]></Parameter>
      <Parameter name="port"><![CDATA[5432]]></Parameter>
      <Parameter name="user"><![CDATA[xxxx]]></Parameter>
      <Parameter name="password"><![CDATA[xxxx]]></Parameter>

    </Datasource>
  </Layer>
```




-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/mod_tile/issues/433#issuecomment-2111445013
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/mod_tile/issues/433/2111445013 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20240514/f1a95f8f/attachment-0001.htm>