on-rev remote database

[Pierre Sahores]

Ien,

If you just need to have a LiveCode client able to speak with the on-rev PostgreSQL backend from anyware all over the world, why don't you choose to send HTTP Posts from your client to an irev script witch will interact in localhost mode with the PostgreSQL backend in full read/write before sending back the pg response to the client ? I do this all the time and it works perfect without any security lacks.

In tunning the pg config, anyone can make PostgreSQL available in full cloud access mode but it's, at least, not a safe way to go...

HTH,

Pierre

Le 18 oct. 2010 à 04:58, Len Morgan a écrit :

> Pierre,
> 
> I'm trying to write a program that will access data on a public database (Postgresql) and I don't really want to give pgAdmin to all of my users.  That would be disaster!  The localhost only access has never been the case.  I've been using Postgres for more than 15 years now and I always have users access a common database (although it's always been from a private network).
> 
> pgAdmin remote access is not my problem.  It's access to the data from the outside.  I can always use cPanel if I need to maintain the database but I've got to have remote access for end users (who could be anywhere in the world).
> 
> len
> 
> 
> On 10/17/2010 7:27 PM, Pierre Sahores wrote:
>> Ien,
>> 
>> You can't do this because the on-rev PostgreSQL servers security rules (following in this the best practices recommanded by the PostgreSQL team) are set to allow localhost connections only. Why don't you  simply use the on-Rev phpPgAdmin panel from your home box ? Works perfect and let us do exactly all what we could do in using PgAdmin on the 5432 unprotected port.
>> 
>> HTH,
>> 
>> Pierre
>> 
>> Le 17 oct. 2010 à 21:42, Len Morgan a écrit :
>> 
>>> Pierre,
>>> 
>>> I'm not having any trouble with the phpPgAdmin because that's running on the same server as Postgres is.  What I'm trying to do is use (for the time being) PgAdmin from my computer at home to talk to the server at on-rev.  So far, all I get is a message that there is no server listening there so I'm thinking it's some sort of firewall issue.  Has anyone been able to successfully connect to Postgres on on-rev from a remote computer?
>>> 
>>> len
>>> 
>>> 
>>> On 10/17/2010 11:52 AM, Pierre Sahores wrote:
>>>> Ien,
>>>> 
>>>> There went some troubles, full solved months ago, about login to the phpPgAdmin panel of the cPanel, on the loki server at least. All worked from that time 100% well. Both MySQL and PostgreSQL are yet full usable in the on-rev environment and some of my apps use both on a 24/7 basis (MySQL for the earliest ones, and PostgreSQL for all the other and next to come.
>>>> 
>>>> HTH,
>>>> 
>>>> Pierre
>>>> 
>>>> Le 17 oct. 2010 à 13:05, Len Morgan a écrit :
>>>> 
>>>>> I seem to remember someone having trouble connecting to a database on their on-rev account remotely a while back.  Was this ever resolved?  I'd like to have a database that can be accessed from anywhere but I'd rather not go through the hoops of making a web service to get at the data.
>>>>> 
>>>>> Was this too much of a security issue for the hosting service to allow?
>>>>> 
>>>>> len morgan
>>>>> _______________________________________________
>>>>> use-revolution mailing list
>>>>> use-revolution at lists.runrev.com
>>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>>> 
>>>> --
>>>> Pierre Sahores
>>>> mobile : (33) 6 03 95 77 70
>>>> 
>>>> www.woooooooords.com
>>>> www.sahores-conseil.com
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>> 
>>>> _______________________________________________
>>>> use-revolution mailing list
>>>> use-revolution at lists.runrev.com
>>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>>> 
>>>> 
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>> 
>> --
>> Pierre Sahores
>> mobile : (33) 6 03 95 77 70
>> 
>> www.woooooooords.com
>> www.sahores-conseil.com
>> 
>> 
>> 
>> 
>> 
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
>> 
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 

--
Pierre Sahores
mobile : (33) 6 03 95 77 70

www.woooooooords.com
www.sahores-conseil.com