on-rev remote database

Pierre Sahores psahores at free.fr
Sun Oct 17 20:27:26 EDT 2010


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









More information about the Use-livecode mailing list