On Mar 17, 2006, at 10:12 PM, Wade Little wrote:
I could you a little help with using the database plugin and postgre
configuration.......
I am trying to do a very basic connection to verify it is
working....Here is the RB code to test the connection:
Dim db as PostgreSQLDatabase
db=New PostgreSQLDatabase
db.host="10.0.1.3"
db.port=5432
db.databaseName="maindb" <<<<verified correct in postgre
db.userName="postgres" <<<<verified correct in postgre
db.Password="postgres" <<<<verified correct in postgre
If db.Connect then
MsgBox "Connection passed!"
else
MsgBox "Connection failed! " + db.ErrorMessage
end if
I get the Connection failed message with the error being socket timed
out. So I assume the problem must be with my Postgre configuration
and they way RB needs it to be.
Here is what I have my pg_hba.conf file looks like:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all password
# IPv4 local connections:
host all all 127.0.0.1/32 password
# IPv6 local connections:
host all all ::1/128 password
The other setting I have done is to this postgresql.conf as I
uncommented the following 2 lines:
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of
addresses;
# defaults to 'localhost', '*'
= all
port = 5432
So can anyone assist me to get this working and point me into what I
am doing wrong....
Thanks!
Wade
Is 10.0.1.3 your local machine ?
If so try using 127.0.0.1 and see if that works
I have this
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
and it works if I use 127.0.0.1
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
