November 2005 - xwiki-users@xwiki.org

Install breakage on Windows XP
by J B Bell 16 Nov '05

16 Nov '05

Hi folks, Mainly just for playing around, I installed xwiki on my Windows XP desktop. I'm using the SDK 1.4.2_10, MySQL 5, and the latest release of xwiki ( 0.9.840). Oh, and Tomcat v. 4.1. Got the database goin OK, and Tomcat, and put xwiki in the webapps dir., but when I try to browse to, e.g., http://localhost:8080/xwiki/bin/view/WebHome, I get a very long error (included after my signature), the crux of which seems to be "Could not execute JDBC batch update". Per the suggestion on the install page, I have tried moving the jta.jar file either into .../webapps/xwiki/WEB-INF/lib or into .../common/lib (the main Tomcat library directory). If I move xwiki's jta.jar into Tomcat's, I simply get connection refused errors. If I move Tomcat's jta.jar into xwiki's, every URL shows up as unavailable. Any clues what the problem might be? --JB

3 5

Error Installing Xwiki
by ikoga＠ig.com.br 10 Nov '05

10 Nov '05

Hi All, I'm a new user in xwiki and i recently installed it. One error appeared in the "news" in the main page. The error is: Error number 4001 in 4: Error while parsing velocity page Main.WebHome Wrapped Exception: Invocation of method 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception class com.xpn.xwiki.XWikiException : Error number 3223 in 3: Exception while searching documents with sql , BaseObject as obj where obj.name=doc.fullName and obj.className='XWiki.ArticleClass' and obj.name<>'XWiki.ArticleClassTemplate' order by doc.creationDate desc Wrapped Exception: could not execute query Probabily it isn't only in the news page but in another place too. Does anyone knows how to correct it? Thank's in advance Ivan Koga

3 2

[MySQL] Database Dump 0.9.2
by moloch lists 10 Nov '05

10 Nov '05

Hi, I am having such trouble importing the mysql dump 0.9.2 into my mysql database. I am working from the installation instructions found at xwiki here: [http://www.xwiki.org/xwiki/bin/view/AdminGuide/Linux+Tomcat+MySQL] I have successfully created an xwiki database instance in my mysql database, created the user and granted the user rights over the xwiki database. The instructions indicate that next I should Download the xwiki-db .zip file and use it to import the required data into my xwiki database using the example command line command as shown. [Download xwiki-db-x.zip and unzip it. Import the mysql dump into the 'xwiki' database using "mysql -u xwiki -pxwiki xwiki < xwiki-db-x.txt" from command prompt] First problem is that the xwiki-db.0.9.2.zip file contains a .sql file, not a .txt file. I assume that the instructions have not been updated to reflect with the new mysql database dump. Secondly I am unable to import this data into my mysql database. I am running Suse9.1 and mysql Ver 12.22 Distrib 4.0.18. I tried the above instruction, to import the dump as: mysql -u xwiki -pxwiki xwiki < xwiki-db-0.9.2.sql I get this error ERROR 1064 at line 21: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 11 I tried to do a mysqlimport but this would obviously never work since "The base name of the text file must be the name of the table that should be used." I get an error mysqlimport: Error: Table 'xwiki.xwiki' doesn't exist, when using table: xwiki I have also tried the mysql control center without much success. It also complains about the SQL sytnax. Any assistance would be greatly appreciated. Many thanks Moloch.

3 2

Bug-Key XWIKI-181
by Ralph Wetter 08 Nov '05

08 Nov '05

Hello I've just installed xwiki 0.9.840 on SUSE-Linux 9.0 with mySql 4.0.15 and tomcat 4.1.27. That worked fine. xwiki runs well and realy seems to be a great product! But one thing "drives me crazy" : The Bug XWIKI-181: When editing Menu and Toolbar changes are reflected on save, but on reediting original content is presented not the previous one. Example: Original Toolbar content: 1.1 Search Change it to : 1.1 Search for. Save it: I see "Search for" in render view Edit page again, I see "1.1 Search" no "1.1 Search for". This Bug comes with every edit-dialog. I woud like to create my xwiki-content but with this bug this is simply not possible. Even a tomcat-restart or a "xwiki-cache-flush" doesn't help :'( Is there some kind of "work around"? Greetings Ralph

2 2

Help with LDAP configuration
by wb＠zootweb.com 08 Nov '05

08 Nov '05

Does anyone have any suggestions for me on what I might be missing getting xwiki integrated with my open-ldap? I've added the following to xwiki.cfg, then no users (including Admin) have the ability to log in. I've tried both existing xwiki users and non-existing xwiki users, and neither work: xwiki.authentication.ldap=1 xwiki.authentication.ldap.server=ldaphost xwiki.authentication.ldap.port=389 xwiki.authentication.ldap.base_DN=ou=People,dc=mydomain,dc=com xwiki.authentication.ldap.UID_attr=uid My LDAP administrator didn't think I needed any settings for the following configuration options, so these are currently commented out: > #xwiki.authentication.ldap.check_level > #xwiki.authentication.ldap.bind_DN > #xwiki.authentication.ldap.bind_pass > #xwiki.authentication.ldap.fields_mapping Any assistance is appreciated.

5 4

Xwiki and Geronimo
by andre.fleischer＠lhsystems.com 03 Nov '05

03 Nov '05

Hi, Did anyone tried to install xwiki on geronimo ? Kind regards André

2 1

AssertionFailure
by andre.fleischer＠lhsystems.com 03 Nov '05

03 Nov '05

Hi I just installed xwiki 0.9.840, my environment is Tomcat 5.5.9 and MySQL 5.0.15 with the latest JDBC-Connector. I got the following exception. I searched around but did not find a solution. Any ideas ? 12:06:22,311 ERROR http-8080-Processor25 http://localhost:8080/xwiki/bin/view/Main/WebHome AssertionFailure:<init>:22 - an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session) org.hibernate.AssertionFailure: possible nonthreadsafe access to session at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:68) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:726) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:320) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86) at com.xpn.xwiki.store.XWikiHibernateStore.endTransaction(XWikiHibernateStore.java:350) at com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiCollection(XWikiHibernateStore.java:982) at com.xpn.xwiki.stats.impl.XWikiStatsServiceImpl.notify(XWikiStatsServiceImpl.java:209) at com.xpn.xwiki.notify.XWikiActionRule.verify(XWikiActionRule.java:51) at com.xpn.xwiki.notify.XWikiNotificationManager.verify(XWikiNotificationManager.java:93) at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:268) 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(Thread.java:595) Kind regards André

2 1

Attach big document
by Xavier MOGHRABI 03 Nov '05

03 Nov '05

Hi I'd like to attach big document to a XWiki page. But If the doc is bigger than 1MB it fails with the following message : java.sql.BatchUpdateException: Packet for query is too large (2152630 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. It seems that it exists a parameter to allow the insertion in the database of document bigger that 1 048 576 B. Does someone know where I should add this param ? BTW, I use MySQL 4.1 over GNU/Linux. Thanks in advance -- Xavier MOGHRABI - Consortium ObjectWeb Email: xavier.moghrabi at objectweb.org Phone: +33 4 76 61 52 35

2 2

Building Form with File upload
by Xavier MOGHRABI 02 Nov '05

02 Nov '05

Hi I'd like to add in a form the possibility for users to upload file. My form look like this one : <form action="" enctype="mutipart/form-data" method="post"> <input type="text" name="submitter" /> <input type="file" name="file" /> <input type="submit" /> </form> The problem I have is with xWiki to get the data from the $request object and handle them by using Velocity. After I'd like to store the uploaded file as attachment in a document. If someone of yours have already done that I'm interesting in getting a such example. By the way, I've noticed that there is a plugin called FileUpload in XWiki. I think it would be great to use it because uploaded file handling is not really handy, but I don't know how to use it within the wiki. Thanks. -- Xavier MOGHRABI - Consortium ObjectWeb Email: xavier.moghrabi at objectweb.org

2 3

scripting help, getObject
by kenk＠ucar.edu 02 Nov '05

02 Nov '05

Hi, I would like some direction in learning to understand things like this (code I found in your demo database): #set($obj = $doc.getObject("XWiki.FAQClass","language",$language, true)) #set($class = $obj.xWikiClass) #foreach($prop in $class.properties) 1.1 ${prop.prettyName}: $doc.display($prop.getName(), "rendered", $obj) <br /> #end ...will I have to look at the code to understand usage on things like "XWiki.FAQClass.properties" in my scripts? Or is there another resource? The above works, but what I really want to do is modify that code to loop thru the objects present in a "table" such as "Blog.Categories" that came with demo. ...But in a nested loop: #set($obj = $doc.getObject("XWiki.MyTable","language",$language, true)) #set($class = $obj.xWikiClass) <--- what is this? #foreach(...object in that class??...) 1 ${...thatObject.Name} #set ($sql = ", BaseObject as obj where obj.name=CONCAT(XWD_WEB,'.',XWD_NAME) and obj.className='Csdg.ArticleClass' and obj.name<>'Csdg.ArticleClassTemplate'") #foreach ($item in $xwiki.searchDocuments($sql)) #set($bentrydoc = $xwiki.getDocument($item)) #set($bentryobj = $bentrydoc.getObject("Csdg.ArticleClass", "language", $language, true)) #if (${bentrydoc.display("audience","view", $bentryobj)} == "Users") * [$item] #end #end #end ...I'm not sure how much help to expect with this, but any comment would be great. thank you in adv. -Ken

2 2