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 _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
