Is it safe too delete .iso files from /vastorage/filr/filerepository/kablink/0/90/folderEntry_663323?
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it! Learn more
Is it safe too delete .iso files from /vastorage/filr/filerepository/kablink/0/90/folderEntry_663323?
Whatever you mean by safe?
Someone has stored this ISO file in its personal storage. If you delete it, then this account will have a problem. And there is another side effect: the operating database will be out of correct information, because you deleted an entry without database control.
So my recommendation is not to do it ...
Use "Verified Answers" if your problem/issue has been solved!
The best thing is to delete it from within Filr. Have a look in the database and work out who's personal storage it is in.
Look in ss_folderentries and find the line with an ID of 663323, look accross and you will find the value of creation principal. Look up in ss_principals that id and you will have the user that owns the file ask them to delete it.
Also set restrictions on size, and ser quotas for personal storage so this doesn't happen in the future
Here is a query I use to return the 100 largest files in a system and their owners. I don't have it set to just return personal storage files so net folder files will be there as well.
SELECT ss_attachments.filename,
ss_attachments.filelength,
ss_principals.name,
ss_forums.pathname
FROM ss_attachments
INNER JOIN ss_forums ON
ss_attachments.owningbinderid = ss_forums.id
INNER JOIN ss_principals ON
ss_attachments.creation_principal = ss_principals.id
WHERE
ss_attachments.type = 'F'
ORDER BY ss_attachments.filelength DESC
LIMIT 100
Hi Robin. I am a bit lost. Do I need to find the information you referring to on FILR under the Administration option or do I need to SSH to the server? This is my /vastorage folders. Under which Directory do you find the ss_folderentries? They are using FILR4.0
filr01-/vastorage/filr # l
total 40
drwxr-xr-x 8 root root 4096 May 25 2017 ./
drwxr-xr-x 9 root root 4096 Aug 24 2019 ../
drwxr-xr-x 5 root root 4096 May 25 2017 cachefilestore/
drwxr-xr-x 2 wwwrun www 4096 May 25 2017 conf/
drwxr-xr-x 3 root root 4096 May 25 2017 extensions/
drwxr-xr-x 3 root root 4096 May 25 2017 filerepository/
drwxr-xr-x 6 wwwrun root 12288 Nov 20 09:22 temp/
drwxr-xr-x 3 root root 4096 May 25 2017 velocity-ext/
Robin loves to work with phppgadmin as I do.
So you have to access your appliance via 9443. If you use an appliance for your database, then connect to this one with 9443.
There you will find phppgadmin, an icon in the second row. Access database filr; user filr - and you have to know the password. Now you can run sql statements.
There were some (webinar) recordings to show how to do it. Hopefully Robin has the right links ...
Use "Verified Answers" if your problem/issue has been solved!
Thank Diethmar and Robin for your advice. I will try these options.