Search

Hello Jllort, I followed your guide on changing the okmAdmin password to admin via https://forum.openkm.com/viewtopic.php?t=12660 as below: Looking for INSERT INTO OKM_USER VALUES('okmAdmin','Administrator' and change for INSERT INTO OKM_USER VALUES('okmAdmin','Administrator','21232f297a57a5a743894a...

Hello Jllort,

There is no option to view the tables. Do you think Migrating from 6.3.0 to 6.3.1 will resolve the issue of not displaying the language in the login page.
I doubt that the authentication error is showing up due to the language option not showing up in the login page.

Regards,
Nigyel

lnovoa wrote: ↑Wed Jun 13, 2018 7:34 am Hi!,
the name with minors does not exist.
Safely that is the reason.

Try:

Code: Select all

select * from OKM_USER

Hello Jllort,

Good day. Using "SQuirreL SQL Client" I was able t o connect to the database. But when I try to view the tables its not showing. Attached is the screenshot.

I wanted to run the language insert script which you have suggested before.

Thanks,
nig.

Hello Jllort,

1. Any other possibilities of repairing just the login page to show the Language as English. I believe if that is possible the users might be able to login.
2. Also can I login to the database from command line?

Regards,
Nigyel.

Hello,

Thank you for pointing out the configuration file. I tried buy getting the 'access denied' message as in the attachment....
I am using the default user 'sa' with blank password.

Thanks,
Nigyel.

Thank you.. When I do test Connection getting the message "unable to get class file." Where am I going wrong. Do bear with me, I am nook in this.

Migth increate VM parameter when starting the application of try other tool like datastudio ( aquafold ) they have a 15 days trial what might be good for you. Hello Jllort, I am not able to find the database selection in datastore. Can you help me which one to choose and configure. Regards, Nigyel.

Hello Jllort,

I somewhat got to run the language script but now getting the message while loading the login page:

Error getting translations: No row with the given identifier exists: [com.openkm.dao.bean.Language#en-GB]

Thanks,
Nigyel.

Hello Jllort,

Thank you. Yes its default one, username as sa. But getting the message 'java.lang.OutOfemoryError: GC overhead limit exceeded'.

Reagrds,
Nigyel.

Hello Jllort,

Thank you for your help. I am not able t o connect to the database. Can you help me again how to move forward. Attached is the screenshot of the RazoeSQL.

Thank you so so much.
Nigyel.

Hello Jllort, Any possibilities of fixing the language option in the login page? I have got the latest repository folders in the repository path and the okmdb.script is also the latest one. If the language option is fixed then I am sure will be able to get all the folders and files in the desktop. T...

Hello friends,

I noticed that in the main login page the language is blank, and maybe because of this all my users are not able to login to the system. Any solution to make it appear as English. Attached is the screenshot.

Regards,
Nigyel.

Hello Jllort and all, To add on I found a very old file okmdb.script of 2015 and when I replace it in the server I am able to login, so I feel that the latest okmdb.script is having some issue. After logging using the old okmdb.script file I am not able to see the latest uploaded files of 2016, 2016...

Hello Jllort, Thank you for your suggestion and solutions. I tried as you mentioned and attached the catalina log file. catalina.out file is empty. Once this issue gets resolved I would like to migrate to MySQL database and your help is required. :) I have not executed anything in the database and a...