Page 1 of 1

ROLE_ADMIN lost its privileges

PostPosted:Thu Mar 21, 2013 4:06 pm
by abelibm
Hello,

I'm quite new with the app and I'm setting the typical customizations.

Well, my problem is that I've followed the steps included in the documentation to change from ROLE_ADMIN to MY_ROLE within the Admin-> Configuration tab, and I also did the same in the file within the TOMCAT_HOME directory.

My problem, (and I guess it's happened to anybody else) is that when I log out from the admin console (because I restart the server as required),
The ADMINISTRATION tab does not show up!!
( I'm using firefox )
It seems that there is another parameter (probably in the admin user information) where I did not change the ROLE.

I've tried searching for the database schema to set this value properly but I could not find it anywhere.

Anybody can help? I wouldn't like to reinstall the server from the very beginning (quite easy to do it, thanks!) because I suppose it's a simple problem or bug that could be fixed.

Many thanks!!!

Re: ROLE_ADMIN lost its privileges

PostPosted:Fri Mar 22, 2013 10:52 am
by jllort
Take a look at table SELECT * FROM OKM_USER_ROLE; to ensure role is assigned to the user.

Re: ROLE_ADMIN lost its privileges

PostPosted:Fri Mar 22, 2013 4:42 pm
by abelibm
Thanks a lot, It really gave me an idea to how troubleshoot this,

The name change of the ROLE_ADMIN didn't quite work, but at least I could restore the previous configuration by editing the database itself.

If you'd like to hear a suggestion, I'd write a little bit clearer the documentation of how to access the database.

Maybe it was only for me a little difficult because I'm a rookie, but I'd have appreciated some more info.

Of course the application is wonderful and we are thinking of setting it up almost all the features possible ( and they are a bunch!!! )

Thank you!

Re: ROLE_ADMIN lost its privileges

PostPosted:Sun Mar 24, 2013 5:03 pm
by jllort
Actually there's a lot of documentation in our wiki, and should be read almost. About administration I suggest read http://wiki.openkm.com/index.php/Administration_Guide here's database query http://wiki.openkm.com/index.php/Database_query

For best performance and prevent database damage I suggest you install in a MySQL ( power shutdown etc.. can easilly damage HSQL, that's more difficult with MySQL ), take a look here http://wiki.openkm.com/index.php/MySQL_-_OpenKM_6.2