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

[Muhammad Faiz Chishti]

Dear Dan and Anoope 

Thnx a lot for your most kind support the following commands worked like a
charm and I got my server back GOD Bless you

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

Kind Regards 
Faiz

-----Original Message-----
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Dan
Wells
Sent: Tuesday, August 16, 2011 5:17 AM
To: open-ils-general at list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] ***SPAM*** RE: ***SPAM*** Urgent help
required please

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