22 Mar
2017
22 Mar
'17
11:54 a.m.
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.
23 Mar
23 Mar
2:08 p.m.
Hi,
On 22 Mar 2017, at 11:54, terminal
<daniel.dasnevescoelho(a)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:
<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
[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.
3:07 p.m.
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.
3:11 p.m.
On 23 Mar 2017, at 15:07, terminal
<daniel.dasnevescoelho(a)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.
3:12 p.m.
On 23 Mar 2017, at 15:11, Vincent Massol
<vincent(a)massol.net> wrote:
See also
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigur…
Thanks
-Vincent
PS: I’ve never use a db name other than “xwiki” so I’m not really an expert on this :)
On 23 Mar 2017, at 15:07, terminal
<daniel.dasnevescoelho(a)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.
3:15 p.m.
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(a)massol.net> wrote:
On 23 Mar 2017, at 15:11, Vincent Massol <vincent(a)massol.net> wrote:
See also
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigur…
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. On 23 Mar 2017, at 15:07, terminal
<daniel.dasnevescoelho(a)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
3:16 p.m.
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.
3:16 p.m.
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(a)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(a)massol.net> wrote:
On 23 Mar 2017, at 15:11, Vincent Massol <vincent(a)massol.net> wrote:
See also
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigur…
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. On 23 Mar 2017, at 15:07, terminal
<daniel.dasnevescoelho(a)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 
3:16 p.m.
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(a)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
--
Thomas Mortagne
On 23 Mar 2017, at 15:12, Vincent Massol
<vincent(a)massol.net> wrote:
On 23 Mar 2017, at 15:11, Vincent Massol <vincent(a)massol.net> wrote:
See also
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration#HConfigur…
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. On 23 Mar 2017, at 15:07, terminal
<daniel.dasnevescoelho(a)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
3:17 p.m.
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.
3:18 p.m.
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.
3:26 p.m.
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(a)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
3:27 p.m.
On Thu, Mar 23, 2017 at 3:26 PM, Thomas Mortagne
<thomas.mortagne(a)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(a)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
3:31 p.m.
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.
3:36 p.m.
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.
3:48 p.m.
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.
4:02 p.m.
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(a)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
4:08 p.m.
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.
24 Mar
24 Mar
8:57 a.m.
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.
10:54 a.m.
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(a)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
2830
days inactive
2832
days old
19 comments
3 participants
participants (3)
-
terminal -
Thomas Mortagne -
Vincent Massol