Postgres Connection Issue

Matthias Rebbe matthias_livecode_150811 at m-r-d.de
Sun Aug 16 03:43:42 EDT 2020


Did you already try t o remove the https://  from tDatabaseAddress?
I am not used with Postgres, but this https would definitely not work when connecting to MySQL. 



Von meinem iPhone gesendet

> Am 16.08.2020 um 07:42 schrieb Todd Fabacher via use-livecode <use-livecode at lists.runrev.com>:
> 
> ocal tDatabaseAddress = "https://xxxxxxxxx-0.a.db.ondigitalocean.com::25060"
> 
> put revOpenDatabase("postgresql", tDatabaseAddress, "admin", tDatabaseUser,
> tDatabasePassword, "sslmode=require") into tConnectionID
> 
> Error Message
> invalid port number: "//xxxxxxxxx-0.a.db.ondigitalocean.com::25060"
> 
> What am I doing wrong? I know the port number is correct as I am connecting
> with NodeJS and two PGAdmin IDEs. I know the default port is 5432 for
> Postgres, but for security reasons, we changed it.
> 
> I would appreciate any help.
> 
> --Todd
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the use-livecode mailing list