Aw: Postgres Connection Issue

[matthias rebbe via use-livecode]

Todd,

could you please also remove the 2 slashes?



-
Matthias Rebbe
Life Is Too Short For Boring Code

> Am 16.08.2020 um 19:33 schrieb Todd Fabacher via use-livecode 
> mailto:use-livecode@lists.runrev.com>>:
> 
> Thanks  Matthias Rebbe for the reply
> 
> Did you already try to remove the https://  from tDatabaseAddress?
> I am not used with Postgres, but this https would definitely not work when
> connecting to MySQL.
> 
> When I took it out the https:, I got this error:
> 
> *could not connect to server: No such file or directory*
> 
> * Is the server running locally and accepting*
> 
> * connections on Unix domain socket
> "//xxe-0.a.db.ondigitalocean.com/.s.PGSQL.25060 
> 
>  >"?*
> 
> 
> MY error is the port number...there should be no issue with the port
> nu,ber. it works everywhere except LiveCode.
> 
> invalid port number: "//-0.a.db.ondigitalocean.com:25060 
> "
> ___
> use-livecode mailing list
> use-livecode@lists.runrev.com 
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



-
Matthias Rebbe
Life Is Too Short For Boring Code

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: Postgres Connection Issue

[Matthias Rebbe via use-livecode]

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 
> :
> 
> ocal tDatabaseAddress = "https://x-0.a.db.ondigitalocean.com::25060;
> 
> put revOpenDatabase("postgresql", tDatabaseAddress, "admin", tDatabaseUser,
> tDatabasePassword, "sslmode=require") into tConnectionID
> 
> Error Message
> invalid port number: "//x-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@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription 
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode


___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Postgres Connection Issue

[Todd Fabacher via use-livecode]

ocal tDatabaseAddress = "https://x-0.a.db.ondigitalocean.com::25060;

put revOpenDatabase("postgresql", tDatabaseAddress, "admin", tDatabaseUser,
tDatabasePassword, "sslmode=require") into tConnectionID

Error Message
invalid port number: "//x-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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode