New wiki creation

classic Classic list List threaded Threaded
20 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

New wiki creation

terminal
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
    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

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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

vmassol
Administrator
Hi,

> On 22 Mar 2017, at 11:54, terminal <[hidden email]> 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.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

vmassol
Administrator

> On 23 Mar 2017, at 15:07, terminal <[hidden email]> 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.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

vmassol
Administrator

> On 23 Mar 2017, at 15:11, Vincent Massol <[hidden email]> wrote:
>
>
>> On 23 Mar 2017, at 15:07, terminal <[hidden email]> 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#HConfigurethenamesofdatabaseschemas

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.
>

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

vmassol
Administrator
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 <[hidden email]> wrote:
>
>>
>> On 23 Mar 2017, at 15:11, Vincent Massol <[hidden email]> wrote:
>>
>>
>>> On 23 Mar 2017, at 15:07, terminal <[hidden email]> 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#HConfigurethenamesofdatabaseschemas
>
> 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.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
Yes indeed :D

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

vmassol
Administrator
In reply to this post by vmassol
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 <[hidden email]> 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 <[hidden email]> wrote:
>>
>>>
>>> On 23 Mar 2017, at 15:11, Vincent Massol <[hidden email]> wrote:
>>>
>>>
>>>> On 23 Mar 2017, at 15:07, terminal <[hidden email]> 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#HConfigurethenamesofdatabaseschemas
>>
>> 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.
>

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

Thomas Mortagne
Administrator
In reply to this post by vmassol
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 <[hidden email]> 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 <[hidden email]> wrote:
>>
>>>
>>> On 23 Mar 2017, at 15:11, Vincent Massol <[hidden email]> wrote:
>>>
>>>
>>>> On 23 Mar 2017, at 15:07, terminal <[hidden email]> 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#HConfigurethenamesofdatabaseschemas
>>
>> 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
In reply to this post by terminal
Sorry, i'm not familiar with the right terms too...
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
In reply to this post by Thomas Mortagne
Thank you. I'm using the root user, he has full rights on MySQL.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

Thomas Mortagne
Administrator
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
<[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

Thomas Mortagne
Administrator
On Thu, Mar 23, 2017 at 3:26 PM, Thomas Mortagne
<[hidden email]> 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
> <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
In reply to this post by 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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
This post was updated on .
In reply to this post by Thomas Mortagne
I hope you are right, here is my hibernate... i tried few different configuration...

If you don't mind take a look...

hibernate.xml
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
Sorry it was too big...

I will keep looking on the hibernate side, thanks.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

Thomas Mortagne
Administrator
In reply to this post by terminal
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
<[hidden email]> 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
>   &quot;-//Hibernate/Hibernate Configuration DTD//EN&quot;
>   &quot;http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd&quot;>
> <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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
That's not good for me... :( i'm using enterprise edition 9.0 and MySQL 5.5.54-0+deb8u1.

Thanks for checking.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

terminal
In reply to this post by Thomas Mortagne
Ok i will try today to updade MySQL server, i used the command to intsall it, but it seems that not the latest version...

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: New wiki creation

Thomas Mortagne
Administrator
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
<[hidden email]> 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
Loading...