PostgreSQL (8.1.23) is available along any on-rev account and works as
expected. For security reasons, the server is unreachable from the outside
world (direct internet connections are forbidden). Instead, we have to reach
the server in localhost mode where :
1.- As client-side components, your stacks have to connect a server-side
cgi-script engine (LiveCode, PHP, etc...) hosted on your on-rev account in
HTTP POST (prefered) or GET mode
2.- This cgi will have to pass your client-side stack request (as a SQL
statement) to the PostgreSQL request controller witch will reply to your cgi
with the appropriate response
3.- witch will be forwarded back to your client-side stacks
Typical configs : OSX/Win LC standalones on the client-side, RevServer 4.6.4 or
LC server 5.0.2 on the server-side with embedded SQL templates and statements,
PhpPgAdmin via CPanel
HTH,
Le 17 août 2012 à 22:20, Dr. Hawkins a écrit :
> I set up and paid for the account this morning, but the server is
> refusing connections.
>
> There seem to be tools for managing remote mysql, but not postgresql.
>
> There is not a web component here; just my stacks needing to create &
> manipulate databases.
>
> When attempting to connect from livecode to create a database, with the line
>
> put revOpenDatabase("postgresql", "dochawkbk.on-rev.com" ,dbName
> ,aty_sqlAct,aty_sqlPswd ) into dbno
>
> the response is
> could not connect to server: Connection refused
> Is the server running on host "dochawkbk.on-rev.com" and accepting
> TCP/IP connections on port 5432?
>
> Similarly, from telnet
> sharpshin:hawk>telnet dochawkbk.on-rev.com 5432
> Trying 74.54.153.71...
> telnet: connect to address 74.54.153.71: Connection refused
> telnet: Unable to connect to remote host
>
>
> --
> The Hawkins Law Firm
> Richard E. Hawkins, Esq.
> (702) 508-8462
> hawkinslawf...@gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV 89109
>
> _______________________________________________
> 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
--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com
_______________________________________________
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
