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