January 2016 - xwiki-users@xwiki.org

Re: [xwiki-users] Fw : Re: getURLContent problem
by Pascal BASTIEN 25 Jan '16

25 Jan '16

Thxs for this log. I tested with wget (through same proxy of my browser) and I obtain a xxxxxxxxx => It's working well with wget too (without option) I tested on my developpment server on ou intranet (through our proxy): $xwiki.getURLContent('https://set7z18fgf.execute-api.us-east-1.amazonaws.com/prod/?route=getClanD…') working. Do you need my log to make it working on myxwiki.org? If yes which one? > The issue is > with the HTTPS protocol used in the URL. > In the logs of myxwiki.org there’s: > Failed to retrieve content from > [https://set7z18fgf.execute-api.us-east-1.amazonaws.com/prod/?route=getClanD…] javax.net.ssl.SSLHandshakeException: > Received fatal alert: handshake_failure > At this point I don’t know > what’s the problem. We’re using httpclient in > getURLContent() which supports HTTP over SSL out of the > box. > Thanks-Vincent > > > > Thxs for your help. > > > > Pascal B > _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

1 0

[xwiki-users] Fw : Re: getURLContent problem
by Pascal BASTIEN 25 Jan '16

25 Jan '16

Thxs for this log. I tested with wget (through same proxy of my browser) and I obtain a "500 Internal Server Error" (I tested with SSLv2, SSLv3, TLSv1, TLSv1_1 and TLSv1_2 protocol) :-/ I tested on my developpment server on ou intranet (through our proxy): $xwiki.getURLContent('https://set7z18fgf.execute-api.us-east-1.amazonaws.com/prod/?route=getClanD…') working. Do you need my log to make it working on myxwiki.org? If yes which one? > The issue is > with the HTTPS protocol used in the URL. > In the logs of myxwiki.org there’s: > Failed to retrieve content from > [https://set7z18fgf.execute-api.us-east-1.amazonaws.com/prod/?route=getClanD…] javax.net.ssl.SSLHandshakeException: > Received fatal alert: handshake_failure > At this point I don’t know > what’s the problem. We’re using httpclient in > getURLContent() which supports HTTP over SSL out of the > box. > Thanks-Vincent > > > > Thxs for your help. > > > > Pascal B >

1 0

[xwiki-users] How to create an XClass and bind to a sheet
by Giordano Ninonà 24 Jan '16

24 Jan '16

Hi users, I am wondering on how to create an XClass from java, and bind it to a class-sheet to be used to represent several objects as XWiki pages. How can I achieve that in a way that allow me to incrementaly update the object every time a modification is performed? Thanks for your help, Giordano.

4 5

[xwiki-users] Page tree stopped working on Main wiki
by Rodrigo Borges Pereira 24 Jan '16

24 Jan '16

Hi, (disclaimer: new user here) I updated from 7.4RC1 to 7.4 (Debian packages, Tomcat7, MySQL). When I click the navigation arrows in the Main wiki, they come up empty. If I create a new wiki, it works fine. What could have happened here? Appreciate any help, thank you! Regards, Rodrigo

5 13

[xwiki-users] getURLContent problem
by Pascal BASTIEN 24 Jan '16

24 Jan '16

Hi, This URL https://set7z18fgf.execute-api.us-east-1.amazonaws.com/prod/?route=getClanD… returns json text but from myxwiki.org this velocity code didn't display json data... $xwiki.getURLContent('https://set7z18fgf.execute-api.us-east-1.amazonaws.com/prod/?route=getClanD…') Could you tell me if the internet domain is forbidden from myxwiki.org? May be I must escape some characters? Thxs for your help. Pascal B

2 1

[xwiki-users] SQL Error after upgrade to 7.4
by Michael Farrell 22 Jan '16

22 Jan '16

Hi, After upgrading to 7.4 from 7.2, the ‘Pages in <spacename>’ on the Dashboard page never finish loading. This error only appears on new spaces. Existing spaces load fine. postgres syslog Jan 22 05:46:54 perch postgres[13210]: [1487-3] DETAIL: parameters: $1 = 'test4', $2 = 'test4.%', $3 = 'dummy', $4 = 'xwiki', $5 = 'xwiki:XWiki.mfarrell', $6 = 'xwiki:XWiki.mfarrell^XWiki.XWikiUsers', $7 = 'xwiki:Main.LDAPFrigoff^XWiki.XWikiGroups', $8 = 'xwiki:Main.LDAPUsers^XWiki.XWikiGroups', $9 = 'xwiki:Main.LDAPAdmin^XWiki.XWikiGroups', $10 = '20' Jan 22 05:46:56 perch postgres[13210]: [1488-1] ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list at character 505 Jan 22 05:46:56 perch postgres[13210]: [1488-2] STATEMENT: select distinct case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end as col_0_0_, case when xwikispace1_.XWS_PARENT='test4' then 0 else 1 end as col_1_0_ from xwikidoc xwikidocum0_ cross join xwikispace xwikispace1_ where xwikispace1_.XWS_HIDDEN<>true and (xwikidocum0_.XWD_HIDDEN<>true or xwikidocum0_.XWD_HIDDEN is null) and (xwikispace1_.XWS_PARENT=$1 or xwikidocum0_.XWD_WEB=$2 and xwikidocum0_.XWD_TRANSLATION=0 and xwikidocum0_.XWD_NAME<>$3) order by lower(case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end), case when xwikispace1_.XWS_PARENT='test4' then xwikispace1_.XWS_NAME else xwikidocum0_.XWD_NAME end limit $4 catalina.out 2016-01-22 05:46:56,315 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… <https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…>] WARN o.h.u.JDBCExceptionReporter - SQL Error: 0, SQLState: 42P10 2016-01-22 05:46:56,327 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… <https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…>] ERROR o.h.u.JDBCExceptionReporter - ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list Position: 505 2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… <https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…>] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #addNestedChildDocuments called at 63:xwiki:XWiki.DocumentTree[line 440, column 1] 2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… <https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…>] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #addChildDocuments called at 63:xwiki:XWiki.DocumentTree[line 626, column 1] 2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… <https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…>] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #addDocumentChildren called at 63:xwiki:XWiki.DocumentTree[line 1, column 1] 2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… <https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…>] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #getChildren called at 63:xwiki:XWiki.DocumentTree[line 39, column 1] 2016-01-22 05:46:56,328 [https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta… <https://xwiki.rockafarrell.com/xwiki/bin/get/XWiki/DocumentTree?outputSynta…>] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #handleDocumentTreeRequest called at 63:xwiki:XWiki.DocumentTree[line 3, column 1]

2 1

[xwiki-users] Fw : Re: Fw : Fw : Re: Fw : Re: Fw : Re: How can I get event object through a form
by Pascal BASTIEN 22 Jan '16

22 Jan '16

> Anyway, how do you found default alias of table name > then? > > By example the alias "act" in my hql string here > "act.eventId" (I found it by chance in error > log) > > #set($results= > $xwiki.activitystream.searchEvents("act.eventId in > ($ListIn)", false, 0, 0)) > > Here i suppose? https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwi… > > Yes. The API is not optimal, I > agree, and it was not really improved along the years. ha ha i never said that! If alias and field name, usable in hql query, are documented it doesn't matter :-) Thxs for ur help

1 0

[xwiki-users] Migrating from 3.5 to 6.4
by Gaurav Gupta 22 Jan '16

22 Jan '16

I am migrating the xwiki installation from 3.5 to 6.4. I followed the upgradation steps and found the best way to upgrade is to install 6.4 war file create an empty db and and hit the xwiki url which would create the db schema and then launches the distribution wizard which is used to install 6.4 ui and xar After this login as admin and import the 3.5 xar file in new installation which I exported from existing installation The important thing to note is I had to manually select the required space/pages customized panels themes and users specific to my project from older xar Please let know whether this the best way or any other way to upgrade my xwiki Awaiting your response on this.. Regards Gaurav

1 0

Re: [xwiki-users] Fw : Fw : Re: Fw : Re: Fw : Re: How can I get event object through a form
by Pascal BASTIEN 22 Jan '16

22 Jan '16

Thxs => useful links bookmarked :-) Anyway, how do you found default alias of table name then? By example the alias "act" in my hql string here "act.eventId" (I found it by chance in error log) #set($results= $xwiki.activitystream.searchEvents("act.eventId in ($ListIn)", false, 0, 0)) Here i suppose? https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwi… -------------------------------------------- En date de : Mer 20.1.16, Eduard Moraru <enygma2002(a)gmail.com> a écrit : Objet: Re: [xwiki-users] Fw : Fw : Re: Fw : Re: Fw : Re: How can I get event object through a form À: "Pascal BASTIEN" <pbasnews-xwiki(a)yahoo.fr>, "XWiki Users" <users(a)xwiki.org> Date: Mercredi 20 janvier 2016, 16h36 Hi, This is the activitystream hibernate mapping where you can see the exact property names: https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwi… ...and this is the regular XWiki model mapping (corresponding to the other tables observed in http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema ) https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwi… Remember that, when writing HQL, you need to look at the hibernate mapping, not just the SQL database schema (which is useful, but can be misleading). Thanks, Eduard

2 1

[xwiki-users] document library
by Paul Pinkerton (ACLCO) 22 Jan '16

22 Jan '16

We are using a SharePoint site to house a document library. I'd like to move this into our xwiki site, but haven't figured out how to configure pages in a way that would make this viable. We use lists in SP - so people can add documents and when they upload them, they need to add in fields such as a description of the document and notes, usually related to when the document was current as of. The site auto adds in who uploaded it. While I can add pages that use the Attachment macro and that makes it easy to display documents, it’s the extra fields that make the information more valuable - and that's the functionality I'd be interested in. One thought I had was to use a form which would then populate a table, but not sure if that's a truly workable solution. Thoughts or ideas would be welcomed! Paul Pinkerton KnowledgeNow Project/ ACLCO

4 3