[rt-users] new rt user having trouble

ahorn at deorth.org ahorn at deorth.org
Mon Apr 28 02:05:36 EDT 2003


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






More information about the rt-users mailing list