When i access any page on my site i am greeted by the error below. I wonder what happened so i checked my mysql file and i see some of my tables created by not all. i looked in my table creation code and it is inside a transaction so i am confused. I write quick code to dump the stack via Application_Error and it doesnt catch that error (however it catches other errors tested locally). I put a try/catch around my startup get an error log that way. The error log was the same message (i should have known) so other then learning it doesnt trigger Application_Error i learn nothing else. I double check my create table code is in a transaction, yes, it is.
Now I am sitting here wondering why this code has an error, why i cant get a better stacktrace. Why i am not getting the error locally even though my user permission is the same as the server and how to fix it without having a root mysql user (i'll try using a root user but i definitely dont want to leave it as that)
Any ideas?
asp.net on apache using mod_mono, debian lenny. MySql db.
-edit- i gave the user super permission and the site seem to work but has some weird errors which i want to debug before setting the limited account. I still have no idea how to debug that error or why i would need super privileges.
Server Error in '/' Application
Access denied; you need the SUPER privilege for this operation
Description: HTTP 500. Error processing request.
Stack Trace:
MySql.Data.MySqlClient.MySqlException: Access denied; you need the SUPER privilege for this operation
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int32& insertedId) [0x00000] in <filename unknown>:0
Version information: Mono Runtime Version: 2.6.4 (tarball Tue Jul 13 11:47:18 UTC 2010); ASP.NET Version: 2.0.50727.1433