-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Adam,
Here are the steps to change the password. I'll use 'mynewpassword' as the new password, and '12345678' as a new salt (you could use the existing one from the localauth table, but picking a new one decreases the number of steps to explain). In a shell, run: echo -n 'mynewpassword12345678' | sha1sum Make note of the output. I'll refer to the output as 'newpasshash'. Get the id for the user: SELECT id FROM user WHERE unityid = 'desired_unityid_here'; Make note of the id. I'll refer to it as 'theuserid'. Update the localauth table: UPDATE localauth SET salt = '12345678', passhash = 'newpasshash', lastupdated = NOW() WHERE userid = theuserid Josh On 09/10/12 15:29, Hechler, Adam wrote: > There doesn't seem to be corresponding (related) fields in the user > table and the localauth table. How do I know which password to > change? > > Adam > >> -----Original Message----- From: Hechler, Adam >> [mailto:[email protected]] Sent: Monday, September 10, 2012 3:23 PM >> To: [email protected] Subject: RE: Change local user email >> address, delete local users >> >> Thanks Josh, >> >> I don't have to know how to decipher salted and hashed passwords, >> do I? >> >> Adam >> >> >>> -----Original Message----- From: Josh Thompson >>> [mailto:[email protected]] Sent: Monday, September 10, >>> 2012 3:16 PM To: [email protected] Subject: Re: Change local >>> user email address, delete local users >>> > This page explains how to manually add local accounts (scroll to > "Adding extra local accounts"): > > https://cwiki.apache.org/confluence/display/VCL/Web+Code+Installation > > You can use that information to figure out how to change the > password of a local user manually in the database. > > Josh > > On 09/10/12 08:49, Aaron Peeler wrote: >>>>> Hi Adam, It probably is. Sorry. >>>>> >>>>> Others might have a way to change it in 2.2.1. >>>>> >>>>> Aaron >>>>> >>>>> On Fri, Sep 7, 2012 at 4:15 PM, Hechler, Adam >>>>> <[email protected]> wrote: >>>>>> Thanks Aaron, >>>>>> >>>>>> Just curious - is this a 2.3 option? We're running 2.2.1 >>>>>> >>>>>> For some reason, when I go to VCL Base Module, the only >>>>>> option we have after that is 1. Add Local VCL User >>>>>> Account >>>>>> >>>>>> No option to Set password. >>>>>> >>>>>> Adam >>>>>> >>>>>>> -----Original Message----- From: Aaron Peeler >>>>>>> [mailto:[email protected]] Sent: Friday, September >>>>>>> 07, 2012 11:56 AM To: [email protected] Subject: Re: >>>>>>> Change local user email address, delete local users >>>>>>> >>>>>>> Adam, >>>>>>> >>>>>>> This can be done on the management node using the >>>>>>> ./vcld --setup option >>>>>>> >>>>>>> /usr/local/vcl/bin/vcld --setup Select 1 VCL Base >>>>>>> Module Select 2 Set Local VCL User Account Password >>>>>>> Then select user >>>>>>> >>>>>>> Aaron >>>>>>> >>>>>>> >>>>>>> On Fri, Sep 7, 2012 at 8:22 AM, Hechler, Adam >>>>>>> <[email protected]> wrote: >>>>>>>> Thanks Josh, >>>>>>>> >>>>>>>> Also, is there some way for an administrator to reset >>>>>>>> a local user's >>>>>>> password? >>>>>>>> >>>>>>>> Adam >>>>>>>> >>>>>>>>> -----Original Message----- From: Josh Thompson >>>>>>>>> [mailto:[email protected]] Sent: Friday, >>>>>>>>> September 07, 2012 8:13 AM To: [email protected] >>>>>>>>> Subject: Re: Change local user email address, >>>>>>>>> delete local users >>>>>>>>> >>>>> Adam, >>>>> >>>>> You are not missing anything. You'll have to change the >>>>> email address in >>>>>>>> the >>>>> database directly. >>>>> >>>>> Deleting accounts is not recommended due to log history >>>>> unless the >>>>>>>> account >>>>> was never used to make reservations. If that's the case, >>>>> you can manually >>>>>>>> delete >>>>> it from the localauth table and the user table. You can >>>>> disable a local account by setting the localauth.passhash >>>>> field to garbage in the >>>>>>>> database. >>>>> >>>>> Josh >>>>> >>>>> On Thu September 6 2012 5:55:30 PM Hechler, Adam wrote: >>>>>>>>>>> Hello, >>>>>>>>>>> >>>>>>>>>>> I must be missing something, but is there a way >>>>>>>>>>> to change the email >>>>> address >>>>>>>>>>> of a local user in VCL? And how would I delete >>>>>>>>>>> local accounts? >>>>>>>>>>> >>>>>>>>>>> Thanks, Adam >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> - - - - - - - - - - - - - - - - - - - - - - - - >>>>>>>>>>> - - - - - - - - Adam Hechler Senior Analyst /PC >>>>>>>>>>> Systems Administrator Rensselaer Polytechnic >>>>>>>>>>> Institute 275 Windsor Street Hartford, CT 06120 >>>>>>>>>>> USA Ph: 860-548-2446 Email: >>>>>>>>>>> [email protected]<mailto:[email protected]> Web: >>>>>>>>>>> http://www.ewp.rpi.edu<http://www.ewp.rpi.edu/> >>>>>>>>>>> >>>>>>>>>>> [Description: >>>>>>>>>>> fb]<http://www.facebook.com/pages/Rensselaer-Hartford- >>>>> >>>>>>>>>>> Campus/21653289505385 >>>>>>>>>>> 8> [Description: tw] >>>>>>>>>>> <https://twitter.com/#!/RPI_Hartford> >>>>>>>> [Description: >>>>>>>>>>> yt] <http://www.youtube.com/user/RPIHartford> >>>>>>>>>>> [Description: blog] >>>>>>>>>>> <http://rpihartford.blogspot.com/> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- Aaron Peeler Program Manager Virtual Computing Lab >>>>>>> NC State University >>>>>>> >>>>>>> All electronic mail messages in connection with State >>>>>>> business which are sent to or received by this account >>>>>>> are subject to the NC Public Records Law and may be >>>>>>> disclosed to third parties. >>>>> >>>>> >>>>> > - -- - ------------------------------- Josh Thompson VCL Developer North Carolina State University my GPG/PGP key can be found at pgp.mit.edu All electronic mail messages in connection with State business which are sent to or received by this account are subject to the NC Public Records Law and may be disclosed to third parties. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux) iEYEARECAAYFAlBPOacACgkQV/LQcNdtPQP0LwCfeC5yphorzJIkZ0q4AxVtZ6Ro on8Ani1JCvcBKX7qtTr9WdBzopEfdNni =X7Zm -----END PGP SIGNATURE-----
