LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 03-16-2003, 10:03 AM   #1
oneiltj
LQ Newbie
 
Registered: Jan 2003
Location: NE, Ohio
Posts: 19

Rep: Reputation: 0
Samba and MS Access Shares


Sorry - I miss posted this first in Software.

Samba and MS Access Shares ( post #1)

I have an access db that a number of people need to share. One ID can log on many times and use the db. Many ID's can't share the DB at the same time. Every ID can get to the db and write to it so long as no one else tries it. I don't think it's straight forward permissions....

mark is the owner xrw
staff is the group xrw

Should I have some one else set up as owner?

At first I thought maybe some type of share violation, now I think it may be related to mark owning the file, pam logs in and cant write to it because mark owned it first.

This is machine runs RH 8.0, Samba 2.2.7.

Thanks in advance.

-t
 
Old 03-16-2003, 10:20 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,384

Rep: Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963Reputation: 1963
http://www.linuxquestions.org/questi...threadid=50024

do not post a question more than once, i know someone told you it would be a good idea, but it's not, trust me. just choose the forum more carefully next time. thanks
 
Old 03-16-2003, 03:08 PM   #3
Finlay
Senior Member
 
Registered: Mar 2003
Location: Seattle
Distribution: Slackware ?-14.1
Posts: 1,029

Rep: Reputation: 47
well acid wasn't too helpful...

You may want to look at the access DB itself through Access. You have to configure them to be able to have multiple connections at once.
 
Old 03-19-2003, 07:06 AM   #4
oneiltj
LQ Newbie
 
Registered: Jan 2003
Location: NE, Ohio
Posts: 19

Original Poster
Rep: Reputation: 0
..no he wasn't, was he.

This data base existed previously on a NT server and functioned well as multi user. The only major diference is now it sits on a unix file system being shared by samba.
 
Old 03-19-2003, 01:54 PM   #5
turnip
Member
 
Registered: Jul 2002
Posts: 143

Rep: Reputation: 15
You can check the veto oplock files = /*.mdb/

You can also look at this link for information of oplocks.

http://www.oreilly.com/catalog/samba...k/ch05_05.html
 
Old 03-20-2003, 08:03 AM   #6
oneiltj
LQ Newbie
 
Registered: Jan 2003
Location: NE, Ohio
Posts: 19

Original Poster
Rep: Reputation: 0
That locks VERY promising.

Get back to you later.
 
Old 04-17-2003, 12:12 PM   #7
oneiltj
LQ Newbie
 
Registered: Jan 2003
Location: NE, Ohio
Posts: 19

Original Poster
Rep: Reputation: 0
I have the same problem.

The files are owned by mark and a group called staff and both have rwx. If another member of staff say john, attempts to use the the file he is denied. I'm wondering if it's because Mark owns it?

Another though is to create a sym link and point the users to the sym link...

Does anyone else have experience shareing databases under samba?
 
Old 04-17-2003, 05:17 PM   #8
J_Szucs
Senior Member
 
Registered: Nov 2001
Location: Budapest, Hungary
Distribution: SuSE 6.4-11.3, Dsl linux, FreeBSD 4.3-6.2, Mandrake 8.2, Redhat, UHU, Debian Etch
Posts: 1,126

Rep: Reputation: 58
Check this thread:
http://www.linuxquestions.org/questi...threadid=53778
 
Old 08-31-2003, 06:47 AM   #9
shannonp
LQ Newbie
 
Registered: Aug 2003
Posts: 2

Rep: Reputation: 0
So is this thread still being monitored??

I am having the same issues....but think I have pinpointed the exact problem, heres an example of my scenario:

I have set up a Samba Domain where I store "records.mdb" which is stored in "/Shared".

"/Shared" and all files stored within are owned by "ntuser" and belongs to group "ntusers", the group "ntusers" have full read write access.

"User1" and "User2" both belong to group "ntusers" which gives them full access to "records.mdb".

This is fine.....now,

Lets say User1 is logged in...this in hand creates "records.ldb" where attributes change so that only the owner has full access. People belonging to the group "ntusers" ONLY have read only access so when User2 tries to log in, it too tries to add itself to "records.ldb" but because only User1 has write access the database bombs out for User2.

I have been able to get past this by going to the server and changing the permissions so that group "ntusers" has full access to "records.ldb" but this is only temporary because ldb files are static so the same problems occurs next time around.

How do you tell Samba to keep group permissions on files in a group share when created by a particular user (as I think this is the primary problem)??

Slightly confused? I am?? (lol)
 
Old 08-31-2003, 10:25 AM   #10
sidmark-2850
Member
 
Registered: Aug 2003
Posts: 133

Rep: Reputation: 15
You should create or modify the smb share as follows:

[Shared]
path = <path to shared folder>
comment = Shared Directory
create mask = 0660
security mask = 0660
directory mask = 2770
directory security mask = 2770

You should also chmod the <path to shared folder> to 2770 and chgrp'ing it to the group that should have access to your folder. In your case staff. Doing this will allow the staff group to share files and have group read write access to the database and other files.

Oh! Also, chmod existing files to 0660 and folders to 2770

Cheers

Last edited by sidmark-2850; 08-31-2003 at 10:27 AM.
 
Old 08-31-2003, 06:58 PM   #11
shannonp
LQ Newbie
 
Registered: Aug 2003
Posts: 2

Rep: Reputation: 0
Ahhhh Cool...thanks sidmark! That worked perfectly!!

I have another question...lets say I have a samba domain and several XP clients connected. Can I automatically MAP shares (lets take /Shared as an example) to a particular drive letter so that when a valid domain user logs into the samba server it checks to see if "/Shared" is mapped to a drive letter? (presuming that the drive letter is available).

Would I have to use netlogon.bat to accomplish this or can I simply add something into my smb.conf?
 
Old 08-31-2003, 10:41 PM   #12
sidmark-2850
Member
 
Registered: Aug 2003
Posts: 133

Rep: Reputation: 15
oneiltj. I hope the posts answered your questions. You probably haven't implemented the change yet. I hate when people don't respond. They meek me in suspense.

shannonp, I am glad that it worked out. Since you are running a samba domain, it should be relatively painless to do what you asked.

First, you create a netlogon share. This share holds your scripts and the logon script parameter set. You probably have it set up already. JIC:

Code:
[global]
	...
	logon script = logon.bat


[Netlogon]
	comment = Logon Server Share
	path = /var/samba/netlogon
	read only = yes
	write list =  shannonp, @script-managers
	create mask = 0664
	security mask = 0664
	directory mask = 2775
	directory security mask = 2775
	browseable = No
In your logon.bat file, or whatever you call it, you need to have something like:

Code:
@echo off
echo Running Windows Logon Script
echo.

if %OS%==Windows_NT goto NTMap
goto Map

:NTMap
echo You are running Windows NTx
echo .
echo Mapping Shared Drive
net use S: \\Server\Shared /persistent:no /y

goto exit

:Map
echo You are Running Windows 9x
echo .
echo Mapping Shared Drive
net use S: \\Server\Shared /persistent:no /y

goto exit


:exit
echo Executing other logon tasks
The /persistent:no parameter tells windows ntx machines not to map the drive automatically at logon. That way, if you decide remove the s or whatever drive letter you choose, nt won't try to map it even thought it is no longer in the script.

The /y parameter supresses the "S: is currently \\Server\Shared. The local device name S: is already in use" and map the drive anyway. This will NOT work if the drive letter is a local disk such as a hard drive or CDrom.

You may need to do some testing with the above script. I haven't used it in a while and I am not sure whether it works as it should on both 9x and nt. I am a bit rusty with dos.

Cheers.
 
Old 08-05-2004, 03:56 PM   #13
Qcon04
LQ Newbie
 
Registered: Aug 2004
Posts: 9

Rep: Reputation: 0
CHmod?

Im having the same kinda issues.. I completed every step until the chmod part. I open the console but was lost at that point. what do the command look like.

i.e chmod sharedfolder 2770?



 
Old 08-08-2004, 08:11 PM   #14
oneiltj
LQ Newbie
 
Registered: Jan 2003
Location: NE, Ohio
Posts: 19

Original Poster
Rep: Reputation: 0
Been away...

sidmark-2850 - Sorry for such a long time in my reply. I've been away from the group for a while.

A number of things came up since this thread was posted limiting my abilllity to work on this.

Thank you all for your help.

--t
 
  


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
can't access samba shares [goldy] Linux - Software 14 08-21-2004 08:42 PM
Can't access samba shares from xp ralupien Linux - Software 11 12-16-2003 01:12 PM
Access denied XP samba shares djtsa Linux - Software 0 10-02-2003 06:26 AM
can't access samba shares from xp hemp4fuel Slackware 20 07-09-2003 01:28 AM
Samba and MS Access Shares oneiltj Linux - Software 3 03-18-2003 11:32 AM


All times are GMT -5. The time now is 11:23 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration