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
