Bob -
bash-3.2# psql -U fossy fossology
Welcome to psql 8.1.18 (server 8.3.8), the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
WARNING: You are connected to a server with major version 8.3,
but your psql client is major version 8.1. Some backslash commands,
such as \d, might not work properly.
fossology=> update users set user_pass='',user_seed='' where user_name='fossy';
UPDATE 1
fossology=>
Reload http://<hostname>/repo/ <http://<hostname>/repo/>
Still unable to login, just returns me back to login prompt.
Thanks -- Bill
________________________________
From: Gobeille, Robert [mailto:[email protected]]
Sent: Thu 11/19/2009 12:10 PM
To: Bill Armstrong
Cc: [email protected]
Subject: Re: [FOSSology] Post Install issue: Initial Login attempt failed
You mentioned that everything in 2.2.3 of the INSTALL doc checks out. That
means you verified that you could log in to the fossology database as user
fossy (psql -d fossology -U fossy). That's good.
Guessing that something is wrong with your fossology user record, do this:
psql -U fossy fossology
update users set user_pass='',user_seed='' where user_name='fossy';
Now try to log in as fossy with no password.
Bob
On Nov 19, 2009, at 11:44 AM, Bill Armstrong wrote:
Re: postgresql running
bash-3.2# /etc/init.d/postgresql-8.3 status
pg_ctl: server is running (PID: 27537)
/opt/PostgreSQL/8.3/bin/postgres "-i" "-D" "/opt/PostgreSQL/8.3/data/"
This email and any attachments are intended for the sole use of the named
recipient(s) and contain(s) confidential information that may be proprietary,
privileged or copyrighted under applicable law. If you are not the intended
recipient, do not read, copy, or forward this email message or any attachments.
Delete this email message and any attachments immediately.
_______________________________________________
fossology mailing list
[email protected]
http://fossology.org/mailman/listinfo/fossology
