Re: [xwiki-users] dafault DB name change
Here it is... Timestamp Jan 30, 2012 17:56:30.064 Log Level INFO Logger javax.enterprise.system.std.com.sun.enterprise.server.logging Name-Value Pairs _ThreadID=25;_ThreadName=Thread-2; Record Number 72 Message ID Complete Message 2012-01-30 17:56:30,064 [http://mydomain.com:8180/xwiki/bin/view/Main/] WARN c.x.x.XWiki - Exception while getting wiki preference [xwiki.plugin.activitystream.daystokeepevents] com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: Access denied for user 'test'@'localhost' to database 'xwiki' at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:856) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:283) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1427) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1470) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2207) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.plugin.ActivityStreamPlugin.getActivityStreamPreference(ActivityStreamPlugin.java:111) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamCleaner.getNumberOfDaysToKeep(ActivityStreamCleaner.java:106) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamCleaner.init(ActivityStreamCleaner.java:215) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamImpl.init(ActivityStreamImpl.java:230) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.plugin.ActivityStreamPlugin.init(ActivityStreamPlugin.java:124) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:152) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:88) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:116) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1111) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:792) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.<init>(XWiki.java:739) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:401) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) [xwiki-platform-legacy-oldcore-3.4.jar:na] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) [struts-1.2.9.jar:1.2.9] at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [javax.servlet.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [javax.servlet.jar:na] at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1539) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128) [xwiki-platform-legacy-oldcore-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) [xwiki-platform-wysiwyg-server-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) [xwiki-platform-webdav-server-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217) [xwiki-platform-container-servlet-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) [xwiki-platform-container-servlet-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595) [web-core.jar:3.1.1] at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:98) [web-glue.jar:3.1.1] at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:91) [web-glue.jar:3.1.1] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:162) [web-core.jar:3.1.1] at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:330) [web-core.jar:3.1.1] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231) [web-core.jar:3.1.1] at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:174) [kernel.jar:3.1.1] at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:828) [grizzly-http.jar:1.9.36] at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:725) [grizzly-http.jar:1.9.36] at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1019) [grizzly-http.jar:1.9.36] at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225) [grizzly-http.jar:1.9.36] at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79) [grizzly-http.jar:1.9.36] at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.ContextTask.run(ContextTask.java:71) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532) [grizzly-utils.jar:1.9.36] at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513) [grizzly-utils.jar:1.9.36] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: Access denied for user 'test'@'localhost' to database 'xwiki' at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:631) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:767) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:731) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] ... 67 common frames omitted Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'test'@'localhost' to database 'xwiki' at sun.reflect.GeneratedConstructorAccessor162.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) ~[na:1.6.0_26] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) ~[na:1.6.0_26] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.setCatalog(ConnectionImpl.java:5086) ~[mysql-connector-java-5.1.18-bin.jar:na] at org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setCatalog(PoolingDataSource.java:333) ~[commons-dbcp-1.3.jar:1.3] at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_26] at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_26] at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at $Proxy213.setCatalog(Unknown Source) ~[na:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:620) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] ... 69 common frames omitted 30 января 2012, 21:29 от Thomas Mortagne <[email protected]>:
On Mon, Jan 30, 2012 at 6:10 PM, Haru Mamburu <[email protected]> wrote:
Yes, I did. :-(
XEM 3.4
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: Access denied for user 'test'@'localhost' to database 'xwiki'
Do you have more ? Would be nice to get the full stack trace.
And actually there is no DB xwiki in Mysql. Xwiki is completely right. The rest settings in xwiki.cfg are intact.
Kind regards
Dmitry
PS. Sorry for the private mailing
30 января 2012, 20:46 от Thomas Mortagne <[email protected]>:
On Mon, Jan 30, 2012 at 5:06 PM, Haru Mamburu <[email protected]> wrote:
Hi, All!
Does anyone know, is it possible to change default DB name xwiki to smth else?
I changed in config.cfg,
xwiki.db=test
in hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/test</property>
After XWiki reload it tries to access xwiki db still. :-(
What is correct way to do it?
Well that's supposed to be the correct way actually. You sure you uncommented xwiki.db ?
Thanks in advance,
Dmitry _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
I just tested and I reproduce the exact same issue when I don't put the proper database in hibernate.cfg.xml file and it works well otherwise. But since you said you have the proper database in hibernate.cfg.xml I don't have much ideas. Maybe <property name="connection.url"> is set several times. On Mon, Jan 30, 2012 at 7:35 PM, Haru Mamburu <[email protected]> wrote:
Here it is...
Timestamp Jan 30, 2012 17:56:30.064 Log Level INFO Logger javax.enterprise.system.std.com.sun.enterprise.server.logging Name-Value Pairs _ThreadID=25;_ThreadName=Thread-2; Record Number 72 Message ID Complete Message 2012-01-30 17:56:30,064 [http://mydomain.com:8180/xwiki/bin/view/Main/] WARN c.x.x.XWiki - Exception while getting wiki preference [xwiki.plugin.activitystream.daystokeepevents] com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: Access denied for user 'test'@'localhost' to database 'xwiki' at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:856) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:283) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1427) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1470) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2207) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.plugin.ActivityStreamPlugin.getActivityStreamPreference(ActivityStreamPlugin.java:111) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamCleaner.getNumberOfDaysToKeep(ActivityStreamCleaner.java:106) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamCleaner.init(ActivityStreamCleaner.java:215) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamImpl.init(ActivityStreamImpl.java:230) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.activitystream.plugin.ActivityStreamPlugin.init(ActivityStreamPlugin.java:124) [xwiki-platform-activitystream-3.4.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:152) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:88) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:116) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1111) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:792) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.<init>(XWiki.java:739) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:401) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) [xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) [xwiki-platform-legacy-oldcore-3.4.jar:na] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) [struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) [struts-1.2.9.jar:1.2.9] at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [javax.servlet.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [javax.servlet.jar:na] at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1539) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:343) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:128) [xwiki-platform-legacy-oldcore-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) [xwiki-platform-wysiwyg-server-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) [xwiki-platform-webdav-server-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:217) [xwiki-platform-container-servlet-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109) [xwiki-platform-container-servlet-3.4.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:256) [web-core.jar:3.1.1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:217) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655) [web-core.jar:3.1.1] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595) [web-core.jar:3.1.1] at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:98) [web-glue.jar:3.1.1] at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:91) [web-glue.jar:3.1.1] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:162) [web-core.jar:3.1.1] at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:330) [web-core.jar:3.1.1] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231) [web-core.jar:3.1.1] at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:174) [kernel.jar:3.1.1] at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:828) [grizzly-http.jar:1.9.36] at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:725) [grizzly-http.jar:1.9.36] at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1019) [grizzly-http.jar:1.9.36] at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225) [grizzly-http.jar:1.9.36] at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79) [grizzly-http.jar:1.9.36] at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.ContextTask.run(ContextTask.java:71) [grizzly-framework.jar:1.9.36] at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532) [grizzly-utils.jar:1.9.36] at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513) [grizzly-utils.jar:1.9.36] at java.lang.Thread.run(Thread.java:662) [na:1.6.0_26] Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: Access denied for user 'test'@'localhost' to database 'xwiki' at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:631) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:767) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:731) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] ... 67 common frames omitted Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'test'@'localhost' to database 'xwiki' at sun.reflect.GeneratedConstructorAccessor162.newInstance(Unknown Source) ~[na:na] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) ~[na:1.6.0_26] at java.lang.reflect.Constructor.newInstance(Constructor.java:513) ~[na:1.6.0_26] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618) ~[mysql-connector-java-5.1.18-bin.jar:na] at com.mysql.jdbc.ConnectionImpl.setCatalog(ConnectionImpl.java:5086) ~[mysql-connector-java-5.1.18-bin.jar:na] at org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingConnection.setCatalog(DelegatingConnection.java:374) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setCatalog(PoolingDataSource.java:333) ~[commons-dbcp-1.3.jar:1.3] at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) ~[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_26] at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_26] at org.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:74) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at $Proxy213.setCatalog(Unknown Source) ~[na:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:620) ~[xwiki-platform-legacy-oldcore-3.4.jar:na] ... 69 common frames omitted
30 января 2012, 21:29 от Thomas Mortagne <[email protected]>:
On Mon, Jan 30, 2012 at 6:10 PM, Haru Mamburu <[email protected]> wrote:
Yes, I did. :-(
XEM 3.4
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3202 in 3: Exception while reading document [name = [XWikiPreferences], type = [DOCUMENT], parent = [name = [XWiki], type = [SPACE], parent = [name = [xwiki], type = [WIKI], parent = [null]]]] Wrapped Exception: Error number 3301 in 3: Exception while switching to database xwiki Wrapped Exception: Access denied for user 'test'@'localhost' to database 'xwiki'
Do you have more ? Would be nice to get the full stack trace.
And actually there is no DB xwiki in Mysql. Xwiki is completely right. The rest settings in xwiki.cfg are intact.
Kind regards
Dmitry
PS. Sorry for the private mailing
30 января 2012, 20:46 от Thomas Mortagne <[email protected]>:
On Mon, Jan 30, 2012 at 5:06 PM, Haru Mamburu <[email protected]> wrote:
Hi, All!
Does anyone know, is it possible to change default DB name xwiki to smth else?
I changed in config.cfg,
xwiki.db=test
in hibernate.cfg.xml
<property name="connection.url">jdbc:mysql://localhost/test</property>
After XWiki reload it tries to access xwiki db still. :-(
What is correct way to do it?
Well that's supposed to be the correct way actually. You sure you uncommented xwiki.db ?
Thanks in advance,
Dmitry _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
participants (2)
-
Haru Mamburu -
Thomas Mortagne