Can't connect to Postgresql Database

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
ifreak
Posts: 1
Joined: 31 Mar 2021, 22:52

Can't connect to Postgresql Database

Post by ifreak »

Hello,
i'm running a PSQL Database on server 1 (ip 1.0.0.1). (PSQL Version psql (PostgreSQL) 12.6 (Debian 12.6-1.pgdg100+1))
I try to connect to this Database from mantis server 2 (ip 1.0.0.2)

ip's only samples ;)

Database is created and owner is set to "mantis"
also command

Code: Select all

GRANT ALL PRIVILEGES ON DATABASE mantis TO mantis;
was executed...

Code: Select all

                             List of databases
   Name    |  Owner   | Encoding  | Collate | Ctype |   Access privileges   
-----------+----------+-----------+---------+-------+-----------------------
 mantis    | mantis   | SQL_ASCII | C       | C     | =Tc/mantis           +
           |          |           |         |       | mantis=CTc/mantis
postgresql.conf is adaptet with

Code: Select all

listen_addresses = '*'
pghba.conf is also configured with

Code: Select all

host    mantis          mantis          1.0.0.2/32         trust
on server 2 i can connect the database via terminal with the following command and entering the password

Code: Select all

psql -h 1.0.0.1 mantis mantis
mantis install.php tell me

Code: Select all

Attempting to connect to database as admin	BAD
Does administrative user have access to the database? ( Database connection failed )
can anybody help me?
Post Reply