On Jul 20, 2013, at 1:52 PM, Vincent Massol <[email protected]> wrote:
On Jul 18, 2013, at 10:48 PM, Danilo Amaral de Oliveira <[email protected]> wrote:
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!
Actually you could use the name you want if you create the database/schema yourself for the subwikis. All you need then is to create the wiki descriptor object to point to it.
Forget that. I misunderstood…. Thanks -Vincent
Thanks -Vincent
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 _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users