<br><font size=2 face="sans-serif">Hi</font>
<br>
<br><font size=2 face="sans-serif">here is the output of </font><tt><font size=2>SHOW
CREATE TABLE Users;</font></tt>
<br>
<br><font size=2 face="sans-serif">mysql> SHOW CREATE TABLE Users;</font>
<br><font size=2 face="sans-serif">+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------+</font>
<br><font size=2 face="sans-serif">| Table | Create Table
|</font>
<br><font size=2 face="sans-serif">+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------+</font>
<br><font size=2 face="sans-serif">| Users | CREATE TABLE `Users` (</font>
<br><font size=2 face="sans-serif"> `id` int(11) NOT NULL AUTO_INCREMENT,</font>
<br><font size=2 face="sans-serif"> `Name` varchar(200) NOT NULL,</font>
<br><font size=2 face="sans-serif"> `Password` varbinary(40) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `Comments` text,</font>
<br><font size=2 face="sans-serif"> `Signature` text,</font>
<br><font size=2 face="sans-serif"> `EmailAddress` varchar(120) CHARACTER
SET ascii DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `FreeformContactInfo` text,</font>
<br><font size=2 face="sans-serif"> `Organization` varchar(200) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `RealName` varchar(120) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `NickName` varchar(16) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `Lang` varchar(16) CHARACTER
SET ascii DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `EmailEncoding` varchar(16) CHARACTER
SET ascii DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `WebEncoding` varchar(16) CHARACTER
SET ascii DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `ExternalContactInfoId` varchar(100)
DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `ContactInfoSystem` varchar(30)
DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `ExternalAuthId` varchar(100)
DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `AuthSystem` varchar(30) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `Gecos` varchar(16) DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `HomePhone` varchar(30) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `WorkPhone` varchar(30) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `MobilePhone` varchar(30) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `PagerPhone` varchar(30) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `Address1` varchar(200) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `Address2` varchar(200) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `City` varchar(100) DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `State` varchar(100) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `Zip` varchar(16) DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `Country` varchar(50) DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `Timezone` varchar(50) CHARACTER
SET ascii DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `PGPKey` blob,</font>
<br><font size=2 face="sans-serif"> `Creator` int(11) NOT NULL DEFAULT
'0',</font>
<br><font size=2 face="sans-serif"> `Created` datetime DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> `LastUpdatedBy` int(11) NOT NULL
DEFAULT '0',</font>
<br><font size=2 face="sans-serif"> `LastUpdated` datetime DEFAULT
NULL,</font>
<br><font size=2 face="sans-serif"> `AuthToken` varchar(16) CHARACTER
SET ascii DEFAULT NULL,</font>
<br><font size=2 face="sans-serif"> PRIMARY KEY (`id`),</font>
<br><font size=2 face="sans-serif"> UNIQUE KEY `Users1` (`Name`),</font>
<br><font size=2 face="sans-serif"> KEY `Users4` (`EmailAddress`)</font>
<br><font size=2 face="sans-serif">) ENGINE=InnoDB AUTO_INCREMENT=8053
DEFAULT CHARSET=utf8 |</font>
<br><font size=2 face="sans-serif">+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------+</font>
<br><font size=2 face="sans-serif">1 row in set (0.02 sec)</font>
<br>
<br><font size=2 face="sans-serif">mit freundlichen Grüßen<br>
Tobias Nebel<br>
<br>
IT-Systeme und Tools, VM-F11<br>
<br>
IAV GmbH
<br>
Rockwellstrasse 16<br>
38518 GIFHORN<br>
GERMANY<br>
<br>
Tel.: +49 5371 805 - 3611<br>
Handy: +49 160 8944187<br>
<br>
E-Mail: <mailto:tobias.nebel@iav.de><br>
Internet: http://www.iav.com<br>
<br>
Sitz/Registered Office: Berlin, <br>
Registergericht/Registration Court: Amtsgericht Charlottenburg, <br>
Registernummer/Company Registration Number: HRB 21 280, <br>
Geschäftsführer/Managing Directors: Kurt Blumenröder, Michael Schubert,
Dr. Rüdiger Goyk<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Kevin Falcone <falcone@bestpractical.com></b>
</font>
<br><font size=1 face="sans-serif">Gesendet von: rt-users-bounces@lists.bestpractical.com</font>
<p><font size=1 face="sans-serif">16.06.2011 14:42</font>
<table border>
<tr valign=top>
<td bgcolor=white>
<div align=center><font size=1 face="sans-serif">Bitte antworten an<br>
rt-users@lists.bestpractical.com</font></div></table>
<br>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">An</font></div>
<td><font size=1 face="sans-serif">rt-users@lists.bestpractical.com</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Kopie</font></div>
<td>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Thema</font></div>
<td><font size=1 face="sans-serif">Re: [rt-users] [RT4] login problems
after update, Signatur Fehler</font><font size=2 face="sans-serif"> </font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br><font size=2 color=#800080 face="sans-serif"><br>
----- Nachricht von Kevin Falcone <falcone@bestpractical.com> auf
Thu, 16 Jun 2011 08:42:15 -0400 -----</font>
<table width=100%>
<tr>
<td width=15%>
<div align=right><font size=3><b>An:</b></font></div>
<td width=84%><font size=3>rt-users@lists.bestpractical.com</font>
<tr>
<td>
<div align=right><font size=3><b>Thema:</b></font></div>
<td><font size=3>Re: [rt-users] [RT4] login problems after update</font></table>
<br><tt><font size=2>On Thu, Jun 16, 2011 at 09:32:59AM +0200, Tobias Nebel
wrote:<br>
> we updated our RT from version 3.6.x to 4.0.0. all RT
features works and the new version is<br>
> great :) but one problem we have:<br>
> <br>
> after the databasetransfer all users can login in RT.
but when they logout from RT and try<br>
> another login, RT say, that the login credentials are
wrong. so we must update (update Users<br>
> SET Password=md5('password') where Name='login';) the
credentials with mysql. than the user<br>
> can login one time again. when i look in the database,
the md5 hashsum changed after every<br>
> login. so it is no wonder why the logins failed.<br>
> i checked the dependencies again and validated the database
with rt-validator, everything<br>
> looks fine. have someone a tip for me to find the problem?<br>
<br>
Please show the output of SHOW CREATE TABLE Users;<br>
<br>
-kevin<br>
</font></tt>
<br>