[xwiki-users] New wiki creation
Hi, I'm searching for weeks now, and i didn't find anything that work... I tried soooo many things without success. My Xwiki server work fine exept one thing, the wiki creation. Every time i have this error: <http://xwiki.475771.n2.nabble.com/file/n7603193/2017-03-22_09_29_02-Cr%C3%A9er_un_nouveau_wiki_%28WikiManager.png> here the complete msg: Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/utilisateurs] Checking Hibernate mapping and updating schema if needed for wiki [utilisateurs] SQL Error: 1146, SQLState: 42S02 Table 'utilisateurs.xwikidbversion' doesn't exist Table 'utilisateurs.xwikidbversion' doesn't exist class com.xpn.xwiki.store.migration.DataMigrationException: Unable to store new data version 90000 into database utilisateurs at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:169) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1340) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1419) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:158) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.hibernate.exception.SQLGrammarException: could not execute update query at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:110) at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:423) at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283) at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1288) at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$3.doInHibernate(HibernateDataMigrationManager.java:163) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1334) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1419) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:158) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class java.sql.SQLSyntaxErrorException: Table 'utilisateurs.xwikidbversion' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:536) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:115) at com.mysql.cj.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:1983) at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1826) at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2034) at com.mysql.cj.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:1970) at com.mysql.cj.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:4984) at com.mysql.cj.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1955) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:101) at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:423) at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283) at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1288) at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$3.doInHibernate(HibernateDataMigrationManager.java:163) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1334) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1419) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBVersionToDatabase(HibernateDataMigrationManager.java:158) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.updateMigrationStatus(AbstractDataMigrationManager.java:509) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(AbstractDataMigrationManager.java:470) at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initializeEmptyDB(HibernateDataMigrationManager.java:143) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(AbstractDataMigrationManager.java:445) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initializeCurrentDatabase(AbstractDataMigrationManager.java:550) at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533) at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:765) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:942) at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:873) at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:865) at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:280) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1817) at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1870) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:65) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Fail to get the configuration document for wiki [utilisateurs]. class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to execute creation steps on the wiki [utilisateurs]. at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:104) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to set metadata to the wiki [utilisateurs]. at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:81) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: class org.xwiki.wiki.user.WikiUserManagerException: Fail to get the configuration document for wiki [utilisateurs]. at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getDocument(DefaultWikiUserConfigurationHelper.java:67) at org.xwiki.wiki.user.internal.DefaultWikiUserConfigurationHelper.getConfiguration(DefaultWikiUserConfigurationHelper.java:79) at org.xwiki.wiki.user.internal.DefaultWikiUserManager.setUserScope(DefaultWikiUserManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.SaveWikiMetaDataStep.execute(SaveWikiMetaDataStep.java:76) at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:96) at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:206) at org.xwiki.job.AbstractJob.run(AbstractJob.java:189) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Finished job of type [wikicreationjob] with identifier [wikicreation/createandinstall/utilisateurs] Here is the Catalina log for this action: catalinaerror.txt <http://xwiki.475771.n2.nabble.com/file/n7603193/catalinaerror.txt> Can someone help me please ? I don't know where to look anymore... I looked the hibernate file, but everything seems ok, the user used for the connexion is the MySQL root user, so he has every rights on the MySQL server... Thank you. Daniel -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi,
On 22 Mar 2017, at 11:54, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Hi,
I'm searching for weeks now, and i didn't find anything that work... I tried soooo many things without success.
My Xwiki server work fine exept one thing, the wiki creation. Every time i have this error:
here the complete msg:
Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/utilisateurs] Checking Hibernate mapping and updating schema if needed for wiki [utilisateurs] SQL Error: 1146, SQLState: 42S02 Table 'utilisateurs.xwikidbversion' doesn't exist Table 'utilisateurs.xwikidbversion' doesn't exist class com.xpn.xwiki.store.migration.DataMigrationException: Unable to store new data version 90000 into database utilisateurs
[snip] Caused by: class java.sql.SQLSyntaxErrorException: Table 'utilisateurs.xwikidbversion' doesn't exist Seems this is your problem. Does it exist? If you’re using MySQL you should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL Thanks -Vincent
Here is the Catalina log for this action: catalinaerror.txt <http://xwiki.475771.n2.nabble.com/file/n7603193/catalinaerror.txt>
Can someone help me please ? I don't know where to look anymore... I looked the hibernate file, but everything seems ok, the user used for the connexion is the MySQL root user, so he has every rights on the MySQL server...
Thank you.
Daniel
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi Vincent, Thank you for your reply. No, the table doesn't exist. Do i need to create it manually ? I taught that the Application manager do the creation of the Database and the tables itself for a new Wiki ? Even if i create manually the database, it's the same message... Thanks for your link, i used it for the installation of Xwiki, it helped me a lot. I don't see anything right now that can solve this issue... :( I searched again this morning, changing hibernate (who i configured with the documentation here) configuration with the SQL dialect extension, tried with superadmin activated, checked on MySQL if the users have the good rights (again), made some change in xwiki.cfg, no change. Do the user name in the hibernate need to be xwiki ?? Because it's the only thing that's is différent right now. Maybe i'm missing something (i will be no suprised of it...), but for now i don't know. I will keep searching and testing this afternoon, if you have any idea who could help me... Or if i did not understand something, sorry... Thank you again, Daniel. -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603211.html Sent from the XWiki- Users mailing list archive at Nabble.com.
On 23 Mar 2017, at 15:07, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Hi Vincent,
Thank you for your reply.
No, the table doesn't exist. Do i need to create it manually ?
No, xwiki does it. It didn’t do it here probably because it’s not correctly configured. Maybe xwiki.cfg has not been modified to tell it to use a DB named something else than “xwiki”? See the following line in xwiki.cfg which you need to change if you don’t use “xwiki” as the db name: # xwiki.db=xwiki
I taught that the Application manager do the creation of the Database and the tables itself for a new Wiki ? Even if i create manually the database, it's the same message...
Thanks for your link, i used it for the installation of Xwiki, it helped me a lot. I don't see anything right now that can solve this issue... :(
If you don’t want problem I’d suggest redoing your install with a db named “xwiki”. If you really want to change your DB name make sure you change it everywhere (hibernate.cfg.xml, xwiki.cfg). Thanks -Vincent
I searched again this morning, changing hibernate (who i configured with the documentation here) configuration with the SQL dialect extension, tried with superadmin activated, checked on MySQL if the users have the good rights (again), made some change in xwiki.cfg, no change.
Do the user name in the hibernate need to be xwiki ?? Because it's the only thing that's is différent right now.
Maybe i'm missing something (i will be no suprised of it...), but for now i don't know. I will keep searching and testing this afternoon, if you have any idea who could help me... Or if i did not understand something, sorry...
Thank you again, Daniel.
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603211.html Sent from the XWiki- Users mailing list archive at Nabble.com.
On 23 Mar 2017, at 15:11, Vincent Massol <vincent@massol.net> wrote:
On 23 Mar 2017, at 15:07, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Hi Vincent,
Thank you for your reply.
No, the table doesn't exist. Do i need to create it manually ?
No, xwiki does it. It didn’t do it here probably because it’s not correctly configured. Maybe xwiki.cfg has not been modified to tell it to use a DB named something else than “xwiki”?
See the following line in xwiki.cfg which you need to change if you don’t use “xwiki” as the db name: # xwiki.db=xwiki
See also http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigure... Thanks -Vincent PS: I’ve never use a db name other than “xwiki” so I’m not really an expert on this :)
I taught that the Application manager do the creation of the Database and the tables itself for a new Wiki ? Even if i create manually the database, it's the same message...
Thanks for your link, i used it for the installation of Xwiki, it helped me a lot. I don't see anything right now that can solve this issue... :(
If you don’t want problem I’d suggest redoing your install with a db named “xwiki”.
If you really want to change your DB name make sure you change it everywhere (hibernate.cfg.xml, xwiki.cfg).
Thanks -Vincent
I searched again this morning, changing hibernate (who i configured with the documentation here) configuration with the SQL dialect extension, tried with superadmin activated, checked on MySQL if the users have the good rights (again), made some change in xwiki.cfg, no change.
Do the user name in the hibernate need to be xwiki ?? Because it's the only thing that's is différent right now.
Maybe i'm missing something (i will be no suprised of it...), but for now i don't know. I will keep searching and testing this afternoon, if you have any idea who could help me... Or if i did not understand something, sorry...
Thank you again, Daniel.
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603211.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Forget what I said, I read too fast. Your problem is not with the main wiki but with creating sub wikis. Thanks -Vincent
On 23 Mar 2017, at 15:12, Vincent Massol <vincent@massol.net> wrote:
On 23 Mar 2017, at 15:11, Vincent Massol <vincent@massol.net> wrote:
On 23 Mar 2017, at 15:07, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Hi Vincent,
Thank you for your reply.
No, the table doesn't exist. Do i need to create it manually ?
No, xwiki does it. It didn’t do it here probably because it’s not correctly configured. Maybe xwiki.cfg has not been modified to tell it to use a DB named something else than “xwiki”?
See the following line in xwiki.cfg which you need to change if you don’t use “xwiki” as the db name: # xwiki.db=xwiki
See also http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigure...
Thanks -Vincent
PS: I’ve never use a db name other than “xwiki” so I’m not really an expert on this :)
I taught that the Application manager do the creation of the Database and the tables itself for a new Wiki ? Even if i create manually the database, it's the same message...
Thanks for your link, i used it for the installation of Xwiki, it helped me a lot. I don't see anything right now that can solve this issue... :(
If you don’t want problem I’d suggest redoing your install with a db named “xwiki”.
If you really want to change your DB name make sure you change it everywhere (hibernate.cfg.xml, xwiki.cfg).
Thanks -Vincent
I searched again this morning, changing hibernate (who i configured with the documentation here) configuration with the SQL dialect extension, tried with superadmin activated, checked on MySQL if the users have the good rights (again), made some change in xwiki.cfg, no change.
Do the user name in the hibernate need to be xwiki ?? Because it's the only thing that's is différent right now.
Maybe i'm missing something (i will be no suprised of it...), but for now i don't know. I will keep searching and testing this afternoon, if you have any idea who could help me... Or if i did not understand something, sorry...
Thank you again, Daniel.
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603211.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Yes indeed :D -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603215.html Sent from the XWiki- Users mailing list archive at Nabble.com.
So I don’t know what your problem is. XWiki should create the tables automatically when creating a sub wiki schema. Maybe someone else has an idea? Thanks -Vincent
On 23 Mar 2017, at 15:15, Vincent Massol <vincent@massol.net> wrote:
Forget what I said, I read too fast.
Your problem is not with the main wiki but with creating sub wikis.
Thanks -Vincent
On 23 Mar 2017, at 15:12, Vincent Massol <vincent@massol.net> wrote:
On 23 Mar 2017, at 15:11, Vincent Massol <vincent@massol.net> wrote:
On 23 Mar 2017, at 15:07, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Hi Vincent,
Thank you for your reply.
No, the table doesn't exist. Do i need to create it manually ?
No, xwiki does it. It didn’t do it here probably because it’s not correctly configured. Maybe xwiki.cfg has not been modified to tell it to use a DB named something else than “xwiki”?
See the following line in xwiki.cfg which you need to change if you don’t use “xwiki” as the db name: # xwiki.db=xwiki
See also http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigure...
Thanks -Vincent
PS: I’ve never use a db name other than “xwiki” so I’m not really an expert on this :)
I taught that the Application manager do the creation of the Database and the tables itself for a new Wiki ? Even if i create manually the database, it's the same message...
Thanks for your link, i used it for the installation of Xwiki, it helped me a lot. I don't see anything right now that can solve this issue... :(
If you don’t want problem I’d suggest redoing your install with a db named “xwiki”.
If you really want to change your DB name make sure you change it everywhere (hibernate.cfg.xml, xwiki.cfg).
Thanks -Vincent
I searched again this morning, changing hibernate (who i configured with the documentation here) configuration with the SQL dialect extension, tried with superadmin activated, checked on MySQL if the users have the good rights (again), made some change in xwiki.cfg, no change.
Do the user name in the hibernate need to be xwiki ?? Because it's the only thing that's is différent right now.
Maybe i'm missing something (i will be no suprised of it...), but for now i don't know. I will keep searching and testing this afternoon, if you have any idea who could help me... Or if i did not understand something, sorry...
Thank you again, Daniel.
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603211.html Sent from the XWiki- Users mailing list archive at Nabble.com.
You should probably make sure whatever MySQL user XWiki use have the right to create tables. On Thu, Mar 23, 2017 at 3:15 PM, Vincent Massol <vincent@massol.net> wrote:
Forget what I said, I read too fast.
Your problem is not with the main wiki but with creating sub wikis.
Thanks -Vincent
On 23 Mar 2017, at 15:12, Vincent Massol <vincent@massol.net> wrote:
On 23 Mar 2017, at 15:11, Vincent Massol <vincent@massol.net> wrote:
On 23 Mar 2017, at 15:07, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Hi Vincent,
Thank you for your reply.
No, the table doesn't exist. Do i need to create it manually ?
No, xwiki does it. It didn’t do it here probably because it’s not correctly configured. Maybe xwiki.cfg has not been modified to tell it to use a DB named something else than “xwiki”?
See the following line in xwiki.cfg which you need to change if you don’t use “xwiki” as the db name: # xwiki.db=xwiki
See also http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigure...
Thanks -Vincent
PS: I’ve never use a db name other than “xwiki” so I’m not really an expert on this :)
I taught that the Application manager do the creation of the Database and the tables itself for a new Wiki ? Even if i create manually the database, it's the same message...
Thanks for your link, i used it for the installation of Xwiki, it helped me a lot. I don't see anything right now that can solve this issue... :(
If you don’t want problem I’d suggest redoing your install with a db named “xwiki”.
If you really want to change your DB name make sure you change it everywhere (hibernate.cfg.xml, xwiki.cfg).
Thanks -Vincent
I searched again this morning, changing hibernate (who i configured with the documentation here) configuration with the SQL dialect extension, tried with superadmin activated, checked on MySQL if the users have the good rights (again), made some change in xwiki.cfg, no change.
Do the user name in the hibernate need to be xwiki ?? Because it's the only thing that's is différent right now.
Maybe i'm missing something (i will be no suprised of it...), but for now i don't know. I will keep searching and testing this afternoon, if you have any idea who could help me... Or if i did not understand something, sorry...
Thank you again, Daniel.
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603211.html Sent from the XWiki- Users mailing list archive at Nabble.com.
-- Thomas Mortagne
Sorry, i'm not familiar with the right terms too... -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603218.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Thank you. I'm using the root user, he has full rights on MySQL. -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603219.html Sent from the XWiki- Users mailing list archive at Nabble.com.
That's weird then. Usually that's all it takes to create new wikis. Do you get any details if you click on " SQL Error: 1146, SQLState: 42S02" warning ? Seems to be the real issue here and the error you printed more a consequence. On Thu, Mar 23, 2017 at 3:18 PM, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Thank you. I'm using the root user, he has full rights on MySQL.
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603219.html Sent from the XWiki- Users mailing list archive at Nabble.com.
-- Thomas Mortagne
On Thu, Mar 23, 2017 at 3:26 PM, Thomas Mortagne <thomas.mortagne@xwiki.com> wrote:
That's weird then. Usually that's all it takes to create new wikis.
Do you get any details if you click on " SQL Error: 1146, SQLState: 42S02" warning ? Seems to be the real issue here and the error you printed more a consequence.
On Thu, Mar 23, 2017 at 3:18 PM, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Thank you. I'm using the root user, he has full rights on MySQL.
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603219.html Sent from the XWiki- Users mailing list archive at Nabble.com.
-- Thomas Mortagne
From what I see on Google it could mean you made a mistake in hibernate.cfg.xml file.
-- Thomas Mortagne
It's not clickable. When i search for that error message, a lot of answers are lincked with "hibernate", that's why i'm focusing on the hibernate configuration, but it seems all good for me.... Thanks. -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603222.html Sent from the XWiki- Users mailing list archive at Nabble.com.
I hope you are right, here is my hibernate... i tried few different configuration... <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="show_sql">false</property> <property name="use_outer_join">true</property> <property name="jdbc.use_scrollable_resultset">false</property> <property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxTotal">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWaitMillis">30000</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.url">jdbc:mysql://localhost/xwiki?useSSL=false</property> <property name="connection.username">root</property> <property name="connection.password">******</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> <property name="hibernate.connection.charSet">UTF-8</property> <property name="hibernate.connection.useUnicode">true</property> <property name="hibernate.connection.characterEncoding">utf8</property> <property name="dbcp.poolPreparedStatements">true</property> <property name="dbcp.maxOpenPreparedStatements">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/> </session-factory> </hibernate-configuration> -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603223.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Sorry it was too big... I will keep looking on the hibernate side, thanks. -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603224.html Sent from the XWiki- Users mailing list archive at Nabble.com.
From what I see I have exactly the same hibernate setup and wiki creation works fine.
I have XWiki 9.1.2 and MySQL 5.7.17 On Thu, Mar 23, 2017 at 3:36 PM, terminal <daniel.dasnevescoelho@forch.fr> wrote:
I hope you are right, here is my hibernate... i tried few different configuration...
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory>
<property name="show_sql">false</property> <property name="use_outer_join">true</property>
<property name="jdbc.use_scrollable_resultset">false</property>
<property name="dbcp.defaultAutoCommit">false</property> <property name="dbcp.maxTotal">50</property> <property name="dbcp.maxIdle">5</property> <property name="dbcp.maxWaitMillis">30000</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<property name="connection.url">jdbc:mysql://localhost/xwiki?useSSL=false</property> <property name="connection.username">root</property> <property name="connection.password">******</property> <property name="connection.driver_class">com.mysql.jdbc.Driver</property> <property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<property name="hibernate.connection.charSet">UTF-8</property> <property name="hibernate.connection.useUnicode">true</property> <property name="hibernate.connection.characterEncoding">utf8</property>
<property name="dbcp.poolPreparedStatements">true</property> <property name="dbcp.maxOpenPreparedStatements">20</property> <mapping resource="xwiki.hbm.xml"/> <mapping resource="feeds.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> <mapping resource="instance.hbm.xml"/> <mapping resource="mailsender.hbm.xml"/>
</session-factory> </hibernate-configuration>
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603223.html Sent from the XWiki- Users mailing list archive at Nabble.com.
-- Thomas Mortagne
That's not good for me... :( i'm using enterprise edition 9.0 and MySQL 5.5.54-0+deb8u1. Thanks for checking. -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603226.html Sent from the XWiki- Users mailing list archive at Nabble.com.
Ok i will try today to updade MySQL server, i used the command to intsall it, but it seems that not the latest version... -- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603231.html Sent from the XWiki- Users mailing list archive at Nabble.com.
I tested on XWiki 9.1.2 + MySQL 5.5.54 (Ubuntu 14.04, the other one was Ubuntu 16.10) and it works fine too. On Fri, Mar 24, 2017 at 8:57 AM, terminal <daniel.dasnevescoelho@forch.fr> wrote:
Ok i will try today to updade MySQL server, i used the command to intsall it, but it seems that not the latest version...
-- View this message in context: http://xwiki.475771.n2.nabble.com/New-wiki-creation-tp7603193p7603231.html Sent from the XWiki- Users mailing list archive at Nabble.com.
-- Thomas Mortagne
participants (3)
-
terminal -
Thomas Mortagne -
Vincent Massol