February 2012 - xwiki-users@xwiki.org

[xwiki-users] Problems with Livetable Macro on MsSql database
by Richard Hierlmeier 14 Feb '12

14 Feb '12

Hi users, I installed xwiki-3.3.1 using MsSql. I works quite well. I found only one problem. The lifetable marco in the document index page does not work. In the log file I found the following logs: 2012-02-14 08:50:41,161 ERROR [http://cloud12-288:8080/xwiki/bin/get/XWiki/LiveTableResults?outputSyntax=p…] o.h.u.JDBCExceptionReporter [JDBCExceptionReporter.java:234] Fehler beim Konvertieren des varchar-Datentyps in float. The jdbc error message is in German, because it is the german jdbc driver. Translated into english it means Error: Cannot convert varchar datatype into float Can someone help me. Is it an error on the jdbc level or is it a problem of the life table marco? Richard

1 0

Re: [xwiki-users] Workspaces and group management
by Dmitry Bakbardin 13 Feb '12

13 Feb '12

Hi, All, again! I found very strange IMO behaviour of access rights in 3.4 XEM. How to reproduce: 1) Clean installation of 3.4 XEM 2) Default Admin creates "test" workspace 14 февраля 2012, 00:04 от Dmitry Bakbardin <haru_mamburu(a)mail.ru>: Hi, For now owner can invite users to workspace. Is there any possibility to invite GROUPS? I need following scenario: - Main Wiki Group A, B, C - Workspace "One" invites Group A, B and denies Group C to see workspace "One" - I register a new user and add it to group A - This user AUTOMATICALLY gains access/invitation to workspace. - I delete user from the Group A and user is rejected by workspace "one" also automatically Is there any simple way to do this? Kind regards, Dmitry Kind regards, Dmitry

1 0

Re: [xwiki-users] Performance tuning for growing wiki
by goldring, richard 13 Feb '12

13 Feb '12

Hi Andrey, You're running using Jetty and HSQL? I had similar problems and eventually moved to Apache Tomcat and MySQL which are more memory efficient - suggest you to the same although I don't lnow if there is another way but I exported my pages to .xar files which I had to break into small .xar file in order to reimport into my new xwiki on Tomcat and MySql (I kept the two installations running until we were happy we had copied everything across ... This process wasn't easy! Hope that helps. Regards, Richard -----Original Message----- From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Crowd Covered Sent: 13 February 2012 17:21 To: users(a)xwiki.org Subject: [xwiki-users] Performance tuning for growing wiki Hi guys, Thanks again for great collaborative tool! We currently have about 1200 pages inside, many with objects, where several people search/read/edit info every day. And we are experiencing performance problems - at least once a day, sometimes more often wiki becomes unresponsive for 3-10 minutes while having high CPU load (my guess is either page file swapping or garbage collection by JVM), Out Of Memory errors becoming more often (sometimes wiki is stable for 1-2 weeks, sometimes fails several times a day). Additionally we've got repeating problems even with quite small attachments 500Kb-2Mb (I am aware of x27 DB storage trouble) According to recommendation in guides and some talks on the Internet I tend to try database tuning or change. Could you please recommend a good candidate among freely available databases or even give a hints on HSQLDB tuning (maybe changing default memory mode to cached)? I've taken a look at H2 vs. HSQLDB comparison but there are quite controversial opinions... Current servlet container configuration is -Xms700m -Xmx700m, no tuning for database, computer is a virtual machine on a farm with 2 GHz CPU and 1 Gb RAM. BTW, is this in general expected behavior for such configuration? Many thanks, Andrey _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

6 6

[xwiki-users] Performance tuning for growing wiki
by Crowd Covered 13 Feb '12

13 Feb '12

Hi guys, Thanks again for great collaborative tool! We currently have about 1200 pages inside, many with objects, where several people search/read/edit info every day. And we are experiencing performance problems - at least once a day, sometimes more often wiki becomes unresponsive for 3-10 minutes while having high CPU load (my guess is either page file swapping or garbage collection by JVM), Out Of Memory errors becoming more often (sometimes wiki is stable for 1-2 weeks, sometimes fails several times a day). Additionally we've got repeating problems even with quite small attachments 500Kb-2Mb (I am aware of x27 DB storage trouble) According to recommendation in guides and some talks on the Internet I tend to try database tuning or change. Could you please recommend a good candidate among freely available databases or even give a hints on HSQLDB tuning (maybe changing default memory mode to cached)? I've taken a look at H2 vs. HSQLDB comparison but there are quite controversial opinions... Current servlet container configuration is -Xms700m -Xmx700m, no tuning for database, computer is a virtual machine on a farm with 2 GHz CPU and 1 Gb RAM. BTW, is this in general expected behavior for such configuration? Many thanks, Andrey

2 1

[xwiki-users] XWiki 3.4, error when exporting PDF
by Ari 13 Feb '12

13 Feb '12

I try to generate PDF from XWiki 3.4. The installation was made from scratch, and imported the documents via XARs from XWiki 3.0.3. >From wiki the error shows as follows: *Detailed information: * * Error number 11015 in 11: Exception while exporting Wrapped Exception: Error number 12002 in 12: Exception while exporting pdf Wrapped Exception: .fop (Permission denied) com.xpn.xwiki.XWikiException: Error number 11015 in 11: Exception while exporting Wrapped Exception: Error number 12002 in 12: Exception while exporting pdf Wrapped Exception: .fop (Permission denied) at com.xpn.xwiki.web.ExportAction.render(ExportAction.java:72) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:231) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:964) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:304) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: com.xpn.xwiki.XWikiException: Error number 12002 in 12: Exception while exporting pdf Wrapped Exception: .fop (Permission denied) at com.xpn.xwiki.pdf.impl.PdfExportImpl.createException(PdfExportImpl.java:699) at com.xpn.xwiki.pdf.impl.PdfExportImpl.renderXSLFO(PdfExportImpl.java:468) at com.xpn.xwiki.pdf.impl.PdfExportImpl.exportXHTML(PdfExportImpl.java:402) at com.xpn.xwiki.pdf.impl.PdfExportImpl.exportHtml(PdfExportImpl.java:298) at com.xpn.xwiki.pdf.impl.PdfExportImpl.export(PdfExportImpl.java:279) at com.xpn.xwiki.web.ExportAction.export(ExportAction.java:209) at com.xpn.xwiki.web.ExportAction.render(ExportAction.java:69) ... 39 more * When I dig the tomcat logs, the error seems to be *[WIKUIURL/format=pdf&pdfcover=1&pdfcover=0&pdftoc=1&pdftoc=0&comments=0&attachments=0] WARN c.x.x.p.i.PdfURLFactory - Failed to save image for PDF export java.io.IOException: Failed to create temporary PDF export file with prefix [pdf], suffix [.] in directory [/opt/tomcat/xwiki34/apache-tomcat-7.0.22/work/Catalina/10.10.1.134/xwiki/YfUqLnp5]* However, the directory listed has enough permission for the user which is used when executing the tomcat.. *root@xwiki34:# ls -lah /opt/tomcat/xwiki34/apache-tomcat-7.0.22/work/Catalina/10.10.1.134/xwiki/ drwxr-xr-x 5 tomcatxwiki34 tomcatxwiki34 4.0K Feb 13 09:33 . drwxr-xr-x 8 tomcatxwiki34 tomcatxwiki34 4.0K Feb 3 13:05 .. drwxr-xr-x 2 tomcatxwiki34 tomcatxwiki34 4.0K Feb 3 13:08 charts drwxr-xr-x 2 tomcatxwiki34 tomcatxwiki34 4.0K Feb 3 13:08 svg drwxr-xr-x 4 tomcatxwiki34 tomcatxwiki34 4.0K Feb 3 14:27 xwiki.plugin.image * properties/conf: *xwiki.cfg:xwiki.temp.dir=/tmp/xwiki/ xwiki.cfg:xwiki.tmp.dir=/tmp xwiki.cfg:xwiki.work.dir=/opt/tomcat/xwiki34/xwiki/work-dir* And there is also sufficient permissions in these directories as well.. Is there any advises of where to find more information or how this could be fixed? With Regards, ari

1 0

[xwiki-users] Groovy script to XWiki 2.0 Syntax - constructing URLs
by Ricardo.Julio.Rodriguez.Fernandez＠sergas.es 12 Feb '12

12 Feb '12

Good morning! I'm trying to move a simple script from XWiki 1.0 Syntax to 2.0 one. It includes this lines with which I can easily use SQL to retrieve pages and present a list of URLs to reach those pages: db2 = Sql.newInstance("jdbc:mysql://hostname/schema", "ROuser", "readonly", "com.mysql.jdbc.Driver") List areas = db2.rows('select... println areas.collect{"<a href='../XWiki/${it.XWD_NAME}'>${it.XWD_TITLE}</a>"}.join("<br>") As I'm having problems to include both Velocity (for instance, to control the information panel visibility) and Groovy scripts in the same page when using 1.0 syntax, I'm trying to move it to 2.0. But using the same lines results in that exact text being displayed in the page, but not the URL showed in 1.0 syntax. Please, could you tell me how could I get the same results with XWiki 2.0 syntax? Thanks!!! I know there are a lot of different methods to get the same results within XWiki, but using SQL in this case is useful to me now as kind of probe of concept showing how easily could we link to "external" datasources by using XWiki. -- Ricardo Rodríguez Research Management and Promotion Technician Health Research Institute of Santiago de Compostela (IDIS) http://www.idisantiago.es Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia desta mensaxe non está autorizada. Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o copia de este mensaje no está autorizada. See more languages: http://www.sergas.es/aviso_confidencialidad.htm

3 7

Re: [xwiki-users] IE bug with top menu
by Dmitry Bakbardin 12 Feb '12

12 Feb '12

Hi, Sorin, This bug was reproduced by many customers, they couldn't find LogOut link, that was the reason of investigation :-) I recommended to start from cache clearance, it was useless. Actually it works, all menus are in right places, but invisible. It was XWiki 3.4 on server under Centos and Tomcat. I made the same test with Windows standalone XWiki. The results you can see at image attached (not logged in). Just unpack zip, run XWiki and load default Main Page. BUT, If you will compare with LOGIN page, it works correctly somehow. To get this page working, you have to uncheck the right of unregistered users to view page and restrict access to any page regardless to rights. After logout you would see correct page (see image). IE is a mysterious creature. :-) By the way, this bug was reported also in IE 8 :-( Hope it helps, Kind regards, Dmitry 08 февраля 2012, 18:04 от Sorin Burjan <sorin.burjan(a)xwiki.com>: Hello Haru, I have tried a XE 3.4 final on Windows + IE9 and it worked. I have cleared the cache, and both compatibility mode and normal mode worked for me. I can see the logout button also. Can you give more details about your problem ? Or maybe exact steps to reproduce. Regards, Sorin B. On Wed, Feb 8, 2012 at 12:15 AM, Haru Mamburu <haru_mamburu(a)mail.ru> wrote: Actually the very fast solution is to turn on "compatibility mode" in IE 9. It works finally, but it's a problem still :-) 08 февраля 2012, 00:02 от Haru Mamburu <haru_mamburu(a)mail.ru>: Hi! XE 3.4. IE 9 gives interesting bug: it doesn't show top menu. It exists, even works, but invisible. So, users can't find logout button :-( http://jira.xwiki.org/browse/XWIKI-7496 Does anyone has a clue how to fix it fast? Kind regards, Dmitry _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users Kind regards, Dmitry ---------------------------------------------------------------------- Kind regards, Dmitry

2 1

[xwiki-users] using DateTime Picker from AppWithinMinutes Application
by Eugen Colesnicov 12 Feb '12

12 Feb '12

Hello everybody! How is it possible to use DateTime Picker from AppWithinMinutes Application on demand? For example - inside application, created based on old sheet system? I checked code AppWithinMinutes - I founded page Date and this page includes related javasript extention. But I cannon understand how I can use it. I tried to write jsx.use... and ssx.use... inside my sheet - but without result - calendar picker didn't show. -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/using-DateTime-Picker-from-AppWithinMinut… Sent from the XWiki- Users mailing list archive at Nabble.com.

2 2

[xwiki-users] Problem upgrading from 2.0 to 3.4 with Postgresql Part 1
by Bryan Montgomery 10 Feb '12

10 Feb '12

Hello, I recently tried upgrading a lightly used wiki to Enterprise 3.4. The initial problem I ran in to was complaining about long. I was able to find several google items on this and by extracting xwiki.hbm.xml was able to get beyond this. However trying to import svn.xva, I get: PSQLException: ERROR: column "xwa_content" is of type bytea but expression is of type bigint Hint: You will need to rewrite or cast the expression. Position: 67 I have tried with the original 8.2 postgres but also with 8.4 and the latest stable jdbc driver. Google only gave me one hit on this and there the issue wasn't solved. Any thoughts? Thanks - Bryan.

1 0

[xwiki-users] AdministrationSearch||Configuration
by mohit gupta 09 Feb '12

09 Feb '12

Hi All, in the administration search configuration i see two options for *Search engine to use* i.e Lucene and database. Could anyone brief which one is better(probably advantages/disadvantages)? and what changes i need to do as administrator/developer if i want to switch from one option to another?

2 1