All,
I was wondering if anyone eventually got DB2 to work with any version of xwiki. Currently, I am running into some problem creating the database tables. I am using the import scripts provided on the Admin page however, DB2 is complaining that the table column definition is invalid. Below is the error I recieved:
17:12:45,093 ERROR main XWikiHibernateBaseStore:updateSchema:327 - Failed updating schema: DB2 SQL error: SQLCODE: -604, SQLSTATE: 42611, SQLERRMC: varchar(4000000)
17:12:45,125 WARN main JDBCExceptionReporter:logExceptions:71 - SQL Error: -204, SQLState: 42704
17:12:45,125 ERROR main JDBCExceptionReporter:logExceptions:72 - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: XWIKI.XWIKIDOC
17:12:45,125 WARN main JDBCExceptionReporter:logExceptions:71 - SQL Error: -727, SQLState: 56098
I have seen some list posts from 2005 however I have not seen any follow up.
Thanks,
Tony Nuzzi
Thanks Richard,
Got the solution to this with googling! IT is specific to LDAP with AD.
Check out the url if you are interested more.
http://forums.devshed.com/ldap-programming-76/javax-naming-authenticationex…
Thanks,
Mrudula
-----Original Message-----
From: Ryszard Lach [mailto:rla@debian.org]
Sent: Tuesday, September 05, 2006 12:40 PM
To: xwiki-users(a)objectweb.org
Subject: Re: [xwiki-users] LDAP Integration of xwiki
On Tue, Sep 05, 2006 at 11:12:36AM +0530, mrudula.madiraju(a)wipro.com wrote:
>
>
>
> I've been able to boil down the exact error to the one shown below. I
> tried a variety of combinations, but it doesn't seem to work with my
> company user id and password. Any pointers here?
Are you sure you can connect to your LDAP using your credentials?
I suggest to install some ldap client on your xwiki machine (e.g.
ldap-utils) and try to connect to LDAP with entered in xwiki.cfg values.
Taking your config try something like that:
> authentication.ldap=1
> authentication.ldap.server=blr-ec-dc01.wipro.com
> authentication.ldap.port=389
> authentication.ldap.check_level=1
> authentication.ldap.base_DN=dc=wipro,dc=com
> authentication.ldap.bind_DN=uid=wipro\<< my user id>>,ou=USERS,dc=wipro,dc=com
>
> authentication.ldap.bind_pass=<<my password>>
> authentication.ldap.UID_attr=Mrudula Madiraju
> authentication.ldap.fields_mapping=name=Mrudula Madiraju,last_name=sn,first_name=givenName,fullname=displayName,mail=mail,ldap_dn=dn
ldapsearch -h blr-ec-dc01.wipro.com -p 389 \
-D 'uid=wipro\<< my user id>>,ou=USERS,dc=wipro,dc=com'
-b 'dc=wipro,dc=com' \
-x -W \
'(<UID_attr>=<xwiki loginname>)'
As you can see I've used in search filter '<UID_attr>', becaues I
suppose that you don't have a field named 'Mrudula Madiraju' in you
LDAP ;-). If your ldap was Active Directory you would have
authentication.ldap.UID_attr=sAMAccountName
in xwiki.cfg, and search field
(sAMAccountName=<xwiki_loginname>)
in your ldapsearch test.
R.
--
"First they ignore you. Then they laugh at you. Then they
fight you. Then you win." - Mohandas Gandhi.
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
www.wipro.com
Hi
I have some issues impeding me to test the latest svn version of xwiki.
Do you know a fix? I want to run xwiki with jetty/hsql using xwiki_start.sh.
I started my investigations by downloading the freshest xwiki version on svn.
For the rest of the story I am using Eclipse, where I imported the project and
I specifed the sources I just downloaded. So far so good.
tips
- I had to manually add junit from the /lib directory to ant classpath (run as
> ant build - the second "ant build" entry) to make ant run. Otherwise it
would always complain about a missing junit class for the cactus target.
Now I can run ant targets. I find the "standalone" target and I run it. It
unzipped the release of jetty stored somewhere (above) and copied the xwiki
files under webapps. That's fine. I find the script/batch_files to start the
wiki, and so do I.
Apparently the database is created but it stops there. I get the following
message in the browser:
---
HTTP ERROR: 500
Error number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3202 in 3: Exception while reading document
XWiki.XWikiPreferences
Wrapped Exception: could not load an entity:
[com.xpn.xwiki.doc.XWikiDocument#104408758]
---
and then in the logs:
---
02:15:05,297 ERROR P1-19 http://lijour:8080/xwiki/bin/view/Main/WebHome
GraphVizPlugin:init:90 - Cannot find graphiz dot program at c:/Program
Files/ATT/GraphViz/bin/dot.exe
02:15:05,298 ERROR P1-19 http://lijour:8080/xwiki/bin/view/Main/WebHome
GraphVizPlugin:init:99 - Cannot find graphiz neato program at c:/Program
Files/ATT/GraphViz/bin/neato.exe
02:15:05,848 WARN P1-19 http://lijour:8080/xwiki/bin/view/Main/WebHome
JDBCExceptionReporter:logExceptions:71 - SQL Error: 0, SQLState: null
02:15:05,849 ERROR P1-19 http://lijour:8080/xwiki/bin/view/Main/WebHome
JDBCExceptionReporter:logExceptions:72 - Borrow prepareStatement from pool
failed
02:15:05,850 WARN P1-19 http://lijour:8080/xwiki/bin/view/Main/WebHome
JDBCExceptionReporter:logExceptions:71 - SQL Error: 0, SQLState: null
02:15:05,851 ERROR P1-19 http://lijour:8080/xwiki/bin/view/Main/WebHome
JDBCExceptionReporter:logExceptions:72 - Borrow prepareStatement from pool
failed
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading
document XWiki.XWikiPreferences
Wrapped Exception: could not load an entity:
[com.xpn.xwiki.doc.XWikiDocument#104408758]
at
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:462)
at
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:157)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:819)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:850)
at com.xpn.xwiki.XWiki.getPrefsClass(XWiki.java:1854)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:590)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:504)
at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:248)
at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:336)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:98)
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.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
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)
---
Thanks.
marc
