It seems I'm not allowed to connect to the osm postgres database from maps-tiles1.wmflab.org. I suspect the config of postgres has not yet been updated to know about the new eqiad-r ip range ?
psql -h osmdb.eqiad.wmnet -U osm gis psql: FATAL: no pg_hba.conf entry for host "172.16.5.154", user "osm", database "gis", SSL off
| Project | Branch | Lines +/- | Subject | |
|---|---|---|---|---|
| operations/puppet | production | +38 -0 | wmcs: Add postgres maps users for eqiad1-r region |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Andrew | T204506 cloudvps: maps project trusty deprecation | |||
| Resolved | TheDJ | T212596 Allow tiles1.wmflabs.org (or possibly entire eqiad-r?) access to osm postgres |
Change 481341 had a related patch set uploaded (by BryanDavis; owner: Bryan Davis):
[operations/puppet@production] wmcs: Add postgres maps users for eqiad1-r region
Change 481341 merged by Arturo Borrero Gonzalez:
[operations/puppet@production] wmcs: Add postgres maps users for eqiad1-r region
@aborrero I can confirm access.
I still get a permission error in the renderer for SELECT ST_SRID("way") AS srid FROM planet_osm_polygon WHERE "way" IS NOT NULL LIMIT 1; but it seems it does that on the old servers as well.. Not sure what that means.