I think what you want to know is: USER_X is the db view for the User form. There is also a db table called USER_CACHE that holds the cache info.
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, May 19, 2008 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: No users can log in. Let me re-iterate, cycling the DB and arserver addressed the issue. I am not down right now, but was looking if anyone has already been down this road. It was acting just like it had lost the caching of all user accounts. I queries user_x and could see all users in the table. Is there a different place/way to verify what remedy really has cached? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gidd Sent: Monday, May 19, 2008 2:14 PM To: arslist@ARSLIST.ORG Subject: Re: No users can log in. Gary, Are you attempting to login using the WUT and/or MT ? Regards...Gidd -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, May 19, 2008 12:07 PM To: arslist@ARSLIST.ORG Subject: Re: No users can log in. I will keep this in mind next time the issue occurs, if it happens again (hopefully not). Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Monday, May 19, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: No users can log in. Have you tried turning on API and Plugin logging and looking at the results? You can do this manually by changing the ar.conf/ar.cfg file (refer to the AR config manual on what to add). -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Garrison, Sean (Norcross) Sent: Monday, May 19, 2008 12:09 PM To: arslist@ARSLIST.ORG Subject: Re: No users can log in. Did someone add a new group into the system? Any new group added through ITSM causes the server to recache the Groups/Users in the system. This in turn prevents users from logging in while the server is re-caching. The only other thing I can think of is that you had a filter loop in your system that caused the server to just hang. You won't know that unless you had logging turned on during the time that it happened. If you had "Server Statistics" turned on it may help you know if it was a workflow/filter loop issue. Sean -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, May 19, 2008 12:22 PM To: arslist@ARSLIST.ORG Subject: Re: No users can log in. Dwayne, this was my first thought, but nothing changed on any part of our environment over the weekend. We didn't change anything on the remedy side, or elsewhere. If it were this suggestion, then whenever I Cycled remedy and sql server, the issue would not have cleared up. It was acting like maybe the cached user entries were messed up. I thought about running arreload to see if that cleared it up, but I just went in and cycled remedy and sql server and it worked. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMI(r) Level 3 Rated Company -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Monday, May 19, 2008 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: No users can log in. Hi Gary, This is a long shot. Have you changed anything in the Server Configuration? We have "Authenticate Registered Users" and "Cross Reference Blank Passwords" checked. That way people with blank passwords, which is just about everyone, must LDAP authenticate. I once inadvertently unchecked "Cross Reference Blank Passwords" and nobody could log in. Dwayne Martin James Madison University ---- Original message ---- >Date: Mon, 19 May 2008 08:46:29 -0500 >From: "Gary Opela (Corporate)" <[EMAIL PROTECTED]> >Subject: No users can log in. >To: arslist@ARSLIST.ORG > > Good morning. I came in this morning and tried to > log in, and received an Authentication Failed > message. I had some other people try, they all got > the same. They have blank passwords, so it is > authenticating them through their network login > account. > > I tried some test accounts I had created that had > static passwords in the user form, they could not > log in either! > > I logged into my server and checked my database, and > user_x is there, and I can query it and pull back > all of my users too. > > I cycled my database and arserver and was able to > log in without issue. > > Has anyone experienced this? Is there a way to fix > it? I've only had my server online for a few weeks > and it's already done this. I don't want to have to > keep dealing with it again. > > AR System 7.1 nopatch > MS SQL Server 2k5 > MS Windows Server 2k3 > MT 7.1 > IE 7 > > Don't use the user client. > > Thanks, > > Gary Opela, Jr., RSP > Remedy Engineer > Leader Communications, Inc. > http://www.5pointleader.com > http://www.lcibest.com > Best Product, Best People, Best PriceTM > An ISO 9001:2000 Certified, CMMI(R) Level 3 Rated > Company > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
