In Base, I have selected PostgreSQL. I have added 192.168.20.108:5432=ptdb as the url
When I put in the username and password to test connection, I get the following error message
Error in database URL ‘sdbc:postgresql:192.168.20.108:5432=ptdb’:
invalid connection option “192.168.20.108:5432”
I have run Wireshark, and nothing appears to have gone out from Base on my interface.
Cheers
Andy
Try postgresql://192.168.20.108:5432/ptdb, assuming ptdb is the name of your database
Type in field “Datasource URL…”
host=192.168.20.108:5432 dbname=ptdb
I typed in as above and it rejected the ip address.
I typed in host=//192.168.20.108:5432 dbname=ptdb and got the following response after test connection
Couldn’t establish database connection to ‘sdbc:postgresql:host=//192.168.20.108:5432 dbname=ptdb’
could not connect to server: Network is unreachable (0x00002743/10051)
Is the server running locally and accepting
connections on Unix domain socket “//192.168.20.108:5432/.s.PGSQL.5432”?
WIreshark did not record any messages on the ethernet port. Incidentally I tried using MySQL and got a response from the server, but, of course, Base failed to connect.
Please pay attention! Compare:
host=192.168.20.108:5432
and
host=**//**192.168.20.108:5432
I have tried both.
Couldn’t establish database connection to ‘sdbc:postgresql:host=192.168.20.108:5432 dbname=ptdb’
could not translate host name “192.168.20.108:5432” to address: Unknown host
It appears the postgresql setting assumes a localhost.