Re: On-Rev and PostgreSQL

2009-11-17 Thread Trevor DeVore
On Nov 15, 2009, at 8:38 PM, Rick Harrison wrote: Since the people at Revolution say that PostgreSQL should work fine on their On-Rev server I think that perhaps they should be held accountable for their advertising of said capabilities. I imagine PostgreSQL works fine if you connect from

Re: On-Rev and PostgreSQL

2009-11-17 Thread Len Morgan
The file you'll need to look at (and possibly modify) is the pg_hba.conf file in the directory above where PostgreSQL stores the actual data tables. It is very well commented (you'll want to go near the bottom of the file to see the examples that come with the standard distribution). You

Re: On-Rev and PostgreSQL

2009-11-17 Thread Mark Wieder
Trevor- Tuesday, November 17, 2009, 10:11:17 AM, you wrote: I haven't tried, but if you are having trouble then I would check whether or not you authorized the user you are connecting with to connect from outside hosts. By default the database user is usually restricted to connecting from

Re: On-Rev and PostgreSQL

2009-11-17 Thread Rick Harrison
Hi Trevor, I appreciate your suggestions. I'm conducting research on the problems, and I'll get back to you with any answers I may find. Thanks again, Rick On Nov 17, 2009, at 1:11 PM, Trevor DeVore wrote: On Nov 15, 2009, at 8:38 PM, Rick Harrison wrote: Since the people at Revolution

Re: On-Rev and PostgreSQL

2009-11-17 Thread Pierre Sahores
Le 17 nov. 09 à 19:37, Mark Wieder a écrit : Good points. Postgresql in particular locks access down to localhost by default. You have to modify the .conf files in order to allow remote access. Hi Mark and all, It's not realy safe to set up a postgreSQL nor MySQL on-rev backend as a

Re: On-Rev and PostgreSQL

2009-11-17 Thread Len Morgan
I agree with you except there are cases where it IS necessary and doesn't require SSL. I have a customer that has an in house network and WAN (it covers about 60 locations around the US but all connections are by VPN back to the corporate office). I don't have the luxury of having an irev

Re: On-Rev and PostgreSQL

2009-11-17 Thread Mark Wieder
Len- Tuesday, November 17, 2009, 12:59:14 PM, you wrote: I agree with you except there are cases where it IS necessary and doesn't require SSL. I have a customer that has an in house network and WAN (it covers about 60 locations around the US but all connections are by VPN back to the

Re: On-Rev and PostgreSQL

2009-11-17 Thread Pierre Sahores
Seems reasonable. If your customer runs a Win IIS or Apache web server, a possible way would be to replace the irev stuff by a cgi but, in practice, i would never be confident about such a solution because windows is not unix/linux Best Regards, Pierre Le 17 nov. 09 à 21:59, Len

On-Rev and PostgreSQL

2009-11-15 Thread Rick Harrison
Hi there, Has anyone been able to read, and write to a PostgreSQL database located on the On-Rev server using a revlet? If you have please let me know. Thanks, Rick ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url

Re: On-Rev and PostgreSQL

2009-11-15 Thread Pierre Sahores
Hi Rick, As long as i was'nt able to set up a test db in using the phpPgAdmin cPanel's module (early days of may 2009), i didn't go further about using PostgreSQL in conjunction with on-rev and switched to MySQL instead witch works perfect (both phpMyAdmin and direct localhost irev

Re: On-Rev and PostgreSQL

2009-11-15 Thread Rick Harrison
Hi Pierre, I'm glad that MySQL is working out well for you. I'm not a fan of MySQL because the PostgreSQL license is much better. Since the people at Revolution say that PostgreSQL should work fine on their On-Rev server I think that perhaps they should be held accountable for their advertising

Re: Python with Rev and postGreSQL?

2006-07-14 Thread John Tregea
Hi Dan, I will have a look at PHP and Ruby, I have seen your comments on Ruby (in other threads) and been intrigued by the possibilities. I have used Tango and Lasso at various times with both WebStar (OS9) and Apache (OSX) with FMPro 5.5 and 6 as a db for web and intranet projects but that

Re: Python with Rev and postGreSQL?

2006-07-14 Thread John Tregea
Hi Kee, I am aware of Rev having XML capabilities, but because of a whole bunch of SQL requirements I have kept it in the back of my mind for future investigation. I will have to look at the Solaris 10 environment and see what will run on a single server with our PostgreSQL database. I am

Re: Python with Rev and postGreSQL?

2006-07-14 Thread John Tregea
Anything that avoids complication is good by me. :-D The project has been incredible to work on. I have had to map and model 1,600 data objects in releation to each other in the database and find naming conventions, permission models, role management methods etc. for the whole thing. The db

Re: Python with Rev and postGreSQL?

2006-07-14 Thread kee nethery
On Jul 13, 2006, at 11:40 PM, John Tregea wrote: Hi Kee, I am aware of Rev having XML capabilities, but because of a whole bunch of SQL requirements I have kept it in the back of my mind for future investigation. Actually, When I say use XML what I really mean is pass the data using

Python with Rev and postGreSQL?

2006-07-13 Thread John Tregea
Thanks Kee, While the database structure is complete, the front end is not, (that is why I am evaluating Rev), I believe python is a good tool to connect to the database, but not sure if it is used by any other Revolutionaries or if anyone can say what has worked well for them? I believe SOAP

Re: Python with Rev and postGreSQL?

2006-07-13 Thread Dan Shafer
John. Chipp Walters and his team have a strong preference for using PHP on the server side and have developed a powerful and stable architecture for using Rev to call PHP commands that return Web pages. I suspect he'll chime in here at some point but that is one of the most tested

Re: Python with Rev and postGreSQL?

2006-07-13 Thread kee nethery
I'd suggest a standard HTTPS connection and just pass it XML as part of a POST. Simple, easy to troubleshoot with a browser. SOAP is a complication and there is really no need for it. Your project sounds like fun. Kee On Jul 13, 2006, at 5:34 PM, John Tregea wrote: Thanks Kee, While the

Re: Rép : Rev cgi, PostgreSQL and standalones

2004-09-20 Thread Jan Schenkel
--- Pierre Sahores [EMAIL PROTECTED] wrote: Hello There, First part available (example app)... To get it, just type http://acacia93.dyndns.org/rev_web_app.zip from within your prefered Web browser. Have fun, Best, Pierre Merci beacoup, Pierre -- I've just downloaded it and will

Re: Rép : Rev cgi, PostgreSQL and standalones

2004-09-20 Thread Pierre Sahores
Hello Jan, I'm just on the way to improve the html's part production in using the FreeWayExpress wisiwig html editor (MacOS only). Golive and Dreamweaver are probably good at this point too. Let me know how this goes for you :) Best, Pierre Le 20 sept. 04, à 12:52, Jan Schenkel a écrit : ---

Re: Rev with PostgreSQL on Linux

2004-09-14 Thread Pierre Sahores
, Jr. a écrit : Has anyone been able to get Rev working with PostgreSQL databases under Linux or Solaris? I have several stacks which work (as well as they do) under OS X and Windows, but seemingly interpret the database library calls as handler exits under Linux and Solaris; am I the only one

Rép : Rev cgi, PostgreSQL and standalones

2004-09-13 Thread Pierre Sahores
Hello There, First part available (example app)... To get it, just type http://acacia93.dyndns.org/rev_web_app.zip from within your prefered Web browser. Have fun, Best, Pierre Le 10 sept. 04, à 10:30, Robert Brenstein a écrit : Hello Jan, Alejandro, Robert, JB, I couldn't upload the rev's web

Re: Rev cgi, PostgreSQL and standalones

2004-09-13 Thread Alejandro Tejada
on Mon, 13 Sep 2004 Pierre Sahores wrote: First part available (example app)... To get it, just type http://acacia93.dyndns.org/rev_web_app.zip from within your prefered Web browser. Have fun, Thanks a lot, Pierre :-)) al = Visit my site: http://www.geocities.com/capellan2000/

Re: Rev cgi, PostgreSQL and standalones

2004-09-10 Thread Pierre Sahores
Hello Jan, Alejandro, Robert, JB, I couldn't upload the rev's web app example i expected to share on my revonline account in response to your mails ;-! Is it my mistake or a bug in the Rev 2.5 build 2 issue (buildnumber 9, 2.6.1 engine) i'm currently using ? I will put some of the old posts

Re: Rev cgi, PostgreSQL and standalones

2004-09-08 Thread jbv
Pierre, This solution is very attractive. I guess it is related to the PHP code you posted to this list a few times during the past couple of years... If yes, it must still be in my archives... The problem is that AFAIR (and as Alejandro pointed out) it's been split across several successive

Re: Rev cgi, PostgreSQL and standalones

2004-09-08 Thread Pierre Sahores
Hello Alejandro, I'm a little confused about a so kindly congratulations. Thank you ;) I plan to write 80 pages about the subject in the first quarter of 2005, freely available to the MC/Rev community and, if possible, to find a fench publisher interested in printing a paper issue dedicated to

Re: Rev cgi, PostgreSQL and standalones

2004-09-07 Thread Pierre Sahores
Le 7 sept. 04, à 20:33, jbv a écrit : Hi again, I'm presently working on a website project for a client, in which all the cgi stuff will be handled by Rev on a linux RH server. A PostgreSQL database is also included and requests will be done by endusers through webpages and cgi scripts. Besides I