December 2008 - xwiki-users@xwiki.org

[xwiki-users] generic XML API snippet, and SOS
by Yishay Mor 19 Dec '08

19 Dec '08

I've posted a snippet: http://code.xwiki.org/xwiki/bin/view/Snippets/GenericXMLapiSnippet Which adds a very simple XML API to a site. This API allows other sites to programmaticaly query the XWiki site, and display data from it in any form they choose. You can see an example here: http://patternlanguagenetwork.myxwiki.org/xwiki/bin/view/api/genericXML I came across two problems in the process of writing this. One is general, and onw specific to my site - and fatal. the first problem is that is seems like this API can deliver protected data to a non-registered user. To avoid this on my site, I restricted it not to show classes under the XWiki space. Shouldn't this be blocked at a lower level? The second problem was that I have some fields (propoerties) in some of the classes which I'm not using. Since I can't delete them, I decided to change the name to ".unused" and filter. However, once I did this it seems to have completly crashed the class at hand. I can't even look at the Class in the ClassEditor to delete the latest versions and go back to the latest good one. Here is the corrupted class: http://patternlanguagenetwork.myxwiki.org/xwiki/bin/view/Cases/CaseClass Any ideas? ___________________________ Yishay Mor, Researcher, London Knowledge Lab http://www.lkl.ac.uk/people/mor.html http://www.google.com/calendar/embed?src=yishaym%40gmail.com +44-20-78378888 x5737

3 4

[xwiki-users] ldap + xwiki.authentication.ldap.user_group
by Bartłomiej Radziszewski 19 Dec '08

19 Dec '08

hello, I want to add access to xwiki only for users from special posixGroup in ldap. So I have added option: #-# only members of the following group will be verified in the LDAP #-# otherwise only users that are found after searching starting from the base_DN xwiki.authentication.ldap.user_group=cn=xwiki,ou=services,dc=xxx,dc=com all works fine but in logs i get exeption when i dont have some user in this group: com.xpn.xwiki.XWikiException: Error number 8001 in 8: LDAP user usertest does not belong to LDAP group cn=xwiki,ou=services,dc=xxx,dc=com. at com.xpn.xwiki.user.impl.LDAP.XWikiLDAPAuthServiceImpl.ldapAuthenticateInContext(XWikiLDAPAuthServiceImpl.java:328) at com.xpn.xwiki.user.impl.LDAP.XWikiLDAPAuthServiceImpl.ldapAuthenticate(XWikiLDAPAuthServiceImpl.java:198) at com.xpn.xwiki.user.impl.LDAP.XWikiLDAPAuthServiceImpl.authenticate(XWikiLDAPAuthServiceImpl.java:149) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.authenticate(MyFormAuthenticator.java:239) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:165) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:148) at com.xpn.xwiki.user.impl.xwiki.XWikiAuthServiceImpl.checkAuth(XWikiAuthServiceImpl.java:203) at com.xpn.xwiki.XWiki.checkAuth(XWiki.java:3578) at com.xpn.xwiki.user.impl.xwiki.XWikiRightServiceImpl.checkAccess(XWikiRightServiceImpl.java:139) at com.xpn.xwiki.XWiki.checkAccess(XWiki.java:3586) at com.xpn.xwiki.XWiki.prepareDocuments(XWiki.java:4572) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:190) 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.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) java.lang.NullPointerException at com.xpn.xwiki.user.impl.LDAP.XWikiLDAPAuthServiceImpl.authenticate(XWikiLDAPAuthServiceImpl.java:157) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.authenticate(MyFormAuthenticator.java:239) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:165) at com.xpn.xwiki.user.impl.xwiki.MyFormAuthenticator.processLogin(MyFormAuthenticator.java:148) at com.xpn.xwiki.user.impl.xwiki.XWikiAuthServiceImpl.checkAuth(XWikiAuthServiceImpl.java:203) at com.xpn.xwiki.XWiki.checkAuth(XWiki.java:3578) at com.xpn.xwiki.user.impl.xwiki.XWikiRightServiceImpl.checkAccess(XWikiRightServiceImpl.java:139) at com.xpn.xwiki.XWiki.checkAccess(XWiki.java:3586) at com.xpn.xwiki.XWiki.prepareDocuments(XWiki.java:4572) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:190) 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.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1124) at com.xpn.xwiki.plugin.webdav.DavFilter.doFilter(DavFilter.java:68) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115) at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:96) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115) at com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:287) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1115) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:361) at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534) at org.mortbay.jetty.ajp.Ajp13Connection.access$2900(Ajp13Connection.java:44) at org.mortbay.jetty.ajp.Ajp13Connection$RequestHandler.content(Ajp13Connection.java:249) at org.mortbay.jetty.ajp.Ajp13Parser.parseNext(Ajp13Parser.java:602) at org.mortbay.jetty.ajp.Ajp13Parser.parseAvailable(Ajp13Parser.java:157) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403) at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522) Probably this NullPointer this is bug.. Thx and greetings, -- Bartłomiej Radziszewski mobile: +48 509 561 540 e-mail: br(a)debian.linux.pl JID: br(a)debian.linux.pl ICQ: #305569725

2 3

[xwiki-users] XWikiAuthServiceImpl.java
by Lewis Denizen 19 Dec '08

19 Dec '08

Hi xwiki-users, In XWikiAuthServiceImpl.java, I see the following lines: Line 521: String createuser = getParam("auth_createuser", context); Line 500~517: protected String getParam(String name, XWikiContext context) { String param = ""; try { param = context.getWiki().getXWikiPreference(name, context); } catch (Exception e) { } if (param == null || "".equals(param)) { try { param = context.getWiki().Param("xwiki.authentication." + StringUtils.replace(name, "auth_", ".")); } catch (Exception e) { } } if (param == null) { param = ""; } return param; } Which requires me to create a key called "xwiki.authentication..createuser" in the config - which is strange... Unless there are any side effects, would it be possible to request the StringUtils.replace() removed? Thanks again for a great release!

2 1

[xwiki-users] Using penrose LDAP server with Xwiki
by Cazottes Nicolas 19 Dec '08

19 Dec '08

Hello, I am trying to use Penrose LDAP virtual server (http://docs.safehaus.org/display/PENROSE/Home) as an LDAP source to manage authentification of my xwiki instance. The connection to the server works fine but when xwiki tries to search for my user, it stops with the following exception : 2008-12-01 10:06:38,921 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] [P1-19] DEBUG ldap.XWikiLDAPUtils - Searching for the user in LDAP: user:nca base: query:(uid=nca) uid:uid 2008-12-01 10:06:39,921 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] [P1-19] DEBUG ldap.XWikiLDAPConnection - LDAP Search failed LDAPException: Client request timed out (85) LDAP Timeout at com.novell.ldap.Message$Timeout.run(Unknown Source) 2008-12-01 10:06:39,921 [http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] [P1-19] DEBUG LDAP.XWikiLDAPAuthServiceImpl - Local LDAP authentication failed. After searching in the xwiki source code, I found there is a timeout of 1s for a search query to execute (in XWikiLDAPConnection line 292). It may explains the error I imagine. Is it possible to make this timeout defined via a configuration key in xwiki.cfg ? Another point related to xwiki LDAP logs : I don't like very much to have the password sent to xwiki writen clearly in the log file when LDAP debug is activated. Is it possible to have stars instead of the real value of the password ? If someone can do these modifications to the code, I will be pleased to test them. I would like to test it by myself but, currently, I did not manage to build xwiki with maven after checking out the source. Thank you for your help. Nicolas CAZOTTES

2 4

[xwiki-users] xwiki + ldap filter
by Bartłomiej Radziszewski 19 Dec '08

19 Dec '08

hello, it is posible to use filter in xwiki user search in ldap? i want to use activeAccount atribute when it is TRUE - user have access to xiwki, when it is FALSE user don't have it.. Thx for help and greetings, Bart -- Bartłomiej Radziszewski mobile: +48 509 561 540 e-mail: br(a)debian.linux.pl JID: br(a)debian.linux.pl ICQ: #305569725

1 0

Re: [xwiki-users] xwiki eating all the CPU
by Dave Mangot 19 Dec '08

19 Dec '08

> > My 1.6 Xwiki install has started eating all my CPU when I try to go to > > any "dynamic page" like Blogs or What's New. Regular static pages work > > fine. Eventually, tomcat times out the connection to the rendered page. > > I upgraded to 1.7 but the behavior is still the same. > Make sure you don't allow robots to browse the PDF exports, as the > export process takes a lot of computation power. See > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances#HRobotstxt > (and in general read all the performance tips on that page). This is an internal corporate wiki and it only blows up when I try to go to "dynamic pages" as I mentioned above. There are no robots involved in any way. > > Attached is the Xwiki.log, which doesn't seem to have much other than an > > NPE which I doubt is the cause. Also included is a thread dump in the > > catalina.out. > Note that our mailing list does not accept attachments, and it is a bad > practice to post large attachments to public mailing list. The best > thing to do is to use a public text sharing tool, like > http://pastebin.com/ or http://rafb.net/paste/ I would hardly consider an 8 K attachment to be "large". The thread dump alone is too big to really put on pastebin but nonetheless: Xwiki.log: http://terracotta.pastebin.com/m3733cc04 Catalina.out: http://terracotta.pastebin.com/m8eaf221 I think "TP-Processor12" looks pretty suspect here. > > At the very least this could be a denial of service attack because I'm > > sure it > > must be because of some entry someone made. > Unlikely. Well, the version of Xwiki hadn't changed, nor tomcat, nor java. One day it's been running for months without issue and the next it is eating CPU every time I try to look at What's New or Blogs. What should I be looking at besides users posting? I've opened XE-351 to track the issue. Thanks for the help, -Dave

1 0

[xwiki-users] xwiki eating all the CPU
by Dave Mangot 18 Dec '08

18 Dec '08

My 1.6 Xwiki install has started eating all my CPU when I try to go to any "dynamic page" like Blogs or What's New. Regular static pages work fine. Eventually, tomcat times out the connection to the rendered page. I upgraded to 1.7 but the behavior is still the same. Attached is the Xwiki.log, which doesn't seem to have much other than an NPE which I doubt is the cause. Also included is a thread dump in the catalina.out. At the very least this could be a denial of service attack because I'm sure it must be because of some entry someone made. Help!? -Dave -- Dave Mangot Terracotta Inc. 650 Townsend St. Suite 325 San Francisco, CA 94103 USA +1 415 738 4059 dmangot(a)terracottatech.com This e-mail incorporates Terracotta's confidentiality policy, which is online at http://www.terracottatech.com/emailconfidentiality.shtml -- Dave Mangot Terracotta Inc. 650 Townsend St. Suite 325 San Francisco, CA 94103 USA +1 415 738 4059 dmangot(a)terracottatech.com This e-mail incorporates Terracotta's confidentiality policy, which is online at http://www.terracottatech.com/emailconfidentiality.shtml

2 1

[xwiki-users] Multiple LDAP backends?
by Daniel Barowy 18 Dec '08

18 Dec '08

Hello everyone, We have XWiki set up to authenticate users against our Active Directory using XWiki's LDAP lookup feature. It works beautifully for our main office. However, we have several other offices, and they would like to use XWiki as well. The problem is that these users are in different domains, and use different AD domain controllers, which means we have to query those LDAP backends separately. It looks to me like XWiki only supports querying of one domain controller at a time. As a workaround until a more permanent solution can be found, I am creating local user accounts on XWiki for these people and allowing fallback authentication against the local database. Of course, this setup will be problematic in the future with regard to password policy, so I'd really like to get LDAP functional for them as well. Any suggestions? Thanks-- we're really liking XWiki here. Dan

4 3

[xwiki-users] xwiki mssql
by hel-o 18 Dec '08

18 Dec '08

Hi, XWiki and mssql doesn't seem to work. I found an hibernate file for mssql in 1.7 (seems to be there by default since 1.5.? (not 1.5 but 1.5.2 didn't look at 1.5.1)). But i can't get the system running (MSSQL Server 2000, jtds Driver 1.2.1). Log for 1.7: "11:50:45,687 [http://localhost/xwiki17/bin/view/Main/] [http-80-1] ERROR impl.SessionFactoryImpl - Error in named query: getAllDocuments org.hibernate.QueryException: could not resolve property: hidden of: com.xpn.xwiki.doc.XWikiDocument [ select doc.fullName from com.xpn.xwiki.doc.XWikiDocument as doc where (doc.hidden <> 1 or doc.hidden is null) ] at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:44) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:38) at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1362) at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:279) at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:386) at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:567) at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:241) at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:188) at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:94) at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:90) at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:728) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1216) at org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4041) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3549) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1712) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72) at org.hibernate.impl.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:402) at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:352) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300) at com.xpn.xwiki.store.XWikiHibernateBaseStore.initHibernate(XWikiHibernateBaseStore.java:165) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:562) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1038) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1082) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:63) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractXWikiMigrationManager.java:68) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.<init>(XWikiHibernateMigrationManager.java:50) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:994) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:726) at com.xpn.xwiki.XWiki.<init>(XWiki.java:668) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:316) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:387) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) 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:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.plugin.webdav.DavFilter.doFilter(DavFilter.java:68) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:287) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 11:50:45,718 [] [http-80-1] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException " Log for 1.5.2: "11:55:36,875 [http://localhost/xwiki15/bin/view/Main/] [http-80-1] ERROR store.XWikiHibernateBaseStore - Failed updating schema while executing query [create table xwikiattrecyclebin (XDA_ID numeric(19,0) identity not null, XDA_DOCID numeric(19,0) not null, XDA_FILENAME varchar(255) not null, XDA_DATE datetime not null, XDA_DOC_NAME varchar(255) null, XDA_DELETER varchar(255) null, XDA_XML varchar(max) not null, primary key (XDA_ID), unique (XDA_DOCID, XDA_FILENAME, XDA_DATE))] java.sql.SQLException: Zeile 1: Falsche Syntax in der Nähe von 'max'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:367) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:225) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:451) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:310) at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:258) at com.xpn.xwiki.store.XWikiHibernateBaseStore.checkHibernate(XWikiHibernateBaseStore.java:520) at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:995) at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1038) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:63) at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.<init>(AbstractXWikiMigrationManager.java:68) at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.<init>(XWikiHibernateMigrationManager.java:50) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.xpn.xwiki.XWiki.createClassFromConfig(XWiki.java:980) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:714) at com.xpn.xwiki.XWiki.<init>(XWiki.java:652) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:312) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:383) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:135) 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:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.web.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:287) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source) 11:55:36,906 [http://localhost/xwiki15/bin/view/Main/] [http-80-1] WARN util.JDBCExceptionReporter - SQL Error: 208, SQLState: 42S02 11:55:36,906 [http://localhost/xwiki15/bin/view/Main/] [http-80-1] ERROR util.JDBCExceptionReporter - Ungültiger Objektname 'xwikidbversion'. 11:55:36,937 [] [http-80-1] WARN action.RequestProcessor - Unhandled Exception thrown: class com.xpn.xwiki.XWikiException" Does anyone have a running system for mssql with xwiki > 1.3.2 Thanks hel. -- View this message in context: http://n2.nabble.com/xwiki-mssql-tp1672414p1672414.html Sent from the XWiki- Users mailing list archive at Nabble.com.

3 3

[xwiki-users] xwiki groups + ldap
by Bartłomiej Radziszewski 18 Dec '08

18 Dec '08

hello, I have a question about ldap posixGroups and xwiki groups. it is posible synchronize ldap groups to xwiki dynamically? for example when i will add group to ldap then it will created in xwiki? I know about opition: #-# [Since 1.3M2, XWikiLDAPAuthServiceImpl] #-# mapps XWiki groups to LDAP groups, separator is "|" # xwiki.authentication.ldap.group_mapping=XWiki.XWikiAdminGroup=cn=AdminRole,ou=groups,o=MegaNova,c=US|\ # XWiki.Organisation=cn=testers,ou=groups,o=MegaNova,c=US ..but after created ldap group i need to add new group to xwiki.cfg file and restart xwiki app.. this is not useful solution. :( Anybody know other solution? thx for help and greets! -- Bartłomiej Radziszewski mobile: +48 509 561 540 e-mail: br(a)debian.linux.pl JID: br(a)debian.linux.pl ICQ: #305569725

2 5