31 Jan
2012
31 Jan
'12
8:26 a.m.
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 <haru_mamburu(a)mail.ru> 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 <thomas.mortagne(a)xwiki.com>om>:
--
Thomas Mortagne
On Mon, Jan 30, 2012 at 6:10 PM, Haru Mamburu
<haru_mamburu(a)mail.ru> wrote:
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users 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
--
Thomas Mortagne
30 января 2012, 20:46 от Thomas Mortagne <thomas.mortagne(a)xwiki.com>om>:
> On Mon, Jan 30, 2012 at 5:06 PM, Haru Mamburu <haru_mamburu(a)mail.ru> 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
> > users(a)xwiki.org
> > http://lists.xwiki.org/mailman/listinfo/users
>
> --
> Thomas Mortagne
>
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users