Open Source Document Management System | OpenKM

Because information matters
https://forum.openkm.com/

:!: Openkm Office does not work

https://forum.openkm.com/viewtopic.php?t=5768

Page 1 of 1

:!: Openkm Office does not work

PostPosted:Mon Feb 27, 2012 10:30 am
by vkasgpta
hi, i have a similar issue to http://forum.openkm.com/viewtopic.php?f=3&t=5715 except that i cant even connect to the demo directory through the add in (checked all the details entered were correct).
I have disabled the firewall and below is a description of my problem:

OpenKM works normally in the web interface but when i try using the Office add in it gives me the following error:

TreeForm - (startUp)
No matching username found in Principals: No matching username found in Principals

So i tried looked around the forums and found
http://forum.openkm.com/search.php?keyw ... sf=msgonly [^]
I followed all his steps,
-i had jdk 1.7 so put inside 1.6,
-changed the Home directory to point to 1.6 instead of 1.7

but he claimed he was able to connect to the test directory so i tried that and got the same error! ofcourse i changed to user0 and user2 when trying...

Now when i try to connect to my own server (same computer) i get the following in the command prompt:
Code: Select all
12:37:29,343 INFO [WSDLFilePublisher] WSDL published to: file:/E:/jboss-4.2.3.GA/server/default/data/wsdl/OpenKM.war/OKMAuthService1770239638623372337.wsdl
12:37:29,343 INFO [WSDLFilePublisher] WSDL published to: file:/E:/jboss-4.2.3.GA/server/default/data/wsdl/OpenKM.war/OKMMailService6430441666756558457.wsdl
12:37:29,359 INFO [WSDLFilePublisher] WSDL published to: file:/E:/jboss-4.2.3.GA/server/default/data/wsdl/OpenKM.war/OKMDocumentService7834267205433096873.wsdl

12:37:29,390 INFO [WSDLFilePublisher] WSDL published to: file:/E:/jboss-4.2.3.GA/server/default/data/wsdl/OpenKM.war/OKMSearchService9033712819814496117.wsdl
12:37:29,390 INFO [WSDLFilePublisher] WSDL published to: file:/E:/jboss-4.2.3.GA/server/default/data/wsdl/OpenKM.war/OKMTestService476888814974743515.wsdl
12:37:29,406 INFO [WSDLFilePublisher] WSDL published to: file:/E:/jboss-4.2.3.GA/server/default/data/wsdl/OpenKM.war/OKMRepositoryService8805659079122092989.wsdl
12:37:29,406 INFO [WSDLFilePublisher] WSDL published to: file:/E:/jboss-4.2.3.GA/server/default/data/wsdl/OpenKM.war/OKMBookmarkService6767996226937586746.wsdl

12:37:30,093 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
12:37:30,531 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
12:37:30,656 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-0.0.0.0-8009
12:37:30,687 INFO [Server] JBoss (MX MicroKernel) [4.2.3.GA (build: SVNTag=JBoss_4_2_3_GA date=200807181439)] Started in 3m:2s:469ms
12:58:55,515 ERROR [DirectAuthModule] No matching username found in Principals:
No matching username found in Principals
javax.jcr.LoginException: No matching username found in Principals: No matching username found in Principals: No matching username found in Principals
        at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1407)
        at com.openkm.module.direct.DirectAuthModule.login(DirectAuthModule.java:88)
        at com.openkm.ws.endpoint.OKMAuth.login(OKMAuth.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.wsf.container.jboss42.InvocationHandlerJSE.invoke(InvocationHandlerJSE.java:102)
        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:221)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:466)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:284)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:201)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:134)
        at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
        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 org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        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:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        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:446)
        at java.lang.Thread.run(Thread.java:662)
Caused by: javax.security.auth.login.FailedLoginException: No matching usernamefound in Principals
        at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:152)
        at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:206)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
        at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
        at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
        at javax.security.auth.login.LoginContext.login(LoginContext.java:579)
        at org.apache.jackrabbit.core.security.authentication.JAASAuthContext.login(JAASAuthContext.java:60)
        at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1392)
        ... 33 more
javax.security.auth.login.FailedLoginException: No matching username found in Principals
        at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:152)
        at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:206)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
        at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
        at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
        at javax.security.auth.login.LoginContext.login(LoginContext.java:579)
        at org.apache.jackrabbit.core.security.authentication.JAASAuthContext.login(JAASAuthContext.java:60)
        at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1392)
        at com.openkm.module.direct.DirectAuthModule.login(DirectAuthModule.java:88)
        at com.openkm.ws.endpoint.OKMAuth.login(OKMAuth.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.wsf.container.jboss42.InvocationHandlerJSE.invoke(InvocationHandlerJSE.java:102)
        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:221)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:466)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:284)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:201)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:134)
        at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
        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 org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        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:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        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:446)
        at java.lang.Thread.run(Thread.java:662)
12:58:55,562 ERROR [SOAPFaultHelperJAXWS] SOAP request exception
com.openkm.core.AccessDeniedException: No matching username found in Principals:
 No matching username found in Principals
        at com.openkm.module.direct.DirectAuthModule.login(DirectAuthModule.java:99)
        at com.openkm.ws.endpoint.OKMAuth.login(OKMAuth.java:66)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.jboss.wsf.container.jboss42.InvocationHandlerJSE.invoke(InvocationHandlerJSE.java:102)
        at org.jboss.ws.core.server.ServiceEndpointInvoker.invoke(ServiceEndpointInvoker.java:221)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.processRequest(RequestHandlerImpl.java:466)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleRequest(RequestHandlerImpl.java:284)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.doPost(RequestHandlerImpl.java:201)
        at org.jboss.wsf.stack.jbws.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:134)
        at org.jboss.wsf.stack.jbws.EndpointServlet.service(EndpointServlet.java:84)
        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 org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        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:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        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:446)
        at java.lang.Thread.run(Thread.java:662)
Caused by: javax.jcr.LoginException: No matching username found in Principals: No matching username found in Principals: No matching username found in Principals
        at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1407)
        at com.openkm.module.direct.DirectAuthModule.login(DirectAuthModule.java:88)
        ... 32 more
Caused by: javax.security.auth.login.FailedLoginException: No matching username found in Principals
        at org.jboss.security.auth.spi.DatabaseServerLoginModule.getUsersPassword(DatabaseServerLoginModule.java:152)
        at org.jboss.security.auth.spi.UsernamePasswordLoginModule.login(UsernamePasswordLoginModule.java:206)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
        at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
        at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
        at javax.security.auth.login.LoginContext.login(LoginContext.java:579)
        at org.apache.jackrabbit.core.security.authentication.JAASAuthContext.login(JAASAuthContext.java:60)
        at org.apache.jackrabbit.core.RepositoryImpl.login(RepositoryImpl.java:1392)
        ... 33 more
Steps To Reproduce
1) Install Excel / Word Addin
2) set up okmAdmin in user, admin in pass and default setting of http://localhost:8080/OpenKM/ [^] in path
3) click on add or edit

Additional Information Notes:
-OpenKM is only being tested and not in a live environment at the moment.
-OpenKM is not listening to outside connections atm, could not figure out how to do that, wiki's command did not work in my computer, not sure if this is causing the issue?
-Java version: jdk1.6.0_30
-.Net version: 4.0,4,3.5,3.0,2.0.5727
-Fresh installation, even live preview and scanner has not been activated yet. Only user db was enabled to allow adding and saving of new users.
-the office is Microsoft Office 2007
-OS XP SP3 32bit

Any ideas on what could be causing this?

Re: :!: Openkm Office does not work

PostPosted:Thu Mar 01, 2012 3:46 pm
by jllort
I thinks it's configuration problem in you adding, which url you've put in your configuration ( revise it ), and revise your username credentials too.

Re: :!: Openkm Office does not work

PostPosted:Fri Mar 02, 2012 3:58 am
by vkasgpta
well thats what i thought at first too, so here are the things i have tried:

Username:okmAdmin
Pass:admin
URL:http://127.0.0.1:8080/OpenKM/

Username:okmAdmin
Pass:admin
URL:http://localhost:8080/OpenKM/

Username:user0
Pass:pass0
URL: http://demo.openkm.com/OpenKM/


Username:user1
Pass:pass1
URL: http://demo.openkm.com/OpenKM/

No spaces anywhere, none at beginning or end.
okmAdmin password is still default pass and unchanged.

Re: :!: Openkm Office does not work

PostPosted:Fri Mar 02, 2012 4:00 am
by vkasgpta
just now when i was testing the user credentials, i noticed 2 extra lines in the error message in command which were not there before, here are the lines:
Code: Select all
11:55:04,109 WARN  [DocConverter] system.openoffice.path not configured
11:55:04,109 WARN  [DocConverter] and also system.openoffice.server not configured
could not having openoffice have a link on the issue with microsoft office..?

PROBLEM SOLVED!

PostPosted:Fri Mar 02, 2012 8:21 am
by vkasgpta
So i used a totally fresh installation of XP on another computer and put .net 2.0 inside and it works fine now. Networked computers can access OpenKM with no issues... maybe the problem was the numberous .net versions on the test machine... well its working now! time to figure out the scanner.... ugh...

Re: :!: Openkm Office does not work

PostPosted:Sun Mar 04, 2012 11:33 am
by jllort
About openoffice message at starting, simply server indicates can not starting openoffice service used by openkm to preview documents and conversion to pdf.

About .net version, the answer is yes, sometimes depending your Os environment ms office adding could have some problems, .net and other installed packages could be a problem on runninb addins ... that's a classical windows problem.

Re: :!: Openkm Office does not work

PostPosted:Mon Mar 12, 2012 11:05 pm
by acastaneda
For situations like this, should the extra versions of .net be uninstalled?

Thanks.

Re: :!: Openkm Office does not work

PostPosted:Wed Mar 14, 2012 4:59 pm
by jllort
Try installing it http://www.openkm.com/download/okm/DotNetFX.zip sometimes solves the problem

Re: :!: Openkm Office does not work

PostPosted:Sat Mar 17, 2012 8:38 am
by vkasgpta
acastaneda wrote:For situations like this, should the extra versions of .net be uninstalled?

Thanks.
Well i am not sure if removal would be enuf... windows has a way of leaving things behind even after uninstall... This problem would also only be there in test / developer machines.

i would say the most sane method is to use a fresh machine. If you are testing the program, using VMWare player is pretty neat to have an image of any kind of OS. After that you can always migrate the files out for production use :)
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited