[Netdisco] postgresql help

[premnath sunkara]

Hi,
I am new to 'netdisco' and am trying to install it
on redhat9.0. I installed postgresql and changed the
pg_hba.conf to look like this
local sameuser all md5
local template1 all ident

Now when I run sql/pg_init I get the following

--> Creating User netdisco.
Choose a password just for this new database user.
bash: /root/.bashrc: Permission denied
Enter password for user "netdisco":
Enter it again:
psql: FATAL: IDENT authentication failed for user
"netdisco"

createuser: creation of user "netdisco" failed

Creating Database netdisco. Use the Password used
above.
bash: /root/.bashrc: Permission denied
Password:
psql: FATAL: IDENT authentication failed for user
"netdisco"

createdb: database creation failed


I tried changing pg_hba.conf to the following
local sameuser all md5
local template1 all trust

I also tried local all all trust

But then I got

--> Creating User netdisco.
Choose a password just for this new database user.
bash: /root/.bashrc: Permission denied
Enter password for user "netdisco":
Enter it again:
psql: FATAL: user "netdisco" does not exist
createuser: creation of user "netdisco" failed

Creating Database netdisco. Use the Password used
above.
bash: /root/.bashrc: Permission denied
Password:
psql: FATAL: user "netdisco" does not exist
createdb: database creation failed

Please help. I have been on this problem for some days
now and couldnt solve it.

Thanks in advance,
Prem

__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you�re looking for faster
http://search.yahoo.com

[Max Baker]

Prem,

It looks like you are trying to create the database user and the database as
the Unix user Netdisco.

This gets confusing, but we're dealing with 2 different types of users, and
4 different users :

Unix Users (/etc/passwd) :
root
netdisco
postgres/pgsql

Postgres' internal users :
netdisco

Edit sql/pg_init and change SYSDBUSER=netdisco to SYSDBUSER=postgres

now su to root and run pg_init

cd /usr/local/netdisco/sql
su
./pg_init


This really should be automated one of these days... Who wants to make an
install script?? ;-)

-m

Post by premnath sunkara
Hi,
I am new to 'netdisco' and am trying to install it
on redhat9.0. I installed postgresql and changed the
pg_hba.conf to look like this
local sameuser all md5
local template1 all ident
Now when I run sql/pg_init I get the following
--> Creating User netdisco.
Choose a password just for this new database user.
bash: /root/.bashrc: Permission denied
psql: FATAL: IDENT authentication failed for user
"netdisco"
createuser: creation of user "netdisco" failed
Creating Database netdisco. Use the Password used
above.
bash: /root/.bashrc: Permission denied
psql: FATAL: IDENT authentication failed for user
"netdisco"
createdb: database creation failed
I tried changing pg_hba.conf to the following
local sameuser all md5
local template1 all trust
I also tried local all all trust
But then I got
--> Creating User netdisco.
Choose a password just for this new database user.
bash: /root/.bashrc: Permission denied
psql: FATAL: user "netdisco" does not exist
createuser: creation of user "netdisco" failed
Creating Database netdisco. Use the Password used
above.
bash: /root/.bashrc: Permission denied
psql: FATAL: user "netdisco" does not exist
createdb: database creation failed
Please help. I have been on this problem for some days
now and couldnt solve it.
Thanks in advance,
Prem