Search found 90 matches

by rdv4rjm
21 May 18 18:25
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

I setup a new router, disabled firewall, hard wired server and 3 clients.
Added Mac client to 2 other Windows clients.

ssh remote connection is successful from client to server, and server to client : ssh "hostname"@"ip address"
by rdv4rjm
21 May 18 18:14
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

Hi username Is the server in DMZ or on the inside? NO SERVER IS NOT IN DMZ. Are the server as well as clients on the same sub net? 192.168.8.x YES CLIENTS AND SERVER ARE ON SAME SUB NET. Do the client try to connect to the servers IP or hostname? WHEN CONNECTING USING IP: "is server running on host ...
by rdv4rjm
21 May 18 17:57
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

Hi amartel I think the problem is that your postgresql server doesn't listen on the correct IP address (only localhost - 127.0.0.1). Edit file postgresql.conf to update line: listen_addresses = '*' I DID MODIFY POSTGRESQL.CONF AS SUGGESTED: 2018-05-21 11:54:07.834 EDT [537] LOG: listening on IPv4 ad...
by rdv4rjm
21 May 18 6:26
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

Screen Shot 2018-05-21 at 1.16.10 AM.png
Screen Shot 2018-05-21 at 1.16.10 AM.png (35.5 KiB) Viewed 1015 times
by rdv4rjm
21 May 18 6:24
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

The attachment Screen Shot 2018-05-21 at 12.21.50 AM.png is no longer available
The attachment Screen Shot 2018-05-21 at 12.21.50 AM.png is no longer available
by rdv4rjm
21 May 18 6:20
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

The attachment Screen Shot 2018-05-21 at 12.21.50 AM.png is no longer available
The attachment Screen Shot 2018-05-21 at 1.12.35 AM.png is no longer available
Screen Shot 2018-05-21 at 1.12.35 AM.png
Screen Shot 2018-05-21 at 1.12.35 AM.png (59.81 KiB) Viewed 1198 times
Still no connection.
Tried pinging from both clients: Packets sent: 4 received: 4. lost: 0
by rdv4rjm
20 May 18 19:11
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

In case this would help:

From Mac Console seconds after correction of error and while trying to connect from 2 different clients.

Don't mean much to me.
There is signs of negotiation with incoming traffic, if I am not mistaking.
by rdv4rjm
20 May 18 18:57
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

Postgres log file 2018-05-20 13:47:22.103 EDT [651] LOG: listening on IPv4 address "127.0.0.1", port 5432 2018-05-20 13:47:22.104 EDT [651] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2018-05-20 13:47:22.286 EDT [652] LOG: database system was shut down at 2018-05-20 08:49:29 EDT 2018-05-20 13...
by rdv4rjm
20 May 18 18:56
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

Hey, you got an eye. Yes this was keeping server from starting. Now it runs, though I still can't connect from client using or hostname or server ip. get same message: The database reports: Connection to database failed (PostgreSQL: could not connect to server: connection refused(0x0000274D/10061) I...
by rdv4rjm
20 May 18 16:41
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

I can from Command com successfully
by rdv4rjm
20 May 18 14:15
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

Postgres Log file
Postgres Log file
Screen Shot 2018-05-20 at 8.59.21 AM.png (45.86 KiB) Viewed 1263 times
by rdv4rjm
20 May 18 14:08
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

I inserted suggested modifications.
The attachment Screen Shot 2018-05-20 at 8.58.18 AM.png is no longer available
Restarted server.
Postgres refuses to start.
pg_hba.conf
pg_hba.conf
Screen Shot 2018-05-20 at 8.58.18 AM.png (29.45 KiB) Viewed 1263 times
by rdv4rjm
20 May 18 6:37
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Re: Connection to database & pow authentification failed

Thanks Hert for your suggestion. I made a clean install of OSX High Sierra v. 10.13.4 Only software installed: PostgreSQL 10, Photo Supreme. Followed installation instructions carefully. Tested Postgres from terminal, and created database. Started PSU. Inserted license. Updated it. Works fine. This ...
by rdv4rjm
13 May 18 14:16
Forum: Photo Supreme
Topic: Connection to database & pow authentification failed
Replies: 22
Views: 2396

Connection to database & pow authentification failed

Running High Sierra 10.13.4. Installed PSU PostgreSQL. Running fine on local computer. Cannot connect from client: Connection to database failed (PostgreSQL: FATAL: password authentication failed for user "idimager_main" Been fighting this for days. Beyond my knowledge. If someone would have solved ...