6 Oct
2009
6 Oct
'09
4:41 p.m.
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.bourree(a)gmail.com>om>:
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.bourree(a)gmail.com>om>:
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.bourree(a)gmail.com>om>:
2009/9/24 Vincent Massol
<vincent(a)massol.net>et>:
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.tabaranu(a)xwiki.com>om>:
>> 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(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users