Hello all,
I am not having much success with connecting to my postgresql server.
Details about my setup are:
OS: Linux OpenSUSE 12.1 up to date: (uname -a)
Linux cm1 3.1.10-1.9-desktop #1 SMP PREEMPT Thu Apr 5 18:48:38 UTC
2012 (4a97ec8) x86_64 x86_64 x86_64 GNU/Linux
Python Version: Python 2.7.2 (default, Aug 19 2011, 20:41:43) [GCC]
on linux2
psycopg2 version: 2.4.5 (newest I think)
postgresql version: PostgreSQL 9.1.3 on x86_64-suse-linux-gnu,
compiled by gcc (SUSE Linux) 4.6.2, 64-bit
mysql: Server version: 5.5.16-log Source distribution
These sql servers are on localhost and require passwords
The tail of my pg_hba.conf file looks like this:
# "local" is for Unix domain socket connections only
# commented out 20120428 wch
#local all all
peer
local all all
password
# IPv4 local connections:
host all all 127.0.0.1/32
ident
# IPv6 local connections:
host all all ::1/128
ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local replication postgres
peer
#host replication postgres 127.0.0.1/32
ident
#host replication postgres ::1/128
ident
The results of my tests are:
I can:
1) invoke psql and connect to the postgresql server and act
2) invoke python/psycopg2 and connect to the postgres server and
act (to a degree)
3) invoke mysql-workbench and connect to the mysql server and act
4) invoke mysql(client) and connect to the mysql server and act
5) invoke CxnEditor and specify a mysql connection and it tests
successful
6) invoke dShell and connect to the mysql server and act
(browse() example works).
I can not:
1) invoke CxnEditor and specify a postgresql connection and it
test successful
2) invoke dShell and connect to the postgresql server withhout error
3) therefore browse example cannot work
Will someone tell me what I have done wrong?
(Also, what is the source of the zip code file. It looks more
comprehensive than those I have found.)
Thanks in advance,
Bill House
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
