I'm having some issues with rhino security and MySQL. NHibernate creates the tables fine (I'm using NH 2.1.2) but then I get this error when a UserGroup is being created. It created the UserGroup table with Id of VARCHAR(40) and Latin1 collation. I changed this to UTF8 thinking that was the problem, but I get the same error.
Any advice appreciated. Here is the stack trace: [MySqlException (0x80004005): Incorrect string value: '\xCE\xE9\xA0C\xCDT...' for column 'Id' at row 1] MySql.Data.MySqlClient.MySqlStream.ReadPacket() +251 MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) +103 MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() +87 MySql.Data.MySqlClient.MySqlDataReader.NextResult() +1451 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +1762 MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +32 MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() +69 NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd) +303 NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation) +65 NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) +923 [GenericADOException: could not insert: [Rhino.Security.Model.UsersGroup#43a0e9ce-54cd-4963-b29f-9d7800ecce85][SQL: INSERT INTO security_UsersGroups (Name, Parent, Id) VALUES (?, ?, ?)]] NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session) +1321 NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session) +312 NHibernate.Action.EntityInsertAction.Execute() +368 NHibernate.Engine.ActionQueue.Execute(IExecutable executable) +187 NHibernate.Engine.ActionQueue.ExecuteActions(IList list) +125 NHibernate.Engine.ActionQueue.ExecuteActions() +35 NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) +221 NHibernate.Event.Default.DefaultAutoFlushEventListener.OnAutoFlush(AutoFlushEvent event) +201 NHibernate.Impl.SessionImpl.AutoFlushIfRequired(ISet`1 querySpaces) +295 NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +519 NHibernate.Impl.CriteriaImpl.List(IList results) +66 NHibernate.Impl.CriteriaImpl.List() +65 NHibernate.Impl.CriteriaImpl.UniqueResult() +31 NHibernate.Impl.CriteriaImpl.UniqueResult() +44 Rhino.Security.Services.AuthorizationRepository.GetOperationByName(String operationName) +141 Rhino.Security.Services.AuthorizationRepository.CreateOperation(String operationName) +224 WB.Calendar.Web.Controllers.<>c__DisplayClass25.<InitializeSecurity>b__f(String operation) in C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:184 System.Collections.Generic.List`1.ForEach(Action`1 action) +56 EnumerableHelper.ForEach(IEnumerable`1 sequence, Action`1 action) +102 WB.Calendar.Web.Controllers.<>c__DisplayClass25.<InitializeSecurity>b__e() in C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:184 WB.Calendar.Web.Controllers.<>c__DisplayClass25.<InitializeSecurity>b__d(Action x) in C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:170 WB.Calendar.Web.Controllers.DatabaseController.InitializeSecurity() in C:\working\calendar\src\WB.Calendar.Web\Controllers\DatabaseController.cs:174 lambda_method(ExecutionScope , ControllerBase , Object[] ) +74 System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17 System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +178 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +24 System.Web.Mvc.<>c__DisplayClassa.<InvokeActionMethodWithFilters>b__7() +52 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +254 System.Web.Mvc.<>c__DisplayClassc.<InvokeActionMethodWithFilters>b__9() +19 System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +192 System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +399 System.Web.Mvc.Controller.ExecuteCore() +126 System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +27 System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +7 System.Web.Mvc.MvcHandler.ProcessRequest(HttpContextBase httpContext) +151 System.Web.Mvc.MvcHandler.ProcessRequest(HttpContext httpContext) +57 System.Web.Mvc.MvcHandler.System.Web.IHttpHandler.ProcessRequest(HttpContext httpContext) +7 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75 -- You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.
