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