All users including okmAdmin not able to login.

[nigyel]

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.

[jllort]

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 )

[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.

[jllort]

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

[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.

[jllort]

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".

[nigyel]

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.

[jllort]

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 ).

[nigyel]

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.

[lnovoa]

Hi!,
the name with minors does not exist.
Safely that is the reason.

Try:

Code: Select all

select * from OKM_USER

[nigyel]

Hi!,
the name with minors does not exist.
Safely that is the reason.

Try:

Code: Select all

select * from OKM_USER

Still the same..

[jllort]

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

[nigyel]

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

[nigyel]

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.

[jllort]

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 ).