Comments (4)
Yep, it's pg_hba.conf
configuration connected. Publisher can't connect to this database with provided credentials. This can help You: https://stackoverflow.com/questions/3278379/how-to-configure-postgresql-to-accept-all-incoming-connections
from web-publisher.
I used that stack overflow answer to change the pg_hba.conf to include:
# IPv4 local connections:
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::0/0 md5
I added the listen_address = '*' to the postgresql.conf file, and I reloaded the configuration. I still get the same error though. I also tried using trust instead of md5, but still the same result.
from web-publisher.
For anyone facing the same issue, I figured it out. By coming back to it and mistakenly entering the second SQL command in the instructions, I got the error SQLSTATE[08006] : role "root" does not exist
. I solved this with an answer from https://github.com/taigaio/taiga-back/issues/387 and added a user named "root" to postgres. Next, I upgraded the root user to a superuser. After that, everything worked just fine. I don't know why it was looking for a user named root instead of the one specified in parameters.yml.
Now, I have no idea if this was actually a secure way of installing this. I'm only testing right now, so I'm not super concerned, but @ahilles107 would you be able to give feedback about this?
from web-publisher.
I'm not sure how it should be done on postgres configuration. I never had to create root user - i always create new user and database for publisher instance.
from web-publisher.
Related Issues (20)
- Theme could not be installed, files are reverted to previous version!
- Can't install default theme HOT 1
- Logging out does not trigger a back-channel logout to OAuth service
- No logging in prod env
- Tenant for host could not be found HOT 10
- grunt build - GC - Javascript heap out of memory HOT 2
- Command "translation:extract" is not defined. HOT 1
- Documentation - theme
- Error Error Error Error Error Error Error Error Error Error Error Error Error Error Error Error Error Error Error Error!!! help HOT 1
- Tenant for host "123abc" could not be found! Please check tenants configuration. Help!!!
- We facing this issue while installing publisher
- Another Error
- An exception occurred while executing 'DELETE FROM swp_package_author': HOT 1
- Elasticsearch down HOT 1
- Feature request: Follow author HOT 1
- Bug: Article updatedAt field is updated when media is converted to webp HOT 3
- Bug: Duplicate messages are added to image_conversion queue HOT 1
- ERROR: relation "swp_user_reset_password_request" does not exist
- Optimize heavy media file transport in getAssetAction HOT 1
- ERROR: Host key verification failed. fatal: Could not read from remote repository. HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from web-publisher.