Open Source Document Management System | OpenKM

PostPosted:**Thu May 24, 2018 6:52 am**

jllort wrote: ↑Tue May 22, 2018 3:27 pm 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.

PostPosted:**Fri May 25, 2018 7:15 am**

https://www.aquaclusters.com/app/home/p ... neric-JDBC

I think you should copy hsqldb.jar file from tomcat/lib to datastudio lib folders ( if it is not present there )

PostPosted:**Fri May 25, 2018 8:15 am**

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.

PostPosted:**Sat May 26, 2018 7:30 am**

Consider looking server.xml connection:

Code: Select all

<Resource name="jdbc/OpenKMDS" auth="Container" type="javax.sql.DataSource"
            maxTotal="100" maxIdle="30" maxWaitMillis="10000" validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"
            username="sa" password="" driverClassName="org.hsqldb.jdbcDriver"
            url="jdbc:hsqldb:${catalina.home}/repository/okmdb"/>

Here you have all data you need, as you can see the class name is org.hsqldb.jdbcDriver

PostPosted:**Wed May 30, 2018 10:52 am**

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.

PostPosted:**Thu May 31, 2018 4:41 pm**

Should be used the same data as is shown in server.xml. Is quite strange the user be "sa@localhost", I think should be "sa".

PostPosted:**Mon Jun 11, 2018 6:55 am**

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.

PostPosted:**Tue Jun 12, 2018 5:54 pm**

You might understanding that languages are not loaded because it seems there's a database issue. You will not be able to login if application is not able to connect to the database, language error is only the tip of the icerberg. The first step should be able to browser into the database, if you do not success it consider your data are lost and consider trying to recover files ( what will be tedious task, this old documentation section https://www.openkm.com/wiki/index.php/D ... recovering might help you on it under linux ).

PostPosted:**Wed Jun 13, 2018 5:22 am**

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.

PostPosted:**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

PostPosted:**Wed Jun 13, 2018 8:34 am**

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

Still the same..

PostPosted:**Fri Jun 15, 2018 7:08 am**

Try listing available tables, should be some option to see existing tables in the tool, no ?

PostPosted:**Fri Jun 15, 2018 9:05 am**

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

PostPosted:**Fri Jun 15, 2018 11:41 am**

Hello Jllort,

I followed your guide on changing the okmAdmin password to admin via 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','21232f297a57a5a743894a0e4a801fc3','noreply@openkm.com','

but I am not able to find the same script but seeing the script as below:(I have changed the password to admin)

INSERT INTO OKM_ACTIVITY VALUES(338,'ADMIN_USER_EDIT','2014-07-03 12:23:12.557000','okmAdmin','{id=okmAdmin, name=Administrator, password=21232f297a57a5a743894a0e4a801fc3, email=myemail@domain.com, active=true, roles=[{id=ROLE_ADMIN, active=true}]}',NULL,'okmAdmin')

Still then I am not able to login. This is the case with all the users... None of us can login.

Your help is highly appreciated.

Regards,
Nig.

PostPosted:**Sat Jun 16, 2018 3:34 pm**

The discussion is this post is into a infinite loop. I continue thinking your database is corrupted or died, if you are not able lo startup the database itself, consider your application died. This are obviously not good news. If you want our IT staff take a look on it, contact with us from our contact website form and sales & marketing they decide what doing in your case.

When embeded database is defunct usually there's nothing to do ( like other databases , the solution is recover from backup if you have or consider data lost ).

Open Source Document Management System | OpenKM

All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.

Re: All users including okmAdmin not able to login.