ROLE_ADMIN lost its privileges

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

[jllort]

Take a look at table SELECT * FROM OKM_USER_ROLE; to ensure role is assigned to the user.

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

[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