Re: On-Rev and PostgreSQL
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 localhost. Does the database work if you connect with an .irev page running on the server? Usually a database won't allow a user to connect from a remote server without you explicitly telling the database to allow them to do so. So the question still remains: Has anyone out there been able read and write to a PostgreSQL database on an On-Rev server using a revlet? 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 localhost only (at least with MySQL). -- Trevor DeVore Blue Mango Learning Systems ScreenSteps: http://www.screensteps.com Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.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
Re: On-Rev and PostgreSQL
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 are allowed to control access to individual databases by not only username/password but also by IP/domain name, whether it is on a secure connection etc. I'm not sure if the PostgreSQL admin program let's you do that or not. I've been using PostgreSQL since version 1.09 (about 12 years) and so have grown up modifying the files with a text editor. On a similar point though, how would you even get the revdb.dll into the revLet so that it could access ANY database? Since revLets are supposed to be platform neutral, how would it know which dll/bundle/so to load in the browser? Has anyone managed to access ANY database from a revLet? If so, could you provide a short script showing how? I'd really like to use SQL Yoga in a revLet but I haven't figured out this (very basic) little detail. len Trevor DeVore wrote: 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 localhost. Does the database work if you connect with an .irev page running on the server? Usually a database won't allow a user to connect from a remote server without you explicitly telling the database to allow them to do so. So the question still remains: Has anyone out there been able read and write to a PostgreSQL database on an On-Rev server using a revlet? 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 localhost only (at least with MySQL). ___ 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
Re: On-Rev and PostgreSQL
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 localhost only (at least with MySQL). 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. -- -Mark Wieder mwie...@ahsoftware.net ___ 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
Re: On-Rev and PostgreSQL
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 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 localhost. Does the database work if you connect with an .irev page running on the server? Usually a database won't allow a user to connect from a remote server without you explicitly telling the database to allow them to do so. So the question still remains: Has anyone out there been able read and write to a PostgreSQL database on an On-Rev server using a revlet? 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 localhost only (at least with MySQL). -- Trevor DeVore ___ 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
Re: On-Rev and PostgreSQL
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 remote bindable rdbms as long as direct communication with those db from the outside world without using an SSL, SHTTP or SSL tunnel will be unsecure. If we need to bind those backends without opening security holes in our processes (login/password transfert over the web, even as MD5 hashes can be dangerous), the best to do is to have the revlet sending its requests to an irev script witch will query the rdbms in localhost mode and send back the result to the revlet. As long as i did'nt set any revlet-irev communication process for yet, i can't realy be realy helpfull about this part of the recommandation but if anyone need some irev-MySQL way to go, i can send some samples. Best, Pierre -- -Mark Wieder mwie...@ahsoftware.net ___ 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.wrds.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
Re: On-Rev and PostgreSQL
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 server on their web server for my revlet to talk to (in their case it's an MS SQL database accessed using ODBC). I need to have the revlet communicate with the DB directly and as I mentioned in my last email, I haven't figured out how to include the necessary .dll to do that from a revlet. len Pierre Sahores wrote: It's not realy safe to set up a postgreSQL nor MySQL on-rev backend as a remote bindable rdbms as long as direct communication with those db from the outside world without using an SSL, SHTTP or SSL tunnel will be unsecure. If we need to bind those backends without opening security holes in our processes (login/password transfert over the web, even as MD5 hashes can be dangerous), the best to do is to have the revlet sending its requests to an irev script witch will query the rdbms in localhost mode and send back the result to the revlet. As long as i did'nt set any revlet-irev communication process for yet, i can't realy be realy helpfull about this part of the recommandation but if anyone need some irev-MySQL way to go, i can send some samples. ___ 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
Re: On-Rev and PostgreSQL
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 corporate office). I don't have the luxury of having an irev server on their web server for my revlet to talk to (in their case it's an MS SQL database accessed using ODBC). I need to have the revlet communicate with the DB directly and as I mentioned in my last email, I haven't figured out how to include the necessary .dll to do that from a revlet. I haven't tried this from a revlet, but I can get to the postgresql database on my in-house jira installation with md5 encryption over the LAN from rev with no problems using revOpenDatabase (postgresql, tServerPort, kDatabase, kUser, kPassword) -- -Mark Wieder mwie...@ahsoftware.net ___ 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
Re: On-Rev and PostgreSQL
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 Morgan a écrit : 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 server on their web server for my revlet to talk to (in their case it's an MS SQL database accessed using ODBC). I need to have the revlet communicate with the DB directly and as I mentioned in my last email, I haven't figured out how to include the necessary .dll to do that from a revlet. len Pierre Sahores wrote: It's not realy safe to set up a postgreSQL nor MySQL on-rev backend as a remote bindable rdbms as long as direct communication with those db from the outside world without using an SSL, SHTTP or SSL tunnel will be unsecure. If we need to bind those backends without opening security holes in our processes (login/password transfert over the web, even as MD5 hashes can be dangerous), the best to do is to have the revlet sending its requests to an irev script witch will query the rdbms in localhost mode and send back the result to the revlet. As long as i did'nt set any revlet-irev communication process for yet, i can't realy be realy helpfull about this part of the recommandation but if anyone need some irev-MySQL way to go, i can send some samples. ___ 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.wrds.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
Re: On-Rev and PostgreSQL
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 request and queries - revlets untested) about what i need from my irev apps. Best, Pierre Le 15 nov. 09 à 17:05, Rick Harrison a écrit : 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 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.wrds.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
Re: On-Rev and PostgreSQL
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 of said capabilities. So the question still remains: Has anyone out there been able read and write to a PostgreSQL database on an On-Rev server using a revlet? Thank you for your reply Pierre! Rick On Nov 15, 2009, at 11:33 AM, Pierre Sahores wrote: 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 request and queries - revlets untested) about what i need from my irev apps. Best, Pierre ___ 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
Re: Rép : Rev cgi, PostgreSQL and standalones
--- 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 poke around in it as soon as I find the time. Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Rép : Rev cgi, PostgreSQL and standalones
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 : --- 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 poke around in it as soon as I find the time. Jan Schenkel. = As we grow older, we grow both wiser and more foolish at the same time. (La Rochefoucauld) __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution -- Bien cordialement, Pierre Sahores 100, rue de Paris F - 77140 Nemours [EMAIL PROTECTED] GSM: +33 6 03 95 77 70 Pro: +33 1 64 45 05 33 Fax: +33 1 64 45 05 33 WEB/EAI services ACID DB over IP Mutualiser les deltas de productivité ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution