October 2005 - xwiki-users@xwiki.org

Using HibernateQL in XWiki ?
by Xavier MOGHRABI 18 Oct '05

18 Oct '05

Hi, I'd like to do a kind of SQL request with XWiki in order to get a data store in an Object. Here's my problem : 1 I've created a Class in XWiki in order to create a form for users. In this class I've named one of a property ID that should allow me to distinct objects. 2. I've created a template associated to this class that contain a single Object of this class. 3. I've created a Form to allow users to fill the data. The problem I have is that I have to give a unique name for the document created. Thus I thought to use to ID property that I've created. So I wanted to do a SQL Query to get the maximum id and by this way my new document name would be Data.Doc"ID+1". The problem is that I don't know how to access the desired property with XWiki. I've read the documentation about the data model : http://www.xwiki.org/xwiki/bin/view/DevGuide/Database+Schema but I didn't find the solution to my problem. If I execute the following Query (my class is XWiki.CFPClass): #set ($sql = "select distinct obj from XWikiDocument as doc, BaseObject as obj where obj.name=doc.fullName and obj.className='XWiki.CFPClass' and doc.name!='CFPClassTemplate'") with this code : #foreach ($item in $xwiki.search($sql)) $item <br /> #end I get fine my objects : CFP.Test 0 XWiki.CFPClass CFP.Test1 0 XWiki.CFPClass But I don't know how can I reach the property ? The property class seems to be 'BaseProperty' but I don't know how can I add it with the query. if I test a query like this : select distinct prop.name from XWikiDocument as doc, BaseObject as obj, BaseProperty as prop where obj.name=doc.fullName and obj.className='XWiki.CFPClass' and doc.name!='CFPClassTemplate' I get all the existing properties even the ones which aren't in the class XWiki.CFPClass. Any Idea ? -- Xavier MOGHRABI - Consortium ObjectWeb Email: xavier.moghrabi at objectweb.org Phone: +33 4 76 61 52 35 - Skype ID: xavier.moghrabi.bureau

2 2

xwiki formatting question
by Tim Suter 14 Oct '05

14 Oct '05

In moving content over from our Zope driven site, I have noticed that several times the content of the Zope page creeps into the right margin and pollutes the Search column. Is there a global setting that will change the XWiki format so that it will auto adjust for the content? With the Toolbar editor, I am sure I could remove the whole column, however I don't want to. Just make it allow for content so it will shift to the right automagically. Thanks, Tim Suter

2 3

How To Setup Virtual Wikis
by Xavier MOGHRABI 11 Oct '05

11 Oct '05

Hi, I try to set up virtual wikis by following the documentation : http://www.xwiki.com/xwiki/bin/view/Doc/HowToSetupVirtualWikis However when I went to the page XWiki.XWikiServerClass, I got the following error. I was using xWiki 0.9.840 with UTF-8 configuration : Error number 0 in 11: Uncaught exception Wrapped Exception: String index out of range: -7 com.xpn.xwiki.XWikiException: Error number 0 in 11: Uncaught exception Wrapped Exception: String index out of range: -7 at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:224) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run()V(Unknown Source) Wrapped Exception: java.lang.StringIndexOutOfBoundsException: String index out of range: -7 at java.lang.String.substring(II)Ljava.lang.String;(Unknown Source) at com.xpn.xwiki.XWiki.getDocumentFromPath(XWiki.java:627) at com.xpn.xwiki.XWiki.prepareDocuments(XWiki.java:2428) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:133) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run()V(Unknown Source) Any clue ? -- Xavier MOGHRABI - Consortium ObjectWeb Email: xavier.moghrabi at objectweb.org Phone: +33 4 76 61 52 35 - Skype ID: xavier.moghrabi.bureau

4 7

Cookie issue with username length
by Stéphane Laurière 10 Oct '05

10 Oct '05

Hi everybody, I have this issue with usernames: it appears that too long logins prevent users from logging in. What is the actual limit for login names, and is there a way to extend it? As a test I have registered on xwiki.org a user with a username having 100 characters, and they cannot login indeed. Locally I see the user is correctly authentified, but then there's a problem with the cookie. Here's the trace I get: ============== !remember-me cookie validation hash mismatch! !remember-me cookie has been tampered with! !remember-me cookie is being deleted! ============== That's a problem for me as my logins are based on the email address, and some have a length of 100 characters. Stéphane -- Stéphane Laurière slauriere(a)mandriva.com http://club.mandriva.com

1 0

MySQL communication link failure
by Stéphane Laurière 10 Oct '05

10 Oct '05

While trying to upgrade an XWiki installation from 0.9.793 to 0.9.840 I face a MySQL connection problem. My server config: ======= MySQL 4.1.12 Tomcat 5.5.9 JDK 1.5 Mandrake Linux virtual server kernel 2.6.9-vs1.9.3 XWiki runs in non virtual mode URL: http://www.edos-project.org ====== XWiki 0.9.793 works perfectly on that server since a while. When trying to run the 0.9.840 version with the same Hibernate and XWiki configuration files, I get the exception below. MySQL "skip-networking" option is correctly set in /etc/my.cnf. I noticed that the error appears in some of previous XWiki build reports such as this one: http://build.xpertnet.biz/cc/buildresults/xwiki?log=log20050628171819Lbuild… Any hint is welcome! Note: getting a simple connection to MySQL with the lines below works perfectly fine on the server. ====================== String url = "jdbc:mysql://localhost/xwiki"; String username = "xwiki"; String password = "passwd"; Connection conn = DriverManager.getConnection(url, username, password); ====================== Exception when running XWiki webapp: 21:32:16,675 WARN http-80-Processor25 http://www.edos-project.org/xwiki/ Configurator:configure:126 - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/usr/local/tomcat/jakarta-tomcat-5.5.9/webapps/xwiki/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml 21:32:21,112 WARN http-80-Processor25 http://www.edos-project.org/xwiki/ JDBCExceptionReporter:logExceptions:71 - SQL Error: 0, SQLState: 08S01 21:32:21,113 ERROR http-80-Processor25 http://www.edos-project.org/xwiki/ JDBCExceptionReporter:logExceptions:72 - Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1842) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2288) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2784) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1347) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:958) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) at org.hibernate.loader.Loader.getResultSet(Loader.java:1239) at org.hibernate.loader.Loader.doQuery(Loader.java:374) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210) at org.hibernate.loader.Loader.doList(Loader.java:1562) at org.hibernate.loader.Loader.list(Loader.java:1545) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) ============================ -- Stéphane Laurière slauriere(a)mandriva.com Mandriva Club - http://club.mandriva.com Mandrakesoft becomes Mandriva!

2 4

JBoss 4.0.2 Postgresql 8.0.3 Debian Sarge AMD64
by Joost Kraaijeveld 10 Oct '05

10 Oct '05

Hi, I have followed the installation instructions but for some reason I do not understand I get the following exception: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiPreferences Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:142) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:202) com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:117) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) javax.servlet.http.HttpServlet.service(HttpServlet.java:697) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) Is there a fool (==me) proof way of installing xwiki with JBoss, PostgreSQL and Debian Sarge AMD64? Is there anyone actually using XWiki with JBoss?? TIA -- Groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 e-mail: J.Kraaijeveld(a)Askesis.nl web: www.askesis.nl

2 2

Serving stand alone VM files
by Matthew Conway 10 Oct '05

10 Oct '05

Is it possible for xwiki to serve a static VM file that is not associated with a document? That is, serve a url like "/xwiki/ foo.vm" and have the velocity evaluated? As a workaround, I can do something like /xwiki/bin/view/XWiki/DummyDoc?xpage=foo.vm but it seems wasteful to have to query the DB to serve a somewhat static file. Matt

2 1

particular page would not save w/o error
by kenk＠ucar.edu 10 Oct '05

10 Oct '05

Hi, I'm using v0.9.842 on tomcat 4.1.31 with j2sdk1.4.2_06 and postgresql 7.3.5: I had been editing and building a page thru the bin/edit function over days without problem, then today it would throw the errors below after every save even tho it still made the changes (most of the time). I tried cutting down the size of the page but finally tried saving a blank page and still got the error so I do not think it was from my mix of wiki syntax and html or html-area generated content that caused the errors. And, during this whole period I was still able to create and edit other pages than the one I had trouble with. I finally deleted the page, and recreated it w/ a different name but same content and it's fine now. I had restarted the db server and tomcat but that had no effect. Does anyone know what this might be? thx in adv -ken here's the generic-looking error: Wrapped Exception: Could not execute JDBC batch update com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document Csdg.WebAppServersAsRPMs Wrapped Exception: Could not execute JDBC batch update at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:540) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:557) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:77) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:560) at com.xpn.xwiki.XWikiService.actionSave(XWikiService.java:445) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:155) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146) [snip] ...sorry at this point I can't do a debug.

2 1

ObjectWeb sucks
by Ron Scott 05 Oct '05

05 Oct '05

I'm sure I'm not the only one who's noticed the outage. Maybe it's time to think about migrating back to sourceforge, or using some other system that's a bit more robust?

2 1

LDAP Authetication working....but...
by Tim Suter 03 Oct '05

03 Oct '05

I got LDAP Authentication working. However, I cannot log in as the xwiki admin. How do I get that log in AND LDAP working at the same time? Also, I need the LDAP users to have editing capabilities and not just be able to view. Thanks, Tim

2 1