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@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
[email protected] <mailto:[email protected]>
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
