Thread: psql: FATAL: Ident authentication failed for user "jira"
Hello all !
I try to start JIRA with PostgreSQL 8.2.5 and have an error - psql: FATAL: Ident authentication failed for user "jira" when i check JIRA log files. Then i try command psql -U jira -d jiradb -h localhost and i got the same error !
Pleasee see my pg_hba.conf
# "local" is for Unix domain socket connections only
local all all password
# IPv4 local connections:
host all all 0.0.0.0/0 trust
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
Please help me with my novice problem!
Thanks in advance !
I try to start JIRA with PostgreSQL 8.2.5 and have an error - psql: FATAL: Ident authentication failed for user "jira" when i check JIRA log files. Then i try command psql -U jira -d jiradb -h localhost and i got the same error !
Pleasee see my pg_hba.conf
# "local" is for Unix domain socket connections only
local all all password
# IPv4 local connections:
host all all 0.0.0.0/0 trust
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
Please help me with my novice problem!
Thanks in advance !
"=?KOI8-R?B?59LJx8/Sycog7snLz87P0s/X?=" <grigory.nikonorov@gmail.com> writes: > I try to start JIRA with PostgreSQL 8.2.5 and have an error - psql: FATAL: > Ident authentication failed for user "jira" when i check JIRA log files. > Then i try command psql -U jira -d jiradb -h localhost and i got the same > error ! > Pleasee see my pg_hba.conf > # "local" is for Unix domain socket connections only > local all all password > # IPv4 local connections: > host all all 0.0.0.0/0 trust > host all all 127.0.0.1/32 trust > # IPv6 local connections: > host all all ::1/128 trust Well, that error message is entirely impossible given that pg_hba.conf, because you don't have ident auth selected anywhere. So I conclude that either (1) you're looking at the wrong pg_hba.conf file, or (2) you changed the file but forgot to SIGHUP the postmaster (pg_ctl reload) afterwards. BTW, your pg_hba.conf seems a bit silly --- why try to enforce passwords on Unix-socket connections when the door is wide open on local TCP connections? Also, do you realize that "0.0.0.0/0 trust" is in fact allowing trust access to the entire IPv4 Internet? regards, tom lane
Hello Tom!
Thanks for the answer. I solve my problem already. My mistake is a wrong permissions in Unix system. Someone change owner from postgres to jira. Now all work fine.
Grigory
Thanks for the answer. I solve my problem already. My mistake is a wrong permissions in Unix system. Someone change owner from postgres to jira. Now all work fine.
Grigory
2007/11/27, Tom Lane <tgl@sss.pgh.pa.us>:
"Григорий Никоноров" <grigory.nikonorov@gmail.com> writes:
> I try to start JIRA with PostgreSQL 8.2.5 and have an error - psql: FATAL:
> Ident authentication failed for user "jira" when i check JIRA log files.
> Then i try command psql -U jira -d jiradb -h localhost and i got the same
> error !
> Pleasee see my pg_hba.conf
> # "local" is for Unix domain socket connections only
> local all all password
> # IPv4 local connections:
> host all all 0.0.0.0/0 trust
> host all all 127.0.0.1/32 trust
> # IPv6 local connections:
> host all all ::1/128 trust
Well, that error message is entirely impossible given that pg_hba.conf,
because you don't have ident auth selected anywhere. So I conclude that
either (1) you're looking at the wrong pg_hba.conf file, or (2) you
changed the file but forgot to SIGHUP the postmaster (pg_ctl reload)
afterwards.
BTW, your pg_hba.conf seems a bit silly --- why try to enforce passwords
on Unix-socket connections when the door is wide open on local TCP
connections? Also, do you realize that "0.0.0.0/0 trust" is in fact
allowing trust access to the entire IPv4 Internet?
regards, tom lane
I want to execute a query such as: select abstime(1196474400) - abstime(1167616800); but specify the result in total minutes, total days (rounding off hours, minutes seconds). I'm sure this is easy but I couldn't find it. What is the proper way to do this in PostgreSQL?