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@backbonesystems.caFrom: ruslan.zakirov@gmail.com [mailto:ruslan.zakirov@gmail.com] On Behalf Of Ruslan Zakirov
Sent: Thursday, December 06, 2012 3:16 PM
To: sky@backbonesystems.ca
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Odd problem with ROOT account after an upgrade
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.
We’re hiring! Careers — Best Practical Solutions
Best regards, Ruslan.