unable to connect to postgres db via psycopy - Mailing list psycopg

From Dan Sawyer
Subject unable to connect to postgres db via psycopy
Date
Msg-id 56E4C11C.9080806@earthlink.net
Whole thread Raw
Responses Re: unable to connect to postgres db via psycopy
List psycopg
All,

Over the last year or so I have developed several scripts to connect to
postgresql. Between last week and today they are no longer connecting.
The system has been upgraded and there may have been a change to
postgresql-server is  'postgresql-server.x86_64 9.4.6-1.fc22'.

The database starts successfully and is accessible from user dan via
psql and all commands appear to work successfully.

The postgres log configuration is not correct so there is no helpful
information there. I am trying to fix that to help debug this issue.

Below is a test script that fails:

#!/usr/bin/python3
import psycopg2
#note that we have to import the Psycopg2 extras library!
import psycopg2.extras
import sys
import pprint
import string
import unittest
from optparse import OptionParser
def main():

     conn_string = "host='localhost' dbname='opace0215' user='dan'
port=5432 password='xxx' "
     print ("Connecting to database\n    ->%s" % (conn_string))
     conn = psycopg2.connect(conn_string)
     cursori = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
     work_mem = 2048
     cursori.execute('SET work_mem TO %s', (work_mem,))
     cursori.execute('select entity_name from opace')
#    f = open("test.txt","w") #opens file with name of "test.txt"
     i = 1
     while i != 10:
         records = cursori.fetchone()
         record = records[0]
         print(record)
         i = i+1
     f.close()
     conn.commit()
if __name__ == "__main__":
     main()

Connecting to database
     ->host='localhost' dbname='opace0215' user='dan' password='s42340'
port=5432
Traceback (most recent call last):
   File "./db_open_test.py", line 35, in <module>
     main()
   File "./db_open_test.py", line 20, in main
     conn = psycopg2.connect(conn_string)
   File "/usr/lib64/python3.4/site-packages/psycopg2/__init__.py", line
164, in connect
     conn = _connect(dsn, connection_factory=connection_factory,
async=async)
psycopg2.OperationalError: FATAL:  Ident authentication failed for user
"dan"

Below are the tables in the db. They all work correctly.

psql --list
                                   List of databases
    Name    |  Owner   | Encoding |   Collate   |    Ctype    | Access
privileges
-----------+----------+----------+-------------+-------------+-----------------------
  ohlcv     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  opace     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  opace0215 | dan      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  opace0421 | dan      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  opace0714 | dan      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  opace0715 | dan      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  opace0815 | dan      | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
=c/postgres          +
            |          |          |             |             |
postgres=CTc/postgres
  template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
postgres=CTc/postgres+
            |          |          |             |             | =c/postgres
(10 rows)




psycopg by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Encountered an error
Next
From: Christophe Pettus
Date:
Subject: Re: unable to connect to postgres db via psycopy