unable to connect to postgres db via psycopy

From: Dan Sawyer <dansawyer(at)earthlink(dot)net>
To: "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org>
Subject: unable to connect to postgres db via psycopy
Date: 2016-03-13 01:23:40
Message-ID: 56E4C11C.9080806@earthlink.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse psycopg by date

  From Date Subject
Next Message Christophe Pettus 2016-03-13 01:26:08 Re: unable to connect to postgres db via psycopy
Previous Message Karsten Hilbert 2016-03-10 22:03:19 Re: Encountered an error