is anyone using postgresql hosting from on-rev?

[Pierre Sahores]

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
> HawkinsLawFirm at gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> 
> _______________________________________________
> 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

--
Pierre Sahores
mobile : 06 03 95 77 70
www.sahores-conseil.com