users with Admin role_id cannot login

[fcamisa]

I cannot login as user admin (which has the Admin role_id:5)
I therefore tried to assign to another user the Admin role_id and than he as well cannot login. As soon as I revert to the original setting the user can log back in.
This is the error message:
Request URI:
http://fcamisa:###@dekiwiki.example....authprovider=1

Server response:
Array
(
[exception] => Array
(
[message] => Negative number
[source] => mscorlib
[stacktrace] => Array
(
[frame] => Array
(
[0] => System.UInt64.Parse (System.String s, NumberStyles style, IFormatProvider fp) [0x00000]
[1] => System.UInt64.Parse (System.String s) [0x00000]
[2] => MySql.Data.Types.MySqlUInt64.MySql.Data.Types.IMyS qlValue.ReadValue (MySql.Data.MySqlClient.MySqlStream stream, Int64 length, Boolean nullVal) [0x00000]
[3] => MySql.Data.MySqlClient.NativeDriver.ReadColumnValu e (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue valObject) [0x00000]
[4] => MySql.Data.MySqlClient.MySqlDataReader.Read () [0x00000]
[5] => MySql.Data.MySqlClient.StoredProcedure.Close () [0x00000]
[6] => MySql.Data.MySqlClient.MySqlCommand.Close () [0x00000]
[7] => Array
(
[#text] => (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand
[line] => :Close ()
)

[8] => MySql.Data.MySqlClient.MySqlDataReader.Close () [0x00000]
[9] => MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y () [0x00000]
[10] => MindTouch.Data.DataCommand.Execute () [0x00000]
)

)

[type] => System.OverflowException
)

)

Thanks in advance

Francesco

[MaxM]

Thats quite strange. You have a role id of 5 in roles table? If you can reproduce this, check your logs in the bin/logs dir to see if there's more info and a fuller call stack

Max

[fcamisa]

I am attaching the complete log.

Thanks in advance for any help

Francesco

2007-10-12 15:12:43,935 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/settings?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X&apikey= THOJoPO3eyn6Ohph4jAd3HE9EM9YjMfF)
2007-10-12 15:12:43,941 [99437456] INFO DekiWikiService_default - Feature [/deki/site/settings] executed in 0ms
2007-10-12 15:12:43,956 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/services?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X&apikey= THOJoPO3eyn6Ohph4jAd3HE9EM9YjMfF&type=auth)
2007-10-12 15:12:44,011 [18226064] INFO DekiWikiService_default - Feature [/deki/site/services] executed in 51ms
2007-10-12 15:12:44,014 [99437456] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/users/authenticate?dream.out.format=php&dream.in.host=de kiwiki.example.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:44,033 [99437456] INFO DekiWikiService_default - Feature [/deki/users/authenticate] executed in 19ms
2007-10-12 15:12:44,050 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/users/3?dream.out.format=php&dream.in.host=dekiwiki.exam ple.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:44,085 [18226064] INFO DekiWikiService_default - Feature [/deki/users/3] executed in 30ms
2007-10-12 15:12:44,095 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/users/=fcamisa?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:44,130 [99437456] INFO DekiWikiService_default - Feature [/deki/users/=fcamisa] executed in 8ms
2007-10-12 15:12:44,133 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/services/1?dream.out.format=php&dream.in.host=dekiwiki.exam ple.com&dream.in.origin=192.168.X.X&apikey=THOJoPO 3eyn6Ohph4jAd3HE9EM9YjMfF)
2007-10-12 15:12:44,138 [20331408] INFO DekiWikiService_default - Feature [/deki/site/services/1] executed in 1ms
2007-10-12 15:12:44,141 [99437456] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/users/3?dream.out.format=php&dream.in.host=dekiwiki.exam ple.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:44,152 [99437456] INFO DekiWikiService_default - Feature [/deki/users/3] executed in 7ms
2007-10-12 15:12:44,186 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/nav/=Special%253AUserlogout/full?dream.out.format=php&dream.in.host=dekiwiki.e xample.com&dream.in.origin=192.168.X.X&width=1600)
2007-10-12 15:12:44,247 [18226064] INFO DekiWikiService_default - Feature [/deki/site/nav/=Special%253AUserlogout/full] executed in 57ms
2007-10-12 15:12:44,257 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/pages/2/security?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:44,303 [20331408] INFO DekiWikiService_default - Feature [/deki/pages/2/security] executed in 21ms
2007-10-12 15:12:44,427 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/settings?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X&apikey= THOJoPO3eyn6Ohph4jAd3HE9EM9YjMfF)
2007-10-12 15:12:44,430 [18226064] INFO DekiWikiService_default - Feature [/deki/site/settings] executed in 0ms
2007-10-12 15:12:44,438 [99437456] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/roles/3?dream.out.format=php&dream.in.host=dekiwiki.exam ple.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:44,443 [99437456] INFO DekiWikiService_default - Feature [/deki/site/roles/3] executed in 1ms
2007-10-12 15:12:44,458 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/services?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X&apikey= THOJoPO3eyn6Ohph4jAd3HE9EM9YjMfF&type=auth)
2007-10-12 15:12:44,463 [20331408] INFO DekiWikiService_default - Feature [/deki/site/services] executed in 2ms
2007-10-12 15:12:44,466 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/services/1?dream.out.format=php&dream.in.host=dekiwiki.exam ple.com&dream.in.origin=192.168.X.X&apikey=THOJoPO 3eyn6Ohph4jAd3HE9EM9YjMfF)
2007-10-12 15:12:44,470 [18226064] INFO DekiWikiService_default - Feature [/deki/site/services/1] executed in 1ms
2007-10-12 15:12:44,472 [99437456] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/services?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X&apikey= THOJoPO3eyn6Ohph4jAd3HE9EM9YjMfF&type=auth)
2007-10-12 15:12:44,477 [99437456] INFO DekiWikiService_default - Feature [/deki/site/services] executed in 2ms
2007-10-12 15:12:44,503 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/nav/=Special%253AUserlogin/full?dream.out.format=php&dream.in.host=dekiwiki.e xample.com&dream.in.origin=192.168.X.X&width=1600)
2007-10-12 15:12:44,525 [20331408] INFO DekiWikiService_default - Feature [/deki/site/nav/=Special%253AUserlogin/full] executed in 19ms
2007-10-12 15:12:44,534 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/pages/1/security?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:44,566 [18226064] INFO DekiWikiService_default - Feature [/deki/pages/1/security] executed in 28ms
2007-10-12 15:12:50,884 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/settings?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X&apikey= THOJoPO3eyn6Ohph4jAd3HE9EM9YjMfF)
2007-10-12 15:12:50,887 [18226064] INFO DekiWikiService_default - Feature [/deki/site/settings] executed in 0ms
2007-10-12 15:12:50,895 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/roles/3?dream.out.format=php&dream.in.host=dekiwiki.exam ple.com&dream.in.origin=192.168.X.X)
2007-10-12 15:12:50,899 [20331408] INFO DekiWikiService_default - Feature [/deki/site/roles/3] executed in 1ms
2007-10-12 15:12:50,911 [99437456] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/services?dream.out.format=php&dream.in.host=dekiwi ki.example.com&dream.in.origin=192.168.X.X&apikey= THOJoPO3eyn6Ohph4jAd3HE9EM9YjMfF&type=auth)
2007-10-12 15:12:50,954 [99437456] INFO DekiWikiService_default - Feature [/deki/site/services] executed in 39ms
2007-10-12 15:12:50,956 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (POST,http://localhost:8081/deki/users/authenticate?dream.out.format=php&dream.in.host=de kiwiki.example.com&dream.in.origin=192.168.X.X&aut hprovider=1)
2007-10-12 15:12:50,964 [18226064] ERROR MindTouch.Data.DataCommand - Execute(Text: 'perm_get_UserRightsFlags', Type: StoredProcedure)

[fcamisa]

System.OverflowException: Negative number
at System.UInt64.Parse (System.String s, NumberStyles style, IFormatProvider fp) [0x00000]
at System.UInt64.Parse (System.String s) [0x00000]
at MySql.Data.Types.MySqlUInt64.MySql.Data.Types.IMyS qlValue.ReadValue (MySql.Data.MySqlClient.MySqlStream stream, Int64 length, Boolean nullVal) [0x00000]
at MySql.Data.MySqlClient.NativeDriver.ReadColumnValu e (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue valObject) [0x00000]
at MySql.Data.MySqlClient.MySqlDataReader.Read () [0x00000]
at MySql.Data.MySqlClient.StoredProcedure.Close () [0x00000]
at MySql.Data.MySqlClient.MySqlCommand.Close () [0x00000]
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:Close ()
at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x00000]
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y () [0x00000]
at MindTouch.Data.DataCommand.Execute () [0x00000]
2007-10-12 15:12:50,968 [18226064] ERROR MindTouch.Dream.DreamFeatureChain - handler for POST:local://250896be4c754faab03f8943b75ae193/deki/users/authenticate?dream.out.format=php&dream.in.host=de kiwiki.example.com&dream.in.origin=192.168.X.X&aut hprovider=1 failed()
System.OverflowException: Negative number
at System.UInt64.Parse (System.String s, NumberStyles style, IFormatProvider fp) [0x00000]
at System.UInt64.Parse (System.String s) [0x00000]
at MySql.Data.Types.MySqlUInt64.MySql.Data.Types.IMyS qlValue.ReadValue (MySql.Data.MySqlClient.MySqlStream stream, Int64 length, Boolean nullVal) [0x00000]
at MySql.Data.MySqlClient.NativeDriver.ReadColumnValu e (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue valObject) [0x00000]
at MySql.Data.MySqlClient.MySqlDataReader.Read () [0x00000]
at MySql.Data.MySqlClient.StoredProcedure.Close () [0x00000]
at MySql.Data.MySqlClient.MySqlCommand.Close () [0x00000]
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:Close ()
at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x00000]
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y () [0x00000]
at MindTouch.Data.DataCommand.Execute () [0x00000]
2007-10-12 15:12:50,969 [18226064] DEBUG MindTouch.Dream.DreamMessage - Response: Internal Error(Negative number
at System.UInt64.Parse (System.String s, NumberStyles style, IFormatProvider fp) [0x00000]
at System.UInt64.Parse (System.String s) [0x00000]
at MySql.Data.Types.MySqlUInt64.MySql.Data.Types.IMyS qlValue.ReadValue (MySql.Data.MySqlClient.MySqlStream stream, Int64 length, Boolean nullVal) [0x00000]
at MySql.Data.MySqlClient.NativeDriver.ReadColumnValu e (Int32 index, MySql.Data.MySqlClient.MySqlField field, IMySqlValue valObject) [0x00000]
at MySql.Data.MySqlClient.MySqlDataReader.Read () [0x00000]
at MySql.Data.MySqlClient.StoredProcedure.Close () [0x00000]
at MySql.Data.MySqlClient.MySqlCommand.Close () [0x00000]
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand:Close ()
at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x00000]
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y () [0x00000]
at MindTouch.Data.DataCommand.Execute () [0x00000] )
2007-10-12 15:12:50,970 [18226064] INFO DekiWikiService_default - Feature [/deki/users/authenticate] executed in 13ms
2007-10-12 15:12:50,980 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/serv...Ad3HE9EM9YjMfF)
2007-10-12 15:12:50,984 [20331408] INFO DekiWikiService_default - Feature [/deki/site/services/1] executed in 1ms
2007-10-12 15:12:50,986 [99437456] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/serv...jMfF&type=auth)
2007-10-12 15:12:50,992 [99437456] INFO DekiWikiService_default - Feature [/deki/site/services] executed in 2ms
2007-10-12 15:12:51,018 [18226064] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/site/nav/...X.X&width=1600)
2007-10-12 15:12:51,039 [18226064] INFO DekiWikiService_default - Feature [/deki/site/nav/=Special%253AUserlogin/full] executed in 18ms
2007-10-12 15:12:51,048 [20331408] DEBUG MindTouch.Dream.Http.HttpTransport - RequestHandler: (GET,http://localhost:8081/deki/pages/1/s...in=192.168.X.X)
2007-10-12 15:12:51,080 [20331408] INFO DekiWikiService_default - Feature [/deki/pages/1/security] executed in 29ms

[MaxM]

What version of mysql are you running? What OS?

Check out this thread: http://forums.opengarden.org/showthread.php?t=572
looks like the same issue caused by a mysql bug.

If you have 5.0.45 or later, please paste the contents of the roles table here

Max

[fcamisa]

Thanks very much!!
You nailed it