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