[OPEN-ILS-GENERAL] ***SPAM*** RE: ***SPAM*** Urgent help required please

[Dan Wells]

Hello Muhammad,

You could also try specifying the host in that command, i.e.:

psql -U evergreen -h localhost evergreen

at the shell prompt. This will essentially trigger a port connection rather
than a local socket connection (on default Ubuntu configs, at least) and
thereby prompt for a password rather than an 'ident' authentication.

Dan

>>> Muhammad Faiz Chishti 08/15/11 12:37 PM >>> 
Can u kindly specify where should I give the command in which login bcz if I 
use root it gives error I am using Ubuntu 10.04 lucid 

$psql -U evergreen evergreen 

-----Original Message----- 
From: Anoop Atre [mailto:anoop.atre at mnsu.edu] 
Sent: Monday, August 15, 2011 9:16 PM 
To: Evergreen Discussion Group 
Cc: Muhammad Faiz Chishti 
Subject: Re: [OPEN-ILS-GENERAL] ***SPAM*** RE: ***SPAM*** Urgent help 
required please 

You can reset the password using SQL update. In the example below we are 
assuming that the Evergreen system username/database is called evergreen and 
the account you are resetting is admin, the updated password is open-ils. 

$psql -U evergreen evergreen 
# update actor.usr set passwd = 'open-ils' where usrname = 'admin'; 
# \q 

-- 

On 08/15/2011 11:04 AM, Muhammad Faiz Chishti wrote: 
> Can any one tell how to change password for admin user for a running 
> server when it is forgotten 
> 
> -----Original Message----- 
> From: open-ils-general-bounces at list.georgialibraries.org 
> [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf 
> Of Jason Etheridge 
> Sent: Monday, August 15, 2011 8:42 PM 
> To: Evergreen Discussion Group 
> Subject: Re: [OPEN-ILS-GENERAL] ***SPAM*** RE: ***SPAM*** Urgent help 
> required please 
> 
>> Well, eg_db_config.pl doesn't actually update the qstore stanza, 
>> largely because qstore isn't used in Evergreen yet. So this part, at 
>> least, is a bit of a red herring. 
> 
> Ah, I even forgot that eg_db_config.pl can update those config files. 
> :) 
> 
> -- 
> Jason Etheridge 
> | Equinox Software, Inc. / Your Library's Guide to Open Source 
> | phone: 1-877-OPEN-ILS (673-6457) 
> | email: jason at esilibrary.com 
> | web: http://www.esilibrary.com 
> 


-- 

Anoop Atre 
IS Developer & Integrator, MnPALS 
PH: 507.389.5060 
OF: 3022 Memorial Library (Office-ML 3022) 
-- 
"Mit der Dummheit kämpfen Götter selbst vergebens" 
~ Johann Christoph Friedrich von Schiller