Well I could install! I set the xwiki.db with my schema database... BUT I have other problEm with the schema "WORKSPACTETEMPLATE" in respect to our enterprise standards I cant do a schema like "WORKSPACETEMPLATE" Is there a way to create manually this schema and indicate to the XEM to use as workspacetemplate? Ps.: I think that the xwiki platform should have a more flexible and easy way to set the name of databases, schemas, etc. A lot of company have standards in their DB that all application needs to respect! Thank you very much! -----Mensagem original----- De: [email protected] [mailto:[email protected]] Em nome de Danilo Amaral de Oliveira Enviada em: quinta-feira, 18 de julho de 2013 16:03 Para: XWiki Users Assunto: [xwiki-users] RES: RES: XEM Installation Questions In time... The error that I get is: type Exception report message com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context description The server encountered an internal error that prevented it from fulfilling this request. exception javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiServerClass] Wrapped Exception: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: error executing work org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) root cause com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiServerClass] Wrapped Exception: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: error executing work com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:421) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:148) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:128) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) ... root cause java.sql.SQLException: ORA-01435: user does not exist oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193) oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1026) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909) oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871) oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318) org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) com.xpn.xwiki.store.XWikiHibernateBaseStore$1.execute(XWikiHibernateBaseStore.java:725) org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997) com.xpn.xwiki.store.XWikiHibernateBaseStore.executeSQL(XWikiHibernateBaseStore.java:718) com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:684) com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:876) com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:808) com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:780) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1503) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1546) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:884) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:854) com.xpn.xwiki.XWiki.<init>(XWiki.java:791) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:401) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:148) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:128) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:621) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) -----Mensagem original----- De: [email protected] [mailto:[email protected]] Em nome de Danilo Amaral de Oliveira Enviada em: quinta-feira, 18 de julho de 2013 15:59 Para: XWiki Users Assunto: [xwiki-users] RES: XEM Installation Questions Anyone can help with my installation in my Oracle databse?? In my company we have standards to our database, schemas and tablespace and the configuration created to the WIKI is: Database: DVS IP: 10.10.161.97 SCHEMA: WIKICRP TABLESPACE (table creation)= TBS_WIKCRP TABLESPACE (Index creation)= TBS_IND_WIKCRP ORACLE SID = DVSHO Well my hibernate configuration is: <property name="connection.url">jdbc:oracle:thin:@10.10.161.97:1521:DVSHO</property> <property name="connection.username">WIKICRP</property> <property name="connection.password">WIKICRP</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.SetBigStringTryClob">true</property> <property name="jdbc.batch_size">0</property> <property name="jdbc.use_streams_for_binary">false</property> <property name="dbcp.ps.maxActive">20</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> But it isn't working, I don't know the hibernate architecture then anyone know if I need to customize anything more to install the XEM? Thank you -----Mensagem original----- De: [email protected] [mailto:[email protected]] Em nome de Thomas Mortagne Enviada em: segunda-feira, 15 de julho de 2013 11:46 Para: XWiki Users Assunto: Re: [xwiki-users] XEM Installation Questions Each wiki has it's own shema so if you want to create new wiki from XWiki you will have to let XWiki create new shemas (and in case of Oracle also create new users since each shema is associated to a user from what I remember). An alternative is to create shema yourself whenever you need and tell XWiki to reuse that existing schema. On Mon, Jul 15, 2013 at 2:23 PM, Danilo Amaral de Oliveira <[email protected]> wrote:
Hello People,
How are you? I am installing the XEM in an Oracle DB and I have a question about the privileges of the xwiki user database. When the site says "you need to guarantee all privileges to user xwiki" what kind of privileges is it describing?
I need to guarantee more privileges than listed below?
grant create session to xwiki; grant create table to xwiki; grant create sequence to xwiki;
Thank you! Danilo Oliveira _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users