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@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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
