[xwiki-users] Problems to create groups
Hello! I have installed xwiki on an Oracle Application Server and Oracle 10g Database. I have problems when I create new groups. I don't get an error in the webbrowser, everything works as normal except that my groups doesn't show up. After I typed the new group name and pressed OK, I return to the list of groups but still only got the XWikiAllGroup. In the log I get this (it is a longer message but I don't want to make a long posting): org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.xpn.xwiki.doc.XWikiDocument#1287555159] at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145) I get the new group in the database (taken from XWIKIOBJECTS; however I don't know the map of the schema you use, so I might be looking on the wrong place): XWO_ID XWO_NUMBER XWO_NAME XWO_CLASSNAME 1300917321 0 XWiki.NewGroup XWiki.TagClass Does anyone have a clue what the solution to the problem is? Btw I can create users... Thanks alot Anders Andersson ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Problems to create groups
I am using XW 1.4 The application server is version 10.1.3.3.0 The install is quiet fresh and has no data yet except of what XWiki creates itself... -- Anders Andersson (on the default startpage it says Creator: on 2008/06/10 09:27 Copyright 2004-2007 (c) XPertNet and Contributing Authors 1.4.9828 so I read the version number as 1.4 revision 9829, hope it is right) Jean-Vincent Drean [EMAIL PROTECTED] 06/10/08 10:10 On Tue, Jun 10, 2008 at 9:41 AM, Anders Andersson [EMAIL PROTECTED] wrote: Hello! I have installed xwiki on an Oracle Application Server and Oracle 10g Database. I have problems when I create new groups. I don't get an error in the webbrowser, everything works as normal except that my groups doesn't show up. After I typed the new group name and pressed OK, I return to the list of groups but still only got the XWikiAllGroup. In the log I get this (it is a longer message but I don't want to make a long posting): org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.xpn.xwiki.doc.XWikiDocument#1287555159] at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145) I get the new group in the database (taken from XWIKIOBJECTS; however I don't know the map of the schema you use, so I might be looking on the wrong place): XWO_ID XWO_NUMBER XWO_NAME XWO_CLASSNAME 1300917321 0 XWiki.NewGroup XWiki.TagClass Does anyone have a clue what the solution to the problem is? Btw I can create users... I'm currently using XE 1.4.1 on jboss 4.2.2 with Oracle 10g and I'm able to create groups. Which version of XW do you use ? Is it a fresh install ? -- Jean-Vincent Drean ___ 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] Problems to create groups
Thanks, that was the problem! Everything seems to work after I imported the XAR and I can create groups. Many thanks! -- Anders Andersson Jean-Vincent Drean [EMAIL PROTECTED] 06/10/08 10:42 Ok, just in case have you installed the default XAR ? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HInstallingtheDefaultWikiXAR On Tue, Jun 10, 2008 at 10:34 AM, Anders Andersson [EMAIL PROTECTED] wrote: I am using XW 1.4 The application server is version 10.1.3.3.0 The install is quiet fresh and has no data yet except of what XWiki creates itself... -- Anders Andersson (on the default startpage it says Creator: on 2008/06/10 09:27 Copyright 2004-2007 (c) XPertNet and Contributing Authors 1.4.9828 so I read the version number as 1.4 revision 9829, hope it is right) Jean-Vincent Drean [EMAIL PROTECTED] 06/10/08 10:10 On Tue, Jun 10, 2008 at 9:41 AM, Anders Andersson [EMAIL PROTECTED] wrote: Hello! I have installed xwiki on an Oracle Application Server and Oracle 10g Database. I have problems when I create new groups. I don't get an error in the webbrowser, everything works as normal except that my groups doesn't show up. After I typed the new group name and pressed OK, I return to the list of groups but still only got the XWikiAllGroup. In the log I get this (it is a longer message but I don't want to make a long posting): org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.xpn.xwiki.doc.XWikiDocument#1287555159] at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:145) I get the new group in the database (taken from XWIKIOBJECTS; however I don't know the map of the schema you use, so I might be looking on the wrong place): XWO_ID XWO_NUMBER XWO_NAME XWO_CLASSNAME 1300917321 0 XWiki.NewGroup XWiki.TagClass Does anyone have a clue what the solution to the problem is? Btw I can create users... I'm currently using XE 1.4.1 on jboss 4.2.2 with Oracle 10g and I'm able to create groups. Which version of XW do you use ? Is it a fresh install ? -- Jean-Vincent Drean ___ 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 -- Jean-Vincent Drean ___ 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
[xwiki-users] Installation problems
Hello! I wonder if you could help me out a little. I have just reinstalled Xwiki (emptied the tablespace), undeployed the old one and installed xwiki-enterprise-1.3.2 as a standalone war file. I did it by deploying it to the application server. The system runs Oracle Application Server and Oracle Database 10g. I can login (right now I have superadmin enabled), but when I try to create an account, nothing happens. When I check the logs I get: com.xpn.xwiki.XWikiException: Error number 8002 in 8: Cannot create user XWiki.KaninHare Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.KaninHare Wrapped Exception: Error number 3212 in 3: Exception while saving property groups of object XWiki.KaninHare Wrapped Exception: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and prop.id.name= :name] 08/05/05 11:06:41 at com.xpn.xwiki.XWiki.createUser(XWiki.java:3156) 08/05/05 11:06:41 at com.xpn.xwiki.XWiki.createUser(XWiki.java:2919) ... Wrapped Exception: com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document XWiki.KaninHare Wrapped Exception: Error number 3212 in 3: Exception while saving property groups of object XWiki.KaninHare Wrapped Exception: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and prop.id.name= :name] 08/05/05 11:06:41 at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:457) 08/05/05 11:06:41 at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97) ... 08/05/05 11:06:41 Wrapped Exception: com.xpn.xwiki.XWikiException: Error number 3212 in 3: Exception while saving property groups of object XWiki.KaninHare Wrapped Exception: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and prop.id.name= :name] 08/05/05 11:06:41 at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiProperty(XWikiHibernateStore.java:1151) 08/05/05 11:06:41 at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiCollection(XWikiHibernateStore.java:776) ... 08/05/05 11:06:41 Wrapped Exception: org.hibernate.QueryException: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and pr op.id.name= :name] at org.hibernate.hql.classic.PathExpressionParser.token(PathExpressionParser.java:167) at org.hibernate.hql.classic.WhereParser.doPathExpression(WhereParser.java:347) ... and the list goes on Does anyone knows what is wrong here? I think it is related to any modification. When I try to modify a page I get: Error number 3201 in 3: Exception while saving document Main.WebHome Wrapped Exception: Error number 3212 in 3: Exception while saving property tags of object Main.WebHome Wrapped Exception: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and prop.id.name= :name] com.xpn.xwiki.XWikiException: Error number 3201 in 3: Exception while saving document Main.WebHome Wrapped Exception: Error number 3212 in 3: Exception while saving property tags of object Main.WebHome Wrapped Exception: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and prop.id.name= :name] at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:457) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97) ... Wrapped Exception: com.xpn.xwiki.XWikiException: Error number 3212 in 3: Exception while saving property tags of object Main.WebHome Wrapped Exception: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and prop.id.name= :name] at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiProperty(XWikiHibernateStore.java:1151) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiCollection(XWikiHibernateStore.java:776) ... Wrapped Exception: org.hibernate.QueryException: dereferenced: baseproper0_.id.id [select prop.name from com.xpn.xwiki.objects.BaseProperty as prop where prop.id.id = :id and prop.id.name= :name] at org.hibernate.hql.classic.PathExpressionParser.token(PathExpressionParser.java:167) at org.hibernate.hql.classic.WhereParser.doPathExpression(WhereParser.java:347) ... Thanks for any help I get. PS: To get everything working I had to add to hibernate.cfg.xml: property name=hibernate.query.factory_classorg.hibernate.hql.classic.ClassicQueryTranslatorFactory/property Anders Andersson ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Privileges on Oracle database
Thanks both of you for the reply. I have decided to atleast give it a try with CREATE/ALTER/DROP/UPDATE TABLE/VIEW/SEQUENCE/SYNONYM/TRIGGER on its own schema and tablespace and SELECT/CONNECT ofcourse. I will inform you later if it works or not, but just want to tell I am greatful for you replys. Anders Andersson [EMAIL PROTECTED] 2008-03-29 23:19:25 In single wiki mode (XWiki Enterprise) it will need read, write to the minimum if you pre create the schema from an existing one. If not you you will need schema read and write. I don't know which oracle privileges that is. Run it once with all privileges to get the database created in one oracle instance. Import that DB in your corporate database. Deactivate updateschema in xwiki.cfg. Then give the oracle privileges one by one. In multiwiki (XEM) the xwiki user needs to be a DBA to be able to create new users. Ludovic [EMAIL PROTECTED] 2008-03-28 18:15 That is a known issue with xWiki and Oracle. As I understand it is being addressed for an upcoming release. So at this point you must use an Oracle user named xwiki. If possible you may use another Db such as mysql,postgresql, or an embedded hsqldb. -- Regards Gabe Wong NGASI AppServer Manager JAVA AUTOMATION and SaaS Enablement http://www.ngasi.com NEW! 8.0 - Centrally manage multiple physical servers Anders Andersson wrote: Hello! I have a question regarding the installation of XWiki. In the installation instructions it says I must type these commands: connect ... create user xwiki identified by xwiki; grant all privileges to xwiki; However this wiki will be installed on a corporate network on their database and application servers and therefor not possible to grant all privileges to xwiki. I wonder if it is possible to run the wiki with more restrictions on the user xwiki? Which privileges is enough for xwiki to operate on the database correctly? Thanks for your time and patients. I will be happy to hear from you again Anders Andersson ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost ___ 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
[xwiki-users] Vd: Sv: Re: Privileges on Oracle database
Hello again! I think (atleast I have asked for it) I got these privileges in Oracle 10g: CREATE/DROP/ALTER/UPDATE TABLE/VIEW/TRIGGER/SYNONYM/SEQUENCE EXECUTE SELECT CONNECT and I got the wiki up and running. I have not used it very much yet. One thing that doesn't work is logging off :D Of some strange reason, I get the exact same page (pixel-by-pixel, including the link log-out) when I press log-out. I don't know what this means, is it a cookie-problem? Anyhow, it is not that serious now... Thanks again! Anders Andersson Anders Andersson 2008-03-31 09:29 Thanks both of you for the reply. I have decided to atleast give it a try with CREATE/ALTER/DROP/UPDATE TABLE/VIEW/SEQUENCE/SYNONYM/TRIGGER on its own schema and tablespace and SELECT/CONNECT ofcourse. I will inform you later if it works or not, but just want to tell I am greatful for you replys. Anders Andersson [EMAIL PROTECTED] 2008-03-29 23:19:25 In single wiki mode (XWiki Enterprise) it will need read, write to the minimum if you pre create the schema from an existing one. If not you you will need schema read and write. I don't know which oracle privileges that is. Run it once with all privileges to get the database created in one oracle instance. Import that DB in your corporate database. Deactivate updateschema in xwiki.cfg. Then give the oracle privileges one by one. In multiwiki (XEM) the xwiki user needs to be a DBA to be able to create new users. Ludovic [EMAIL PROTECTED] 2008-03-28 18:15 That is a known issue with xWiki and Oracle. As I understand it is being addressed for an upcoming release. So at this point you must use an Oracle user named xwiki. If possible you may use another Db such as mysql,postgresql, or an embedded hsqldb. -- Regards Gabe Wong NGASI AppServer Manager JAVA AUTOMATION and SaaS Enablement http://www.ngasi.com NEW! 8.0 - Centrally manage multiple physical servers Anders Andersson wrote: Hello! I have a question regarding the installation of XWiki. In the installation instructions it says I must type these commands: connect ... create user xwiki identified by xwiki; grant all privileges to xwiki; However this wiki will be installed on a corporate network on their database and application servers and therefor not possible to grant all privileges to xwiki. I wonder if it is possible to run the wiki with more restrictions on the user xwiki? Which privileges is enough for xwiki to operate on the database correctly? Thanks for your time and patients. I will be happy to hear from you again Anders Andersson ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost ___ 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
[xwiki-users] Privileges on Oracle database
Hello! I have a question regarding the installation of XWiki. In the installation instructions it says I must type these commands: connect ... create user xwiki identified by xwiki; grant all privileges to xwiki; However this wiki will be installed on a corporate network on their database and application servers and therefor not possible to grant all privileges to xwiki. I wonder if it is possible to run the wiki with more restrictions on the user xwiki? Which privileges is enough for xwiki to operate on the database correctly? Thanks for your time and patients. I will be happy to hear from you again Anders Andersson ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
