[rt-users] Migration Prep

[Paul O'Rorke]

Thanks again Kevin,

so I did try what's on that page you sent me to:

    perl -I/opt/rt4/local/lib -I/opt/rt4/lib \
         -MRT -MRT::User \
         -e'RT::LoadConfig();RT::Init(); my $u =
    RT::User->new($RT::SystemUser); $u->Load("root");
    $u->SetPassword("secret")'

returned to a prompt with no messages and the hash displayed in MySQL 
changed so I'm thinking it worked:

    mysql> SELECT * FROM Users WHERE Name='root'\G;
    *************************** 1. row ***************************
                        id: 12
                      Name: root
                  Password: !sha512!8MzDJesb8kr4UHIA!784B/mzwvLcUEEa
                  Comments: SuperUser
                 Signature: NULL
              EmailAddress: root at localhost
       FreeformContactInfo: NULL
              Organization: NULL
                  RealName: Enoch Root
                  NickName: NULL
                      Lang: NULL
             EmailEncoding: NULL
               WebEncoding: NULL
    ExternalContactInfoId: NULL
         ContactInfoSystem: NULL
            ExternalAuthId: NULL
                AuthSystem: NULL
                     Gecos: root
                 HomePhone: NULL
                 WorkPhone: NULL
               MobilePhone: NULL
                PagerPhone: NULL
                  Address1: NULL
                  Address2: NULL
                      City: NULL
                     State: NULL
                       Zip: NULL
                   Country: NULL
                  Timezone: NULL
                    PGPKey: NULL
                   Creator: 1
                   Created: 2010-03-19 21:41:50
             LastUpdatedBy: 1
               LastUpdated: 2013-07-31 17:14:02
                 AuthToken: e4b79ac4754841d8
    1 row in set (0.00 sec)

I still cannot login using root:secret.  Here is mysql> show create 
table Users;

    mysql> show create table Users;
    +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Table | Create Table |
    +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Users | CREATE TABLE `Users` (
       `id` int(11) NOT NULL AUTO_INCREMENT,
       `Name` varchar(200) NOT NULL,
       `Password` varbinary(40) DEFAULT NULL,
       `Comments` text,
       `Signature` text,
       `EmailAddress` varchar(120) DEFAULT NULL,
       `FreeformContactInfo` text,
       `Organization` varchar(200) DEFAULT NULL,
       `RealName` varchar(120) DEFAULT NULL,
       `NickName` varchar(16) DEFAULT NULL,
       `Lang` varchar(16) DEFAULT NULL,
       `EmailEncoding` varchar(16) DEFAULT NULL,
       `WebEncoding` varchar(16) DEFAULT NULL,
       `ExternalContactInfoId` varchar(100) DEFAULT NULL,
       `ContactInfoSystem` varchar(30) DEFAULT NULL,
       `ExternalAuthId` varchar(100) DEFAULT NULL,
       `AuthSystem` varchar(30) DEFAULT NULL,
       `Gecos` varchar(16) DEFAULT NULL,
       `HomePhone` varchar(30) DEFAULT NULL,
       `WorkPhone` varchar(30) DEFAULT NULL,
       `MobilePhone` varchar(30) DEFAULT NULL,
       `PagerPhone` varchar(30) DEFAULT NULL,
       `Address1` varchar(200) DEFAULT NULL,
       `Address2` varchar(200) DEFAULT NULL,
       `City` varchar(100) DEFAULT NULL,
       `State` varchar(100) DEFAULT NULL,
       `Zip` varchar(16) DEFAULT NULL,
       `Country` varchar(50) DEFAULT NULL,
       `Timezone` varchar(50) DEFAULT NULL,
       `PGPKey` text,
       `Creator` int(11) NOT NULL DEFAULT '0',
       `Created` datetime DEFAULT NULL,
       `LastUpdatedBy` int(11) NOT NULL DEFAULT '0',
       `LastUpdated` datetime DEFAULT NULL,
       `AuthToken` varchar(16) CHARACTER SET ascii DEFAULT NULL,
       PRIMARY KEY (`id`),
       UNIQUE KEY `Users1` (`Name`),
       KEY `Users4` (`EmailAddress`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10612 DEFAULT CHARSET=utf8 |
    +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    1 row in set (0.01 sec)

Does that suggest anything?

Regards

Paul O'Rorke
Tracker Software Products Canada Limited

paul at tracker-software.com <mailto:paul at tracker-software.com>
tracker-software.com <http://tracker-software.com>

Tel: +1 (250) 324 1621
Fax: +1 (250) 324 1623
On 07/31/2013 08:48 AM, Kevin Falcone wrote:
> On Tue, Jul 30, 2013 at 03:17:11PM -0700, Paul O'Rorke wrote:
>>     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
> 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.
>
>>     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?
> 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.
>
> http://requesttracker.wikia.com/wiki/RecoverRootPassword
>
> However, this does bring up a question.  Show us
> show create table Users;
>
> -kevin

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130731/74de3882/attachment.htm>