[xwiki-users] listing all users
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.
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
Hi, Anyone else have problems with myxwiki.org skin? Wei-hsing
On Sep 24, 2009, at 4:58 PM, [email protected] wrote:
Hi, Anyone else have problems with myxwiki.org skin?
We've just upgraded it? Try ctrl+refresh on http://myxwiki.org If you're having pb on a subwiki please let us know. Thanks -Vincent
My site, parents2.myxwiki.org is skinless. Please take a look. -------------- Original message from Vincent Massol <[email protected]>: --------------
On Sep 24, 2009, at 4:58 PM, [email protected] wrote:
Hi, Anyone else have problems with myxwiki.org skin?
We've just upgraded it? Try ctrl+refresh on http://myxwiki.org
If you're having pb on a subwiki please let us know.
Thanks -Vincent
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
Hi, On Sep 24, 2009, at 6:04 PM, [email protected] wrote:
My site, parents2.myxwiki.org is skinless.
This is what I see: http://tinycoke.com/_6rk1A1e9MElKw/picture_1.png The skin is there.... -Vincent
Please take a look.
-------------- Original message from Vincent Massol <[email protected]
: --------------
On Sep 24, 2009, at 4:58 PM, [email protected] wrote:
Hi, Anyone else have problems with myxwiki.org skin?
We've just upgraded it? Try ctrl+refresh on http://myxwiki.org
If you're having pb on a subwiki please let us know.
Thanks -Vincent
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 !!! 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
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
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.
Hi Wang, The problem was that you had forbidden unregistered users from viewing any documents in the XWiki space and since the skin is in that space they couldn't view it... I have modified the permission to allow unreg users to view the XWiki space (this is needed anyone for xwiki to work fine). Thanks -Vincent PS: Consequently the problem you had was not related to the upgrade to the 2.0 version. On Thu, Sep 24, 2009 at 6:15 PM, Vincent Massol <[email protected]> wrote:
Hi,
On Sep 24, 2009, at 6:04 PM, [email protected] wrote:
My site, parents2.myxwiki.org is skinless.
This is what I see: http://tinycoke.com/_6rk1A1e9MElKw/picture_1.png
The skin is there....
-Vincent
Please take a look.
-------------- Original message from Vincent Massol <[email protected]>: --------------
On Sep 24, 2009, at 4:58 PM, [email protected] wrote:
Hi, Anyone else have problems with myxwiki.org skin?
We've just upgraded it? Try ctrl+refresh on http://myxwiki.org
If you're having pb on a subwiki please let us know.
Thanks -Vincent
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
Yes, the skin is back. (to me, it went away for hours) -------------- Original message from Vincent Massol <[email protected]>: --------------
Hi,
On Sep 24, 2009, at 6:04 PM, [email protected] wrote:
My site, parents2.myxwiki.org is skinless.
This is what I see: http://tinycoke.com/_6rk1A1e9MElKw/picture_1.png
The skin is there....
-Vincent
Please take a look.
-------------- Original message from Vincent Massol
: --------------
On Sep 24, 2009, at 4:58 PM, [email protected] wrote:
Hi, Anyone else have problems with myxwiki.org skin?
We've just upgraded it? Try ctrl+refresh on http://myxwiki.org
If you're having pb on a subwiki please let us know.
Thanks -Vincent
users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On Sep 25, 2009, at 4:23 AM, [email protected] wrote:
Yes, the skin is back. (to me, it went away for hours)
See my other mail where I explained the error you made.... (you prevented unregistered users from viewing documents in the XWiki space). Thanks -Vincent
-------------- Original message from Vincent Massol <[email protected]
: --------------
Hi,
On Sep 24, 2009, at 6:04 PM, [email protected] wrote:
My site, parents2.myxwiki.org is skinless.
This is what I see: http://tinycoke.com/_6rk1A1e9MElKw/picture_1.png
The skin is there....
-Vincent
Please take a look.
-------------- Original message from Vincent Massol
: --------------
On Sep 24, 2009, at 4:58 PM, [email protected] wrote:
Hi, Anyone else have problems with myxwiki.org skin?
We've just upgraded it? Try ctrl+refresh on http://myxwiki.org
If you're having pb on a subwiki please let us know.
Thanks -Vincent
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
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
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 <[email protected]>:
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
participants (4)
-
Arnaud bourree -
Oana Tabaranu -
Vincent Massol -
wangwh＠att.net