Hi Tim, > On 17 Aug 2016, at 18:17, Tim.Jones <tim.jones....@gmail.com> 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-denied-for-user-xwiki-tp7600693.html > Sent from the XWiki- Users mailing list archive at Nabble.com. > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
