no pg_hba.conf entry for host "30.30.30.1" but host should be 30.30.30.30
Nobody has claimed this yet.
- Dominant language
- CartoCSS
- Stars
- 703
- Forks
- 222
- PR merge metrics
- No merged PRs in 30d
Description
```
Postgis Plugin: FATAL: no pg_hba.conf entry for host "30.30.30.1", user "vagrant", database "osm", SSL on
FATAL: no pg_hba.conf entry for host "30.30.30.1", user "vagrant", database "osm", SSL off
host=30.30.30.30 port=5432 dbname=osm user=vagrant password=osm connect_timeout=4 encountered during parsing of layer 'landuse_gen0' in Layer at line 214
```
Why does TileMill tries to connect to 30.30.30.1 if 30.30.30.30 is configured as host?
`configure.py`
``` python
#...
config["postgis"]["host"] = "30.30.30.30"
config["postgis"]["port"] = "5432"
config["postgis"]["dbname"] = "osm"
config["postgis"]["user"] = "vagrant"
config["postgis"]["password"] = "osm"
#...
```
Any help appreciated.
Regards
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with configure.py and trace how the configured PostGIS host is passed into the layer connection that reports the pg_hba.conf error. Compare the configured 30.30.30.30 value with the reported 30.30.30.1 value and determine where they diverge. Done means the cause is identified and the connection uses the intended host or the configuration behavior is documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100