[postgis-users] Postgis Plugin: fe_sendauth: no password supplied

[Willie Hallock]

Hello,

I am using the instructions found at
https://switch2osm.org/manually-building-a-tile-server-18-04-lts/ to setup
a OSM mapping server. If the ubuntu user matches the postgresql user ( i.e.
renderaccount) everything works without any problems.

However, I would like to get stuff to work where the ubuntu user is XXX and
the postgresql user remains renderaccount.

I can get past most issues by:

1. changing pg_hba.conf so:

local   all             all                                     peer



looks like:

local   all             all                                     md5


2. Setting the PGUSER environment variable to renderaccount

3. adding *:*:gis:renderaccount:<password> to ~/.pgpass

However, when I am ready to startup the renderer by doing:

renderd -f -c /usr/local/etc/renderd.conf


I am presented with the errors:

renderd[47532]: An error occurred while loading the map layer 'ajt':
Postgis Plugin: fe_sendauth: no password supplied
Connection string: ' dbname=gis connect_timeout=4'
  encountered during parsing of layer 'landcover-low-zoom' in Layer at line
765 of '/home/lander/src/openstreetmap-carto-de/osm.xml'
renderd[47532]: An error occurred while loading the map layer 'ajt':
Postgis Plugin: fe_sendauth: no password supplied
Connection string: ' dbname=gis connect_timeout=4'
  encountered during parsing of layer 'landcover-low-zoom' in Layer at line
765 of '/home/lander/src/openstreetmap-carto-de/osm.xml'
renderd[47532]: An error occurred while loading the map layer 'ajt':
Postgis Plugin: fe_sendauth: no password supplied
Connection string: ' dbname=gis connect_timeout=4'
  encountered during parsing of layer 'landcover-low-zoom' in Layer at line
765 of '/home/lander/src/openstreetmap-carto-de/osm.xml'
renderd[47532]: An error occurred while loading the map layer 'ajt':
Postgis Plugin: fe_sendauth: no password supplied
Connection string: ' dbname=gis connect_timeout=4'
  encountered during parsing of layer 'landcover-low-zoom' in Layer at line
765 of '/home/lander/src/openstreetmap-carto-de/osm.xml'


I am assuming what is going on is that it is trying to talk to the database
using the renderaccount user, but because there is a password, it cannot
and does not try to look at the .pgpass file.

This seems to be an issue with postgis...is there some way to configure
postgis to get past this problem?

Regards,
Willie
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190920/c3cf05f2/attachment.html>