<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: [rt-users] problems with login after upgrade to mysql 4.x and RT 3.0.5</TITLE>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle18 {
COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV>
<DIV><SPAN class=828045013-10092003><FONT face=Arial color=#0000ff size=2>Ok, a
complete list of things that changed between when it was working and now might
be helpful.</FONT></SPAN></DIV>
<DIV><SPAN class=828045013-10092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=828045013-10092003><FONT face=Arial><FONT color=#0000ff><FONT
size=2>Do the login attempts at least show up in apache's access_log? What
status code does access_log say apache is returning? If apache is seeing the
request and just returning you to the login screen, perhaps RT is just rejecting
the username and password. Are you sure you still have the username and
passwords where RT is looking for them now?<SPAN
class=140045413-10092003>
</SPAN></FONT></FONT></FONT></SPAN></DIV></DIV>
<DIV> </DIV>
<P><FONT size=2>--<BR>Wes Sheldahl<BR>iHigh NetOps </FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Ted Serreyn
[mailto:ted@serreyn.com]<BR><B>Sent:</B> Wednesday, September 10, 2003 9:23
AM<BR><B>To:</B> wesley.sheldahl@ihigh.com<BR><B>Subject:</B> RE: [rt-users]
problems with login after upgrade to mysql 4.x and RT
3.0.5<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">It has been upgrade
to 4.X now, that is one of the things that changed.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<P class=MsoAutoSig><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">--</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">Ted
Serreyn
262-363-9265</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face="Times New Roman" color=navy size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: navy">Serreyn Network Services,
LLC
http://www.serreyn.com/</SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
wesley.sheldahl@ihigh.com [mailto:wesley.sheldahl@ihigh.com] <BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, September 10, 2003 6:42
AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> ted@serreyn.com;
rt-users@lists.fsck.com<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [rt-users] problems with
login after upgrade to mysql 4.x and RT 3.0.5</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">The documentation for RT 3.x says it requires at least
mysql 4.x (I think it was more specific) because of some problems in the way
mysql 3.x handles certain SQL statements. I'd suggest upgrading mysql first of
all.</SPAN></FONT></P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-- </SPAN></FONT><BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">Wes Sheldahl</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">iHigh NetOps </SPAN></FONT></P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">-----Original Message-----</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt">From: Ted Serreyn [<A
href="mailto:ted@serreyn.com">mailto:ted@serreyn.com</A>]</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Sent: Wednesday, September 10,
2003 12:07 AM</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">To:
rt-users@lists.fsck.com</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">Subject: [rt-users] problems with login after upgrade
to mysql 4.x and</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">RT 3.0.5</SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Was working for 3.0.4 and mysql 3.X, but now I get a
login screen, type</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">username and password, and get the login screen
again. No errors in http</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">logs, no idea why rt is not logging any debugging
information.</SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Anyone want to give me a short primer in
troubleshooting RT?</SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">--</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">Ted
Serreyn
262-363-9265</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">Serreyn Network Services,
LLC <A
href="http://www.serreyn.com/"
target=_blank>http://www.serreyn.com/</A></SPAN></FONT> </P>
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 0.5in; MARGIN-RIGHT: 0in"><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">_______________________________________________</SPAN></FONT>
<BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">rt-users mailing
list</SPAN></FONT> <BR><FONT size=2><SPAN
style="FONT-SIZE: 10pt">rt-users@lists.fsck.com</SPAN></FONT> <BR><FONT
size=2><SPAN style="FONT-SIZE: 10pt"><A
href="http://lists.fsck.com/mailman/listinfo/rt-users"
target=_blank>http://lists.fsck.com/mailman/listinfo/rt-users</A></SPAN></FONT>
</P>
<P style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=2><SPAN
style="FONT-SIZE: 10pt">Have you read the FAQ? The RT FAQ Manager lives at <A
href="http://fsck.com/rtfm"
target=_blank>http://fsck.com/rtfm</A></SPAN></FONT>
</P></DIV></BLOCKQUOTE></BODY></HTML>