ok, this is what i did to follow Mariano's suggestions:

as root:
> service iptables stop  // should allow or accept all interfaces and ports
> cp /usr/pgsql-9.1/share/pg_hba.conf.sample /usr/pgsql-9.1/share/pg_hba.conf

which the previous has the lines in it
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
hostssl    all             all             127.0.0.1/32            md5

which i restarted postgresql with
> service postgresql-9.1 restart
which worked with confirmation
> service postgresql-9.1 status
 (pid  18674) is running...

then into as lucas:
> python
Python 2.6.5 (r265:79063, Jun 25 2011, 08:36:25)
[GCC 4.4.4 20100726 (Red Hat 4.4.4-13)] on linux2
>>>import psycopg2
>>> psycopg2.connect(database="prac2", user="lucas", 
>>> password="passwdnotposted", host="localhost")
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
psycopg2.OperationalError: FATAL:  Ident authentication failed for
user "lucas"

i did the above python stuff after making sure that postgresql had the
user added and proper password under template1 using psql, the
database created, and that user had all granted privileges to the
database.

i can't think of anything else.  suggestions, please?  lucas

Reply via email to