Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
Help me understand system locking/permissions |
Thu, Dec 15 2011 9:57 AM | Permanent Link |
Iztok Lajovic (1) | Hi
I've been having problems with accessing certain files for some time now. I wrote about my problems in Elevate DB tech support forum and found out that error 11013 that I get is usually the result of AV or some other process locking mentioned files. After reading about others problems I found out that account permissions could also be guilty for it. I used the method Tim suggested (thank you Tim!) which is looking for opened files via: Control Panel/Administrative Tools/Computer Management/Shared Folders/Open Files. None of the tables that I am trying to open are marked as opened. Than I used "unlockIt" tool which is supposed to show which process has certain files locked. It didn't show any of my .dat files as locked by any process. To further explain ... I can open those files if I use my server computer, but I can't open them if I use any other "client" machines and I am opening them manually (double click on the file). So my problem should be somewhere in user/account permissions, wright? But my permissions are the same for the entire disk. All other files are OK, just this one directory is giving me problems. And the last thing to add to my confusion is something I discovered today. I can delete those files through my local machine but I can't rename or open them??? Where is the logic in that? I don't use "simple file sharing" because I had even more problems with that. So .. how to set my permissions above full (every permission check box is checked) to avoid those errors in future? I have deinstalled AV, DBISAM server and resetted all computers. My temp file location is set to dir with full control. Thank you Iztok Lajovic |
Thu, Dec 15 2011 10:12 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Iztok
I have a vague memory of something similar. The onnly way I eventually found to cure it was to create a new directory, copy all the files into there, delete the original directory and rename the new one. I never did find out what the problem was. Roy Lambert [Team Elevate] |
Thu, Dec 15 2011 10:37 AM | Permanent Link |
Raul Team Elevate | Iztok,
I'm assuming based on your description the files are shared from a server/workstation and run by remote clients over share. The permissions are fairly straightforward in this case: - on server computer make sure Everyone has Full Control to the folder and subfolders in question - similarly on the shared folder (i assume it's one of the top folders from previous step) make sure under sharing Everyone has Full Control again (basically you need both local and share permissions to allow full control for remote users to have full control on files). As Roy suggested recreating folders and shares might be a good idea. Simple sharing should be turned off. Also disable anti-virus real-time scan on clients temporarily if it's still running - I've seen some AV engines scan a remote share whenever your OS accesses it by UNC and it causes all kinds of problems. As i recall the "Shared Folders/Open Files" only shows files open by remote clients and not by server itself (for example AntiVirus or even something like dbsys running on server does not show there). The other tool that has helped me with this kind of troubleshooting is the Process Monitor from sysinternals: http://technet.microsoft.com/en-us/sysinternals/bb896645 Basically run it on your server and set the filter so it only shows your DB files (e.g. set filter : path contains <your folder> include"). The procmon will log every file open/read/etc so if you run it and try to run the app from remote workstation you might be able to see what it actually taking place underneath at file access level. It can generate lot of data but if you filter and then run a controlled test with single remote client it should be easy to read. Raul On 12/15/2011 9:57 AM, Iztok Lajovic (1) wrote: > Hi > > I've been having problems with accessing certain files for some time now. I wrote about my problems in Elevate DB tech support forum and found out that error 11013 that I get is usually the result of AV or some other process locking mentioned files. After reading about others problems I found out that account permissions could also be guilty for it. > > I used the method Tim suggested (thank you Tim!) which is looking for opened files via: Control Panel/Administrative Tools/Computer Management/Shared Folders/Open Files. > None of the tables that I am trying to open are marked as opened. > > Than I used "unlockIt" tool which is supposed to show which process has certain files locked. It didn't show any of my .dat files as locked by any process. > > To further explain ... I can open those files if I use my server computer, but I can't open them if I use any other "client" machines and I am opening them manually (double click on the file). So my problem should be somewhere in user/account permissions, wright? > But my permissions are the same for the entire disk. All other files are OK, just this one directory is giving me problems. > And the last thing to add to my confusion is something I discovered today. I can delete those files through my local machine but I can't rename or open them??? Where is the logic in that? > > I don't use "simple file sharing" because I had even more problems with that. So .. how to set my permissions above full (every permission check box is checked) to avoid those errors in future? > I have deinstalled AV, DBISAM server and resetted all computers. My temp file location is set to dir with full control. > > Thank you > > Iztok Lajovic > |
Thu, Dec 15 2011 11:50 AM | Permanent Link |
Robert Kaplan | <Iztok Lajovic (1)> wrote in message news:3D0EA79E-5B12-4F30-BC71-4AED188A4ABB@news.elevatesoft.com... > Hi > There is an issue when you do table updates, restructures, optimize, etc. in that the new table is created on the temp folder and then moved to the database folder but with the temp permissions. See if this could be your problem. Robert |
Fri, Dec 16 2011 3:37 AM | Permanent Link |
Iztok Lajovic (1) | Hi
Thanks to all for your help. Moving those files to another locations actually worked. That solution is not exactly a good one since I have to manually move those files, but at least it works. I will also change the location for my temp folder so there is no confusion about permissions. Iztok Lajovic |
Thu, Dec 22 2011 12:55 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< There is an issue when you do table updates, restructures, optimize, etc. in that the new table is created on the temp folder and then moved to the database folder but with the temp permissions. See if this could be your problem. >> That's exactly what I was thinking also - the permissions are okay, but then keep getting changed as the files are created locally and then re-copied to the share: http://www.elevatesoft.com/bulletins?action=view&category=dbisam&bulletin=windows_xp_file_sharing -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |