All users including okmAdmin not able to login.

OpenKM has many interesting features, but requires some configuration process to show its full potential.
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.
nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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.
Attachments
2.png
1.png

jllort
Moderator
Moderator
Posts: 10037
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: All users including okmAdmin not able to login.

Post by jllort » 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 )

nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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.
Attachments
error.png

jllort
Moderator
Moderator
Posts: 10037
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: All users including okmAdmin not able to login.

Post by jllort » 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

nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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.
Attachments
access-denied.png

jllort
Moderator
Moderator
Posts: 10037
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: All users including okmAdmin not able to login.

Post by jllort » 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".

nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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.

jllort
Moderator
Moderator
Posts: 10037
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: All users including okmAdmin not able to login.

Post by jllort » 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 ).

nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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.
Attachments
database.png

lnovoa
Senior Boarder
Senior Boarder
Posts: 59
Joined: Tue Mar 27, 2018 8:00 am

Re: All users including okmAdmin not able to login.

Post by lnovoa » 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

nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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..

jllort
Moderator
Moderator
Posts: 10037
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: All users including okmAdmin not able to login.

Post by jllort » Fri Jun 15, 2018 7:08 am

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

nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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

nigyel
Junior Boarder
Junior Boarder
Posts: 28
Joined: Wed Jul 02, 2014 9:08 am

Re: All users including okmAdmin not able to login.

Post by nigyel » 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.

jllort
Moderator
Moderator
Posts: 10037
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: All users including okmAdmin not able to login.

Post by jllort » 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 ).

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests