User authentication failed !

Started by Ralf Weidemannabout 27 years ago2 messagesgeneral
Jump to latest
#1Ralf Weidemann
RalfW@Scalar.DE

Hi,

can someone please tell me what's wrong here ??

Thanks,
Ralf

[wdba@onyx pgdata]$ cat pg_hba.conf
local all trust
host all 192.168.0.0 255.255.255.255 password passwd

[wdba@onyx pgdata]$ ping onyx
PING onyx.nowhere.net (192.168.1.1): 56 data bytes
64 bytes from 192.168.1.1: icmp_seq=0 ttl=255 time=0.2 ms
 --- onyx.nowhere.net ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max = 0.2/0.2/0.2 ms

[wdba@onyx pgdata]$ pg_passwd passwd
File "passwd" does not exist. Create? (y/n): y
Username: wdba
New password:
Re-enter new password:

[wdba@onyx pgdata]$ /opt/wdb/bin/postmaster -i -D /opt/wdb/var/pgdata > /opt/wdb/var/logs/postmaster.log 2>&1 &
[1]: 1417

[wdba@onyx pgdata]$ psql -h onyx -u
Username: wdba
Password:

Connection to database 'wdba' failed.
User authentication failed

[wdba@onyx pgdata]$ psql
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: wdba

wdba=> \q

[wdba@onyx pgdata]$

#2Ralf Weidemann
Finc01@DX1.HRZ.Uni-Dortmund.DE
In reply to: Ralf Weidemann (#1)
user authentication & database destroy failed !

Hi,

I'm running a fresh build of pgsql 6.4.2 on LinuxPPC
R4 (kernel 2.2pre4). Building went fine and I con-
figured pgsql with:

./configure --prefix=/opt/wdb --enable-hba
--enable-locale --with-tcl --with-perl --with-x

But after some playing I discovered that I can't de-
stroy any databases.

----
[wdba@onyx wdba]$ createdb test3
[wdba@onyx wdba]$ destroydb test3
ERROR: typeidTypeRelid: Invalid type - oid = 0
ERROR: typeidTypeRelid: Invalid type - oid = 0
destroydb: database destroy failed on test3.
----

Also user authentication failed. I'm not sure, maybe
I did something wrong here ?

----
[wdba@onyx pgdata]$ cat pg_hba.conf
local all trust
host all 192.168.0.0 255.255.255.255 password passwd

[wdba@onyx pgdata]$ ping onyx
PING onyx.nowhere.net (192.168.1.1): 56 data bytes
64 bytes from 192.168.1.1: icmp_seq=0 ttl=255 time=0.2 ms
 --- onyx.nowhere.net ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max = 0.2/0.2/0.2 ms

[wdba@onyx pgdata]$ pg_passwd passwd
File "passwd" does not exist. Create? (y/n): y
Username: wdba
New password:
Re-enter new password:

[wdba@onyx pgdata]$ /opt/wdb/bin/postmaster -i -D
/opt/wdb/var/pgdata > /opt/wdb/var/logs/postmaster.log 2>&1 &
[1]: 1417

[wdba@onyx pgdata]$ psql -h onyx -u
Username: wdba
Password:

Connection to database 'wdba' failed.
User authentication failed

[wdba@onyx pgdata]$ psql
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: wdba

wdba=> \q
[wdba@onyx pgdata]$
----

[Sorry if this already arrived the list, but since I didn't
get it myself in the last 24h, I think something went wrong..]

Thanks,
Ralf