Hi
here is the output of 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) 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=8053 DEFAULT CHARSET=utf8 |
1 row in set (0.02 sec)
mit freundlichen Grüßen
Tobias Nebel
IT-Systeme und Tools, VM-F11
IAV GmbH
Rockwellstrasse 16
38518 GIFHORN
GERMANY
Tel.: +49 5371 805 - 3611
Handy: +49 160 8944187
E-Mail: mailto:tobias.nebel@iav.de
Internet: http://www.iav.com
Sitz/Registered Office: Berlin,
Registergericht/Registration Court: Amtsgericht Charlottenburg,
Registernummer/Company Registration Number: HRB 21 280,
Geschäftsführer/Managing Directors: Kurt Blumenröder, Michael Schubert,
Dr. Rüdiger Goyk
Kevin Falcone falcone@bestpractical.com
Gesendet von: rt-users-bounces@lists.bestpractical.com
16.06.2011 14:42
Bitte antworten an
rt-users@lists.bestpractical.com
An
rt-users@lists.bestpractical.com
Kopie
Thema
Re: [rt-users] [RT4] login problems after update, Signatur Fehler
----- Nachricht von Kevin Falcone falcone@bestpractical.com auf Thu, 16
Jun 2011 08:42:15 -0400 -----
An:
rt-users@lists.bestpractical.com
Thema:
Re: [rt-users] [RT4] login problems after update
we updated our RT from version 3.6.x to 4.0.0. all RT features works
and the new version is
great but one problem we have:
after the databasetransfer all users can login in RT. but when they
logout from RT and try
another login, RT say, that the login credentials are wrong. so we
must update (update Users
SET Password=md5(‘password’) where Name=‘login’ the credentials
with mysql. than the user
can login one time again. when i look in the database, the md5
hashsum changed after every
login. so it is no wonder why the logins failed.
i checked the dependencies again and validated the database with
rt-validator, everything
looks fine. have someone a tip for me to find the problem?
Please show the output of SHOW CREATE TABLE Users;
-kevin