June 2011 - xwiki-users@xwiki.org

[xwiki-users] [external datasource] Howto
by Nicolas Hernandez 29 Jun '11

29 Jun '11

Hello, I am looking for the best solution to import data from external datasource (mysql), and using it to produce charts. Any idea ? SQL Plugin looks obsolete :-( Thanx for your help -- - Nicolas Hernandez a-n - aleph-networks *manager* http://www.aleph-networks.com

2 1

[xwiki-users] Display Objects help
by Ashtar Communications 29 Jun '11

29 Jun '11

Hi, At the outset - I admit to being a complete and total newbie at this. Apologize for asking what are probably dumb questions - and likely to be lots more than one. Any help people would be willing to give me would be much appreciated. I have been through all the tutorials, the API JavaDoc, and as many examples of code as I could find, but I still can't seem to find anything that looks directly applicable or works when I try to adapt it. What I'm ultimately trying to do seems pretty straightforward. I would like to have a set of pages which each contain structured data that can be modified, added, or deleted one object at a time, and which display in reverse chronological order. I would like each of those objects to be displayed with specific HTML formatting. Eventually, I will also need to be able to interact with those objects using the REST API. My current understanding of the process I need to use to get started is this: 1) Create a new Class (We'll call it "Entry") with specific properties 2) Create the Class Sheet and Template. The Template includes a link to the Class Sheet for displaying instances of the class. 3) Edit the Class Sheet to get the attached objects to display properly 4) Create a new page from the Template, add several instances of the class to it - they should then display on the new page. First two steps are easy - but the first place that I am hung up is figuring out how to get the Class Sheet to display multiple objects of the same class attached to the same page. I have a page with 3 objects of the Entry class attached (with different info in the properties). Ultimately the info and formatting will need to be more complex, but I can't even get the basics to work - this is what I have tried so far: ****START CODE**** #foreach($entry in $doc.getObjects("XWiki.EntryClass")) #foreach($prop in $entry.properties) : $doc.display($prop.getName()) #end #end ****END CODE*** The problem is that this code displays the info for the first object three times, instead of the unique properties for each class. The fact that it displays three times seems to indicate that the loop is correctly going through each object in the document - but it is obviously not incrementing the properties to the next $entry. Sure it's a simple syntax error, but don't know what it is. I also can't tell from the JavaDoc enough about how to use .display() or the properties of a vector to know how to do basic things like display the number of objects or the name of each one. Can't figure out how to interact with objects very well, basically. Side question - Should I be using one object per page and then including pages instead of having multiple objects on one page? I have worked my way through the TOC demo, and it seems that each TOC entry is saved on a separate page - and the livetable macro is then used on the "display" page to populate the table with all the entries. Thank you in advance, Aaron

2 2

[xwiki-users] Template attachments not loaded
by Ramon Gomes Brandão 28 Jun '11

28 Jun '11

Hi, I've created a page template that has some images on it (like different logos according to the document). On the template, I've upload the image and inserted it on wysiwyg option. I used, then, this page on my template provider. When I create a new page from this template, the image seems to be not copied from the template to the new page, and the image is not loaded. Any way to turn around on this? I'm using XE 3.1-M2. Regards, -- * * * * *Ramon Gomes Brandão* *//*

2 2

[xwiki-users] Admin screen errors (TemplateParseException...) on upgrade to 3.1
by Tim Jones 28 Jun '11

28 Jun '11

I have just carefully upgraded a wiki from 2.6 to 3.1 At first glance It seemed to have gone fine, but I noticed velocity errors on the new-style Admin page (XWiki.XWikiPreferences): ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ... Caused by: org.apache.velocity.runtime.parser.TemplateParseException: Encountered "\'checkbox\'" at xwiki:XWiki.AdminSheet[line 231, column 26] Was expecting one of: "," ... ")" ... <WHITESPACE> ... ... ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ (full error message copied below) The result is that none of the administration pages displays properly. Has anyone an idea of what might be causing this problem? Thanks for your help, Tim ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Failed to execute the [velocity] macro org.xwiki.rendering.macro.MacroExecutionException: Failed to evaluate Velocity Macro for content [## Constants: #set($redirectParameter = 'xredirect') #set($nameOfThisDocument = 'XWiki.ConfigurableClass') #* * If this document is saved with programming access or is includeForm'd into a document with programming, we have to * drop programming rights in order for it to run safely because it evaluates potentially untrustworthy code. *### #macro(sandboxDocument) #if($xcontext.hasProgrammingRights()) $xcontext.dropPermissions()## #end #end #* * Any documents which are on the provided list ($documentNames) which are locked by the current user will be unlocked. * If this macro has programming rights, then they are unlocked programmatically, otherwise a javascript tag is * generated with ajax calls to cancel for all of the documents. If there are documents on this list which are not * locked by the current user, then they are ignored. * * @param $documentNames - List<String> - fullNames of documents which should be unlocked if they are locked by the * current user. *### #macro(unlockDocuments $documentNames) #if($documentNames.size() > 0) #set($sql = "doc.fullName=") #foreach($documentName in $documentNames) #set($sql = "${sql}'$documentName' or doc.fullName=") #end ## Trim the dangling ' or doc.fullName=?' #set($sql = $sql.substring(0, $sql.lastIndexOf(' or doc.fullName='))) #set($sql = ", XWikiLock lock where lock.docId=doc.id and lock.userName='$xcontext.getUser()' and (${sql})") #set($namesOfdocumentsToUnlock = $xwiki.searchDocuments($sql)) ## Use ajax and hope the user runs javascript. {{html}} <script type="text/javascript"> document.observe("dom:loaded", function() { #foreach($nameOflockedDocument in $namesOfdocumentsToUnlock) new Ajax.Request("$xwiki.getURL($nameOflockedDocument, 'cancel', 'ajax=1')"); #end }); </script> {{/html}} #end## If output list size > 0 #end #* * Try to determine whether a document was edited by a user who has edit right on this page. This is tricky because * documents are imported with the name XWiki.XWikiGuest who has no access to anything after import. * * @param theDoc - Document who's editor should be checked for edit access on this document. *### #macro(checkDocumentSavedByAuthorizedUser, $docToCheck, $currentDoc, $hasAccess) ## The system is started and the only user is XWikiGuest who has admin right but gives it up when he imports the default ## documents, we are checking to see if this looks like the guest imported the document with the first import. #if($docToCheck.getWiki() == $xcontext.getMainWikiName() && $docToCheck.getVersion() == '1.1' && $docToCheck.getCreator() != $docToCheck.getContentAuthor() && $docToCheck.getContentAuthor() == 'XWiki.XWikiGuest') ## #set($userToCheck = $docToCheck.getCreator()) #else #set($userToCheck = $docToCheck.getAuthor()) #end #set ($hasAccess = $util.null) #setVariable ("$hasAccess" $xwiki.hasAccessLevel('edit', $userToCheck, $currentDoc)) #end #* * Find names of documents which contain objects of the class 'XWiki.ConfigurableClass' * * @param $section - String - Look for apps which specify that they should be configured in this section, * if null or "" then returns them for all sections. * * @param $globaladmin - boolean - If true then we will look for applications which should be configured globally. * * @param $space - String - If not looking for apps which are configured globally, then this is the space where we * will look for apps in. If null or "" or if $globaladmin is true, then all spaces will be * searched. * * @param $outputList - List - The returns from this macro will be put in this list, passing the list as a parameter * a safety measure because macros can't return values. *### #macro(findNamesOfAppsToConfigure, $section, $globaladmin, $space, $outputList) ## Use a parameterized sql query to prevent injection. #set($params = []) #if($section && $section != '') #set($discard = $params.add("$section")) #set($sqlA = ' StringProperty as section,') #set($sqlB = " and section.id=obj.id and section.name='displayInSection' and section.value=?") #else ## Make sure they are "" in case they were set prior to calling the macro. #set($sqlA = '') #set($sqlB = '') #end ## Set up query based on value of $globaladmin #if($globaladmin == true) #set($sqlC = '1') #else #if($space && $space != '') #set($sqlC = '0 and doc.space = ?') #set($discard = $params.add($space)) #else #set($sqlC = '0') #end #end #set($sql = ", BaseObject as obj,$sqlA IntegerProperty as global where " + "doc.fullName=obj.name and obj.className='" + $nameOfThisDocument + "'$sqlB " + "and global.id=obj.id and global.name='configureGlobally' and global.value=$sqlC " + "order by doc.creationDate") ## ## Run the search #set($discard = $outputList.addAll($xwiki.searchDocuments($sql, 0, 0, $params))) ## #end #macro(findCustomSectionsToConfigure $adminMenu) #set ($outputList = []) #set ($global = ($editor == 'globaladmin')) #findNamesOfAppsToConfigure('', $global, $currentSpace, $outputList) #set ($sectionsByName = {}) #set ($categoriesByName = {}) #foreach ($category in $adminMenu) #set ($discard = $categoriesByName.put($category.id, $category)) #foreach ($section in $category.children) #set ($discard = $sectionsByName.put($section.id, $section)) #end #end ## #set ($query = "editor=$escapetool.url(${editor})") #if ($editor != 'globaladmin') #set ($query = $query + "&space=$escapetool.url(${currentSpace})") #end #foreach ($appName in $outputList) ## ## Get the configurable application #set ($app = $xwiki.getDocument($appName)) ## ## If getDocument returns null, then warn the user that they don't have view access to that application. #if (!$app) ! #set ($discard = $appsUserCannotView.add($appName)) #end ## #foreach ($configurableObject in $app.getObjects($nameOfThisDocument)) #set ($displayInSection = $app.getValue('displayInSection', $configurableObject)) ## ## If there is no section for this configurable or if the section cannot be edited, then check if the ## application can be edited by the current user, if so then we display the icon from the current app and ## don't display any message to tell the user they can't edit that section. #if ($sectionsByName.containsKey($displayInSection)) #set ($appSection = $sectionsByName.get($displayInSection)) #set ($appSection.configurable = true) #set ($newSection = false) #else ## ## If there is no section for this configurable, then we will have to add one. #set ($appSection = {'id' : $displayInSection, 'name' : $msg.get("admin.${displayInSection.toLowerCase()}"), 'url': $xwiki.getURL($currentDoc, $adminAction, "${query}&section=$escapetool.url(${displayInSection})"), 'configurable' : true}) #if ($app.getValue('configureGlobally', $configurableObject) != 1) #set ($appSection.perSpace = true) #end #set ($key = "admin.${displayInSection.toLowerCase()}.description") #if ($msg.get($key) != $key) #set ($appSection.description = $msg.get($key)) #end #set ($discard = $sectionsByName.put($displayInSection, $appSection)) #set ($discard = $categoriesByName.get('applications').children.add($appSection)) #set ($newSection = true) #end ## ## If an attachment by the filename iconAttachment exists and is an image #set ($attachment = $app.getAttachment("$!app.getValue('iconAttachment', $configurableObject)")) #if ($attachment && $attachment.isImage()) ## Set the icon for this section as the attachment URL. #set ($appSection.iconReference = "${appName}(a)${attachment.getFilename()}") #elseif(!$appSection.iconReference) #set ($appSection.iconReference = 'XWiki.ConfigurableClass(a)DefaultAdminSectionIcon.png') #end ## ## If the user doesn't have edit access to the application, we want to show a message on the icon #if (!$xcontext.hasAccessLevel('edit', $app.getFullName()) && $newSection) #set ($appSection.readOnly = true) #elseif ($xcontext.hasAccessLevel('edit', $app.getFullName()) && $appSection.readOnly) #set ($appSection.readOnly = false) #end #end## Foreach configurable object in this app. #end## Foreach application which is configurable. #end #* * Show the heading for configuration for a given application. * * $appName (String) Name of the application to show configuration heading for. * * $headingAlreadyShowing (boolean) If true then we don't make another heading. Otherwise it is set to true. *### #macro(showHeading, $appName, $headingAlreadyShowing) #if(!$headingAlreadyShowing) #set($headingAlreadyShowing = true) = $msg.get("admin.customize") __[[$appName>>$appName]]__: = #end #end #define($formHtml) #if ($objClass.getPropertyNames().size() > 0) <dl> #foreach($propName in $objClass.getPropertyNames()) #if($propertiesToShow.size() > 0 && !$propertiesToShow.contains($propName)) ## Silently skip over this property. #else #set($prettyName = "#evaluate($app.displayPrettyName($propName, $obj))") ## ## Further processing of the field display HTML is needed. ## Step 1: Strip <pre> tags which $obj.display inserts, this won't affect content because it's escaped. #set($out = $obj.display($propName, 'edit').replaceAll('<[/]?+pre>', '')) ## Step 2: Select only content between first < and last > because $obj.display inserts html macros. ## Careful not to remove html macros from the content because they are not escaped! #set ($out = $out.substring($out.indexOf('<'), $mathtool.add(1, $out.lastIndexOf('>')))) ## Step 3: Prepend app name to all ID and FOR attributes to prevent id collision with multiple apps on one page. #set ($out = $out.replaceAll( " id='$objClass.getName()_$obj.getNumber()_$propName", " id='${escapedAppName}_$objClass.getName()_$obj.getNumber()_$propName").replaceAll( " for='$objClass.getName()_$obj.getNumber()_$propName", " for='${escapedAppName}_$objClass.getName()_$obj.getNumber()_$propName")) ## App Name is prepended to for= to make label work with id which is modified to prevent collisions. <dt><label for="${escapedAppName}_$objClass.getName()_$obj.getNumber()_$propName"> #if ($out.indexOf('type=''checkbox''') != -1) $out #end $escapetool.xml($prettyName) </label> #if($linkPrefix != '') #set($linkScript = "$linkPrefix$propName") <a href="$escapetool.xml("#evaluate($linkScript)")" class="xHelp" title="$msg.get('admin.documentation')">$msg.get('admin.documentation')</a> #end </dt> #if ($out.indexOf('type=''checkbox''') == -1) <dd>$out</dd> #end #end## If property is in propertiesToShow #end## Foreach property in this class </dl> #end #end## define $formHtml] at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:125) at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:44) at org.xwiki.rendering.macro.script.AbstractScriptMacro.evaluateBlock(AbstractScriptMacro.java:298) at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:190) at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:57) at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transformOnce(MacroTransformation.java:184) at org.xwiki.rendering.internal.transformation.macro.MacroTransformation.transform(MacroTransformation.java:129) at org.xwiki.rendering.internal.transformation.DefaultTransformationManager.performTransformations(DefaultTransformationManager.java:72) at com.xpn.xwiki.doc.XWikiDocument.performSyntaxConversion(XWikiDocument.java:7409) at com.xpn.xwiki.doc.XWikiDocument.performSyntaxConversion(XWikiDocument.java:7358) at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:831) at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:782) at com.xpn.xwiki.doc.XWikiDocument.getRenderedContent(XWikiDocument.java:874) at com.xpn.xwiki.api.Document.getRenderedContent(Document.java:537) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389) at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378) at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270) at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252) at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:332) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87) at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106) at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336) at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:196) at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:161) at com.xpn.xwiki.render.XWikiVelocityRenderer.evaluate(XWikiVelocityRenderer.java:116) at com.xpn.xwiki.XWiki.evaluateTemplate(XWiki.java:1874) at com.xpn.xwiki.web.Utils.parseTemplate(Utils.java:155) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:226) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:117) 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:129) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:152) 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:218) 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:112) 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:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:403) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:301) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:162) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) 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: org.xwiki.velocity.XWikiVelocityException: Failed to evaluate content with id [xwiki:XWiki.AdminSheet] at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:205) at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:161) at org.xwiki.rendering.internal.macro.velocity.VelocityMacro.evaluateString(VelocityMacro.java:118) ... 72 more Caused by: org.apache.velocity.runtime.parser.TemplateParseException: Encountered "\'checkbox\'" at xwiki:XWiki.AdminSheet[line 231, column 26] Was expecting one of: "," ... ")" ... <WHITESPACE> ... at org.apache.velocity.runtime.parser.Parser.parse(Parser.java:119) at org.apache.velocity.runtime.RuntimeInstance.parse(RuntimeInstance.java:1131) at org.xwiki.velocity.internal.DefaultVelocityEngine.evaluate(DefaultVelocityEngine.java:189) ... 74 more ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

3 2

[xwiki-users] Component registration process
by Wouter 27 Jun '11

27 Jun '11

Hello, I am trying to replicate the first example in the tutorial[ http://rendering.xwiki.org/xwiki/bin/view/Main/GettingStarted] using Maven. It worked great at first, but when I try to build a shaded JAR using the maven-shade-plugin, I keep getting a nasty exception: org.xwiki.component.manager.ComponentLookupException: Can't find descriptor for the component [role = [org.xwiki.rendering.converter.Converter] hint = [default]] It seems that some descriptor should have registered itself, but it does not always do that, depending on the project setup. My question: is there a way to poke whichever class has to register itself? If not, can you point me to a place where I can learn more about the registration process? All the best, Wouter

1 0

[xwiki-users] request for xwiki
by Randy Rostie 27 Jun '11

27 Jun '11

I would like to start a xWiki about "Green Lawns": reel mowers, propane powered mowers and other subjects about organic lawns and landscaping. note: I am planning to start a business in this field, but I can make the wiki strictly about information people can use and doesn't bennefit me or my business, except an occasional link. I just think it's important for people to be exposed to information on ways to have a organic lawn and garden. I'm also looking to try out different wiki software to find one that is the easiest to use but is still flexible. Randy

1 0

[xwiki-users] Treeview of single space
by Florian Rhomberg 27 Jun '11

27 Jun '11

Hello! I have a question according to the tree view in xwiki. Is there a possibility to change the velocity code that I can display the treeview of a single space? I didn´t find anything according to this topic. Thanks for your help! Florian

2 3

[xwiki-users] Installation problem
by Neil Streeter 24 Jun '11

24 Jun '11

Hi all, I need help with installation... I'm trying to get xwiki running on: RHEL 6 x64... JDK 6 latest... Mysql 5.1.52... Tomcat 7.0.14 I've followed the admin guide as near as possible... The deviations I've made are.. created my db as 'testxwiki' instead of just xwiki... modified xwiki.db=testxwiki (this was just a stab in the dark - not sure I need to change this) made appropriate modifications to the jdbc url in hibernate.cfg.xml... I've varified that I can connect to the database using: mysql -uxwiki -psome_password testxwiki and show tables returns the empty set... xwiki / hibernate is supposed to create the initial schema on startup right (less indexes)? A more complete catalina.out snip is below but essentially I'm getting... FATAL store.DBCPConnectionProvider - Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. Unfortunately I have been through this file many many times... and I just don't see anything wrong with it... I also get some interesting results when I stop tomcat after attempting to browse the xwiki site... SEVERE: The web application [/xwiki] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/xwiki] appears to have started a thread named [EvictionTimer-0] but has failed to stop it. This is very likely to create a memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/xwiki] appears to have started a thread named [EvictionTimer-1] but has failed to stop it. This is very likely to create a memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/xwiki] created a ThreadLocal with key of type [org.apache.log4j.helpers.ThreadLocalMap] (value [org.apache.log4j.helpers.ThreadLocalMap@2a717ef5]) and a value of type [java.util.Hashtable] (value [{}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/xwiki] created a ThreadLocal with key of type [org.apache.log4j.helpers.ThreadLocalMap] (value [org.apache.log4j.helpers.ThreadLocalMap@2a717ef5]) and a value of type [java.util.Hashtable] (value [{url=http://neil.nmc.edu:8080/xwiki/bin/view/Main/}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/xwiki] created a ThreadLocal with key of type [org.apache.log4j.helpers.ThreadLocalMap] (value [org.apache.log4j.helpers.ThreadLocalMap@2a717ef5]) and a value of type [java.util.Hashtable] (value [{url=http://neil.nmc.edu:8080/xwiki/bin/view/Main/}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. Here's the gory details of everything I did (as well as I can remember)... ==== Installed the 64bit jdk from oracle.. java -version java version "1.6.0_25" Java(TM) SE Runtime Environment (build 1.6.0_25-b06) Java HotSpot(TM) 64-Bit Server VM (build 20.0-b11, mixed mode) ==== Downloaded tomcat and installed it... tar -zxvf apache-tomcat-7.0.14.tar.gz Modified the server.xml file and added: deployOnStartup="true" to the Host node Modified catalina.sh and added: JAVA_HOME=/usr/local/jdk160_25 JAVA_OPTS="-Xmx512m -XX:MaxPermSize=128m" Removed examples, host-manager, and manager from 'webapps'... I prefer not to leave them... ==== Started tomcat - at that point I could get to the ROOT application and browse the tomcat docs... ==== Installed mysql from RPM packages... Configured a few parameters in my.cnf... default-storage-engine=INNODB innodb_file_per_table skip-external-locking max_connections=200 read_buffer_size=1M sort_buffer_size=1M key_buffer_size=128M max_allowed_packet=32M innodb_data_file_path = ibdata1:100M:autoextend innodb_buffer_pool_size=256M innodb_additional_mem_pool_size=20M innodb_log_file_size=64M innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 ==== Created the database and the user... create database testxwiki default character set utf8; grant all privileges on testxwiki.* to xwiki@localhost identified by 'some_password'; flush privileges; ==== Extracted the war file to 'xwiki' inside of webapps... Added mysql-connector-java-5.1.16-bin.jar to xwiki/WEB-INF/lib ==== Changed hibernate.cfg.xml by: commenting out the hsqldb section... moved the comment tag for the mysql section up under the reference to xwiki-1945 Leaving the property and mapping nodes uncommented: <property name="connection.url">jdbc:mysql://localhost/testxwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> <property name="connection.username">xwiki</property> <property name="connection.password">some_password</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQLDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> ==== changed xwiki.cfg as follows: diff xwiki.original xwiki.cfg 82c82 < # xwiki.store.hibernate.path=/WEB-INF/hibernate.cfg.xml --- > xwiki.store.hibernate.path=/WEB-INF/hibernate.cfg.xml 104c104 < # xwiki.db=xwiki --- > xwiki.db=testxwiki DO I NEED TO CHANGE THE XWIKI.DB PROPERTY??? ==== When I start tomcat and go to the xwiki site I get the following in catalina.out STARTING TOMCAT... May 26, 2011 2:02:57 AM org.apache.catalina.core.AprLifecycleListener init INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/local/jdk160_25/jre/lib/amd64/server:/usr/local/jdk160_25/jre/lib/amd64:/usr/local/jdk160_25/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib May 26, 2011 2:02:57 AM org.apache.coyote.AbstractProtocolHandler init INFO: Initializing ProtocolHandler ["http-bio-8080"] May 26, 2011 2:02:57 AM org.apache.coyote.AbstractProtocolHandler init INFO: Initializing ProtocolHandler ["ajp-bio-8009"] May 26, 2011 2:02:57 AM org.apache.catalina.startup.Catalina load INFO: Initialization processed in 1213 ms May 26, 2011 2:02:57 AM org.apache.catalina.core.StandardService startInternal INFO: Starting service Catalina May 26, 2011 2:02:57 AM org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet Engine: Apache Tomcat/7.0.14 May 26, 2011 2:02:57 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory xwiki May 26, 2011 2:02:59 AM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-html-1.0.2 is already defined May 26, 2011 2:02:59 AM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-bean-1.0.2 is already defined May 26, 2011 2:02:59 AM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://jakarta.apache.org/struts/tags-logic-1.0.2 is already defined May 26, 2011 2:03:09 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory docs May 26, 2011 2:03:09 AM org.apache.catalina.startup.HostConfig deployDirectory INFO: Deploying web application directory ROOT May 26, 2011 2:03:09 AM org.apache.coyote.AbstractProtocolHandler start INFO: Starting ProtocolHandler ["http-bio-8080"] May 26, 2011 2:03:09 AM org.apache.coyote.AbstractProtocolHandler start INFO: Starting ProtocolHandler ["ajp-bio-8009"] May 26, 2011 2:03:09 AM org.apache.catalina.startup.Catalina start INFO: Server startup in 12410 ms BROWSE TO THE XWIKI APP.... 2011-05-26 02:03:29,868 [/xwiki/bin/view/Main/] FATAL store.DBCPConnectionProvider - Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Unexpected exception encountered during query.) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.xpn.xwiki.store.DBCPConnectionProvider.configure(DBCPConnectionProvider.java:193) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124) at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56) at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:414) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:62) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2073) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:166) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:560) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1073) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1117) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:68) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractXWikiMigrationManager.java:68) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.<init>(XWikiHibernateMigrationManager.java:51) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:1132) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:813) at com.xpn.xwiki.XWiki.<init>(XWiki.java:756) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:408) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:496) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:137) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:117) 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:129) 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:152) 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:218) 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:112) 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:240) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311) 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: java.sql.SQLException: Unexpected exception encountered during query. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2665) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1698) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1617) at com.mysql.jdbc.ConnectionImpl.setSessionVariables(ConnectionImpl.java:5210) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3375) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2385) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) ... 64 more Caused by: java.lang.NullPointerException at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3100) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2095) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) ... 83 more 2011-05-26 02:03:29,876 [/xwiki/bin/view/Main/] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException May 26, 2011 2:22:34 AM org.apache.catalina.core.StandardServer await WHEN STOPPING TOMCAT.... INFO: A valid shutdown command was received via the shutdown port. Stopping the Server instance. May 26, 2011 2:22:34 AM org.apache.coyote.AbstractProtocolHandler pause INFO: Pausing ProtocolHandler ["http-bio-8080"] May 26, 2011 2:22:35 AM org.apache.coyote.AbstractProtocolHandler pause INFO: Pausing ProtocolHandler ["ajp-bio-8009"] May 26, 2011 2:22:36 AM org.apache.catalina.core.StandardService stopInternal INFO: Stopping service Catalina May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc SEVERE: The web application [/xwiki] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/xwiki] appears to have started a thread named [EvictionTimer-0] but has failed to stop it. This is very likely to create a memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/xwiki] appears to have started a thread named [EvictionTimer-1] but has failed to stop it. This is very likely to create a memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/xwiki] created a ThreadLocal with key of type [org.apache.log4j.helpers.ThreadLocalMap] (value [org.apache.log4j.helpers.ThreadLocalMap@2a717ef5]) and a value of type [java.util.Hashtable] (value [{}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/xwiki] created a ThreadLocal with key of type [org.apache.log4j.helpers.ThreadLocalMap] (value [org.apache.log4j.helpers.ThreadLocalMap@2a717ef5]) and a value of type [java.util.Hashtable] (value [{url=http://neil.nmc.edu:8080/xwiki/bin/view/Main/}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. May 26, 2011 2:22:37 AM org.apache.catalina.loader.WebappClassLoader checkThreadLocalMapForLeaks SEVERE: The web application [/xwiki] created a ThreadLocal with key of type [org.apache.log4j.helpers.ThreadLocalMap] (value [org.apache.log4j.helpers.ThreadLocalMap@2a717ef5]) and a value of type [java.util.Hashtable] (value [{url=http://neil.nmc.edu:8080/xwiki/bin/view/Main/}]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak. May 26, 2011 2:22:37 AM org.apache.coyote.AbstractProtocolHandler stop INFO: Stopping ProtocolHandler ["http-bio-8080"] May 26, 2011 2:22:37 AM org.apache.coyote.AbstractProtocolHandler stop INFO: Stopping ProtocolHandler ["ajp-bio-8009"]

3 3

[xwiki-users] export pages with object XWikiuser
by Gerritjan Koekkoek 23 Jun '11

23 Jun '11

Hi Is there a tool/script that allows for exporting only pages from space XWiki with object XWikiuser I know the export tool can export pages by selecting all or checkmark individual pages, but we have > 500 users, this becomes a drag.... Nice to have if it could also take group-object and which user is in what group So we have a whole identity and access export Gerritjan

2 1

[xwiki-users] Starting an external application
by Frank Marrenbach 21 Jun '11

21 Jun '11

Hello all, In a elearning invironment XWIKI have to be linket to an external software tool. In a second step XWIKI send some data to the external tool to open a specific file. At the end of the usage of the external tool XWIKI will get some date from the external tool and store it in a page. What kind of externsion I need to solve these problem? Are there any examples? Thank you for help! Yours Frank Marrenbach

2 1