[xwiki-users] XWiki 8 failure to add new wiki - Access denied for user 'xwiki'@'%'
Created a new 8.2.1 wiki using mysql and tomcat 7 and initial user (created by the distribution wizard) seems unable to create a new wiki despite being part of the admin group, which was granted "create wiki" right and also being given "create wiki" right in the administration app. The salient error seems to be: *Access denied for user 'xwiki'@'%' to database 'wikiweb'* (where wikiweb was the new wiki name) the 'xwiki'@'localhost' mysql user has all privileges on *.*, so this does not seem to be the problem - could anyone shed any light on what the problem might be or what I could look at? Thanks Tim The full set of error messages are below: Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/wikiweb] Access denied for user 'xwiki'@'%' to database 'wikiweb' class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to execute creation steps on the wiki [wikiweb]. at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:102) 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 create the wiki [wikiweb]. at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:54) 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.manager.WikiManagerException: Failed to create database for wiki "wikiweb" at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:69) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) 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 3401 in 3: Exception while create wiki database wikiweb at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:338) at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:629) at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:67) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) 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.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xwiki'@'%' to database 'wikiweb' at sun.reflect.GeneratedConstructorAccessor167.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:320) at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:629) at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:67) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) 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/wikiweb] -- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-8-failure-to-add-new-wiki-Access-den... Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi Tim,
On 17 Aug 2016, at 18:17, Tim.Jones <[email protected]> wrote:
Created a new 8.2.1 wiki using mysql and tomcat 7 and initial user (created by the distribution wizard) seems unable to create a new wiki despite being part of the admin group, which was granted "create wiki" right and also being given "create wiki" right in the administration app.
The salient error seems to be:
*Access denied for user 'xwiki'@'%' to database 'wikiweb'* (where wikiweb was the new wiki name)
the 'xwiki'@'localhost' mysql user has all privileges on *.*, so this does not seem to be the problem - could anyone shed any light on what the problem might be or what I could look at?
Looking at the error, it really looks like an error at the DB level (and not at the xwiki level). As you mentioned, it seems to be a privilege issue: the xwiki users must have the right permissions for all schemas. I can’t tell you more but you should check this out. Something like: mysql -u root -e "grant all privileges on *.* to xwiki@localhost identified by 'xwiki'" Thanks -Vincent
Thanks
Tim
The full set of error messages are below:
Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/wikiweb] Access denied for user 'xwiki'@'%' to database 'wikiweb' class org.xwiki.platform.wiki.creationjob.WikiCreationException: Failed to execute creation steps on the wiki [wikiweb]. at org.xwiki.platform.wiki.creationjob.internal.WikiCreationJob.runInternal(WikiCreationJob.java:102) 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 create the wiki [wikiweb]. at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:54) 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.manager.WikiManagerException: Failed to create database for wiki "wikiweb" at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:69) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) 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 3401 in 3: Exception while create wiki database wikiweb at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:338) at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:629) at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:67) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) 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.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'xwiki'@'%' to database 'wikiweb' at sun.reflect.GeneratedConstructorAccessor167.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) at com.mysql.jdbc.Util.getInstance(Util.java:387) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2503) at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:839) at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:739) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:291) at com.xpn.xwiki.store.XWikiHibernateStore.createWiki(XWikiHibernateStore.java:320) at com.xpn.xwiki.store.XWikiCacheStore.createWiki(XWikiCacheStore.java:629) at org.xwiki.wiki.internal.manager.DefaultWikiCreator.create(DefaultWikiCreator.java:67) at org.xwiki.wiki.internal.manager.DefaultWikiManager.create(DefaultWikiManager.java:88) at org.xwiki.platform.wiki.creationjob.internal.steps.CreateWikiStep.execute(CreateWikiStep.java:52) 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/wikiweb]
-- View this message in context: http://xwiki.475771.n2.nabble.com/XWiki-8-failure-to-add-new-wiki-Access-den... Sent from the XWiki- Users mailing list archive at Nabble.com.
participants (2)
-
Tim.Jones -
Vincent Massol