unable to connect to postgres db via psycopy

Поиск
Список
Период
Сортировка
От Dan Sawyer
Тема unable to connect to postgres db via psycopy
Дата
Msg-id 56E4C11C.9080806@earthlink.net
обсуждение исходный текст
Ответы Re: unable to connect to postgres db via psycopy  (Christophe Pettus <xof@thebuild.com>)
Список 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 по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: Encountered an error
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: unable to connect to postgres db via psycopy