rt v3.0.1 on NetBSD1.6 with modperl1 and mysql.
I try to login using the default login of root/password. I simply get
dumped back to the login screen each time with no error.
I’ve checked the rt3 database. The entry in Users table for root has the
right password.
I enabled logging on mysql and see the following seris of transactions
occuring when I try to login :
030427 15:12:04 18 Query SELECT * FROM Users WHERE Name =
'RT_System’
18 Query SELECT * FROM Users WHERE Name =
'Nobody’
18 Query SELECT
GET_LOCK(‘Apache-Session-0ad684d4f1176168aa5c797c9f53bb47’, 3600)
18 Query SELECT a_session FROM sessions WHERE
id = '0ad684d4f1176168aa5c797c9f53bb47’
18 Query SELECT * FROM Users WHERE Name =
‘RT::CurrentUser=HASH(0xab7c5f8)‘
18 Query UPDATE sessions SET a_session =
’\0\0\0RT::CurrentUser\0\0\0\0\0\0\nid\0\0\0_PrimaryKeysRT::I18N::en\0\0\0\0\0\0\0\nLangHandle\0\0\0\0\0\rcache_for_se\0\0\0cache_\0\0\0\rfast_update_p\0\0\0_CacheConfig\0\0\0\0\0\0\0user\nUsers\0\0\0table\0\0\0CurrentUser\n
0ad684d4f1176168aa5c797c9f53bb47\0\0\0_session_id’ WHERE id =
'0ad684d4f1176168aa5c797c9f53bb47’
18 Query SELECT
RELEASE_LOCK(‘Apache-Session-0ad684d4f1176168aa5c797c9f53bb47’)
19 Query SELECT * FROM Users WHERE Name =
'RT_System’
19 Query SELECT * FROM Users WHERE Name =
'Nobody’
19 Query SELECT
GET_LOCK(‘Apache-Session-0ad684d4f1176168aa5c797c9f53bb47’, 3600)
19 Query SELECT a_session FROM sessions WHERE
id = ‘0ad684d4f1176168aa5c797c9f53bb47’
19 Query UPDATE sessions SET a_session =
’\0\0\0\n
0ad684d4f1176168aa5c797c9f53bb47\0\0\0_session_idRT::CurrentUser\0\0\0\0\0\0\nid\0\0\0_PrimaryKeys\0\0\0\0\0\rcache_for_se\0\0\0cache_\0\0\0\rfast_update_p\0\0\0_CacheConfig\0\0\0\0\0\0\0user\nUsers\0\0\0table\0\0\0CurrentUser’
WHERE id = '0ad684d4f1176168aa5c797c9f53bb47’
19 Query SELECT
RELEASE_LOCK(‘Apache-Session-0ad684d4f1176168aa5c797c9f53bb47’)
I’m suspicious of the line that reads
18 Query SELECT * FROM Users WHERE Name =
‘RT::CurrentUser=HASH(0xab7c5f8)’
Surely the Name = part should have a real username after it.
Any help appreciated 
Cheers,
Al