<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>