When using the provider directly, the insert works fine.
here was my test:
using (var conn = new
MySqlConnection("server=localhost;database=hampton_calendar;user=root"))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "INSERT INTO security_usersgroups
(Name, Parent, Id) VALUES (@name, @parent, @id)";
cmd.Parameters.AddWithValue("name", "Test");
cmd.Parameters.AddWithValue("parent", DBNull.Value);
cmd.Parameters.AddWithValue("id", Guid.NewGuid());
}
conn.Close();
}
On Sun, May 16, 2010 at 2:44 PM, Ayende Rahien <[email protected]> wrote:
> When you use the provider directly, can you insert to that table?
>
>
> On Sun, May 16, 2010 at 7:44 PM, Ayende Rahien <[email protected]> wrote:
>
>> What _is_ the recommended value for guids in MySQL?
>>
>> I am sorry, never tried RS on MySQL
>>
>> On Sun, May 16, 2010 at 7:38 PM, Nathan Stott <[email protected]> wrote:
>>
>>> The GUID that Rhino Security is generating for the UserGroup. It changes
>>> everytime. Last one was
>>> 47ef19c0-b865-407c-b9ba-9d7800f0acef
>>>
>>>
>>> On Sun, May 16, 2010 at 2:32 PM, Ayende Rahien <[email protected]>wrote:
>>>
>>>> What is the value that it is actually trying to insert/
>>>>
>>>> On Sun, May 16, 2010 at 7:30 PM, Nathan Stott <[email protected]>wrote:
>>>>
>>>>> 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]<rhino-tools-dev%[email protected]>
>>>>> .
>>>>> For more options, visit this group at
>>>>> http://groups.google.com/group/rhino-tools-dev?hl=en.
>>>>>
>>>>
>>>> --
>>>> 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]<rhino-tools-dev%[email protected]>
>>>> .
>>>> For more options, visit this group at
>>>> http://groups.google.com/group/rhino-tools-dev?hl=en.
>>>>
>>>
>>> --
>>> 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]<rhino-tools-dev%[email protected]>
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/rhino-tools-dev?hl=en.
>>>
>>
>>
> --
> 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]<rhino-tools-dev%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/rhino-tools-dev?hl=en.
>
--
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.
