25 Sep
2009
25 Sep
'09
11:47 a.m.
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:
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
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
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