October 2006 - xwiki-users@xwiki.org

XWiki Silicon Valley Meetup this week - Oct 16 to Oct 21st ?
by Ludovic Dubost 18 Oct '06

18 Oct '06

With Jeremi, we are visiting Silicon Valley thanks to Google organizing a Summer of Code Mentor Meetup. We will be staying one week until December 22nd. Maybe it could be possible to organize an XWiki Meetup sometime this week if somebody can host us. We could talk about what's currently happening on XWiki, XWiki's future, how XWiki is currently used and what we could improve. It could include any type of users XWiki. It could last a few hours after work time one evening. We will be staying a little out of town (Santa Cruz) but we have a car and can move to the valley in the evenings. We will also be back on Friday evening somewhere around Mountain View. The Meetup could also be saturday morning. Anybody interested and/or able to host the meetup ? Ludovic -- Ludovic Dubost XPertNet: http://www.xpertnet.fr/ Blog: http://www.ludovic.org/blog/ XWiki: http://www.xwiki.com Skype: ldubost AIM: nvludo Yahoo: ludovic

2 3

RE: [xwiki-users] how to move xwiki port to 80
by Anurag Chitlangia 18 Oct '06

18 Oct '06

This works for windows, I tried, but will this work for linux? cheers anurag chitlangia To Err is Human, to forgive is not COMPANY policy! .- -. ..- .-. .- --. -----Original Message----- From: Artem Melentyev [mailto:melenartem@yandex.ru] Sent: Wednesday, October 18, 2006 3:36 PM To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] how to move xwiki port to 80 Anurag Chitlangia wrote: > Currently my tomcat is pointing to 8080 port > > And I want it to be on 80 port. Any clues as how can I do it! Change in tomcat/conf/server.xml <Connector port="8080" ... to <Connector port="80" ... and run tomcat on user root (administrator) -- Artem Melentyev, UralSU, CS401 This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at http://www.amdocs.com/email_disclaimer.asp

2 1

AW: RE: [xwiki-users] how to move xwiki port to 80
by Frank Häfemeier 18 Oct '06

18 Oct '06

In linux, there is no difference to windows. There could be a problem if you have a web server running on the same machine. Bye Frank > >This works for windows, I tried, but will this work for linux? > > >cheers >anurag chitlangia >To Err is Human, to forgive is not COMPANY policy! >.- -. ..- .-. .- --. > >-----Original Message----- >From: Artem Melentyev [mailto:melenartem@yandex.ru] >Sent: Wednesday, October 18, 2006 3:36 PM >To: xwiki-users(a)objectweb.org >Subject: Re: [xwiki-users] how to move xwiki port to 80 > >Anurag Chitlangia wrote: >> Currently my tomcat is pointing to 8080 port >> >> And I want it to be on 80 port. Any clues as how can I do it! >Change in tomcat/conf/server.xml ><Connector port="8080" ... >to ><Connector port="80" ... > >and run tomcat on user root (administrator) > >-- > Artem Melentyev, UralSU, CS401 > > >This message and the information contained herein is proprietary and >confidential and subject to the Amdocs policy statement, >you may review at http://www.amdocs.com/email_disclaimer.asp > > > >-- >You receive this message as a subscriber of the xwiki-users(a)objectweb.org >mailing list. >To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org >For general help: mailto:sympa@objectweb.org?subject=help >ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

1 0

how to move xwiki port to 80
by Anurag Chitlangia 18 Oct '06

18 Oct '06

Currently my tomcat is pointing to 8080 port And I want it to be on 80 port. Any clues as how can I do it! cheers anurag chitlangia To Err is Human, to forgive is not COMPANY policy! .- -. ..- .-. .- --. This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement, you may review at http://www.amdocs.com/email_disclaimer.asp

2 1

Trouble setting up xWiki with SQL Server
by renny.samuel＠ge.com 18 Oct '06

18 Oct '06

Hi, I am trying to get XWiki installed with SQL Server for the first time. When I try to access WebHome...it gives me this error javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiUsers Wrapped Exception: Error number 3221 in 3: Exception while saving class XWiki.XWikiUsers Wrapped Exception: Error number 3222 in 3: Exception while saving class XWiki.XWikiUsers Wrapped Exception: JDBC rollback failed org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397) javax.servlet.http.HttpServlet.service(HttpServlet.java:689) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127 Please help. Thanks in advance Renny

2 5

XWiki Api Documentation
by jeremi joslin 17 Oct '06

17 Oct '06

Hi, Ludovic and me worked on the documentation of the API. I haven't finish the documentation of Document. here is the link : http://build.xpertnet.biz/latestdoc/api/ jeremi

1 0

RE: [xwiki-users] delete spam comments
by wangwh＠att.net 17 Oct '06

17 Oct '06

Hi, Brian, Thanks a lot. My site is on Xwiki.com, can I do all these steps? Is there a way just to stop showing comments right now? Wei-hsing -------------- Original message ---------------------- From: "THOMAS, BRIAN M (SBCSI)" <bt0008(a)att.com> > Direct database time... > > First, BACK UP your database. > > No. First, if you are not an SQL hack, get someone who is. > > Now, BACK UP your database. > > Next, you must delete all rows connected with spam comments. > > I'm going to derive the process whereby you do this, because I'm a > little rusty on the XWiki database schemas, and because I'm an > inveterate pedant. You can skip some of these steps that exist for > information only if you wish, especially if you already know how to do > them. > > First, it's necessary to know which rows constitute comments. XWiki's > dynamic typing is a great boon to users and an equally great bane to > administrators, as you will soon see. The xwikiclasses table describes > user-defined classes (well, actually it doesn't; it names them, and > describes server-defined custom classes if there are any, which > fortunately there aren't, because I couldn't tell you what to do if > there were). The class that defines XWiki comments is named > XWiki.XWikiComments. The xwikiclassesprop table contains the list of > fields for a given class, which is identified not by its name but by the > unique ID from the xwikiclasses table. So you need to get the ID of the > row in the xwikiclasses table whose name field is 'XWiki.XWikiComments', > and retrieve the field name and type from all rows of the > xwikiclassesprop table that have that ID. The following SQL does this > less verbosely: > > select xwp_name, xwp_classtype > from xwikiclassesprop p, xwikiclasses c > where xwo_name = 'XWiki.XWikiComments' > and p.xwp_id = c.xwo_id > > The results of this should be: > +-----------+---------------------------------------------+ > | xwp_name | xwp_classtype | > +-----------+---------------------------------------------+ > | author | com.xpn.xwiki.objects.classes.StringClass | > | comment | com.xpn.xwiki.objects.classes.TextAreaClass | > | date | com.xpn.xwiki.objects.classes.DateClass | > | highlight | com.xpn.xwiki.objects.classes.TextAreaClass | > | replyto | com.xpn.xwiki.objects.classes.NumberClass | > +-----------+---------------------------------------------+ > 5 rows in set (0.00 sec) > > You'd have to go into the XWiki source (more specifically, the Hibernate > configuration, I believe) to see how the xwp_classtype field above links > to what I'm doing below; I leave that as an exercise for the reader. > All that's really needed is to know the types of the fields and which > tables they're stored in. > > I've actually misled you somewhat: this is not the actual schema of > existing comment objects but the prototype for the creation of new > comments. I've done this ostensibly to give you a fuller understanding > of how XWiki allows one to change the definition of a user-defined class > without breaking existing instances, but it's really because I got > tripped up on it myself, and I wanted to share my misery with you. > > To get the actual schema for existing comments you have to look at the > xwikiobjects table, which defines actual XWiki object instances in terms > of their class names and the document to which they belong. The xwo_id > field is the field that ties all of the tables together. > > So the following query: > > select distinct(xwp_name), xwp_classtype > from xwikiobjects o, xwikiproperties p > where xwo_classname='XWiki.XWikiComments' > and xwo_id = xwp_id > > yields a similar-looking result (in my database, anyway), because the > XWiki.XWikiComments class hasn't changed since these comments were > added: > +-----------+-------------------------------------------+ > | xwp_name | xwp_classtype | > +-----------+-------------------------------------------+ > | author | com.xpn.xwiki.objects.StringProperty | > | date | com.xpn.xwiki.objects.DateProperty | > | comment | com.xpn.xwiki.objects.LargeStringProperty | > | replyto | com.xpn.xwiki.objects.IntegerProperty | > | highlight | com.xpn.xwiki.objects.LargeStringProperty | > +-----------+-------------------------------------------+ > 5 rows in set (0.05 sec) > > So now we know (without explaining how) that (for example) the contents > of the "author" field of an instance of the class named > XWiki.XWikiComments is in the xwikistrings table, in a row whose xws_id > field matches the xwo_id field of an xwikiobjects row whose > xwo_classname file is "XWiki.XWikiComments". All the field values can > be found thus: > > field name table name field value > author xwikistrings xws_value > date xwikidates xws_value > comment xwikilargestrings xwl_value > replyto xwikiintegers xwi_value > highlight xwikilargestrings xwl_value > > So all the fields of a comment would be retrieved, given its ID, by the > following query: > > select s.xws_value, /* author name */ > d.xws_value, /* comment date */ > l.xws_value, /* comment text */ > i.xwi_value, /* reply-to field */ > h.xwl_value /* highlight field */ > from xwikistrings s, > xwikidates d, > xwikilargestrings l, > xwikiintegers i, > xwikilargestrings h > where s.xws_id = <comment ID> and s.xws_name = 'author' > and d.xws_id = s.xws_id and d.xws_name = 'date' > and l.xws_id = s.xws_id and l.xws_name = 'comment' > and i.xwi_value = s.xws_id and i.xwi_name = 'replyto' > and h.xwl_value = s.xws_id and h.xwl_name = 'highlight' > > Of course, the job is much simpler than this, for several reasons. > First, the replyto and highlight fields are not populated by XWiki's > default templates, so they're always null anyway; second, of the > remaining values, each one is uniquely identified by the object's ID > field anyway, so the respective name fields don't need to be specified. > > To get a list of all comments in the database, with only their object ID > field, author name, and date (which produces a fairly neat display) this > query should do it. > > select o.xwo_id, > s.xws_value, > d.xws_value > from xwikiobjects o, > xwikistrings s, > xwikidates d > where xwo_classname='XWiki.XWikiComments' > and s.xws_id = o.xwo_id > and d.xws_id = o.xwo_id > order by xwo_id > > > > With all that as background, what you need to do is: > > 1. Identify the offending comments (by their object IDs). > > If the comments were all from bogus registrations, then the above query > with an added qualifier something like: > > where s.xws_value in ('XWiki.spammer1', 'XWiki.spammer2'[,...]) > > will give you the object IDs you need. > > If you have allowed anonymous users to comment, then other criteria must > be used, although of course "s.xws_value = 'XWiki.XWikiGuest'" should be > in your WHERE clause. Most likely, you could probably nail most of them > by saying > > select o.xwo_id from xwikiobjects o, xwikilargestrings l > where o.classname = 'XWiki.XWikiComments' and l.xwl_id = o.xwo_id > and l.xwl_value like "%Viagra%" > or l.xwl_value like "%sex" > or l.xwl_value like "%stock%" > or ... > > you get the idea. > > The best idea, of course, is to keep running and refining your query > until you are sure that you've identified all of the offending comments > and only the offending comments. > > 2. After you've built a query that identifies the set of records you > want to remove, you must delete them from each table where they appear. > The easiest way to do this is to modify your query to return only the > xwikiobjects.xwo_id field in the SELECT clause and put it into a > temporary table: > > create temporary table badcomments (comment_id integer); > > insert into badcomments select o.xwo_id from xwikiobjects o [... where, > etc...]; > > Then delete every row from xwikistrings, xwikilargestrings, xwikidates, > and xwikiintegers where the respective ID fields (xws_id, xwl_id, > xws_id, and xwi_id, respectively) match the comment_id field from your > badcomments table. > > > You can also do it using the $xwiki.search() method, but there you have > to tie the XWiki objects together using HQL. The advantage is that you > don't have to have server access; the disadvantage is that it's > miserable to get it right (my opinion). > > brain[sic] > > > -----Original Message----- > > From: wangwh(a)att.net [mailto:wangwh@att.net] > > Sent: Tuesday, October 17, 2006 12:32 AM > > To: xwiki-users(a)objectweb.org > > Subject: [xwiki-users] delete spam comments > > > > > > Hi, > > My wiki site got over a thousand spam comments, anyone know > > how can I delete them quickly (better than edit object, then > > delete one by one). > > Wei-hsing > > > > > >

5 11

Re: [xwiki-users] delete spam comments
by wangwh＠att.net 17 Oct '06

17 Oct '06

If your Wiki is getting some traffic, you can be the next target also, someone can put in lots of spam comments with nothing but links to his/her sites to promote the sites. If possible, you might want to allow only certain people to leave comments. *** I assume people reading this email do not do this, but... To some *ill-minded* Wiki users, please stop doing that to others! (the sites you are advertising will get bad names...) -------------- Original message ---------------------- From: wangwh(a)att.net > Hi, > My wiki site got over a thousand spam comments, anyone know how can I delete > them quickly (better than edit object, then delete one by one). > Wei-hsing >

1 0

delete spam comments
by wangwh＠att.net 17 Oct '06

17 Oct '06

Hi, My wiki site got over a thousand spam comments, anyone know how can I delete them quickly (better than edit object, then delete one by one). Wei-hsing

2 1

Java Stack Tracing Saving 7MB Attachment
by Smith, Nathan 16 Oct '06

16 Oct '06

Dear xwiki-users, We are getting a Java exception when saving a 7MB attachment. The attachment appears to be attached properly, since it appears in the attachment list and can be downloaded after the error. However, after attaching four or five files the server becomes so unresponsive that a restart is required. Configuration Info: OS: Windows 2000 Server RAM: 1GB JDK: 1.5.0_8 App Server: JBoss 4.0.4 Database: MySQL 4.1.21 Note that JBoss is run with -Xmx 512M, and increasing that to -Xmx 1024M has no effect. I've gone through the attachment documentation and mailing list archives and didn't see any references to a similar problem. Any help would be appreciated - I plan to checkout the code and see what's happening! Here is the stack trace: A problem occured while trying to service your request. Please contact the support if this happens again. Detailed information: Error number 0 in 11: Uncaught exception Wrapped Exception: Java heap space com.xpn.xwiki.XWikiException: Error number 0 in 11: Uncaught exception Wrapped Exception: Java heap space at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:224) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestPr ocessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java: 226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodi ngFilter.java:127) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte r.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:178) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs sociationValve.java:175) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j ava:74) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:86 9) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc essConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorker Thread.java:112) at java.lang.Thread.run(Thread.java:595) Wrapped Exception: java.lang.OutOfMemoryError: Java heap space Thanks, Nathan Smith

4 3