<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">..I also looked at the real mysql log file (i.e., " <serverName>.err"), and that did not reveal any worthy information, besides its timestamp was also as of Aug 30th (again way before my password problem of last night).<div><br></div><div>-Behzad<br><div><div>On Sep 25, 2009, at 10:25 AM, Behzad Mahini wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br></div><div>1) Systemlog & MySQL log points:</div><div>==========================</div>system.log file:<div><br></div><div>RT[350]: FAILED LOGIN for root from xx.xx.xx.xx (/some_dir_xx//share/html/autohandler:268)</div><div>..<<which is saying the same thing that my Apache error_log indicated>></div><div><br></div><div><br></div><div>Mysql log files:</div><div>The only log files that I have for MySQL are binary log files and they are:</div><div><br></div><div>mysql-bin.xxx0</div><div>mysql-bin.xxx1</div><div>...</div><div><br></div><div>and </div><div>ib_logfile0</div><div>ib_logfile1</div><div><br></div><div>..and timestamp associated to these ar as of Aug 30, 2009 (which way before I started having my password problem of yesterday!)</div><div><br></div><div>2) I rebooted my box, in the hopes of it clearing up some item that I am not aware of -- that did not do any good</div><div>===============================================================</div><div><br></div><div>3) Using the "RecoverRootPassword" Wiki page, I tried to change my password at the command/Perl level:</div><div>==================================================================================</div><div><br></div><div><span class=" argument-content"><pre>perl -I/opt/rt3/local/lib -I/opt/rt3/lib \
-MRT -MRT::User \
-e'RT::LoadConfig();RT::Init(); my $u = RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'</pre></span></div><div>that did not help either, and I got the following complaint:</div><div><br></div><div><!--StartFragment--><p class="MsoNormal"><span style="font-size:8.0pt;mso-bidi-font-size:12.0pt">Change of config option 'MaxInlineBody' at /ngs/app/rt/oppresso/rt-3.8.4/local/plugins/RT-IR/etc/RTIR_Config.pm line 13 has been ignored. It's may be ok, but we want you to be aware. This option earlier has been set in /ngs/app/rt/oppresso/rt-3.8.4/etc/RT_SiteConfig.pm line 152. at /usr/local/src/oppresso/rt-3.8.4/lib/RT/Config.pm line 738.<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:8.0pt;mso-bidi-font-size:12.0pt">Change of config option 'Active_MakeClicky' at /ngs/app/rt/oppresso/rt-3.8.4/local/plugins/RT-IR/etc/RTIR_Config.pm line 263 has been ignored. It's may be ok, but we want you to be aware. This option earlier has been set in /ngs/app/rt/oppresso/rt-3.8.4/etc/RT_SiteConfig.pm line 186. at /usr/local/src/oppresso/rt-3.8.4/lib/RT/Config.pm line 738.<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:8.0pt;mso-bidi-font-size:12.0pt">[Fri Sep 25 16:59:45 2009] [crit]: Can't locate RT/FM.pm in @INC (@INC contains: /usr/local/src/oppresso/rt-3.8.4/lib /ngs/app/rt/oppresso/rt-3.8.4/lib /Library/Perl/Updates/5.8.8/darwin-thread-multi-2level /Library/Perl/Updates/5.8.8 /System/Library/Perl/5.8.8/darwin-thread-multi-2level /System/Library/Perl/5.8.8 /Library/Perl/5.8.8/darwin-thread-multi-2level /Library/Perl/5.8.8 /Library/Perl /Network/Library/Perl/5.8.8/darwin-thread-multi-2level /Network/Library/Perl/5.8.8 /Network/Library/Perl /System/Library/Perl/Extras/5.8.8/darwin-thread-multi-2level /System/Library/Perl/Extras/5.8.8 /Library/Perl/5.8.6 /Library/Perl/5.8.1 .) at /usr/local/src/oppresso/rt-3.8.4/lib/RT.pm line 627. (/usr/local/src/oppresso/rt-3.8.4/lib/RT.pm:377)<o:p></o:p></span></p><p class="MsoNormal"><span style="font-size:8.0pt;mso-bidi-font-size:12.0pt">Can't locate RT/FM.pm in @INC (@INC contains: /usr/local/src/oppresso/rt-3.8.4/lib /ngs/app/rt/oppresso/rt-3.8.4/lib /Library/Perl/Updates/5.8.8/darwin-thread-multi-2level /Library/Perl/Updates/5.8.8 /System/Library/Perl/5.8.8/darwin-thread-multi-2level /System/Library/Perl/5.8.8 /Library/Perl/5.8.8/darwin-thread-multi-2level /Library/Perl/5.8.8 /Library/Perl /Network/Library/Perl/5.8.8/darwin-thread-multi-2level /Network/Library/Perl/5.8.8 /Network/Library/Perl /System/Library/Perl/Extras/5.8.8/darwin-thread-multi-2level /System/Library/Perl/Extras/5.8.8 /Library/Perl/5.8.6 /Library/Perl/5.8.1 .) at /usr/local/src/oppresso/rt-3.8.4/lib/RT.pm line 627.<o:p></o:p></span></p> <!--EndFragment--> </div><div><br></div><div>-Behzad<br><div><div>On Sep 25, 2009, at 9:46 AM, Jesse Vincent wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><br><br><br>On Fri, Sep 25, 2009 at 09:03:56AM -0700, Behzad Mahini wrote:<br><blockquote type="cite">Hoping this additional piece of Information from Apache 'error_log" <br></blockquote><blockquote type="cite">file would provide more clue for debugging:<br></blockquote><br>Out of curiousity, is there anything interesting in your syslog or<br>database error log?<br><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">====<br></blockquote><blockquote type="cite">[error]: FAILED LOGIN for root from xx.xxx.xx.xxx (/some_dir_xxx/share/ <br></blockquote><blockquote type="cite">html/autohandler:268)<br></blockquote><blockquote type="cite">====<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">lines of the code within "autohandler" that the above error message is <br></blockquote><blockquote type="cite">pointing to are:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">====<br></blockquote><blockquote type="cite">unless( $session{'CurrentUser'} ) {<br></blockquote><blockquote type="cite"> # If the user is logging in, let's authenticate<br></blockquote><blockquote type="cite"> if( defined $user && defined $pass ) {<br></blockquote><blockquote type="cite"> my $user_obj = RT::CurrentUser->new;<br></blockquote><blockquote type="cite"> $user_obj->Load( $user );<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> unless ( $user_obj->id && $user_obj->IsPassword( $pass ) ) {<br></blockquote><blockquote type="cite"> $RT::Logger->error("FAILED LOGIN for $user from <br></blockquote><blockquote type="cite">$ENV{'REMOTE_ADDR'}");<span class="Apple-tab-span" style="white-space:pre"> </span><<..........line 268, WHERE the complaint is <br></blockquote><blockquote type="cite">being made...>><br></blockquote><blockquote type="cite"> $m->comp( '/Elements/Login', %ARGS,<br></blockquote><blockquote type="cite"> Error => loc('Your username or password is <br></blockquote><blockquote type="cite">incorrect'),<br></blockquote><blockquote type="cite"> );<br></blockquote><blockquote type="cite"> $m->callback( %ARGS, CallbackName => 'FailedLogin' );<br></blockquote><blockquote type="cite"> $m->abort;<br></blockquote><blockquote type="cite"> }<br></blockquote><blockquote type="cite"> $session{'CurrentUser'} = $user_obj;<br></blockquote><blockquote type="cite"> $RT::Logger->info(<br></blockquote><blockquote type="cite"> "Successful login for $user from $ENV{'REMOTE_ADDR'}");<br></blockquote><blockquote type="cite"> $m->callback( %ARGS, CallbackName => 'SuccessfulLogin' );<br></blockquote><blockquote type="cite"> }<br></blockquote><blockquote type="cite"> # if no credentials then show him login page<br></blockquote><blockquote type="cite"> else {<br></blockquote><blockquote type="cite"> $m->comp( '/Elements/Login', %ARGS );<br></blockquote><blockquote type="cite"> $m->abort;<br></blockquote><blockquote type="cite"> }<br></blockquote><blockquote type="cite">}<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">====<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">-Behzad<br></blockquote><blockquote type="cite">On Sep 24, 2009, at 4:56 PM, Behzad Mahini wrote:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite">Using 'root' I granted "ModifySelf" to another userName, and now I can<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">no longer login using "root", neither the other user could login.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">The error message that I get is:<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><span class="Apple-tab-span" style="white-space:pre"> </span>Error "Your username or password is incorrect"<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Thanks,<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Behzad<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">_______________________________________________<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite"><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br></blockquote><blockquote type="cite">Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <br></blockquote><blockquote type="cite">Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br></blockquote><blockquote type="cite"><br></blockquote><br>-- <br></div></blockquote></div><br></div></div>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help: http://wiki.bestpractical.com<br>Commercial support: sales@bestpractical.com<br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <br>Buy a copy at http://rtbook.bestpractical.com</blockquote></div><br></div></body></html>