Hi Joe, Thank you for the reply. Can I ask you one more questions, sorry but this issue has been bugging for a while.
Still unable to resolve this database restoration issue. Is there a way to rest the DB password.Tried through DB tab in server settings but failed giving sql error. also when tried to restore the Database from one server to other server got a sql error ARERR 552 ( Login failure). Here's the post. --------------------------------------------------------------------------------------------------------------------------------------------- Where to make changes for DOMAIN change ? http://groups.google.com/group/arslist/browse_thread/thread/99e11928969eb6eb/25e4d7c1cea6fd04?hl=en&lnk=gst&q=domain+change#25e4d7c1cea6fd04 Please advise, Thanks, Raj On Oct 26, 10:52 am, Joe DeSouza <joe_rem...@yahoo.com> wrote: > You could also do this at DB level by resetting the password in the > view user_x and the cache table user_cache. > > update user_x set password = null where login_name = 'Demo'; > update user_cache set password = null where username = 'Demo'; > commit; > > user_x is a view of the User table as you see in your User tool, and > user_cache is the user cache table, where the system actually reads the > password from while authenticating. Having reset the password value in both > these tables, you would be good to go.. > > Make sure that you do not have multiple entries for Demo in the user_cache > table.. It had happened on one of my customers system, we have no idea what > caused that.. that did give us authentication problems too - only that it > would authenticate Demo with either of the two passwords on both those > records.. If you see multiple records in the user_cache table for the > username Demo, delete all except one of those records.. Be cautious of not > deleting records belonging to other users or you will cause other problems.. > > Joe > > ________________________________ > From: Howard Richter <hbr4...@gmail.com> > To: arsl...@arslist.org > Sent: Mon, October 26, 2009 11:31:23 AM > Subject: Re: Password for Demo Account ? Reset. > > ** > There use to be a startup string that would reset the Demo account. That is > something toggle you could put at that start of the arserver. Its been a long > time and in my old age I have forgotten it. > > Maybe some one has that string. > > Howard > > On Mon, Oct 26, 2009 at 11:19 AM, Raj <ravi6...@gmail.com> wrote: > > Hello All, > > > > > > >By default I know there is no password for Demo, since lot of people > >in our team has started logging in using Demo. > > >I tried changing it by going into user form. Now, unable to login > >through Demo / and the new password created in the user form. > > >Is there a way to reset the password for Demo.Tried logging in through > >other accounts AppAdmin , etc but can't view user form through those > >accounts . > > >Please advise, > > >Raj > > >_______________________________________________________________________________ > >UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > >Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > Howard Richter > Red Hat Certified Technician > CompTIA Linux+ Certified > ITIL Foundation Certified > E-Mail = hbr4...@gmail.com > LinkedIn Profile =http://www.linkedin.com/in/hbr4270 > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
