LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 08-13-2005, 07:07 AM   #1
jorasmi
Member
 
Registered: Apr 2002
Location: Philippines
Distribution: Slackware 10.2
Posts: 111

Rep: Reputation: 15
File permission help!


Hi guys,

I'm so confused... I have a Linux file server where I am housing a Microsoft Access Database. I have 5 users who needs to access the database at the same time but only one cilent can open the file at a time. I'm pretty sure that the problem is with the permission. When an access database is open, an "ldb" file is automatically created. Thats where the problem start because the by default, the read and write permission is only granted for the user but not for the group.

I think the problem will be solve if i can set the default permission of the newly created files to have read, write and execute permision. I dont know how to do it. Please help..

Thanks in advance!
 
Old 08-13-2005, 11:22 AM   #2
kodon
Member
 
Registered: Jul 2004
Location: [jax][fl][usa]
Distribution: Slackware64-current
Posts: 796

Rep: Reputation: 31
'man umask'
 
Old 08-14-2005, 06:47 AM   #3
d00bid00b
Member
 
Registered: Aug 2005
Location: London, UK
Distribution: Debian Testing
Posts: 157

Rep: Reputation: 31
Re: File permission help!

Quote:
Originally posted by jorasmi
I'm so confused... I have a Linux file server where I am housing a Microsoft Access Database. I have 5 users who needs to access the database at the same time but only one cilent can open the file at a time. I'm pretty sure that the problem is with the permission. When an access database is open, an "ldb" file is automatically created. Thats where the problem start because the by default, the read and write permission is only granted for the user but not for the group.

I think the problem will be solve if i can set the default permission of the newly created files to have read, write and execute permision. I dont know how to do it. Please help..
If I understand your question correctly, I suspect that the problem might well reside within the MS Access protocol itself and won't be an issue you could resolve with server-level permission sets. I think that Access (like Excel) will automatically lock a file while it is active with one user. A second user might be able to access it read-only at the same time, but that would be it. I don't think that using MS Access is a real-time multi-user application, but I stand to be corrected. You might want to look into this before fiddling with user and group permissions on the server.
 
Old 08-14-2005, 09:24 PM   #4
jorasmi
Member
 
Registered: Apr 2002
Location: Philippines
Distribution: Slackware 10.2
Posts: 111

Original Poster
Rep: Reputation: 15
Re: Re: File permission help!

Quote:
Originally posted by d00bid00b
If I understand your question correctly, I suspect that the problem might well reside within the MS Access protocol itself and won't be an issue you could resolve with server-level permission sets. I think that Access (like Excel) will automatically lock a file while it is active with one user. A second user might be able to access it read-only at the same time, but that would be it. I don't think that using MS Access is a real-time multi-user application, but I stand to be corrected. You might want to look into this before fiddling with user and group permissions on the server.
That is true with excel but i think not in ms access. Before when the database is in Windows, all my clients can access the files at the same time.
 
Old 08-14-2005, 09:52 PM   #5
shashir
Member
 
Registered: Jul 2004
Posts: 70

Rep: Reputation: 15
What protocol are you using for this functionality?

I really don't think the current Linux compatibility with Access databases is high. I suggest that you use Windows if Access is the only database system you will use.
 
Old 08-14-2005, 10:27 PM   #6
jorasmi
Member
 
Registered: Apr 2002
Location: Philippines
Distribution: Slackware 10.2
Posts: 111

Original Poster
Rep: Reputation: 15
tcpip is the protocol.

right now, once a user open a database i chmod the file that access created so that all users can access it at the same time. i think umask will help.

is it possible to umask a certain directory? i think my problem wil be solve if only all new files created will have a default 777 permission.
 
Old 08-15-2005, 08:37 PM   #7
zapatengo
LQ Newbie
 
Registered: Aug 2005
Posts: 1

Rep: Reputation: 0
I recently set up a Centos 4 file server for a small company. Op_locks must be disabled on both the Samba server (smb.conf) and the Win clients. Microsoft calls it 'write behind cache'. I tend to think of it as 'he who gets there first wins.' Access and Quickbooks need this done for a multiuser environment. I will try to look up the exact registry values for the win boxes. Try Samba.org to see an example of opportunistic locks = xx in an smb file. Battery low = gotta go. gary
 
Old 08-15-2005, 10:07 PM   #8
jorasmi
Member
 
Registered: Apr 2002
Location: Philippines
Distribution: Slackware 10.2
Posts: 111

Original Poster
Rep: Reputation: 15
zapatengo! THANKS! IT WORKS! I edit some lines in my samba configuration and it works! Thanks all guys!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
About the file permission ust Linux - Distributions 1 05-06-2005 03:05 AM
The file permission ust Linux - Distributions 1 05-05-2005 04:37 AM
file permission jh31480 Linux - Newbie 2 01-25-2005 06:42 PM
file permission ust Linux - General 3 04-20-2004 06:14 AM
File Permission glock19 Linux - General 4 01-02-2002 07:40 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 09:37 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration