Projects tigase _server server-core Issues #1490
Connection to localhost:5432 refused (#1490)
Open
Unknown opened 2 years ago

I have followed error

Connection not validated
Validating DBConnection, URI: jdbc:postgresql://localhost:5432/postgres?user=postgres&password=*****&useSSL=false
Problem validating database connection: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
image

but any other application is able to connect Zrzut ekranu 2023-01-29 o 21 34 46

How I runned the server:

$ docker pull tigase/tigase-xmpp-server
$ docker run --name tigase-server -p 8080:8080 -p 5222:5222 tigase/tigase-xmpp-server
Unknown commented 2 years ago

Hi, How do you run postgresql? Via docker as well? If so you should make your postgres container and tigase container use the same dedicated network (see https://github.com/tigase/tigase-xmpp-server-docker/#dedicated-network) and then reference postgres via container name (which is also it's hostname within dedicated network)

Unknown commented 2 years ago

I have postgres installed by brew install postgresql

Unknown commented 2 years ago

I would recommend switching to one deployed in docker as well - makes maintenance easier, especially if your other tools also rely on docker. As for your use-case, accessing host services from within docker is somewhat tricky, but possible, see https://stackoverflow.com/questions/31324981/how-to-access-host-port-from-docker-container#43541732. In a nutshell: add --add-host=host.docker.internal:host-gateway to your docker run command and then in the installer use host.docker.internal for postgres database.

Alternatively, you can run Tigase without docker - simply download latest distribution package from https://github.com/tigase/tigase-server/releases/tag/tigase-server-8.3.0, extract it and in the directory run ./scripts/tigase.sh start etc/tigase.conf (at least JDK17 has to be installed)

issue 1 of 1
Type
Bug
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#1490
Please wait...
Page is in error, reload to recover