• :!: Openkm Office does not work

  • Problems with installing OpenKM? No problemo, the solution is closer than you think.
Problems with installing OpenKM? No problemo, the solution is closer than you think.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #14174  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?
 #14240  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.
 #14251  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.
 #14252  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..?
 #14254  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...
 #14270  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.
 #14557  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 :)

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.