Help regarding Security rights....

[mohasinmujawar56]

I am using OpenKM 6.3 on Windows server 2008 R2 as well as on Windows 7 with MySQL database.
I have 5 users, 4 with ROLE_USER and 1 with ROLE_ADMIN (myself). I have removed the access rights of folders and documents for ROLE_USER. And y mistake I removed security rights for myself on a folder and applied recursively. So now I am not able to see any folders and documents.
Can you please help me to revert the rights???
I guess it can be done from database but only UUIDs are stored in it.

[jllort]

did you removed ROLE_ADMIN to okmAdmin ? otherwise you can login with this super user.
did you changed default database configuration ( embeded hypersonic ) or you've configured MySQSL ( we suggest this one for production )

[mohasinmujawar56]

The problem is solved....
I know the date when I have uploaded documents i selected the document uuids from node_base table uploaded within the date range and inserted the records in node_user_permission with desired rights...

Note (For other forum Users): Please don't try this unless & until you have a backup and you know MySQL or other database queries and their impacts.

[jllort]

If you change grants from database, you got a unsynchronized data between openkm database and search engine, for updating it you must go to Administration -> Utilities -> Rebuild indexes and choose Lucene indexes

[mohasinmujawar56]

I have done metadata on these files and if I am rebuilding indexes then the metadata done on the files are lost. I had the backup so I have restored it again. But if I am rebuilding indexes then I am loosing metadata done on the files which I cannot tell users to do again as the number of files stored are more than 4000.

[jllort]

If you choose rebuild indexes options you shoult not loosing metadata asociated to the documents. If you've removed the association between document and metadata then I can understand, otherwise should maintan it.

Can you make some screenshots. 1 document with metadata( I want to see metadata tab) , 2 search, 3 result of search after you've selected "lucene indexes"