OK, I find MySql configuration here http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Encoding I just change for MySql configuration utf8_general_ci into utf8_binary => My wiki is now broken (by chance it is test instance)
Does it mean that I have to restore my previous MYSql configuration, dump db, change conf to utf8_binary and import back db? Arnaud. 2009/9/25 Arnaud bourree <[email protected]>: > 1/ I don't find any how to configure my MySQL db to be case sensitive > on query with natural language. > > 2/ I don't understand how I can have to page: XWiki.jdoe and > XWiki.JDOE if my query are case insensitive > It should not be able to create 2nd user. > I just made the test on fresh install of XWiki 2.0RC2: > - I register jdoe, I'm able to login as jdoe > - I try to register jdoe again, it is forbidden > - I register JDOE (not forbidden), I'm able to login as JDOE but no > more as jdoe > - I try again my groovy code to list users: only jdoe is listed > > Should I create a bug in Jira? > > Arnaud. > > 2009/9/24 Arnaud bourree <[email protected]>: >> 2009/9/24 Vincent Massol <[email protected]>: >>> Hi Arnaud, >>> >>> On Sep 24, 2009, at 5:51 PM, Arnaud bourree wrote: >>> >>>> Hello, >>>> >>>> I test it also in velocity without success. >>>> I try an other code >>>> {{groovy}} >>>> def sql = "" >>>> count = 0 >>>> for (item in xwiki.searchDocuments(sql)) { >>>> u = xwiki.getDocument(item) >>>> xu = u.getObject('XWikiUsers') >>>> if (null == xu) continue >>>> count++ >>>> print item+"\n" >>>> } >>>> print "**Total "+count+"**\n" >>>> {{/groovy}} >>>> >>>> I still not found jdoe >>>> But if I edit XWiki.jdoe page in object mode there is XWikiUsers >>>> object !!! >>> >>> My take is that you're using MySQL as the database and in default mode >>> which doesn't differentiate lowercase and uppercase. >>> >>> Could that be it? >>> >>> Thanks >>> -Vincent >>> >> Yes it is MySQL >> I will check its configuration tomorrow >> >> But I just google it and find that on *nix system (like I am), table >> name are case sensitive: I don't need to configure it >> And query looks to be case sensitive excepted for natural language >> where additional keyword it's needed >> >> What it is the configuration to be sure that query will be case >> sensitive (natural language included)? >> >> Arnaud >> >>>> Arnaud. >>>> >>>> 2009/9/24 Oana Tabaranu <[email protected]>: >>>>> Hi Arnaud, >>>>> >>>>> I have tested your query in velocity and it works fine for me: >>>>> #set($users =$xwiki.searchDocuments(", BaseObject obj where >>>>> obj.name = >>>>> doc.fullName and obj.className = 'XWiki.XWikiUsers' and >>>>> doc.fullName <> >>>>> 'XWiki.Admin' and doc.fullName <> 'XWiki.TEST' and doc.fullName <> >>>>> 'XWiki.dummy'")) >>>>> #foreach ($u in $users) >>>>> $u >>>>> #end >>>>> My result is: >>>>> XWiki.JDOE >>>>> XWiki.jdoe >>>>> >>>>> Oana >>>>> >>>>> Arnaud bourree wrote: >>>>>> Hello, >>>>>> >>>>>> I'm building a migration to LDAP page for my company on one XWiki >>>>>> 2.0 >>>>>> RC1 instance. >>>>>> For this I need to list all users registered in. >>>>>> I used the following code to list users: >>>>>> for(u in xwiki.wrapDocs(xwiki.searchDocuments(", BaseObject obj >>>>>> where >>>>>> obj.name = doc.fullName and obj.className = 'XWiki.XWikiUsers' and >>>>>> doc.fullName <> 'XWiki.Admin' and doc.fullName <> 'XWiki.TEST' and >>>>>> doc.fullName <> 'XWiki.dummy'"))) { >>>>>> ... >>>>>> } >>>>>> >>>>>> That looks good, most of my users are listed. >>>>>> But at least one user is missing: one user register as JDOE one time >>>>>> and one other time as jdoe >>>>>> So there are two John Doe users: XWiki.jdoe and XWiki.JDOE but my >>>>>> loop >>>>>> only find JDOE and not jdoe >>>>>> >>>>>> What it is wrong in my request? >>>>>> >>>>>> Arnaud. >>> _______________________________________________ >>> users mailing list >>> [email protected] >>> http://lists.xwiki.org/mailman/listinfo/users >>> >> > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
