[rt-users] Odd problem with ROOT account after an upgrade

[sky at backbonesystems.ca]

CREATE TABLE `Users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(200) NOT NULL DEFAULT '',
  `Password` varbinary(40) DEFAULT NULL,
  `Comments` text,
  `Signature` text,
  `EmailAddress` varchar(120) CHARACTER SET ascii DEFAULT NULL,
  `FreeformContactInfo` text,
  `Organization` varchar(200) DEFAULT NULL,
  `RealName` varchar(120) DEFAULT NULL,
  `NickName` varchar(16) DEFAULT NULL,
  `Lang` varchar(16) CHARACTER SET ascii DEFAULT NULL,
  `EmailEncoding` varchar(16) CHARACTER SET ascii DEFAULT NULL,
  `WebEncoding` varchar(16) CHARACTER SET ascii 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) CHARACTER SET ascii DEFAULT NULL,
  `PGPKey` blob,
  `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=101751 DEFAULT CHARSET=utf8;





sky.schumacher
sky at backbonesystems.ca

-----Original Message-----
From: ruslan.zakirov at gmail.com [mailto:ruslan.zakirov at gmail.com] On Behalf Of Ruslan Zakirov
Sent: Thursday, December 06, 2012 3:16 PM
To: sky at backbonesystems.ca
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Odd problem with ROOT account after an upgrade

On Fri, Dec 7, 2012 at 2:18 AM, SkyS <sky at backbonesystems.ca> wrote:
> I recently upgraded a RT install from 3.6.1 to 4.0.7 I managed to get 
> everything going, yet now I am having a bit of a problem.
>
> Since the upgrade, i have to manually re-set the root password.
> Once I log in and log off, i can no longer log in as root unless i 
> re-set the password again.
>
> Anyone have any advise on how to even trouble shoot the problem?

You have not upgraded properly. I suspect that Password field in Users table of your DB is short. One of ugprade scripts makes it wide enough to hold new hashing algorithm. Output of "SHOW CREATE TABLE Users" can confirm my assumption.

>
> Thanks.
>
>
>
> --
> View this message in context: 
> http://requesttracker.8502.n7.nabble.com/Odd-problem-with-ROOT-account
> -after-an-upgrade-tp52109.html Sent from the Request Tracker - User 
> mailing list archive at Nabble.com.
> --------
> We're hiring! http://bestpractical.com/jobs



--
Best regards, Ruslan.