<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/4.0.1">
</HEAD>
<BODY>
Kevin,<BR>
<BR>
No-one can log in (including root). I eventually figured out I could reset a password with: <BR>
UPDATE Users SET Password=md5('password') WHERE Name='knarrj';<BR>
<BR>
This resets the password of the user. I changed my loglevel to debug and restarted httpd and sure enough I'm locked out again.<BR>
<BR>
log snippit:<BR>
[Mon Jun 6 14:54:10 2011] [debug]: RT's GnuPG libraries couldn't successfully read your configured GnuPG home directory (/opt/rt4/var/data/gpg). PGP support has been disabled (/opt/rt4/sbin/../lib/RT/Config.pm:521)<BR>
[Mon Jun 6 14:54:29 2011] [error]: FAILED LOGIN for knarrj from 172.25.30.147 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:639)<BR>
[Mon Jun 6 14:54:36 2011] [error]: FAILED LOGIN for knarrj from 172.25.30.147 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:639)<BR>
[Mon Jun 6 14:54:50 2011] [error]: FAILED LOGIN for knarrj from 172.25.30.147 (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:639)<BR>
<BR>
Extensions - we're very boring here and have no extensions installed.<BR>
<BR>
Thanks,<BR>
Josh<BR>
<BR>
On Mon, 2011-06-06 at 10:45 -0400, Kevin Falcone wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
On Mon, Jun 06, 2011 at 09:29:03AM -0400, Joshua Knarr wrote:
> I am upgrading from RT 3.4.5 to RT 4.
>
> I read the docs and stopped at 3.8, did the schema stuff, and then continued to 4 per the
> instructions for upgrading mysql also.
>
> On the new system it runs for a few hours just fine, but then suddenly everyones account gets
> locked.
What does "everyones account gets locked" mean?
What is in your debug logs.
What extensions do you have installed.
-kevin
> I restarted the services, I checked my configs, I'm coming up empty. What went wrong or where
> should I be looking?
</PRE>
</BLOCKQUOTE>
<BR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
-- <BR>
<FONT SIZE="1">Joshua Knarr</FONT><BR>
<FONT SIZE="1">Systems Engineer</FONT><BR>
<FONT SIZE="1">GSI Commerce, Inc. <A HREF="http://www.gsicommerce.com/">http://www.gsicommerce.com</A></FONT><BR>
<FONT SIZE="1">E-Mail: <A HREF="mailto:hellerk@gsicommerce.com">knarrj@gsicommerce.com</A></FONT><BR>
<FONT SIZE="1">Office: 610-491-7110</FONT><BR>
<FONT SIZE="1">Mobile: 484-636-7371</FONT><BR>
<BR>
<FONT SIZE="1">The information contained in this electronic mail transmission is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of GSI Commerce, Inc. or its subsidiaries and/or affiliates.</FONT>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>