March 2009 - xwiki-users@xwiki.org

Re: [xwiki-users] Stats module configuration
by Dilipkumar Jadhav 10 Mar '09

10 Mar '09

Hello friends, I've tried placing the new xwiki-plugin-jodatime-1.3.jar. Restarted tomcat and still no statistics. The result set like another friend said is still : NULL There is definitely valid data in the stats tables (when i query it through Sqlyog). Thank you....

2 1

Re: [xwiki-users] Stats module configuratio
by PERINAUD Christophe 10 Mar '09

10 Mar '09

Thank you Sergiu. Now i don't have this exceptions anymore. Like Dilipkumar, now i have graphics but only with 0 values I checked the content of the ActivityData page and all i have is titles and red messages with "Table: null" when i open the page (but maybe it needs some extra parameters) I wait for the helpdesk to accept the install of DbVisualizer to check the content of Stats tables and try to execute the SQL query that is in XWikiStatsReader.java to check the result. All other stats tables are ok and filled with values. -----Message d'origine----- De : users-bounces(a)xwiki.org [mailto:[email protected]] De la part de Sergiu Dumitriu Envoyé : lundi 9 mars 2009 17:24 À : XWiki Users Objet : Re: [xwiki-users] Stats module configuratio PERINAUD Christophe wrote: > Sorry, bad eyes .... > xwiki-plugin-jodatime-1.2.jar This one had a minor bug that prevented the whole plugin from working (http://jira.xwiki.org/jira/browse/XPJODA-9) You should replace it with http://maven.xwiki.org/releases/com/xpn/xwiki/platform/plugins/xwiki-plugin… > -----Message d'origine----- > De : users-bounces(a)xwiki.org [mailto:[email protected]] De la part de Sergiu Dumitriu > Envoyé : lundi 9 mars 2009 16:56 > À : XWiki Users > Objet : Re: [xwiki-users] Stats module configuratio > > PERINAUD Christophe wrote: >> I currently use this file : joda-time-1.4.jar >> I think it's the one delivered with the 1.7.1 pack > > No, not joda-time, xwiki-plugin-jodatime. >> -----Message d'origine----- >> De : users-bounces(a)xwiki.org [mailto:[email protected]] De la part de Sergiu Dumitriu >> Envoyé : lundi 9 mars 2009 16:23 >> À : XWiki Users >> Objet : Re: [xwiki-users] Stats module configuratio >> >> PERINAUD Christophe wrote: >>> Hi, >>> >>> I have the kind of same problem with statistics that are not displayed on my main wiki or that crashes in any virtual wiki. >>> The Joda time plugin is enabled but when i follow the advice from Sergiu in a virtual wiki by editing the Current Month Activity panel i can see that the plugin is installed, is available but when i call the getDateTime method it throws a null pointer exception as if the getProtectedPlugin().getDateTime() (line 67 of JodaTimePluginApi) is not working as expected in virtual mode (what ever is the parameter value). >>> In the main wiki, it works but does not display any activity (always 0 values) despite values in the database (Oracle 10) >>> >>> What is strange is that the problem occured only in graphical statistics (not stats like most edited pages for example) >>> >>> -----Message d'origine----- >>> >>> 2. The Joda time plugin might be disabled >>> >>> I see that the line com.xpn.xwiki.plugin.jodatime.JodaTimePlugin is in >>> my xwiki.cfg properties >>> Also, joda-time-1.4.jar is available in WEB_INF > lib folder >>> >>> >> What version of xwiki-plugin-jodatime do you have in WEB-INF/lib? >> > > -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

1 0

[xwiki-users] RTF-Export (1.8RC2)
by hel-o 10 Mar '09

10 Mar '09

Hi, since sometime my rtf-Export doesn't work anymore. First i could make an export but i couldn't open the document. Now (updated to 1.8RC2) i only get the following error. "21:11:38,464 [http://xwiki.jbk-net.com/xwiki/bin/export/GettingStarted/WebHome?format=rtf] [http-8180-Processor20] ERROR datatypes.LengthBase - getBaseLength called without context" Any help appreciated. Thanks hel. ----- hel. hel(a)hel.at -- View this message in context: http://n2.nabble.com/RTF-Export-%281.8RC2%29-tp2451398p2451398.html Sent from the XWiki- Users mailing list archive at Nabble.com.

2 2

[xwiki-users] XWiki authentication configuration for encrypted userPassword sotred in LDAP (SHA algorithm)
by Christophe GRAVIER 09 Mar '09

09 Mar '09

Dear XWiki users, I have been looking for authenticating my xwiki users against a LDAP directory (OpenLdap, debian box), where the userPassword field is encrypted using the SHA algorithm. Unfortunately, I am not able to configure xwiki to encrypt the password entered by the user before the authentication and authorization process. I receive the following snip, after enabling ldap logging in a custom log4j.properties file as indicated in the doc: com.xpn.xwiki.XWikiException: Error number 8001 in 8: LDAP authentication failed: could not validate the password: wrong password for uid=gravier.christophe,ou=xxx,o=yyyy,c=fr The configuration is nevertheless good in overall, because I can log in if I store my password as plain text binary in my LDAP server (but I don't want it to be plain text in the LDAP server of course...). I have been searching the documentation, FAQ and user/dev mailing lists, and I only found encryption related to cookie storage, or SHA encryption for xwiki-webdav module (http://xwiki.markmail.org/message/k2r2qqu2twjputml?q=ldap+SHA ) developpers' thoughts. Does someone have any clue on how to configure xwiki for encrypted userPassword stored in OpenLDAP please ? Thank you in advance for any information in this matter ! Best Regards, Ch. Gravier -- Dr.-Ing. Christophe Gravier DIOM laboratory - http://diom.telecom-st-etienne.fr/ TELECOM Saint-Étienne (formerly "Istase") - http://www.telecom-st-etienne.fr/ Jabber ID : gravier.christophe(a)jabber.istase.com Homepage: http://diom.telecom-st-etienne.com/public/cgravier/ Research project: http://diom.istase.fr/satin/einst/

2 3

Re: [xwiki-users] Bug : unable to delete attached files in virtualwikis
by PERINAUD Christophe 09 Mar '09

09 Mar '09

Niels, Thank you again. I changed the configuration to disable the recycle bin and now i am able to delete attached files I disabled also for pages and it works too. -----Message d'origine----- De : users-bounces(a)xwiki.org [mailto:[email protected]] De la part de Niels Mayer Envoyé : samedi 7 mars 2009 10:47 À : XWiki Users Objet : Re: [xwiki-users] Bug : unable to delete attached files in virtualwikis I had a similar problem, with attachments not being deletable, which also prevented the document itself from being deleted. Unfortunately, this also suggested an additional issue arising with attachments. If a user makes large attachments to their user-document, e.g. XWiki.MyName then even in a "closed" wiki that only allows users to edit their own user document, they can cause a denial of service attack through large attachments. In other words, even if the wiki is setup so that regular registered XWikiAllGroup users don't have write access to any directory, just comment-access to documents; they'll still have write access to their own XWiki.MyName document created through registration... and that means they'll be able to add attachments even when you think they couldn't. The "Rights" adminstration checkbox "Prevent unregistered users from editing pages, regardless of the page or space rights" doesn't prevent attachments from being added to user's own pages. Anyways, I ended up solving the blowups and OOM errors by deleting the attachments directly in the database: mysql> select XWA_ID,XWA_DOC_ID,XWA_FILENAME,XWA_SIZE,XWA_AUTHOR from xwikiattachment where XWA_AUTHOR='XWiki.JG'; | XWA_ID | XWA_DOC_ID | XWA_FILENAME | XWA_SIZE | XWA_AUTHOR| | 1185703559 | 168880978 | foo.pdf | 9817587 | XWiki.JG | | -352107721 | 168880978 | bar.pdf | 13049680 | XWiki.JG | | 1527849923 | 168880978 | baz.pdf | 293 | XWiki.JG | | -2073884056 | 168880978 | frop.pdf | 5904061 | XWiki.JG | | 1039500510 | 168880978 | schlop.pdf | 4440028 | XWiki.JG | | 942569068 | 168880978 | plop.pdf | 14033466 | XWiki.JG | | 1363529635 | 168880978 | schnops.pdf | 0 | XWiki.JG | | -1054875919 | 168880978 | hops.jpg | 3081 | XWiki.JG | 8 rows in set (0.00 sec) mysql> delete from xwikiattachment where XWA_AUTHOR='XWiki.JG'; Query OK, 8 rows affected (0.00 sec) Someone please tell me if this is not the right way to fix such issues... As afterthought, I realized that setting xwiki.store.attachment.versioning.hint=void in xwiki.cfg might prevent xwiki from reading/diffing and attempting to version a large attachment. Doing so could certainly make it run out of memory, and changing this option might prevent the bug?: #-# The attachment versioning storage. Use 'void' to disable attachment versioning. # xwiki.store.attachment.versioning.hint=default Also, perhaps by not sending deleted attachments to the recycle bin, it won't need to be copied anywhere, and therefore there'll not be any memory to run out copying a giant attachment through java (assuming that's what happens on delete). #-# The attachment recycle bin storage. # xwiki.store.attachment.recyclebin.hint=default Niels http://nielsmayer.com PS: perhaps the defaults for xwiki.store.attachment.versioning.hint and xwiki.store.attachment.recyclebin.hint need to be changed? On Fri, Mar 6, 2009 at 2:37 AM, PERINAUD Christophe < Christophe.PERINAUD(a)kbl-bank.com> wrote: > Hello (again) > > All is ok in the main wiki but in a virtual wiki i can't delete an attached > file of a page. After the confirmation message i got : > > A problem occured while trying to service your request. Please contact the > support if this happens again. > > Detailed information: > > Error number 0 in 3: Exception while hibernate execute > Wrapped Exception: could not get next sequence value > com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while > hibernate execute > Wrapped Exception: could not get next sequence value > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1052) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1098) > at > com.xpn.xwiki.store.hibernate.HibernateAttachmentRecycleBinStore.saveToRecycleBin(HibernateAttachmentRecycleBinStore.java:83) > at > com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:2799) > at > com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:2782) > at > com.xpn.xwiki.web.DeleteAttachmentAction.action(DeleteAttachmentAction.java:72) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:215) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) > at > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:135) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:287) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) > at org.mortbay.http.HttpServer.service(HttpServer.java:954) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) > at > org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) > at > org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) > > > Wrapped Exception: > > java.sql.SQLException: ORA-02289: sequence does not exist > > at > oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74) > at > oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) > at > oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) > at > oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) > at > oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) > at > oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) > at > oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) > at > oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) > at > org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75) > at > org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:99) > at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) > at > org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33) > at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) > at > org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27) > at > org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) > at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535) > at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523) > at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519) > at > com.xpn.xwiki.store.hibernate.HibernateAttachmentRecycleBinStore$1.doInHibernate(HibernateAttachmentRecycleBinStore.java:87) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1046) > at > com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1098) > at > com.xpn.xwiki.store.hibernate.HibernateAttachmentRecycleBinStore.saveToRecycleBin(HibernateAttachmentRecycleBinStore.java:83) > at > com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:2799) > at > com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:2782) > at > com.xpn.xwiki.web.DeleteAttachmentAction.action(DeleteAttachmentAction.java:72) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:215) > at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:115) > at > org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) > at > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) > at > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) > at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830) > at > com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:68) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:135) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:287) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) > at > org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821) > at > org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1565) > at > org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) > at org.mortbay.http.HttpContext.handle(HttpContext.java:1517) > at org.mortbay.http.HttpServer.service(HttpServer.java:954) > at org.mortbay.http.HttpConnection.service(HttpConnection.java:816) > at > org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983) > at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833) > at > org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244) > at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) > at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534) > > Again it's an Oracle problem. Any idea if it's because of the shema used or > a DBA problem (admin Db team followed instructions from web site to allow > all rigts to the xwiki user) ? > > Thank you > > > System : > Windows Server 2003 SP2 in a VMWare instance > Oracle 10g > Java 1.6.0_12 > Xwiki 1.7.1 from the pack Jetty/HSQL > > Christophe Périnaud > > > -------------------------------------------------------------------------------- > > This e-mail is intended only for the addressee named above. It does not > bind the sender, except in the case of an existing written convention with > the addressee. This e-mail may contain material that is confidential and > privileged for the sole use of the intended recipient. Any review, reliance > or distribution by others or forwarding without express permission is > strictly prohibited and may be unlawful. If you are not the intended > recipient, please contact the sender and delete all copies. > > While reasonable precautions have been taken to ensure that this e-mail and > any attachments are free from any computer virus or similar defect, no > liability will be accepted in that respect. Anyone accessing this e-mail > must take their own precautions as to security and virus protection. > > KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, > R.C.S. Luxembourg B 6395, T (352) 47 97 1 > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

2 1

Re: [xwiki-users] Stats module configuratio
by PERINAUD Christophe 09 Mar '09

09 Mar '09

Sorry, bad eyes .... xwiki-plugin-jodatime-1.2.jar -----Message d'origine----- De : users-bounces(a)xwiki.org [mailto:[email protected]] De la part de Sergiu Dumitriu Envoyé : lundi 9 mars 2009 16:56 À : XWiki Users Objet : Re: [xwiki-users] Stats module configuratio PERINAUD Christophe wrote: > I currently use this file : joda-time-1.4.jar > I think it's the one delivered with the 1.7.1 pack No, not joda-time, xwiki-plugin-jodatime. > > -----Message d'origine----- > De : users-bounces(a)xwiki.org [mailto:[email protected]] De la part de Sergiu Dumitriu > Envoyé : lundi 9 mars 2009 16:23 > À : XWiki Users > Objet : Re: [xwiki-users] Stats module configuratio > > PERINAUD Christophe wrote: >> Hi, >> >> I have the kind of same problem with statistics that are not displayed on my main wiki or that crashes in any virtual wiki. >> The Joda time plugin is enabled but when i follow the advice from Sergiu in a virtual wiki by editing the Current Month Activity panel i can see that the plugin is installed, is available but when i call the getDateTime method it throws a null pointer exception as if the getProtectedPlugin().getDateTime() (line 67 of JodaTimePluginApi) is not working as expected in virtual mode (what ever is the parameter value). >> In the main wiki, it works but does not display any activity (always 0 values) despite values in the database (Oracle 10) >> >> What is strange is that the problem occured only in graphical statistics (not stats like most edited pages for example) >> >> -----Message d'origine----- >> >> 2. The Joda time plugin might be disabled >> >> I see that the line com.xpn.xwiki.plugin.jodatime.JodaTimePlugin is in >> my xwiki.cfg properties >> Also, joda-time-1.4.jar is available in WEB_INF > lib folder >> >> > > What version of xwiki-plugin-jodatime do you have in WEB-INF/lib? > -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

2 1

Re: [xwiki-users] Stats module configuratio
by PERINAUD Christophe 09 Mar '09

09 Mar '09

I currently use this file : joda-time-1.4.jar I think it's the one delivered with the 1.7.1 pack -----Message d'origine----- De : users-bounces(a)xwiki.org [mailto:[email protected]] De la part de Sergiu Dumitriu Envoyé : lundi 9 mars 2009 16:23 À : XWiki Users Objet : Re: [xwiki-users] Stats module configuratio PERINAUD Christophe wrote: > Hi, > > I have the kind of same problem with statistics that are not displayed on my main wiki or that crashes in any virtual wiki. > The Joda time plugin is enabled but when i follow the advice from Sergiu in a virtual wiki by editing the Current Month Activity panel i can see that the plugin is installed, is available but when i call the getDateTime method it throws a null pointer exception as if the getProtectedPlugin().getDateTime() (line 67 of JodaTimePluginApi) is not working as expected in virtual mode (what ever is the parameter value). > In the main wiki, it works but does not display any activity (always 0 values) despite values in the database (Oracle 10) > > What is strange is that the problem occured only in graphical statistics (not stats like most edited pages for example) > > -----Message d'origine----- > > 2. The Joda time plugin might be disabled > > I see that the line com.xpn.xwiki.plugin.jodatime.JodaTimePlugin is in > my xwiki.cfg properties > Also, joda-time-1.4.jar is available in WEB_INF > lib folder > > What version of xwiki-plugin-jodatime do you have in WEB-INF/lib? -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

2 1

Re: [xwiki-users] Stats module configuratio
by PERINAUD Christophe 09 Mar '09

09 Mar '09

Hi, I have the kind of same problem with statistics that are not displayed on my main wiki or that crashes in any virtual wiki. The Joda time plugin is enabled but when i follow the advice from Sergiu in a virtual wiki by editing the Current Month Activity panel i can see that the plugin is installed, is available but when i call the getDateTime method it throws a null pointer exception as if the getProtectedPlugin().getDateTime() (line 67 of JodaTimePluginApi) is not working as expected in virtual mode (what ever is the parameter value). In the main wiki, it works but does not display any activity (always 0 values) despite values in the database (Oracle 10) What is strange is that the problem occured only in graphical statistics (not stats like most edited pages for example) -----Message d'origine----- 2. The Joda time plugin might be disabled I see that the line com.xpn.xwiki.plugin.jodatime.JodaTimePlugin is in my xwiki.cfg properties Also, joda-time-1.4.jar is available in WEB_INF > lib folder > Message: 7 > Date: Sun, 8 Mar 2009 10:51:34 +0100 > From: Thomas Mortagne <thomas.mortagne(a)xwiki.com> > Subject: Re: [xwiki-users] Stats module configuration > To: XWiki Users <users(a)xwiki.org> > Message-ID: > <a8e97d9c0903080151t75b2a7b6l202fa944df5170ac(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi, > > On Sat, Mar 7, 2009 at 16:59, Dilipkumar Jadhav > <jadhav.dilipkumar(a)gmail.com> wrote: >> Hello friends, >> My wiki has grown considerably now and we are at a phase where we >> would like to measure and analyze contributors and their >> contributions. ?I am using XWiki 1.7.2. >> >> I followed the instructions at >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration and >> set the following in the ?xwiki.cfg file. >> >> xwiki.stats=1 >> xwiki.stats.default=1 >> >> Now, I can see that the stats are being recorded in the database (mysql) tables. >> However, when i visit the stats home in my wiki all i see is "No >> statistics have been recorded" for all statistics panels. All the >> graphs show no activity. Also, i have enabled the stats module about 2 >> weeks back during which course there has been a lot of activity on the >> wiki. >> >> Also, the stats seems to work on the XWiki installed on my home pc. >> However, at my office ?instance of XWiki the stats module does not >> work. Could it have something to do with the proxy server that we have >> setup in office. > > "No statistics have been recorded" is printed when statistics are > disabled so I doubt it has anything to do with proxy (it does not > really check if there is something recorded or not, even if nothing > was in the database it should generate en empty graph). Maybe you have > a "statistics" field set to 0 in XWiki.XWikiPreferences (edit in > object mode to check) > >> >> Did i miss out on some crucial steps... >> Any help will be greatly appreciated. >> >> Thank you... >> _______________________________________________ >> users mailing list >> users(a)xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> > > > > -- > Thomas Mortagne > > > ------------------------------ > > Message: 8 > Date: Sun, 08 Mar 2009 11:40:58 +0100 > From: Sergiu Dumitriu <sergiu(a)xwiki.com> > Subject: Re: [xwiki-users] Stats module configuration > To: XWiki Users <users(a)xwiki.org> > Message-ID: <49B3A0BA.3070603(a)xwiki.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Thomas Mortagne wrote: >> Hi, >> >> On Sat, Mar 7, 2009 at 16:59, Dilipkumar Jadhav >> <jadhav.dilipkumar(a)gmail.com> wrote: >>> Hello friends, >>> My wiki has grown considerably now and we are at a phase where we >>> would like to measure and analyze contributors and their >>> contributions. I am using XWiki 1.7.2. >>> >>> I followed the instructions at >>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration and >>> set the following in the xwiki.cfg file. >>> >>> xwiki.stats=1 >>> xwiki.stats.default=1 >>> >>> Now, I can see that the stats are being recorded in the database (mysql) tables. >>> However, when i visit the stats home in my wiki all i see is "No >>> statistics have been recorded" for all statistics panels. All the >>> graphs show no activity. Also, i have enabled the stats module about 2 >>> weeks back during which course there has been a lot of activity on the >>> wiki. >>> >>> Also, the stats seems to work on the XWiki installed on my home pc. >>> However, at my office instance of XWiki the stats module does not >>> work. Could it have something to do with the proxy server that we have >>> setup in office. >> >> "No statistics have been recorded" is printed when statistics are >> disabled so I doubt it has anything to do with proxy (it does not >> really check if there is something recorded or not, even if nothing >> was in the database it should generate en empty graph). Maybe you have >> a "statistics" field set to 0 in XWiki.XWikiPreferences (edit in >> object mode to check) >> > > No Thomas, the message when statistics are disabled is "The statistics > module is disabled by default for improved performance. For more > details, see ..". This message means that nothing was retrieved from the > database. > > There might be a problem with another component, the best thing to do is > to debug each statement in one of the panels. Take for example the > Stats.CurrentMonthActivity document, edit the panel, and after each #set > line print the newly set variable, and see which one is wrong. A > possible problem is that the jodatime plugin is disabled. > > -- > Sergiu Dumitriu > http://purl.org/net/sergiu/ > > > ------------------------------ > > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > > > End of users Digest, Vol 20, Issue 16 > ************************************* > _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users -------------------------------------------------------------------------------- This e-mail is intended only for the addressee named above. It does not bind the sender, except in the case of an existing written convention with the addressee. This e-mail may contain material that is confidential and privileged for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender and delete all copies. While reasonable precautions have been taken to ensure that this e-mail and any attachments are free from any computer virus or similar defect, no liability will be accepted in that respect. Anyone accessing this e-mail must take their own precautions as to security and virus protection. KBL European Private Bankers S.A., 43 boulevard Royal L-2955 Luxembourg, R.C.S. Luxembourg B 6395, T (352) 47 97 1

2 1

Re: [xwiki-users] Stats module configuratio
by Dilipkumar Jadhav 09 Mar '09

09 Mar '09

Dear all, Thank you so much for your prompt response. I've tried to check all the things you have suggested. This is where i stand now: 1. Debug each line of the stats panel I printed out the values at the end of each #set line in the most edited pages panel. This is what i got as a result: com.xpn.xwiki.criteria.impl.Scope@19fd285 com.xpn.xwiki.criteria.impl.Period@11ff313 com.xpn.xwiki.criteria.impl.Range@4348c6 [] The final [] in the fourth line above is the value for $stats 2. The Joda time plugin might be disabled I see that the line com.xpn.xwiki.plugin.jodatime.JodaTimePlugin is in my xwiki.cfg properties Also, joda-time-1.4.jar is available in WEB_INF > lib folder 3. "Maybe you have a "statistics" field set to 0 in XWiki.XWikiPreferences (edit in object mode to check)" I went to the XWiki.XwikiPreferences page and checked it in the object mode. Unfortunately, i do not see any "statistics" field in there. Could you please provide me with some exact example that i should look for in this page. I see info about panels & skins et al. But nothing about the statistics field. 4. I read the line in the user guide that says - "When statistics are globally enabled, storage can be enabled/disabled by wiki using the XWikiPreference property "statistics" Is this the same statistics field that we are talking about in point 3 above...If so, i really need some more clarity on looking up XWikipreferences in the object mode. 5. I have disabled the module and enabled it again. But there is still no data being displayed on the panels. All it says is - "No statistics recorded" Please help...thank you friends. > Message: 7 > Date: Sun, 8 Mar 2009 10:51:34 +0100 > From: Thomas Mortagne <thomas.mortagne(a)xwiki.com> > Subject: Re: [xwiki-users] Stats module configuration > To: XWiki Users <users(a)xwiki.org> > Message-ID: > <a8e97d9c0903080151t75b2a7b6l202fa944df5170ac(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > Hi, > > On Sat, Mar 7, 2009 at 16:59, Dilipkumar Jadhav > <jadhav.dilipkumar(a)gmail.com> wrote: >> Hello friends, >> My wiki has grown considerably now and we are at a phase where we >> would like to measure and analyze contributors and their >> contributions. ?I am using XWiki 1.7.2. >> >> I followed the instructions at >> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration and >> set the following in the ?xwiki.cfg file. >> >> xwiki.stats=1 >> xwiki.stats.default=1 >> >> Now, I can see that the stats are being recorded in the database (mysql) tables. >> However, when i visit the stats home in my wiki all i see is "No >> statistics have been recorded" for all statistics panels. All the >> graphs show no activity. Also, i have enabled the stats module about 2 >> weeks back during which course there has been a lot of activity on the >> wiki. >> >> Also, the stats seems to work on the XWiki installed on my home pc. >> However, at my office ?instance of XWiki the stats module does not >> work. Could it have something to do with the proxy server that we have >> setup in office. > > "No statistics have been recorded" is printed when statistics are > disabled so I doubt it has anything to do with proxy (it does not > really check if there is something recorded or not, even if nothing > was in the database it should generate en empty graph). Maybe you have > a "statistics" field set to 0 in XWiki.XWikiPreferences (edit in > object mode to check) > >> >> Did i miss out on some crucial steps... >> Any help will be greatly appreciated. >> >> Thank you... >> _______________________________________________ >> users mailing list >> users(a)xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> > > > > -- > Thomas Mortagne > > > ------------------------------ > > Message: 8 > Date: Sun, 08 Mar 2009 11:40:58 +0100 > From: Sergiu Dumitriu <sergiu(a)xwiki.com> > Subject: Re: [xwiki-users] Stats module configuration > To: XWiki Users <users(a)xwiki.org> > Message-ID: <49B3A0BA.3070603(a)xwiki.com> > Content-Type: text/plain; charset=UTF-8; format=flowed > > Thomas Mortagne wrote: >> Hi, >> >> On Sat, Mar 7, 2009 at 16:59, Dilipkumar Jadhav >> <jadhav.dilipkumar(a)gmail.com> wrote: >>> Hello friends, >>> My wiki has grown considerably now and we are at a phase where we >>> would like to measure and analyze contributors and their >>> contributions. I am using XWiki 1.7.2. >>> >>> I followed the instructions at >>> http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Configuration and >>> set the following in the xwiki.cfg file. >>> >>> xwiki.stats=1 >>> xwiki.stats.default=1 >>> >>> Now, I can see that the stats are being recorded in the database (mysql) tables. >>> However, when i visit the stats home in my wiki all i see is "No >>> statistics have been recorded" for all statistics panels. All the >>> graphs show no activity. Also, i have enabled the stats module about 2 >>> weeks back during which course there has been a lot of activity on the >>> wiki. >>> >>> Also, the stats seems to work on the XWiki installed on my home pc. >>> However, at my office instance of XWiki the stats module does not >>> work. Could it have something to do with the proxy server that we have >>> setup in office. >> >> "No statistics have been recorded" is printed when statistics are >> disabled so I doubt it has anything to do with proxy (it does not >> really check if there is something recorded or not, even if nothing >> was in the database it should generate en empty graph). Maybe you have >> a "statistics" field set to 0 in XWiki.XWikiPreferences (edit in >> object mode to check) >> > > No Thomas, the message when statistics are disabled is "The statistics > module is disabled by default for improved performance. For more > details, see ..". This message means that nothing was retrieved from the > database. > > There might be a problem with another component, the best thing to do is > to debug each statement in one of the panels. Take for example the > Stats.CurrentMonthActivity document, edit the panel, and after each #set > line print the newly set variable, and see which one is wrong. A > possible problem is that the jodatime plugin is disabled. > > -- > Sergiu Dumitriu > http://purl.org/net/sergiu/ > > > ------------------------------ > > _______________________________________________ > users mailing list > users(a)xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > > > End of users Digest, Vol 20, Issue 16 > ************************************* >

2 1

Re: [xwiki-users] Need HQL query for date comparison
by MaryEllen Coleman 09 Mar '09

09 Mar '09

I'm using this query now: #set($sql = ", BaseObject as obj, $proptype as prop where obj.className='${ISDclassname}' and obj.id=prop.id.id and prop.name='${viewby}' and doc.fullName=obj.name and doc.fullName!='$ {ISDclasstemplate}' and $xwiki.getDate()-doc.contentUpdateDate<15 order by prop.value") And I am getting this error: Error number 4001 in 4: Error while parsing velocity page ISDCenter.WebHome Wrapped Exception: Failed to evaluate content with id Web Home Let me guess: subtracting doc.contentUpdateDate from $xwiki.getDate() is invalid? Is there another way that I should manipulate the dates so that I can determine if a document is too old to display? Thanks! Mary Ellen Coleman

1 0