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)