Re: [xwiki-users] Can't get XWiki to work with Oracle
What I have discovered is that this is happening when I try to use an Oracle user other than "xwiki". Somehow the code to run the initialization oracle script has been bound to this user. It is a problem cause you can never have two different xwiki installations working with the same oracle SID (i.e. on the same instance of oracle XE). anyone that can look in the code and try to verify this?
Hi Nikos, I also had some trouble initially with the schema names in oracle since I didn't want to call it simply "xwiki". I wanted separate schemas in the same database, for instance: xwiki_test and xwiki_prod It is possible to configure this in the xwiki config file. I dont have access to my xwiki config file right now, but if I recall correctly the config property is called "xwiki.db".
From an xwiki.cfg example file found in th AdminGuide ( http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HSamplexwi... )
#-# [Since 1.6M1] #-# Force the database name for the main wiki in virtual mode and for the wiki itself in non virtual mode # xwiki.db=xwiki Try uncomment the line with xwiki.db= and change the default value to your schema name. I hope this can help you. Kind regards, Jonas On Sun, Aug 16, 2009 at 11:20 AM, Nikos Georgosopoulos <georgosn@gmail.com>wrote:
What I have discovered is that this is happening when I try to use an Oracle user other than "xwiki". Somehow the code to run the initialization oracle script has been bound to this user. It is a problem cause you can never have two different xwiki installations working with the same oracle SID (i.e. on the same instance of oracle XE).
anyone that can look in the code and try to verify this? _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Hi, I apologize in advance for the lengthy email. I am using XWiki Enterprise 2.0.24043 now, after upgrading from 1.9.2 recently. I have some custom classes created a year ago and I have tried to convert all their pages to 2.0 syntax. There have been quite a few problems I have been able to solve, but there is one that I am quite confused about. I need the pages that have these class objects to default to inline edit mode since that is the only useful way for the users to enter the data. In the older (pre 2.0) version this happened automatically -- although I don't know why, it was like magic -- and things were fine. Now when the user clicks the edit menu it automatically goes to WYSIWYG (or wiki depending on the user). I thought I could get around this by redirecting the edit to inline, I think I was able to do this in older versions of xwiki. I have tried many versions of code like this: {{velocity filter="none"}} ## check for admin is so that I can still edit pages in wiki as normal, ## but non admin users should get the inline version #set($hasGlobalAdmin = $xwiki.hasAccessLevel("admin", $context.user, "XWiki.XWikiPreferences")) #if($context.action == 'edit' && !$hasGlobalAdmin) ## for redirection, I tried a few different methods like ## $response.sendRedirect($doc.getURL('inline')) ## and this $response.sendRedirect($xwiki.getURL($doc.name, 'inline')) ## tried with and without the stop #stop #else {{include document="Projects.TestRequestClassSheet"/}} #end {{/velocity}} but instead is does this crazy thing of sending the entire page to a WYSIWYG editor (meaning the entire xwiki page with the top menus, panels, everything) with the page I am trying to edit showing as if it was inline but not actually editable. The URL in the browser doesn't change at all. However if I just choose the inline edit mode to start or type in the url "/xwiki/bin/inline/Projects/mynewtestrequest" for example that works like it should. I tried upgrading to XWiki Enterprise 2.0.3.24848 and the behavior persists. I fear I am going to have to get into the java code to find a solution, which means a lot more work -- so I am appealing to the group to see if there is something easier that I am not seeing. It appears to me that the $redirect support has changed somehow. TIA for your help! Regan
On 11/09/2009 12:22 AM, Regan Gill wrote:
Hi,
I apologize in advance for the lengthy email. I am using XWiki Enterprise 2.0.24043 now, after upgrading from 1.9.2 recently. I have some custom classes created a year ago and I have tried to convert all their pages to 2.0 syntax. There have been quite a few problems I have been able to solve, but there is one that I am quite confused about.
I need the pages that have these class objects to default to inline edit mode since that is the only useful way for the users to enter the data. In the older (pre 2.0) version this happened automatically -- although I don't know why, it was like magic -- and things were fine. Now when the user clicks the edit menu it automatically goes to WYSIWYG (or wiki depending on the user). I thought I could get around this by redirecting the edit to inline, I think I was able to do this in older versions of xwiki. I have tried many versions of code like this:
{{velocity filter="none"}} ## check for admin is so that I can still edit pages in wiki as normal, ## but non admin users should get the inline version #set($hasGlobalAdmin = $xwiki.hasAccessLevel("admin", $context.user, "XWiki.XWikiPreferences")) #if($context.action == 'edit'&& !$hasGlobalAdmin) ## for redirection, I tried a few different methods like ## $response.sendRedirect($doc.getURL('inline')) ## and this $response.sendRedirect($xwiki.getURL($doc.name, 'inline')) ## tried with and without the stop #stop #else {{include document="Projects.TestRequestClassSheet"/}}
You must add an object of type XWiki.SheetClass to the Projects.TestRequestClassSheet document. No need to do anything else.
#end {{/velocity}}
but instead is does this crazy thing of sending the entire page to a WYSIWYG editor (meaning the entire xwiki page with the top menus, panels, everything) with the page I am trying to edit showing as if it was inline but not actually editable. The URL in the browser doesn't change at all.
However if I just choose the inline edit mode to start or type in the url "/xwiki/bin/inline/Projects/mynewtestrequest" for example that works like it should.
I tried upgrading to XWiki Enterprise 2.0.3.24848 and the behavior persists. I fear I am going to have to get into the java code to find a solution, which means a lot more work -- so I am appealing to the group to see if there is something easier that I am not seeing. It appears to me that the $redirect support has changed somehow.
TIA for your help!
Regan
-- Sergiu Dumitriu http://purl.org/net/sergiu/
Thank you for the reply. Unfortunately that doesn't do anything for this case for some reason. Is there an example some where I can look at that does work and maybe I can determine what is different. -----Original Message----- From: users-bounces@xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Sergiu Dumitriu Sent: Sunday, November 08, 2009 3:30 PM To: XWiki Users Subject: Re: [xwiki-users] problem getting inline edit for pages with objects On 11/09/2009 12:22 AM, Regan Gill wrote:
Hi,
I apologize in advance for the lengthy email. I am using XWiki Enterprise 2.0.24043 now, after upgrading from 1.9.2 recently. I have some custom classes created a year ago and I have tried to convert all their pages to 2.0 syntax. There have been quite a few problems I have been able to solve, but there is one that I am quite confused about.
I need the pages that have these class objects to default to inline edit mode since that is the only useful way for the users to enter the data. In the older (pre 2.0) version this happened automatically -- although I don't know why, it was like magic -- and things were fine. Now when the user clicks the edit menu it automatically goes to WYSIWYG (or wiki depending on the user). I thought I could get around this by redirecting the edit to inline, I think I was able to do this in older versions of xwiki. I have tried many versions of code like this:
{{velocity filter="none"}} ## check for admin is so that I can still edit pages in wiki as normal, ## but non admin users should get the inline version #set($hasGlobalAdmin = $xwiki.hasAccessLevel("admin", $context.user, "XWiki.XWikiPreferences")) #if($context.action == 'edit'&& !$hasGlobalAdmin) ## for redirection, I tried a few different methods like ## $response.sendRedirect($doc.getURL('inline')) ## and this $response.sendRedirect($xwiki.getURL($doc.name, 'inline')) ## tried with and without the stop #stop #else {{include document="Projects.TestRequestClassSheet"/}}
You must add an object of type XWiki.SheetClass to the Projects.TestRequestClassSheet document. No need to do anything else.
#end {{/velocity}}
but instead is does this crazy thing of sending the entire page to a WYSIWYG editor (meaning the entire xwiki page with the top menus, panels, everything) with the page I am trying to edit showing as if it was inline but not actually editable. The URL in the browser doesn't change at all.
However if I just choose the inline edit mode to start or type in the url "/xwiki/bin/inline/Projects/mynewtestrequest" for example that works like it should.
I tried upgrading to XWiki Enterprise 2.0.3.24848 and the behavior persists. I fear I am going to have to get into the java code to find a solution, which means a lot more work -- so I am appealing to the group to see if there is something easier that I am not seeing. It appears to me that the $redirect support has changed somehow.
TIA for your help!
Regan
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Hi Regan, the solution provided by Sergiu does work (I've used it a number of times already). You have to add the XWiki.SheetClass object to the page that is called by the include (which in your case seems to be 'Projects.TestRequestClassSheet' ). Are you sure you: 1. Added the object to the right page? 2. All your application's pages are in syntax 2? 3. You tried clicking on 'Edit' once on your test page (and not directly on 'wiki' or 'wysiwyg')? You can check out how this works in the latest version of the bulletin board application: http://code.xwiki.org/xwiki/bin/view/Applications/BulletinBoardApplication (look at BBCode.CategoryClassSheet) Or by looking at the FAQ tutorial: http://platform.xwiki.org/xwiki/bin/view/DevGuide/FAQTutorial#HCreatethePage... Hope this helps, Guillaume On Mon, Nov 9, 2009 at 5:47 AM, Regan Gill <rgill@acceptsoftware.com> wrote:
Thank you for the reply. Unfortunately that doesn't do anything for this case for some reason. Is there an example some where I can look at that does work and maybe I can determine what is different.
-----Original Message----- From: users-bounces@xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Sergiu Dumitriu Sent: Sunday, November 08, 2009 3:30 PM To: XWiki Users Subject: Re: [xwiki-users] problem getting inline edit for pages with objects
On 11/09/2009 12:22 AM, Regan Gill wrote:
Hi,
I apologize in advance for the lengthy email. I am using XWiki Enterprise 2.0.24043 now, after upgrading from 1.9.2 recently. I have some custom classes created a year ago and I have tried to convert all their pages to 2.0 syntax. There have been quite a few problems I have been able to solve, but there is one that I am quite confused about.
I need the pages that have these class objects to default to inline edit mode since that is the only useful way for the users to enter the data. In the older (pre 2.0) version this happened automatically -- although I don't know why, it was like magic -- and things were fine. Now when the user clicks the edit menu it automatically goes to WYSIWYG (or wiki depending on the user). I thought I could get around this by redirecting the edit to inline, I think I was able to do this in older versions of xwiki. I have tried many versions of code like this:
{{velocity filter="none"}} ## check for admin is so that I can still edit pages in wiki as normal, ## but non admin users should get the inline version #set($hasGlobalAdmin = $xwiki.hasAccessLevel("admin", $context.user, "XWiki.XWikiPreferences")) #if($context.action == 'edit'&& !$hasGlobalAdmin) ## for redirection, I tried a few different methods like ## $response.sendRedirect($doc.getURL('inline')) ## and this $response.sendRedirect($xwiki.getURL($doc.name, 'inline')) ## tried with and without the stop #stop #else {{include document="Projects.TestRequestClassSheet"/}}
You must add an object of type XWiki.SheetClass to the Projects.TestRequestClassSheet document. No need to do anything else.
#end {{/velocity}}
but instead is does this crazy thing of sending the entire page to a WYSIWYG editor (meaning the entire xwiki page with the top menus, panels, everything) with the page I am trying to edit showing as if it was inline but not actually editable. The URL in the browser doesn't change at all.
However if I just choose the inline edit mode to start or type in the url "/xwiki/bin/inline/Projects/mynewtestrequest" for example that works like it should.
I tried upgrading to XWiki Enterprise 2.0.3.24848 and the behavior persists. I fear I am going to have to get into the java code to find a solution, which means a lot more work -- so I am appealing to the group to see if there is something easier that I am not seeing. It appears to me that the $redirect support has changed somehow.
TIA for your help!
Regan
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ 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
-- Guillaume Lerouge Product Manager - XWiki SAS Skype: wikibc Twitter: glerouge http://guillaumelerouge.com/
Hi All, I solved the problem and am posting this in case anyone else sees the issue. The answer to the questions below was all yes, and yet it still didn't work. But finally I tried removing the macro tags '{{velocity filter="none"}}' Just {{include document="Projects.TestRequestClassSheet"/}} Works fine -- edit opens in inline mode. Thanks for your help, Regan -----Original Message----- From: users-bounces@xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Guillaume Lerouge Sent: Monday, November 09, 2009 12:40 AM To: XWiki Users Subject: Re: [xwiki-users] problem getting inline edit for pages with objects Hi Regan, the solution provided by Sergiu does work (I've used it a number of times already). You have to add the XWiki.SheetClass object to the page that is called by the include (which in your case seems to be 'Projects.TestRequestClassSheet' ). Are you sure you: 1. Added the object to the right page? 2. All your application's pages are in syntax 2? 3. You tried clicking on 'Edit' once on your test page (and not directly on 'wiki' or 'wysiwyg')? You can check out how this works in the latest version of the bulletin board application: http://code.xwiki.org/xwiki/bin/view/Applications/BulletinBoardApplicati on (look at BBCode.CategoryClassSheet) Or by looking at the FAQ tutorial: http://platform.xwiki.org/xwiki/bin/view/DevGuide/FAQTutorial#HCreatethe PageDesignSheet Hope this helps, Guillaume On Mon, Nov 9, 2009 at 5:47 AM, Regan Gill <rgill@acceptsoftware.com> wrote:
Thank you for the reply. Unfortunately that doesn't do anything for this case for some reason. Is there an example some where I can look at that does work and maybe I can determine what is different.
-----Original Message----- From: users-bounces@xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Sergiu Dumitriu Sent: Sunday, November 08, 2009 3:30 PM To: XWiki Users Subject: Re: [xwiki-users] problem getting inline edit for pages with objects
On 11/09/2009 12:22 AM, Regan Gill wrote:
Hi,
I apologize in advance for the lengthy email. I am using XWiki Enterprise 2.0.24043 now, after upgrading from 1.9.2 recently. I have some custom classes created a year ago and I have tried to convert all their pages to 2.0 syntax. There have been quite a few problems I have been able to solve, but there is one that I am quite confused about.
I need the pages that have these class objects to default to inline edit mode since that is the only useful way for the users to enter the data. In the older (pre 2.0) version this happened automatically -- although I don't know why, it was like magic -- and things were fine. Now when the user clicks the edit menu it automatically goes to WYSIWYG (or wiki depending on the user). I thought I could get around this by redirecting the edit to inline, I think I was able to do this in older versions of xwiki. I have tried many versions of code like this:
{{velocity filter="none"}} ## check for admin is so that I can still edit pages in wiki as normal, ## but non admin users should get the inline version #set($hasGlobalAdmin = $xwiki.hasAccessLevel("admin", $context.user, "XWiki.XWikiPreferences")) #if($context.action == 'edit'&& !$hasGlobalAdmin) ## for redirection, I tried a few different methods like ## $response.sendRedirect($doc.getURL('inline')) ## and this $response.sendRedirect($xwiki.getURL($doc.name, 'inline')) ## tried with and without the stop #stop #else {{include document="Projects.TestRequestClassSheet"/}}
You must add an object of type XWiki.SheetClass to the Projects.TestRequestClassSheet document. No need to do anything else.
#end {{/velocity}}
but instead is does this crazy thing of sending the entire page to a WYSIWYG editor (meaning the entire xwiki page with the top menus, panels, everything) with the page I am trying to edit showing as if it was inline but not actually editable. The URL in the browser doesn't change at all.
However if I just choose the inline edit mode to start or type in the url "/xwiki/bin/inline/Projects/mynewtestrequest" for example that works like it should.
I tried upgrading to XWiki Enterprise 2.0.3.24848 and the behavior persists. I fear I am going to have to get into the java code to find a solution, which means a lot more work -- so I am appealing to the group to see if there is something easier that I am not seeing. It appears to me that the $redirect support has changed somehow.
TIA for your help!
Regan
On Nov 11, 2009, at 4:10 AM, Regan Gill wrote:
Hi All,
I solved the problem and am posting this in case anyone else sees the issue. The answer to the questions below was all yes, and yet it still didn't work. But finally I tried removing the macro tags '{{velocity filter="none"}}'
Just
{{include document="Projects.TestRequestClassSheet"/}}
Works fine -- edit opens in inline mode.
Indeed, only top level macros are checked (nested macros cannot really be checked since the semantic of each macro content depends on the containing macro). In any case this way of doing inline edit is a small hack and only temporary till we have the implementation for what we call Document Types. Thanks -Vincent
Thanks for your help, Regan
-----Original Message----- From: users-bounces@xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Guillaume Lerouge Sent: Monday, November 09, 2009 12:40 AM To: XWiki Users Subject: Re: [xwiki-users] problem getting inline edit for pages with objects
Hi Regan,
the solution provided by Sergiu does work (I've used it a number of times already).
You have to add the XWiki.SheetClass object to the page that is called by the include (which in your case seems to be 'Projects.TestRequestClassSheet' ).
Are you sure you:
1. Added the object to the right page? 2. All your application's pages are in syntax 2? 3. You tried clicking on 'Edit' once on your test page (and not directly on 'wiki' or 'wysiwyg')?
You can check out how this works in the latest version of the bulletin board application: http://code.xwiki.org/xwiki/bin/view/Applications/BulletinBoardApplicati on (look at BBCode.CategoryClassSheet)
Or by looking at the FAQ tutorial: http://platform.xwiki.org/xwiki/bin/view/DevGuide/FAQTutorial#HCreatethe PageDesignSheet
Hope this helps,
Guillaume
On Mon, Nov 9, 2009 at 5:47 AM, Regan Gill <rgill@acceptsoftware.com> wrote:
Thank you for the reply. Unfortunately that doesn't do anything for this case for some reason. Is there an example some where I can look at that does work and maybe I can determine what is different.
-----Original Message----- From: users-bounces@xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Sergiu Dumitriu Sent: Sunday, November 08, 2009 3:30 PM To: XWiki Users Subject: Re: [xwiki-users] problem getting inline edit for pages with objects
On 11/09/2009 12:22 AM, Regan Gill wrote:
Hi,
I apologize in advance for the lengthy email. I am using XWiki Enterprise 2.0.24043 now, after upgrading from 1.9.2 recently. I have some custom classes created a year ago and I have tried to convert all their pages to 2.0 syntax. There have been quite a few problems I have been able to solve, but there is one that I am quite confused about.
I need the pages that have these class objects to default to inline edit mode since that is the only useful way for the users to enter the data. In the older (pre 2.0) version this happened automatically -- although I don't know why, it was like magic -- and things were fine. Now when the user clicks the edit menu it automatically goes to WYSIWYG (or wiki depending on the user). I thought I could get around this by redirecting the edit to inline, I think I was able to do this in older versions of xwiki. I have tried many versions of code like this:
{{velocity filter="none"}} ## check for admin is so that I can still edit pages in wiki as normal, ## but non admin users should get the inline version #set($hasGlobalAdmin = $xwiki.hasAccessLevel("admin", $context.user, "XWiki.XWikiPreferences")) #if($context.action == 'edit'&& !$hasGlobalAdmin) ## for redirection, I tried a few different methods like ## $response.sendRedirect($doc.getURL('inline')) ## and this $response.sendRedirect($xwiki.getURL($doc.name, 'inline')) ## tried with and without the stop #stop #else {{include document="Projects.TestRequestClassSheet"/}}
You must add an object of type XWiki.SheetClass to the Projects.TestRequestClassSheet document. No need to do anything else.
#end {{/velocity}}
but instead is does this crazy thing of sending the entire page to a WYSIWYG editor (meaning the entire xwiki page with the top menus, panels, everything) with the page I am trying to edit showing as if it was inline but not actually editable. The URL in the browser doesn't change at all.
However if I just choose the inline edit mode to start or type in the url "/xwiki/bin/inline/Projects/mynewtestrequest" for example that works like it should.
I tried upgrading to XWiki Enterprise 2.0.3.24848 and the behavior persists. I fear I am going to have to get into the java code to find a solution, which means a lot more work -- so I am appealing to the group to see if there is something easier that I am not seeing. It appears to me that the $redirect support has changed somehow.
TIA for your help!
Regan
participants (6)
-
Guillaume Lerouge -
Jonas Almfeldt -
Nikos Georgosopoulos -
Regan Gill -
Sergiu Dumitriu -
Vincent Massol