• Authentication Error on First Attempt to Login

  • 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.
 #46473  by Wraith
 
Hi All,

I've recently "successfully" installed OpenKM and MySQL 8.0. Upon my first login attempt I am receiving an Authentication error.

I have tried the following combinations:
  • User: 'openkm'; Password: #Password# This is as per the user setup in the installation script
    User: 'okmAdmin'; Password: #Password# This is as per the user login shown in the installation video
In MySQL Workbench I've confirmed that the user 'openkm' has been created and database 'okmdb' exists.

Would appreciate any feedback or guidance on how to get the login working.

I've attached a compressed copy of openkm.log and catalina.log

Thanks in advance
Attachments
(9.93 KiB) Downloaded 207 times
 #46481  by Wraith
 
Hi jllort,

The catalina.log and openkm.log files were attached within the 7zip archive attached to the first post. I wasn't permitted to upload a .log file.

I have read the resource you've linked and made the changes suggested within. I also, based on other posts, have stoped OpenKM, modified the OpenKM.cfg file to read "...=create" on the appropriate line, deleted the repository file, restarted OpenKM and tried to access again.

In my opinion, some or all of the above contributed to me getting as far as I have [the login screen]. Let me know if you need any other info or the catalina.log file uploaded in a different format or manner.

Thanks for your help so far.
 #46483  by jllort
 
I do not see any kind of error in the log ( only wrong authentication for okmAdmin user what is quite strange ). Also I was expected to find some extra rows what in your case seems are missing in the log for a complete OpenKM starting up, like soffice binding or server start up time in the log what is not shown in your case.

How are you starting the application ?
Check default tomcat ports be available an not used by other apps ? 8080, 8005 and 8009
 #46510  by Wraith
 
Hi jllort,
How are you starting the application ?
I find "OpenKM" in Services, right click and select Start
Check default tomcat ports be available an not used by other apps ? 8080, 8005 and 8009
netstat -n -a -o does not report any PID's using ports 8080, 8005 or 8009.

Thanks!
 #46524  by jllort
 
The OS user and password are ( openkm / openkm )
The OpenKM default user and password are ( okmAdmin / admin ) -> do not forget to write the A ( Uppercase )
 #46543  by Wraith
 
The OS user and password are ( openkm / openkm )
This didn't work :(
The OpenKM default user and password are ( okmAdmin / admin ) -> do not forget to write the A ( Uppercase )
This DID work! :)

Would appreciate some clarity - If the passwords are either "openkm" or "admin" then what is the password entered or chosen during the installation process?
 #46546  by jllort
 
The user openkm with password openkm is for OS of the Virtual Machine, the OpenKM development environment. In both cases, clean installation or running the development environment the credentials for the OpenKM application are user okmAdmin with password admin. Might be now the explanation is clearly ?

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.