[rt-users] Login fails after reinstall of RT 3.4.4 -- SOLVED

[Scott Courtney]

On Thursday 10 November 2005 10:45, Ruslan Zakirov wrote:
> ENGINE TYPE MUST BE InnoDB!!! Other variants are not supported.

Thanks for the warning. I wasn't aware of this. I dumped the database,
re-created using InnoDB (and modified the engine type on the table create
statements in the dump file), and reloaded.

All is well. I found that the root cause of the problem was that the data
I migrated from our old server was UTF8, but our new server (and the new
version of MySQL) use LATIN1 by default. Now that I have everything in
agreement, RT works fine.

Thanks again for all the good advice. Ruslan, you probably saved me from
some nasty problems down the road.

Scott

-- 
------------------------------------------------------------------------------
Scott Courtney         | "I don't mind Microsoft making money. I mind them
scott at 4th.com          | having a bad operating system."    -- Linus Torvalds
http://4th.com/        | ("The Rebel Code," NY Times, 21 February 1999)
                       | PGP Public Key at http://4th.com/keys/scott.pubkey