Re: authentication failure - Mailing list pgsql-general
From | Adrian Klaver |
---|---|
Subject | Re: authentication failure |
Date | |
Msg-id | 2496e0fb-bb23-ae29-b0d8-1b96456de56d@aklaver.com Whole thread Raw |
In response to | authentication failure (armand pirvu <armand.pirvu@gmail.com>) |
List | pgsql-general |
On 04/12/2018 06:51 AM, armand pirvu wrote: > Hi there > > I have a process in place which runs several queries from one host to another one > > > All of a sudden I started noticing authentication failures > > Like below > > .009 ms statement: COPY NACDS.tf_show_code_response_person FROM STDIN with csv;",,,,,,,,,"psql" > 2018-04-12 00:10:48.765 CDT,"csidba","birstdb",7553,"172.16.20.4:40330",5aceea2e.1d81,1,"UPDATE",2018-04-12 00:10:06 CDT,24/0,0,LOG,00000,"duration:425 > 90.993 ms statement: UPDATE > csischema.tf_transaction_person > SET > is_deleted = 'TRUE', > birst_is_deleted = 'TRUE', > update_datetime = now()::timestamp(0) > WHERE > show_id = '984BIOWC18' AND > birst_is_deleted = 'FALSE' AND > person_transaction_id IN ( > SELECT a.person_transaction_id > FROM csischema.tf_transaction_person a > LEFT JOIN BIOWC.tf_transaction_person b > ON a.person_transaction_id=b.person_transaction_id > WHERE a.show_id = '984BIOWC18' AND b.person_transaction_id IS NULL > ) > ;",,,,,,,,,"psql" > 2018-04-12 00:10:48.823 CDT,"csidba","birstdb",7755,"172.16.20.4:40455",5aceea58.1e4b,1,"authentication",2018-04-12 00:10:48CDT,3/20320168,0,FATAL,28P0 > 1,"password authentication failed for user ""csidba""","Connection matched pg_hba.conf line 84: ""host all all 0.0.0.0/0md5""",,,,,,,,"" > 2018-04-12 00:10:48.841 CDT,"csidba","birstdb",7756,"172.16.20.4:40456",5aceea58.1e4c,1,"authentication",2018-04-12 00:10:48CDT,3/20320169,0,FATAL,28P0 > 1,"password authentication failed for user ""csidba""","Connection matched pg_hba.conf line 84: ""host all all 0.0.0.0/0md5""",,,,,,,,"" > 2018-04-12 00:10:48.957 CDT,"csidba","birstdb",7759,"172.16.20.4:40459",5aceea58.1e4f,1,"authentication",2018-04-12 00:10:48CDT,3/20320172,0,FATAL,28P0 > > > pg_hba.conf > > # "local" is for Unix domain socket connections only > #local all all peer > local all all md5 > # IPv4 local connections: > #host all all 127.0.0.1/32 ident > host all all 0.0.0.0/0 md5 > # IPv6 local connections: > host all all ::1/128 ident > # Allow replication connections from localhost, by a user with the > # replication privilege. > #local replication postgres peer > #host replication postgres 127.0.0.1/32 ident > #host replication postgres ::1/128 ident > local replication csidba md5 > host replication csidba 127.0.0.1/32 md5 > host replication csidba 0.0.0.0/0 md5 > local replication repuser md5 > host replication repuser 127.0.0.1/32 md5 > host replication repuser 0.0.0.0/0 md5 > local all repuser md5 > host all repuser 127.0.0.1/32 md5 > host all repuser 0.0.0.0/0 md5 > > > > Did I run in somthing similar to a racong condition ? > > > Any ideas ? Is the process using the correct password? > > > > Many thanks > > — Armand > > > > > -- Adrian Klaver adrian.klaver@aklaver.com
pgsql-general by date: