Hello
I find good search to list user:
for(du in xwiki.search("select doc from XWikiDocument doc, BaseObject
obj where obj.name = doc.fullName and obj.className =
'XWiki.XWikiUsers' order by doc.fullName")) {
print du
}
And that list all users without case insensitive in oposition of
xwiki.wrapDocs(xwiki.searchDocuments())
Arnaud.
2009/9/25 Arnaud bourree <arnaud.bour...@gmail.com>:
> 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 <arnaud.bour...@gmail.com>:
>> 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 <arnaud.bour...@gmail.com>:
>>> 2009/9/24 Vincent Massol <vinc...@massol.net>:
>>>> 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 <oana.tabar...@xwiki.com>:
>>>>>> 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
>>>> users@xwiki.org
>>>> http://lists.xwiki.org/mailman/listinfo/users
>>>>
>>>
>>
>
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
