[xwiki-users] What is recommended DB for XWiki?
Hello, As we are currently migrating our XWiki server to 64bit platform I believe I have freedom to consider switching DB. We are currently using 32bit MySQLv5.0.77 (innodb engine, 500M of attachments stored in-db) so the options are · Upgrade to MySQLv5.6.x · Migrate to PostgreSQL 8.1 (via XWiki export/import as xar backup feature) The question is: which of those databases is more supported? (mostly used for development, supported by admin application, etc) Regards, Roman ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] What is recommended DB for XWiki?
On Nov 6, 2012, at 1:31 PM, Roman Muntyanu rmunt...@softserveinc.com wrote: Hello, As we are currently migrating our XWiki server to 64bit platform I believe I have freedom to consider switching DB. We are currently using 32bit MySQLv5.0.77 (innodb engine, 500M of attachments stored in-db) so the options are · Upgrade to MySQLv5.6.x · Migrate to PostgreSQL 8.1 (via XWiki export/import as xar backup feature) The question is: which of those databases is more supported? (mostly used for development, supported by admin application, etc) MySQL. For example, ATM virtual mode is not supported for PostgreSQL AFAIK. Thanks -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] What is recommended DB for XWiki?
Thanks, then we'll go the MySQL path ( ... for now ;) ) -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Vincent Massol Sent: Tuesday, November 06, 2012 14:38 PM To: XWiki Users Subject: Re: [xwiki-users] What is recommended DB for XWiki? On Nov 6, 2012, at 1:31 PM, Roman Muntyanu rmunt...@softserveinc.com wrote: Hello, As we are currently migrating our XWiki server to 64bit platform I believe I have freedom to consider switching DB. We are currently using 32bit MySQLv5.0.77 (innodb engine, 500M of attachments stored in-db) so the options are * Upgrade to MySQLv5.6.x * Migrate to PostgreSQL 8.1 (via XWiki export/import as xar backup feature) The question is: which of those databases is more supported? (mostly used for development, supported by admin application, etc) MySQL. For example, ATM virtual mode is not supported for PostgreSQL AFAIK. Thanks -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] What is recommended DB for XWiki?
Actually we have http://dev.xwiki.org/xwiki/bin/view/Community/DatabaseSupportStrategy But I've just realized we don't detail the level of support we have ATM. Something to improve… Thanks -Vincent On Nov 6, 2012, at 1:37 PM, Vincent Massol vinc...@massol.net wrote: On Nov 6, 2012, at 1:31 PM, Roman Muntyanu rmunt...@softserveinc.com wrote: Hello, As we are currently migrating our XWiki server to 64bit platform I believe I have freedom to consider switching DB. We are currently using 32bit MySQLv5.0.77 (innodb engine, 500M of attachments stored in-db) so the options are · Upgrade to MySQLv5.6.x · Migrate to PostgreSQL 8.1 (via XWiki export/import as xar backup feature) The question is: which of those databases is more supported? (mostly used for development, supported by admin application, etc) MySQL. For example, ATM virtual mode is not supported for PostgreSQL AFAIK. Thanks -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Question About Link Checker Module
vmassol wrote On Nov 6, 2012, at 7:52 AM, debanjan lt; debanjan2005@ gt; wrote: Hi Vincent, Yes I got that and added that configuration in xwiki.properties file(and restarted the Tomcat service) and ran into a couple of new issues. i. I went into the External Links page, it showed me 2 broken links(which is correct). Then I edited by broken links test page and corrected the broken links and as expected the items in External Links Page went away. Now as I again re-created the broken links, the External Links page is no more showing up the broken links. I had to restart the Tomcat service to make it work. Broken links are reported only once every hour and this cache is not refreshed when a broken link is fixed AFAIK. ii. This one is a little odd. If I keep the icon parameter in the config. rendering.transformations = macro, icon , linkchecker, this is what is happening to the page contents: http://xwiki.475771.n2.nabble.com/file/n7582181/xwiki.png That's perfectly normal. (x) is the symbol for the red cross for ex. See http://extensions.xwiki.org/xwiki/bin/view/Extension/Icon+Transformation Thanks -Vincent Lisa posting for Debanjan: Hi Vincent, Right, I assume then we have remove icon from the configuration. That is exactly the way we configured in the first place (as below) rendering.transformations = macro, linkchecker Am I correct in guessing that with the configuration as above, the link checker would not work? Thanks, Debanjan -- View this message in context: http://xwiki.475771.n2.nabble.com/Question-About-Link-Checker-Module-tp7580939p7582195.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Question About Link Checker Module
On Nov 6, 2012, at 2:40 PM, iceicelady lisa6...@hotmail.com wrote: vmassol wrote On Nov 6, 2012, at 7:52 AM, debanjan lt; debanjan2005@ gt; wrote: Hi Vincent, Yes I got that and added that configuration in xwiki.properties file(and restarted the Tomcat service) and ran into a couple of new issues. i. I went into the External Links page, it showed me 2 broken links(which is correct). Then I edited by broken links test page and corrected the broken links and as expected the items in External Links Page went away. Now as I again re-created the broken links, the External Links page is no more showing up the broken links. I had to restart the Tomcat service to make it work. Broken links are reported only once every hour and this cache is not refreshed when a broken link is fixed AFAIK. ii. This one is a little odd. If I keep the icon parameter in the config. rendering.transformations = macro, icon , linkchecker, this is what is happening to the page contents: http://xwiki.475771.n2.nabble.com/file/n7582181/xwiki.png That's perfectly normal. (x) is the symbol for the red cross for ex. See http://extensions.xwiki.org/xwiki/bin/view/Extension/Icon+Transformation Thanks -Vincent Lisa posting for Debanjan: Hi Vincent, Right, I assume then we have remove icon from the configuration. That is exactly the way we configured in the first place (as below) rendering.transformations = macro, linkchecker Am I correct in guessing that with the configuration as above, the link checker would not work? It should work fine. The linkchecker transformation is independent of the icon transformation. Does it make any change for you when you have icon transformation active or not? Thanks -Vincent Thanks, Debanjan -- View this message in context: http://xwiki.475771.n2.nabble.com/Question-About-Link-Checker-Module-tp7580939p7582195.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Question About Link Checker Module
vmassol wrote Lisa posting for Debanjan: Hi Vincent, Right, I assume then we have remove icon from the configuration. That is exactly the way we configured in the first place (as below) rendering.transformations = macro, linkchecker Am I correct in guessing that with the configuration as above, the link checker would not work? It should work fine. The linkchecker transformation is independent of the icon transformation. Does it make any change for you when you have icon transformation active or not? Thanks -Vincent If I'm understanding your question correctly, Vincent, then yes, there is a change. We've had this configuration in xwiki.properties all along: rendering.transformations = macro, linkchecker (icon transformation inactive) But the Link Checker has not worked properly, as described in earlier posts. And we have visited all the pages, multiple times. When Debanjan added icon again, the Link Checker started working as expected. But we *don't* want the Icon Transformation active. Regarding an earlier question you asked, I'm not 100% sure whether we are behind an HTTP proxy or not; I will have to wait for Debanjan (in another time zone) to answer that. (I'm the business analyst/content administrator; he's the developer.) I don't think we are, but if so, would that make a difference, and how? -- View this message in context: http://xwiki.475771.n2.nabble.com/Question-About-Link-Checker-Module-tp7580939p7582197.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Question About Link Checker Module
On Nov 6, 2012, at 3:08 PM, iceicelady lisa6...@hotmail.com wrote: vmassol wrote Lisa posting for Debanjan: Hi Vincent, Right, I assume then we have remove icon from the configuration. That is exactly the way we configured in the first place (as below) rendering.transformations = macro, linkchecker Am I correct in guessing that with the configuration as above, the link checker would not work? It should work fine. The linkchecker transformation is independent of the icon transformation. Does it make any change for you when you have icon transformation active or not? Thanks -Vincent If I'm understanding your question correctly, Vincent, then yes, there is a change. We've had this configuration in xwiki.properties all along: rendering.transformations = macro, linkchecker (icon transformation inactive) But the Link Checker has not worked properly, as described in earlier posts. And we have visited all the pages, multiple times. When Debanjan added icon again, the Link Checker started working as expected. But we *don't* want the Icon Transformation active. ok I've tested it again with just: rendering.transformations = macro, linkchecker And it works just fine… Here's what I did: * Modified xwiki.properties to have: rendering.transformations = macro, linkchecker (note: make sure the line is NOT commented of course ;)) * Restarted xwiki * Went to AllDocs, clicked on external links tab, it's empty * Went to Sandbox.WebHome * Went again to AllDocs, click on external links tab and verified it contains one entry for http://xwiki.org (since this link is on the sandbox page) In short, there's no reason for the icon transformation to make any difference whether it's there or not. Thanks -Vincent Regarding an earlier question you asked, I'm not 100% sure whether we are behind an HTTP proxy or not; I will have to wait for Debanjan (in another time zone) to answer that. (I'm the business analyst/content administrator; he's the developer.) I don't think we are, but if so, would that make a difference, and how? -- View this message in context: http://xwiki.475771.n2.nabble.com/Question-About-Link-Checker-Module-tp7580939p7582197.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] AUTO: MaryEllen Coleman/Rochester/IBM is out of the office. (returning 11/07/2012)
I am out of the office until 11/07/2012. I will have no Internet access. If this is an emergency, please contact my manager, Kathy Kennedy, and she will find someone on my team to help you. Note: This is an automated response to your message users Digest, Vol 64, Issue 5 sent on 11/06/2012 7:00:03. This is the only notification you will receive while this person is away. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Apache/Tomcat-configuration, no login possible
Hello, i have installed XWIKI Enterprise 4.2 on a Tomcat-server with Apache in front. Direct access on Tomcat-URL is OK. But if go over Apache and try to login the message occurs: Unauthorized: This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (eg, bad password) or your browser doesn't understand how to supply the credentials required. The browser's URL is redirected to https://mysub.mydomain.com/xwiki/bin/login/XWiki/XWikiLogin?xredirect=%2Fxwiki%2Fbin%2Fview%2FMain%2FWebHome xwiki.cfg is configured with: xwiki.home=https://mysub.mydomain.com/xwiki/ xwiki.url.protocol=https xwiki.webapppath=xwiki/ Do you have a hint ? Thanks in advance. Best regards Ingo ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Apache/Tomcat-configuration, no login possible
+1 The same issue. Today I finished tests with Jetty and XWiki + Jetty iy works fine (Standalone version). Tue, 6 Nov 2012 16:39:29 +0100 от Ingo Oellers mmx10...@hotmail.de: Hello, i have installed XWIKI Enterprise 4.2 on a Tomcat-server with Apache in front. Direct access on Tomcat-URL is OK. But if go over Apache and try to login the message occurs: Unauthorized: This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (eg, bad password) or your browser doesn't understand how to supply the credentials required. The browser's URL is redirected to https://mysub.mydomain.com/xwiki/bin/login/XWiki/XWikiLogin?xredirect=%2Fxwiki%2Fbin%2Fview%2FMain%2FWebHome xwiki.cfg is configured with: xwiki.home=https://mysub.mydomain.com/xwiki/ xwiki.url.protocol=https xwiki.webapppath=xwiki/ Do you have a hint ? Thanks in advance. Best regards Ingo ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users Kind regards, Dmitry ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Using custom JSON in a livetable
Hello! I need help for livetable with custom json page. I did it all, but - no any visual results (rows with data) in a livetable. Maybe I wrote something wrong. For the easy example, I only trying to add column 'no' with row number. = Content of custom JSON page (etvcPlanningsCode.wJSON): = {{include document=XWiki.LiveTableResultsMacros /}} {{velocity}} #if($!{request.xpage} == 'plain') $response.setContentType('application/json') #end #set($map = {}) #gridresult_buildJSON($!etvcPlanningsCode.wClass $request.collist.split(',') $map) #foreach($row in $map.get('rows')) #set($discard = $row.put('no', $foreach.count)) #end $json = $jsontool.serialize($map) {{/velocity}} = This content give me result: = $json = {reqNo:null,matchingtags:{},tags:[],totalrows:539,returnedrows:15,offset:1,rows:[{doc_viewable:true,doc_name:t4pTable,doc_fullName:xwiki:etvcPlanningsCode.t4pTable,doc_space:etvcPlanningsCode,doc_url:/xwiki/bin/view/etvcPlanningsCode/t4pTable,doc_space_url:/xwiki/bin/view/etvcPlanningsCode/WebHome,doc_hasadmin:true,doc_hasedit:true,doc_hasdelete:true,doc_edit_url:/xwiki/bin/edit/etvcPlanningsCode/t4pTable,doc_copy_url:/xwiki/bin/view/etvcPlanningsCode/t4pTable?xpage=copy,doc_delete_url:/xwiki/bin/delete/etvcPlanningsCode/t4pTable,doc_rename_url:/xwiki/bin/view/etvcPlanningsCode/t4pTable?xpage=renamestep=1,doc_rights_url:/xwiki/bin/edit/etvcPlanningsCode/t4pTable?editor=rights,doc_author_url:/xwiki/bin/view/XWiki/Admin,doc_date:14.10.2012,doc_title:t4p Table,doc_author:Administrator,doc_creationDate:04.12.2011,doc_creator:Administrator,no:1}, ... == My livetable code: == {{velocity}} #set($columns = [ no , wIndex , wAlias , wName , wTeam , wActive , doc.date , _actions ]) #set($columnsProperties = { no : { type : text, size : 10, filterable : true, sortable: true }, wIndex : { type : text, size : 10, filterable : true, sortable: true }, wAlias : { type : text, link : view, size : 10, filterable : true, sortable: true }, wName : { type : text, link : view, size : 10, filterable : true, sortable: true }, wTeam : { type : text, size : 10, filterable : true, sortable: true }, wActive : { type : text, size : 10, filterable : true, sortable: true }, doc.date : { type : text, size : 10, filterable : true, sortable: true }, _actions : { 'actions' : ['edit', 'delete'] } }) #set($options = { resultPage : etvcPlanningsCode.wJSON, translationPrefix : w2.livetable., rowCount: 15, maxPages : 10, selectedColumn : wIndex, defaultOrder : asc }) #livetable(w2 $columns $columnsProperties $options) -- Thanks beforehand! Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/Using-custom-JSON-in-a-livetable-tp7582208.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Using custom JSON in a livetable
I found one issue on custom JSON page. My last variant: = Content of custom JSON page (etvcPlanningsCode.wJSON): = {{include document=XWiki.LiveTableResultsMacros /}} {{velocity}} #if($!{request.xpage} == 'plain') $response.setContentType('application/json') #end #set($map = {}) #gridresult_buildJSON($!etvcPlanningsCode.wClass $request.collist.split(',') $map) #foreach($row in $map.get('rows')) #set($discard = $row.put('no', $foreach.count)) #end $json = $jsontool.serialize($map) {{/velocity}} Also I checked JSON result with http://jsonlint.com/ - I got Valid JSON ... But unfortunatly - no any results in a livetable ... Can somebody can help me? -- Thanks beforehand! Eugen Colesnicov -- Thanks -- View this message in context: http://xwiki.475771.n2.nabble.com/Using-custom-JSON-in-a-livetable-tp7582208p7582210.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Using custom JSON in a livetable
As a final - I found problem! When I setting livetable options need to write not only rezultPage parameter - by also and className parameter ... My working variant: = JSON page: = {{include document=XWiki.LiveTableResultsMacros /}} {{velocity}} #if($!{request.xpage} == 'plain') $response.setContentType('application/json') #end #set($map = {}) #gridresult_buildJSON($!request.classname $request.collist.split(',') $map) #foreach($row in $map.get('rows')) #set($discard = $row.put('no', $foreach.count)) #end $jsontool.serialize($map) {{/velocity}} === Livetable page === {{velocity}} #set($columns = [ no , wIndex , wAlias , wName , wTeam , wActive , doc.date , _actions ]) #set($columnsProperties = { no : { type : text, size : 10, filterable : true, sortable: true }, wIndex : { type : text, size : 10, filterable : true, sortable: true }, wAlias : { type : text, link : view, size : 10, filterable : true, sortable: true }, wName : { type : text, link : view, size : 10, filterable : true, sortable: true }, wTeam : { type : text, size : 10, filterable : true, sortable: true }, wActive : { type : text, size : 10, filterable : true, sortable: true }, doc.date : { type : text, size : 10, filterable : true, sortable: true }, _actions : { 'actions' : ['edit', 'delete'] } }) #set($options = { className:etvcPlanningsCode.wClass, resultPage : etvcPlanningsCode.wJSON, translationPrefix : w2.livetable., tagCloud : true, rowCount: 15, maxPages : 10, selectedColumn : wIndex, defaultOrder : asc }) #livetable(w2 $columns $columnsProperties $options) {{/velocity}} -- View this message in context: http://xwiki.475771.n2.nabble.com/Using-custom-JSON-in-a-livetable-tp7582208p7582211.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users