IllegalArgumentException when trying to login

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.
Post Reply
mahima11
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Mon Mar 23, 2020 1:42 am

IllegalArgumentException when trying to login

Post by mahima11 »

I have used installer to setup OpenKM,
database-mysql, OS-windows 10
Installation was completed successfully however when I try to login it throws java.lang.IllegalArgumentException: "option code" 65436 must be an unsigned 8 bit value.
Screenshot (1).png
Trying login using the default credentials username:okAdmin password:admin

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

Re: IllegalArgumentException when trying to login

Post by jllort »

Change your DNS service, I think you are pointing to Azure DNS service, currently there's an issue with it. Try with google DNS ( 8.8.8.8, 8.8.4.4 ).

jhr
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Sat Mar 28, 2020 2:27 pm

Re: IllegalArgumentException when trying to login

Post by jhr »

i have the same problem...

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

Re: IllegalArgumentException when trying to login

Post by jllort »

Did you tryed changing the DNS servers either using Azure ones?

tcconsulting
Fresh Boarder
Fresh Boarder
Posts: 11
Joined: Fri Jun 02, 2017 6:50 pm

Re: IllegalArgumentException when trying to login

Post by tcconsulting »

Well, I'm getting the same message.

I have several instances running on openkm-ce:6.3.9-DEV. I tried starting a new one on that same image today and am getting this error.

It looks like a change was made to that image 4 months ago. Did that change introduce this issue? Or did something with Azure change?

I'm running OpenKM and MySQL in separate Docker containers on an Azure VM. OpenKM talks to MySQL via the internal Docker network. It isn't resolving external domain names. After all, it knows when I'm typing valid credentials, so it's talking to the database.

So even if I did change the DNS settings for the Azure VM to non-Azure DNS servers, they wouldn't be resolving the database connection. Why is it dependent on resolving external domain?

tcconsulting
Fresh Boarder
Fresh Boarder
Posts: 11
Joined: Fri Jun 02, 2017 6:50 pm

Re: IllegalArgumentException when trying to login

Post by tcconsulting »

Or is this purely a web user interface issue?

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

Re: IllegalArgumentException when trying to login

Post by jllort »

The issue is caused by Azure DNS change ( upgrade or similar ). Try changing to google DNS, I suppose you can have principal and secondary dns, try google as principals and Azure as secondary, maybe it works.

tcconsulting
Fresh Boarder
Fresh Boarder
Posts: 11
Joined: Fri Jun 02, 2017 6:50 pm

Re: IllegalArgumentException when trying to login

Post by tcconsulting »

I was testing changing the DNS in the Azure VM to use Google DNS servers.

Now I can log in, but once the interface begins to load, it crashes with:

Code: Select all

OKM-022024(getEnabledExtensions): OKM-022024

could not load an entity: [com.openkm.dao.bean.Profile#1]
Looking at the logs, I see this error:

Code: Select all

ERROR o.h.util.JDBCExceptionReporter - Unknown column 'profile0_.PRF_MN_TL_OMR_VIS' in 'field list',
I did not initially see that column in the OKM_PROFILE table in the MySQL database, so I ran the instance with "hibernate.hbm2ddl=update". Now I see the column, but while I don't get the error popping up when I log in, but I can't get past "Loading user values". No errors in the log, either.

I've tried with both these containers:
  • openkm/openkm-ce:6.3.9
  • openkm/openkm-ce:6.3.9-DEV (which was working fine before the Azure DNS change)
Is there any other reason to see the "PRF_MN_TL_OMR_VIS'" error other than an older database?

tcconsulting
Fresh Boarder
Fresh Boarder
Posts: 11
Joined: Fri Jun 02, 2017 6:50 pm

Re: IllegalArgumentException when trying to login

Post by tcconsulting »

I also tried with "hibernate.hbm2ddl=create".

Still hangs at "Loading user values".

No errors in the log.

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

Re: IllegalArgumentException when trying to login

Post by jllort »

The last issue you shared have not relation with the current topic, I suggest create another post for it. This type of error happens in OpenKM upgrade I'm talking about this kind of error

Code: Select all

Unknown column 'profile0_.PRF_MN_TL_OMR_VIS' 
If it is not a fresh OpenKM, you should switch to

Code: Select all

hibernate.hbm2ddl=update
And then restart OpenKM

Post Reply