Page 1 of 1
IllegalArgumentException when trying to login
PostPosted:Mon Mar 23, 2020 1:49 am
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 (70.86 KiB) Viewed 135040 times
Trying login using the default credentials username:okAdmin password:admin
Re: IllegalArgumentException when trying to login
PostPosted:Mon Mar 23, 2020 3:59 pm
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 ).
Re: IllegalArgumentException when trying to login
PostPosted:Sat Mar 28, 2020 2:30 pm
by jhr
i have the same problem...
Re: IllegalArgumentException when trying to login
PostPosted:Sun Mar 29, 2020 10:36 am
by jllort
Did you tryed changing the DNS servers either using Azure ones?
Re: IllegalArgumentException when trying to login
PostPosted:Tue Apr 14, 2020 6:38 pm
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?
Re: IllegalArgumentException when trying to login
PostPosted:Tue Apr 14, 2020 6:50 pm
by tcconsulting
Or is this purely a web user interface issue?
Re: IllegalArgumentException when trying to login
PostPosted:Sat Apr 18, 2020 10:04 am
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.
Re: IllegalArgumentException when trying to login
PostPosted:Thu May 14, 2020 7:41 pm
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 allOKM-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 allERROR 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-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?
Re: IllegalArgumentException when trying to login
PostPosted:Thu May 14, 2020 8:16 pm
by tcconsulting
I also tried with "hibernate.hbm2ddl=create".
Still hangs at "Loading user values".
No errors in the log.
Re: IllegalArgumentException when trying to login
PostPosted:Tue May 19, 2020 5:51 pm
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 allUnknown column 'profile0_.PRF_MN_TL_OMR_VIS'
If it is not a fresh OpenKM, you should switch to
And then restart OpenKM