<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 again Kevin,<br>
<br>
so I did try what's on that page you sent me to:<br>
<blockquote><tt>perl -I/opt/rt4/local/lib -I/opt/rt4/lib \</tt><br>
<tt> -MRT -MRT::User \</tt><br>
<tt> -e'RT::LoadConfig();RT::Init(); my $u =
RT::User->new($RT::SystemUser); $u->Load("root");
$u->SetPassword("secret")'</tt><br>
</blockquote>
returned to a prompt with no messages and the hash displayed in
MySQL changed so I'm thinking it worked:<br>
<br>
<blockquote><tt>mysql> SELECT * FROM Users WHERE Name='root'\G;</tt><tt><br>
</tt><tt>*************************** 1. row
***************************</tt><tt><br>
</tt><tt> id: 12</tt><tt><br>
</tt><tt> Name: root</tt><tt><br>
</tt><tt> Password:
!sha512!8MzDJesb8kr4UHIA!784B/mzwvLcUEEa</tt><tt><br>
</tt><tt> Comments: SuperUser</tt><tt><br>
</tt><tt> Signature: NULL</tt><tt><br>
</tt><tt> EmailAddress: root@localhost</tt><tt><br>
</tt><tt> FreeformContactInfo: NULL</tt><tt><br>
</tt><tt> Organization: NULL</tt><tt><br>
</tt><tt> RealName: Enoch Root</tt><tt><br>
</tt><tt> NickName: NULL</tt><tt><br>
</tt><tt> Lang: NULL</tt><tt><br>
</tt><tt> EmailEncoding: NULL</tt><tt><br>
</tt><tt> WebEncoding: NULL</tt><tt><br>
</tt><tt>ExternalContactInfoId: NULL</tt><tt><br>
</tt><tt> ContactInfoSystem: NULL</tt><tt><br>
</tt><tt> ExternalAuthId: NULL</tt><tt><br>
</tt><tt> AuthSystem: NULL</tt><tt><br>
</tt><tt> Gecos: root</tt><tt><br>
</tt><tt> HomePhone: NULL</tt><tt><br>
</tt><tt> WorkPhone: NULL</tt><tt><br>
</tt><tt> MobilePhone: NULL</tt><tt><br>
</tt><tt> PagerPhone: NULL</tt><tt><br>
</tt><tt> Address1: NULL</tt><tt><br>
</tt><tt> Address2: NULL</tt><tt><br>
</tt><tt> City: NULL</tt><tt><br>
</tt><tt> State: NULL</tt><tt><br>
</tt><tt> Zip: NULL</tt><tt><br>
</tt><tt> Country: NULL</tt><tt><br>
</tt><tt> Timezone: NULL</tt><tt><br>
</tt><tt> PGPKey: NULL</tt><tt><br>
</tt><tt> Creator: 1</tt><tt><br>
</tt><tt> Created: 2010-03-19 21:41:50</tt><tt><br>
</tt><tt> LastUpdatedBy: 1</tt><tt><br>
</tt><tt> LastUpdated: 2013-07-31 17:14:02</tt><tt><br>
</tt><tt> AuthToken: e4b79a</tt>c<tt>4754841d8</tt><tt><br>
</tt><tt>1 row in set (0.00 sec)</tt><br>
</blockquote>
I still cannot login using root:secret. Here is mysql> show
create table Users;<br>
<blockquote><tt>mysql> show create table Users;</tt><br>
<tt>+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</tt><br>
<tt>| Table | Create
Table &nb
sp;
&nb
sp; &nb
sp;
&nb
sp; &nb
sp;
&nb
sp;
|</tt><br>
<tt>+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</tt><br>
<tt>| Users | CREATE TABLE `Users` (</tt><br>
<tt> `id` int(11) NOT NULL AUTO_INCREMENT,</tt><br>
<tt> `Name` varchar(200) NOT NULL,</tt><br>
<tt> `Password` varbinary(40) DEFAULT NULL,</tt><br>
<tt> `Comments` text,</tt><br>
<tt> `Signature` text,</tt><br>
<tt> `EmailAddress` varchar(120) DEFAULT NULL,</tt><br>
<tt> `FreeformContactInfo` text,</tt><br>
<tt> `Organization` varchar(200) DEFAULT NULL,</tt><br>
<tt> `RealName` varchar(120) DEFAULT NULL,</tt><br>
<tt> `NickName` varchar(16) DEFAULT NULL,</tt><br>
<tt> `Lang` varchar(16) DEFAULT NULL,</tt><br>
<tt> `EmailEncoding` varchar(16) DEFAULT NULL,</tt><br>
<tt> `WebEncoding` varchar(16) DEFAULT NULL,</tt><br>
<tt> `ExternalContactInfoId` varchar(100) DEFAULT NULL,</tt><br>
<tt> `ContactInfoSystem` varchar(30) DEFAULT NULL,</tt><br>
<tt> `ExternalAuthId` varchar(100) DEFAULT NULL,</tt><br>
<tt> `AuthSystem` varchar(30) DEFAULT NULL,</tt><br>
<tt> `Gecos` varchar(16) DEFAULT NULL,</tt><br>
<tt> `HomePhone` varchar(30) DEFAULT NULL,</tt><br>
<tt> `WorkPhone` varchar(30) DEFAULT NULL,</tt><br>
<tt> `MobilePhone` varchar(30) DEFAULT NULL,</tt><br>
<tt> `PagerPhone` varchar(30) DEFAULT NULL,</tt><br>
<tt> `Address1` varchar(200) DEFAULT NULL,</tt><br>
<tt> `Address2` varchar(200) DEFAULT NULL,</tt><br>
<tt> `City` varchar(100) DEFAULT NULL,</tt><br>
<tt> `State` varchar(100) DEFAULT NULL,</tt><br>
<tt> `Zip` varchar(16) DEFAULT NULL,</tt><br>
<tt> `Country` varchar(50) DEFAULT NULL,</tt><br>
<tt> `Timezone` varchar(50) DEFAULT NULL,</tt><br>
<tt> `PGPKey` text,</tt><br>
<tt> `Creator` int(11) NOT NULL DEFAULT '0',</tt><br>
<tt> `Created` datetime DEFAULT NULL,</tt><br>
<tt> `LastUpdatedBy` int(11) NOT NULL DEFAULT '0',</tt><br>
<tt> `LastUpdated` datetime DEFAULT NULL,</tt><br>
<tt> `AuthToken` varchar(16) CHARACTER SET ascii DEFAULT NULL,</tt><br>
<tt> PRIMARY KEY (`id`),</tt><br>
<tt> UNIQUE KEY `Users1` (`Name`),</tt><br>
<tt> KEY `Users4` (`EmailAddress`)</tt><br>
<tt>) ENGINE=InnoDB AUTO_INCREMENT=10612 DEFAULT CHARSET=utf8 |</tt><br>
<tt>+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</tt><br>
<tt>1 row in set (0.01 sec)</tt><br>
</blockquote>
Does that suggest anything?<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>
Tel: +1 (250) 324 1621<br>
Fax: +1 (250) 324 1623<br>
</div>
</div>
</div>
On 07/31/2013 08:48 AM, Kevin Falcone wrote:<br>
</div>
<blockquote cite="mid:20130731154805.GD22003@jibsheet.com"
type="cite">
<pre wrap="">On Tue, Jul 30, 2013 at 03:17:11PM -0700, Paul O'Rorke wrote:
</pre>
<blockquote type="cite">
<pre wrap=""> I am assuming that I can't just UPDATE the passwords in MySQL because of the hashing? I tried
without success:
mysql> UPDATE rtdb.Users SET Password=PASSWORD('xxxx') WHERE Name='jamie';
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1
</pre>
</blockquote>
<pre wrap="">
The jamie user will definitely not be able to log in after this.
That puts a MySQL password hash into RT, which is *not* expecting
that.
</pre>
<blockquote type="cite">
<pre wrap=""> 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?
</pre>
</blockquote>
<pre wrap="">
You can safely use the techniques here. RT should update the md5 one
for you and if you change rt3 for rt4 in the perl code, it will
generate a proper password the first time out.
<a class="moz-txt-link-freetext" href="http://requesttracker.wikia.com/wiki/RecoverRootPassword">http://requesttracker.wikia.com/wiki/RecoverRootPassword</a>
However, this does bring up a question. Show us
show create table Users;
-kevin
</pre>
</blockquote>
<br>
</body>
</html>