<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Thanks for that Kevin,<br>
<br>
not the first time - a silly little mistake had me scratching my
head. I had in my Apache config a rewrite rule for /rt and had
the wrong value in RT_Siteconfig for Set($WebPath, '');<br>
<br>
So I now get my logon screen but cannot log in. <br>
<br>
I did run the password updater:<br>
<blockquote><tt>root@rt4:/opt/rt4# perl
/opt/rt4/etc/upgrade/vulnerable-passwords --fix</tt><br>
<tt>Upgrading 16 users...</tt><br>
<tt>Done.</tt><br>
</blockquote>
I am assuming that I can't just UPDATE the passwords in MySQL
because of the hashing? I tried without success: <br>
<blockquote><tt>mysql> UPDATE rtdb.Users SET
Password=PASSWORD('xxxx') WHERE Name='jamie';</tt><br>
<tt>Query OK, 1 row affected, 1 warning (0.01 sec)</tt><br>
<tt>Rows matched: 1 Changed: 1 Warnings: 1</tt><br>
</blockquote>
I guess I have missed something in these upgrade README files. I
do appreciate your help. Now that I've the Apache thing sorted
I'm feeling like on the home stretch - if only I can sort these
passwords out. Is there another related script I missed perhaps?<br>
<br>
Sincerely<br>
<br>
<div class="moz-signature">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<title></title>
<div style="font-family: Arial,Helvetica,sans-serif">
<div style="color: gray"> <span style="font-weight: bold">Paul
O'Rorke</span><br>
Tracker Software Products Canada Limited<br>
<br>
<a href="mailto:paul@tracker-software.com">paul@tracker-software.com</a><br>
<a href="http://tracker-software.com">tracker-software.com</a><br>
<br>
Tel: +1 (250) 324 1621<br>
Fax: +1 (250) 324 1623<br>
<br>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++<br>
<br>
PLEASE NOTE : - If you are sending files for us to look at
or assist with<br>
these must ALWAYS be wrapped in either a ZIP/RAR or 7z FILE<br>
or they will be removed by our Firewall/Virus management
software.<br>
<br>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++<br>
<br>
**Certified by Microsoft**<br>
"Works with Vista"<br>
PDF-XChange & SDK, Image-XChange SDK,<br>
PDF-Tools & SDK, TIFF-XChange & SDK.<br>
<br>
Support:<br>
<a href="http://tracker-software.com/support/">http://docu-track.com/support/</a><br>
or<br>
<a href="http://tracker-software.com">http://www.tracker-software.com/forum/index.php</a><br>
<br>
<br>
Download latest Releases<br>
<a href="http://tracker-software.com/downloads">http://www.tracker-software.com/downloads/</a><br>
</div>
</div>
</div>
On 07/30/2013 07:42 AM, Kevin Falcone wrote:<br>
</div>
<blockquote cite="mid:20130730144234.GX22003@jibsheet.com"
type="cite">
<pre wrap="">On Mon, Jul 29, 2013 at 02:30:35PM -0700, Paul O'Rorke wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> In the meanwhile I am finding that after running make upgrade-database (took me through all
the upgrades from 3.8.4 to 4.0.15) and then trying to set up Apache again I'm running into a
loop on the login page. If I run Apache I don't get a login page at all. If I stop Apache
and start
</pre>
</blockquote>
<pre wrap="">
Are you running your 3.8 Apache config or a new 4.0 config.
We can't help debug that problem without seeing error logs or a
config.
</pre>
<blockquote type="cite">
<pre wrap=""> /opt/rt4/sbin/rt-server
then I get:
</pre>
</blockquote>
<pre wrap="">
You don't say what you did to cause this. Load the login page?
Attempt to log in? There are clearly a few actions mixed in there.
Also - did you run the password updater, either as a security fix back
in 3.8 or more recently as part of the upgrade?
<a class="moz-txt-link-freetext" href="http://bestpractical.com/docs/rt/latest/UPGRADING-3.8.html">http://bestpractical.com/docs/rt/latest/UPGRADING-3.8.html</a>
-kevin
</pre>
<blockquote type="cite">
<pre wrap=""> Reason: your browser did not supply a Referrer header
(/opt/rt4/sbin/../lib/RT/Interface/Web.pm:397)
[Mon Jul 29 21:25:46 2013] [notice]: Marking original destination as having side-effects
before redirecting for login.
Request: /rt/NoAuth/Login.html?next=d820f5cbf943dfe116cbee257b840411
Reason: your browser did not supply a Referrer header
(/opt/rt4/sbin/../lib/RT/Interface/Web.pm:397)
[Mon Jul 29 21:26:00 2013] [error]: FAILED LOGIN for root from 192.168.0.254
(/opt/rt4/sbin/../lib/RT/Interface/Web.pm:753)
[Mon Jul 29 21:26:12 2013] [error]: FAILED LOGIN for rtuser from 192.168.0.254
(/opt/rt4/sbin/../lib/RT/Interface/Web.pm:753)
I'm assuming I've not actually managed to get my database upgraded properly as I'm very
confident of the credentials used (tried others as well that worked in 3.8.4). After running
make upgrade-database do I still need to do the individual upgrades in each of the README
files for the various updates or does make upgrade-database effectively do the same?
</pre>
</blockquote>
</blockquote>
<br>
</body>
</html>