<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">Sorry to keep bugging this list,<br>
<br>
can anyone tell me why I can't set the password in MySQL with the
UPDATE statement below? I have upgraded from 3.8.4 to 4.0.14 and
run the password updater. MySQL was at 5.1 so I didn't need to
do the MySQL update stuff as far as my reading shows. <br>
<br>
Is there something wrong with my query or is there something that
RT is doing such that the passwords are perhaps hashed
differently?<br>
<br>
I'd so love to get past this final hurdle and be able to make
tickets again...<br>
<br>
Is there perhaps some further info that I should supply that I
have not to help understand this?<br>
<br>
Regards<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>
<br>
<br>
</div>
</div>
</div>
On 07/30/2013 03:17 PM, Paul O'Rorke wrote:<br>
</div>
<blockquote cite="mid:51F83B67.1030802@tracker-software.com"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<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 moz-do-not-send="true"
href="mailto:paul@tracker-software.com">paul@tracker-software.com</a><br>
<a moz-do-not-send="true"
href="http://tracker-software.com">tracker-software.com</a><br>
<br>
Tel: +1 (250) 324 1621<br>
Fax: +1 (250) 324 1623<br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
</body>
</html>