- CheckMates
- :
- Products
- :
- Developers
- :
- API / CLI Discussion
- :
- community Object is viewed in read only mode
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Are you a member of CheckMates?
×- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
community Object is viewed in read only mode
Hello,
ran into bizzar situation my VPN community is locked i didn't do anything or published nothing. just entered my admin user
in SmartConsole R81.10 and the object is locked. i tried all the above here and nothing.
it is a Lab environment so i can do whatever no harming clients.
- jumbo fix didnt help
- revert session also
any ideas?
Mor
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
thank you for the help. i actually solved it with this link here:
https://community.checkpoint.com/t5/Management/How-to-release-lock-from-objects-in-R80-10/td-p/6969#
with this command:
psql_client cpm postgres -c "SELECT objid, name, dlesession, cpmitable, subquery1.lockingsessionid, subquery1.operation FROM dleobjectderef_data, (SELECT lockedobjid, lockingsessionid, operation FROM locknonos) subquery1 WHERE subquery1.lockedobjid = objid and not deleted and dlesession >=0;"
Then, delete the object from locknonos db-table to release it.
psql_client cpm postgres -c "delete from locknonos where lockedobjid='[objid-from previous command]';"
cpstop;cpstart to restart the services.
AND ALL WORKS FINE!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
login with a super admin account and check if you have any unpublished sessions. Once one is found, take it over and publish.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
thank you for the help. i actually solved it with this link here:
https://community.checkpoint.com/t5/Management/How-to-release-lock-from-objects-in-R80-10/td-p/6969#
with this command:
psql_client cpm postgres -c "SELECT objid, name, dlesession, cpmitable, subquery1.lockingsessionid, subquery1.operation FROM dleobjectderef_data, (SELECT lockedobjid, lockingsessionid, operation FROM locknonos) subquery1 WHERE subquery1.lockedobjid = objid and not deleted and dlesession >=0;"
Then, delete the object from locknonos db-table to release it.
psql_client cpm postgres -c "delete from locknonos where lockedobjid='[objid-from previous command]';"
cpstop;cpstart to restart the services.
AND ALL WORKS FINE!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great to see you have your answer, but this is not a recommended way. It may break legitimate sessions, if applied during someone else making changes.
You should always try to clean abandoned sessions and make sure nobody is connected to the management server before applying this approach.
