Bluehost.com Web Hosting $6.95

[Samba] Looking for a set of definitive answers (long)

This is a discussion on [Samba] Looking for a set of definitive answers (long) within the Samba forums, part of the Networking and Network Related category; Question: We recently moved to a Samba-based file server, which holds mission- critical data on it (.dbf files used ...


Go Back   Usenet Forums > Networking and Network Related > Samba

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 05-21-2008
Avery Payne
 
Posts: n/a
Default [Samba] Looking for a set of definitive answers (long)

Question:

We recently moved to a Samba-based file server, which holds mission-
critical data on it (.dbf files used by our Accounting software, etc.)
The goal was to create a file server that had excellent performance while
providing Volume Management, but we felt that something like Veritas was
overkill for our needs.

Design Goals:
- Redundant Hardware
- Manual Failover (this was an acceptable solution)
- Very large storage capacity (minimum 1 Terabyte)
- Better than 100Mbyte/sec throughput
- Volume Management, Journaled Filesystem
- Drop-In Replacement for aging Win2k file server
- Use existing admin tools to avoid retraining


The proposed solution was a Samba file server running on a pair of
redundant servers, with one connected to an eSATA raid box, with LVM and
Ext3 providing volume management and journaling. Our transition was a
bit rough, but in the end it has been very stable and fast. We have been
really pleased with the performance of the hardware/software combo,
seeing sustained throughput of about 250Mbyte/sec with peaks as high as
300Mbyte/sec. But along the way, we encountered some oddities, and I
have some remaining questions.

First, the oddities (long-time Samba devs and admins, take this with a
grain of salt, when I say oddity I mean it from the perspective of an
experienced Windows administrator):

- File permissions do not behave as expected (from the viewpoint of other
staff working with the server).

The *nix permission bits cause a user, group, and "Everyone" entry to
become permanent and persistent. There was some initial grousing over
this fact as our long-time Windows admin scratched his head over why he
couldn't remove these entries as he saw fit. After explaining that there
would always be three settings no matter what, that they could never be
deleted, and that they represented actual filesystem-level bits that
wouldn't go away, it was accepted. I didn't notice if this was in the
docs or not, but I certainly didn't find it. It also meant enabling ACLs
on all of the filesystems and doing some creative thinking with the
permissions. The closest I could do was to map all files as owner root,
group set to Domain Admins, and Everyone set to disallowed; members of
the IT staff would be mapped with the "admin users" parameter; from
there, any additional permissions would be mapped via ACLs. We've found
that this method has the closest behavior to a "real" Windows server and
has satisfied everyone.

- Permissions don't propigate through the filesystem.

On a Real Windows Box(tm) you would be able to set permissions at the
parent level of a directory and have them show up for each child object.
Because the filesystem semantics are not the same in *nix-land, you need
to go into the directly and manually propigate the permissions, or if
you're stuck trying to administer permissions through a windows session
(like the other IT staffers in my department), using the Advanced setting
to force-reset all permissions on all child objects. This has also
caused a bit of grousing as we have several nested directories with a
heiarchy of permissions; getting one parent directory wrong means
rebuilding permissions for several child directories as well. I have
never been able to get a satisfactory answer as to how to resolve this
issue, other than the process I described above (which I had to resolve
for myself without documentation).

- To oplock or not to oplock: that is the question

The documentation is not entirely clear about when you should and
shouldn't use oplocks on shared files. It would have been much simplier
(IMHO) to simply say "use your best judgement, BUT if you are using
shared data files like Access or Excel or DBF's, you will want to disable
them or you'll have problems!". Yes those words show up on newsgroups,
but it should also show up in the documentation clearly.

- Office file locking workaround(s) were not immediately obvious

Buried in the nice (but large) Official Samba Reference and HOWTO is a
fix for sharing Word and Excel files through Samba, which involves using
the sticky bit for group permissions. While the fix was adequate and
works well, it should have been I think a little more prominently
displayed in the documentation.

- What? You want me to unlock that file?

We have had recurring instances where a workstation on the network has
seized a DBF file and held onto it, not allowing any other workstation or
server to perform writes to the file. This locking issue shows up in
random intervals and always requires that we have the person quit the
program we are using and log back in. It is not an application issue
that we can determine - the rest of the system continues to funciton, it
just prevents one of our servers (or anyone else) from locking the file.

- Speaking of which - just WHO does have that file lock?

For some reason, using the computer management tool in a windows
workstation shows stale information. In our past arrangement, we were
able to determine who would have the locked file by simply connecting the
tool to the server, and sorting on the number of locks present; the tool
would show the data file with a lock count greater than zero. Apparently
this doesn't fly when connecting to the Samba server - it shows files
open, but the lock count is for ALL locks (including reads) and not just
write locks.

- You sure you still have that file open? It says you don't even have it!

The computer management tool also has an issue with data appearing to be
stale. Workstations that have been powered down still show a file open.
Or in some cases, the workstation is working with the file, but no file
handle appears in the tool! This was (and still is) a major issue for
our staff, and as a result of this they have learned not to trust this
once-reliable tool, because from their point of view, it lies to them. I
have had to come up with some work-arounds and while they do work they
are suboptimal in their eyes.

Now, the remaining question(s):

- The vendor initially set up our authentication via tdb files and
Winbind. We have been using this combination succesfully for some time,
but in the Official Samba Guide it talks about regular maintenance of the
tdb files via tdbbackup. The department head has asked that I find the
definitive answer on how to do this, as we cannot afford more than a few
minutes of scheduled downtime. The vendor's response was that tdb files
should not be used because they can be corrupted when applying tdbbackup
to them (despite the fact that it was the vendor that set us up to use
them to begin with - go figure). This has caused even more concern -
millions of dollars in business and 50+ users are supported by this
server, running 24/7/365. So, if we were to loose our file server
tomorrow, and had to activate the backup server (which we would do by
plugging in the eSATA array into the new units and starting up the
system), how could we guarantee that the GUIDs, etc. would be consistent
and we wouldn't have a complete mess on our hands? I have seen someone
else recently mention that they should be using an LDAP authentication
backend. So who's correct, the vendor's original setup which uses tdb
files, or the 2nd vendor response which says don't use them, or should we
be on LDAP authentication connected to our Win2k3 domain controllers?

- Is there a way to get the Computer Mangement tool to not "lie" to us
about the state of file handles and locks? It would be a godsend to not
have to watch everyone roll their eyes because the "expected" way of
locating file issues simply doesn't work for them. This is an ongoing
issue and I can't really provide a satisfactory answer - even SWAT
appears to have this issue as well! I have resorted to shell scripting
to provide us with the answers we need but this is hardly a long-term
solution. Is there some magic setting I need to flip in the registry for
our Windows XP clients to make this issue just go away? Is it related to
protocol changes in the newer versions of the Windows redirectors? Just
why does this happen?

A parting thought as well:

It would have been nice to have had a reasonably generic template or
example somewhere that pointed this out, instead of wasting an incredible
amount of time (a month!) reading many many many pages of documentation,
sometimes scattered into different chapters, as well as contacting the
vendor twice with over a half-dozen messages. I would think that a
simple, single smb.conf file named "smb.conf.dom-member.filesserver" with
a generic looking setup would have resolved many of these issues, by
having the appropriate settings and comments already in the file while
pointing out what parts of the template needed to be changed. Everyone
that I have talked to outside of my work looks at Samba as a drop-in
replacement for existing Win2k(3) file servers, and a template with
settings that come closest to emulating that same behavior would go a
long ways towards adoption. I'm not trying to be overly critical, but
rather, I'm trying to point out a missing part of the software package
that I think administrators would like to have, especially as more and
more companies start to operate in mixed environments.

--
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/listinfo/samba

Reply With Quote
  #2 (permalink)  
Old 05-21-2008
Jeremy Allison
 
Posts: n/a
Default Re: [Samba] Looking for a set of definitive answers (long)

On Wed, May 21, 2008 at 06:47:52PM +0000, Avery Payne wrote:
> Question:
>
> We recently moved to a Samba-based file server, which holds mission-
> critical data on it (.dbf files used by our Accounting software, etc.)
> The goal was to create a file server that had excellent performance while
> providing Volume Management, but we felt that something like Veritas was
> overkill for our needs.
>
> Design Goals:
> - Redundant Hardware
> - Manual Failover (this was an acceptable solution)
> - Very large storage capacity (minimum 1 Terabyte)
> - Better than 100Mbyte/sec throughput
> - Volume Management, Journaled Filesystem
> - Drop-In Replacement for aging Win2k file server
> - Use existing admin tools to avoid retraining
>
>
> The proposed solution was a Samba file server running on a pair of
> redundant servers, with one connected to an eSATA raid box, with LVM and
> Ext3 providing volume management and journaling. Our transition was a
> bit rough, but in the end it has been very stable and fast. We have been
> really pleased with the performance of the hardware/software combo,
> seeing sustained throughput of about 250Mbyte/sec with peaks as high as
> 300Mbyte/sec. But along the way, we encountered some oddities, and I
> have some remaining questions.
>
> First, the oddities (long-time Samba devs and admins, take this with a
> grain of salt, when I say oddity I mean it from the perspective of an
> experienced Windows administrator):


Great post, thanks for writing it !

I always appreciate it when users come and tell us about their
experiences, and where we can improve.

Now onto the specifics:

> - File permissions do not behave as expected (from the viewpoint of other
> staff working with the server).


Yes, ACLs are just different between UNIX & Windows. We map Windows
ACLs onto POSIX as best as we can, but the mapping is not perfect.
The goal is to make the two common cases : "these groups and user
fred have access", and "these groups but *not* user fred have access"
as intuitive as possible.

For 3.3 we're planning to overlay a Windows ACL model that will
allow perfect Windows ACL restrictions to be added to Samba,
but not perfect Windows ACL allowances (ie. we'll store the
Windows ACLs and use them to restrict access early on access
denied returns, but still map down to POSIX to allow the underlying
file permissions to take effect).

Hopefully this might help you.

> - To oplock or not to oplock: that is the question
>
> The documentation is not entirely clear about when you should and
> shouldn't use oplocks on shared files. It would have been much simplier
> (IMHO) to simply say "use your best judgement, BUT if you are using
> shared data files like Access or Excel or DBF's, you will want to disable
> them or you'll have problems!". Yes those words show up on newsgroups,
> but it should also show up in the documentation clearly.


Ok, I believe we are *identical* w.r.t. Windows as far as
oplocks go. If the vendor says disable oplocks with Windows,
disable them with Samba also. If not, leave them in place.

> - Office file locking workaround(s) were not immediately obvious
>
> Buried in the nice (but large) Official Samba Reference and HOWTO is a
> fix for sharing Word and Excel files through Samba, which involves using
> the sticky bit for group permissions. While the fix was adequate and
> works well, it should have been I think a little more prominently
> displayed in the documentation.


Can you point that out to me. We've done more work on ACL compatibility
with 3.0.28a and I believe that fix may not now be needed.

> - What? You want me to unlock that file?
>
> We have had recurring instances where a workstation on the network has
> seized a DBF file and held onto it, not allowing any other workstation or
> server to perform writes to the file. This locking issue shows up in
> random intervals and always requires that we have the person quit the
> program we are using and log back in. It is not an application issue
> that we can determine - the rest of the system continues to funciton, it
> just prevents one of our servers (or anyone else) from locking the file.


Sounds like a bug to me. Not sure where, client app or Samba. Need
more info on this.

> - Speaking of which - just WHO does have that file lock?
>
> For some reason, using the computer management tool in a windows
> workstation shows stale information. In our past arrangement, we were
> able to determine who would have the locked file by simply connecting the
> tool to the server, and sorting on the number of locks present; the tool
> would show the data file with a lock count greater than zero. Apparently
> this doesn't fly when connecting to the Samba server - it shows files
> open, but the lock count is for ALL locks (including reads) and not just
> write locks.


This seems like a Samba dificiency with that tool. You should be
able to get that info by running smbstatus on the Samba box.

> - You sure you still have that file open? It says you don't even have it!
>
> The computer management tool also has an issue with data appearing to be
> stale. Workstations that have been powered down still show a file open.
> Or in some cases, the workstation is working with the file, but no file
> handle appears in the tool! This was (and still is) a major issue for
> our staff, and as a result of this they have learned not to trust this
> once-reliable tool, because from their point of view, it lies to them. I
> have had to come up with some work-arounds and while they do work they
> are suboptimal in their eyes.


Same as above. smbstatus should give you this info.

> Now, the remaining question(s):
>
> - The vendor initially set up our authentication via tdb files and
> Winbind. We have been using this combination succesfully for some time,
> but in the Official Samba Guide it talks about regular maintenance of the
> tdb files via tdbbackup. The department head has asked that I find the
> definitive answer on how to do this, as we cannot afford more than a few
> minutes of scheduled downtime. The vendor's response was that tdb files
> should not be used because they can be corrupted when applying tdbbackup
> to them (despite the fact that it was the vendor that set us up to use
> them to begin with - go figure). This has caused even more concern -
> millions of dollars in business and 50+ users are supported by this
> server, running 24/7/365. So, if we were to loose our file server
> tomorrow, and had to activate the backup server (which we would do by
> plugging in the eSATA array into the new units and starting up the
> system), how could we guarantee that the GUIDs, etc. would be consistent
> and we wouldn't have a complete mess on our hands? I have seen someone
> else recently mention that they should be using an LDAP authentication
> backend. So who's correct, the vendor's original setup which uses tdb
> files, or the 2nd vendor response which says don't use them, or should we
> be on LDAP authentication connected to our Win2k3 domain controllers?


It is safe to use tdbbackup on a live system. The vendor is
mistaken.

> - Is there a way to get the Computer Mangement tool to not "lie" to us
> about the state of file handles and locks? It would be a godsend to not
> have to watch everyone roll their eyes because the "expected" way of
> locating file issues simply doesn't work for them. This is an ongoing
> issue and I can't really provide a satisfactory answer - even SWAT
> appears to have this issue as well! I have resorted to shell scripting
> to provide us with the answers we need but this is hardly a long-term
> solution. Is there some magic setting I need to flip in the registry for
> our Windows XP clients to make this issue just go away? Is it related to
> protocol changes in the newer versions of the Windows redirectors? Just
> why does this happen?


Needs more work in Samba on supporting the Computer management
tool. Currently smbstatus works better for this.

> A parting thought as well:
>
> It would have been nice to have had a reasonably generic template or
> example somewhere that pointed this out, instead of wasting an incredible
> amount of time (a month!) reading many many many pages of documentation,
> sometimes scattered into different chapters, as well as contacting the
> vendor twice with over a half-dozen messages. I would think that a
> simple, single smb.conf file named "smb.conf.dom-member.filesserver" with
> a generic looking setup would have resolved many of these issues, by
> having the appropriate settings and comments already in the file while
> pointing out what parts of the template needed to be changed. Everyone
> that I have talked to outside of my work looks at Samba as a drop-in
> replacement for existing Win2k(3) file servers, and a template with
> settings that come closest to emulating that same behavior would go a
> long ways towards adoption. I'm not trying to be overly critical, but
> rather, I'm trying to point out a missing part of the software package
> that I think administrators would like to have, especially as more and
> more companies start to operate in mixed environments.


Yep, this is true. We depend on the Linux vendors to do this as
we don't have the resources (or more accurately haven't spent
the resources we have) on doing this. Sometimes they do a good
job, sometimes not. This is why server appliance vendors often
are a better choice than a full blown Linux solution, as they
sell a pre-set up solution.

Thanks for your thoughts !

Jeremy.
--
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/listinfo/samba

Reply With Quote
  #3 (permalink)  
Old 05-21-2008
John H Terpstra
 
Posts: n/a
Default Re: [Samba] Looking for a set of definitive answers (long)

Avery,

OK - I'll respond too. I see Jeremy has beaten me to it.

Let me tell you up front, if you want the documentation to be improved the
best thing you can do is contribute changes and updates. Making us aware of
docuentation problems is a good start, but please take this a step further -
send us your updates and changes.

One other thing, before I get too far into answer or commenting is this: The
Official Samba3 HOWTO and Reference Guide (TOSHARG) is a document (book) that
sets out how specific parts of Samba function. It was never intended to
provide a working template or a scripted recipe.

I did write the Samba3-ByExample book with the specific objective to provide
detailed step-by-step, fully worked, examples of real working networks, did
you consult that document at any time? Are you offering to improve its value
and utility by contributing your experiences and recommendations?

Users and admins like yourself are in the best position to improve the
documentation.

Please see comments below.

Chees,
John T.

On Wednesday 21 May 2008 01:47:52 pm Avery Payne wrote:
> Question:
>
> We recently moved to a Samba-based file server, which holds mission-
> critical data on it (.dbf files used by our Accounting software, etc.)
> The goal was to create a file server that had excellent performance while
> providing Volume Management, but we felt that something like Veritas was
> overkill for our needs.


A noble goal that can be achieved.

> Design Goals:
> - Redundant Hardware
> - Manual Failover (this was an acceptable solution)
> - Very large storage capacity (minimum 1 Terabyte)
> - Better than 100Mbyte/sec throughput
> - Volume Management, Journaled Filesystem
> - Drop-In Replacement for aging Win2k file server
> - Use existing admin tools to avoid retraining


The last two goals are a little ambitious. A drop-in replacement is a tall
order that I believe can not be met today. There are some existing tools,
but none are a complete replacement for the nicely integrated Microsoft
toolset.

> The proposed solution was a Samba file server running on a pair of
> redundant servers, with one connected to an eSATA raid box, with LVM and
> Ext3 providing volume management and journaling.


I would not architect the solution this way. There are way too many pitfals
with this solution. You have identified one already - the SID <=> UID/GID
mapping challenge.

I would have used a RAID5 array in each server with rsync to synchronize from
the master to the slave. This could be run from cron. Anyhow, this is a
digression from your problems.

> Our transition was a
> bit rough, but in the end it has been very stable and fast. We have been
> really pleased with the performance of the hardware/software combo,
> seeing sustained throughput of about 250Mbyte/sec with peaks as high as
> 300Mbyte/sec. But along the way, we encountered some oddities, and I
> have some remaining questions.


What lab work did you do in a test environment before rolling this life?
Proper pre-rollout evaluation can save a lot of head-banging later.

> First, the oddities (long-time Samba devs and admins, take this with a
> grain of salt, when I say oddity I mean it from the perspective of an
> experienced Windows administrator):


Grain of salt taken. Your initiative to write this email is most appreciated.
It is a first step in the process of improvement.

> - File permissions do not behave as expected (from the viewpoint of other
> staff working with the server).
>
> The *nix permission bits cause a user, group, and "Everyone" entry to
> become permanent and persistent. There was some initial grousing over
> this fact as our long-time Windows admin scratched his head over why he
> couldn't remove these entries as he saw fit.


Samba is an engine that sits on top of a host OS. That host OS is NOT Windows.
Samba has to go along with the rules imposed by the host OS. The TOSHARG
chapter on "File, Directory, and Share Access Controls" should be the red
flag that underlying file system semantics are exerted by Samba. Windows
admins need to be trained to understand that Samba is not Windows NT/2Kx,
etc.

Jeremy's notes about the VFS modular work aimed at providing better Windows
ACLs emulation may provide the solution you are looking for.

> After explaining that there
> would always be three settings no matter what, that they could never be
> deleted, and that they represented actual filesystem-level bits that
> wouldn't go away, it was accepted. I didn't notice if this was in the
> docs or not, but I certainly didn't find it.


It would help me to understand your problem if you can point out how you went
about searching for answers. What questions did you frame mentally in your
search? Where and how did you look?

Did you use a hard-copy of the book? Search online in the HTML web pages? Or
did you download the PDF of the book and use the hotlinked pages in the
subject and topic indexes?

> It also meant enabling ACLs
> on all of the filesystems and doing some creative thinking with the
> permissions. The closest I could do was to map all files as owner root,
> group set to Domain Admins, and Everyone set to disallowed; members of
> the IT staff would be mapped with the "admin users" parameter; from
> there, any additional permissions would be mapped via ACLs. We've found
> that this method has the closest behavior to a "real" Windows server and
> has satisfied everyone.


Please write this up in a step-by-step form that can be added to one of the
books.


> - Permissions don't propigate through the filesystem.
>
> On a Real Windows Box(tm) you would be able to set permissions at the
> parent level of a directory and have them show up for each child object.
> Because the filesystem semantics are not the same in *nix-land, you need
> to go into the directly and manually propigate the permissions, or if
> you're stuck trying to administer permissions through a windows session
> (like the other IT staffers in my department), using the Advanced setting
> to force-reset all permissions on all child objects.


You can also add to the smb.conf share definition stanza the following
parameters that are documented in the smb.conf man page:

inherit owner
inherit acls
inherit permissions

Did you consider these? If so, what problems did they cause you?

> This has also
> caused a bit of grousing as we have several nested directories with a
> heiarchy of permissions; getting one parent directory wrong means
> rebuilding permissions for several child directories as well. I have
> never been able to get a satisfactory answer as to how to resolve this
> issue, other than the process I described above (which I had to resolve
> for myself without documentation).


OK - I understand the problem. What did you do to bring about better
documentation? Did you consider contributing some guidance documentation and
then circulation to get positive feedback from other Samba users?

Better documentation is always welcome. Contributions are continually sought.


> - To oplock or not to oplock: that is the question
>
> The documentation is not entirely clear about when you should and
> shouldn't use oplocks on shared files. It would have been much simplier
> (IMHO) to simply say "use your best judgement, BUT if you are using
> shared data files like Access or Excel or DBF's, you will want to disable
> them or you'll have problems!". Yes those words show up on newsgroups,
> but it should also show up in the documentation clearly.


I have not seen a single installation where DBF files and MDB file sharing
works acceptably with more than 3-5 concurrent users. It makes not
difference if the files are served off Windows Server 2003 or off a Samba
server. Oplocks slow things down and have side-effects. What-ever problems
you have with Windows servers will follow you to the Samba server also.

Best advice is do not use file sharing for multiple concurrent access database
files. Instead, use a SQL backend database.


> - Office file locking workaround(s) were not immediately obvious
>
> Buried in the nice (but large) Official Samba Reference and HOWTO is a
> fix for sharing Word and Excel files through Samba, which involves using
> the sticky bit for group permissions. While the fix was adequate and
> works well, it should have been I think a little more prominently
> displayed in the documentation.


Where in the book would you prefer to see this documented? What changes would
you make to the documentation to make this more prominent and more readily
capble of being found?


> - What? You want me to unlock that file?
>
> We have had recurring instances where a workstation on the network has
> seized a DBF file and held onto it, not allowing any other workstation or
> server to perform writes to the file. This locking issue shows up in
> random intervals and always requires that we have the person quit the
> program we are using and log back in. It is not an application issue
> that we can determine - the rest of the system continues to funciton, it
> just prevents one of our servers (or anyone else) from locking the file.


This is a client-side caching issue. Samba does not know that the file has
been released until the client notifies Samba that it has released the file.
Windows clients can go down without ever releasing the file. There are
Microsoft KB articles on how to disable client-side caching. Should this be
more vigorously documented in the HOWTO? If so, where should it be documented
in TOSHARGs?


> - Speaking of which - just WHO does have that file lock?
>
> For some reason, using the computer management tool in a windows
> workstation shows stale information. In our past arrangement, we were
> able to determine who would have the locked file by simply connecting the
> tool to the server, and sorting on the number of locks present; the tool
> would show the data file with a lock count greater than zero. Apparently
> this doesn't fly when connecting to the Samba server - it shows files
> open, but the lock count is for ALL locks (including reads) and not just
> write locks.


What tool are you using to explore this?


> - You sure you still have that file open? It says you don't even have it!
>
> The computer management tool also has an issue with data appearing to be
> stale. Workstations that have been powered down still show a file open.


See comment to previous question about this.

> Or in some cases, the workstation is working with the file, but no file
> handle appears in the tool! This was (and still is) a major issue for
> our staff, and as a result of this they have learned not to trust this
> once-reliable tool, because from their point of view, it lies to them. I
> have had to come up with some work-arounds and while they do work they
> are suboptimal in their eyes.


This sounds like a bug. How can we reproduce this?


> Now, the remaining question(s):
>
> - The vendor initially set up our authentication via tdb files and
> Winbind. We have been using this combination succesfully for some time,
> but in the Official Samba Guide it talks about regular maintenance of the
> tdb files via tdbbackup.


Unless I am sadly mistaken, the TOSHARG docs are correct. You really should
use tdbbackup on a regular basis in every large installation.

> The department head has asked that I find the
> definitive answer on how to do this, as we cannot afford more than a few
> minutes of scheduled downtime. The vendor's response was that tdb files
> should not be used because they can be corrupted when applying tdbbackup
> to them (despite the fact that it was the vendor that set us up to use
> them to begin with - go figure).


The vendor is mistaken. Please ask the vendor to speak with one of the Samba
developers.

> This has caused even more concern -
> millions of dollars in business and 50+ users are supported by this
> server, running 24/7/365. So, if we were to loose our file server
> tomorrow, and had to activate the backup server (which we would do by
> plugging in the eSATA array into the new units and starting up the
> system), how could we guarantee that the GUIDs, etc. would be consistent
> and we wouldn't have a complete mess on our hands? I have seen someone
> else recently mention that they should be using an LDAP authentication
> backend. So who's correct, the vendor's original setup which uses tdb
> files, or the 2nd vendor response which says don't use them, or should we
> be on LDAP authentication connected to our Win2k3 domain controllers?


LDAP is the way to go for IDMAP sharing across domain member servers. The tdb
files really should not be replicated across servers.

> - Is there a way to get the Computer Mangement tool to not "lie" to us
> about the state of file handles and locks? It would be a godsend to not
> have to watch everyone roll their eyes because the "expected" way of
> locating file issues simply doesn't work for them. This is an ongoing
> issue and I can't really provide a satisfactory answer - even SWAT
> appears to have this issue as well!


SWAT is not being actively maintained.

> I have resorted to shell scripting
> to provide us with the answers we need but this is hardly a long-term
> solution. Is there some magic setting I need to flip in the registry for
> our Windows XP clients to make this issue just go away? Is it related to
> protocol changes in the newer versions of the Windows redirectors? Just
> why does this happen?


So far as I am aware Samba fully matches the behavior of Windows server 2003.
Samba can not fix client-sied issues. You need to set your client registry
correctly to stop client-side caching for MDB and DBF files. I do believe
that is documented somewhere in TOSHARG.


> A parting thought as well:
>
> It would have been nice to have had a reasonably generic template or
> example somewhere that pointed this out, instead of wasting an incredible
> amount of time (a month!) reading many many many pages of documentation,
> sometimes scattered into different chapters, as well as contacting the
> vendor twice with over a half-dozen messages. I would think that a
> simple, single smb.conf file named "smb.conf.dom-member.filesserver" with
> a generic looking setup would have resolved many of these issues, by


Where would you search for this information? Which chapter? Which book? How
should it be documented? Are you willing to write this up in a usable form?

> having the appropriate settings and comments already in the file while
> pointing out what parts of the template needed to be changed. Everyone
> that I have talked to outside of my work looks at Samba as a drop-in
> replacement for existing Win2k(3) file servers,


Everyone can be mistaken, fortunately not everone is always mistaken.

> and a template with
> settings that come closest to emulating that same behavior would go a
> long ways towards adoption. I'm not trying to be overly critical, but
> rather, I'm trying to point out a missing part of the software package
> that I think administrators would like to have, especially as more and
> more companies start to operate in mixed environments.


I want to commend you on your email. You comments are due criticism. Your
assistance to close out your concerns is most appreciated.

Cheers,
John T.
--
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/listinfo/samba

Reply With Quote
  #4 (permalink)  
Old 05-22-2008
Chris Osicki
 
Posts: n/a
Default Re: [Samba] Looking for a set of definitive answers (long)

On Wed, 21 May 2008 18:47:52 +0000 (UTC)
Avery Payne <apayne@pcfruit.com> wrote:

> Question:
>
> We recently moved to a Samba-based file server, which holds mission-
> critical data on it (.dbf files used by our Accounting software, etc.)
> The goal was to create a file server that had excellent performance while
> providing Volume Management, but we felt that something like Veritas was
> overkill for our needs.
>
> Design Goals:
> - Redundant Hardware
> - Manual Failover (this was an acceptable solution)
> - Very large storage capacity (minimum 1 Terabyte)
> - Better than 100Mbyte/sec throughput
> - Volume Management, Journaled Filesystem
> - Drop-In Replacement for aging Win2k file server
> - Use existing admin tools to avoid retraining


[snip]

>
> - Permissions don't propigate through the filesystem.
>


With POSIX ACL's they do. Take a look at "default ACL", it defines permissions
newly created files/directories inherits from their parent directory.
I might be misunderstanding your complains, though.
My Windows know-how is limited to an absolute minimum necessary to survive
in the wild world out there ;-)

As for the winbind and tdb files: if you fail over to the standby server you don't have
your SID to UID/GID mappings anymore, unless you copy then somehow over.
The LDAP backend for winbind is a great feature and I would suggest you to take it into
consideration.
I run several Samba instances on few Linux clusters with a SunOne Ldap "cluster" as backend
and it works very well (touching wood ;-)

Thanks and regards,
Chris
--
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/listinfo/samba

Reply With Quote
  #5 (permalink)  
Old 05-22-2008
Avery Payne
 
Posts: n/a
Default [Samba] Re: Looking for a set of definitive answers (long)

On Wed, 21 May 2008 12:33:34 -0700, Jeremy Allison wrote:

> On Wed, May 21, 2008 at 06:47:52PM +0000, Avery Payne wrote:
>> Question:
>>
>> We recently moved to a Samba-based file server, which holds mission-
>> critical data on it (.dbf files used by our Accounting software, etc.)
>> [big snip]


>> But along the way, we encountered some oddities,
>> and I have some remaining questions.
>>
>> First, the oddities (long-time Samba devs and admins, take this with a
>> grain of salt, when I say oddity I mean it from the perspective of an
>> experienced Windows administrator):

>
> Great post, thanks for writing it !
>
> I always appreciate it when users come and tell us about their
> experiences, and where we can improve.
>
> Now onto the specifics:
>
>> - File permissions do not behave as expected (from the viewpoint of
>> other staff working with the server).

>
> Yes, ACLs are just different between UNIX & Windows. We map Windows ACLs
> onto POSIX as best as we can, but the mapping is not perfect. The goal
> is to make the two common cases : "these groups and user fred have
> access", and "these groups but *not* user fred have access" as intuitive
> as possible.
>
> For 3.3 we're planning to overlay a Windows ACL model that will allow
> perfect Windows ACL restrictions to be added to Samba, but not perfect
> Windows ACL allowances (ie. we'll store the Windows ACLs and use them to
> restrict access early on access denied returns, but still map down to
> POSIX to allow the underlying file permissions to take effect).
>
> Hopefully this might help you.


I think it will. :)

>
>> - To oplock or not to oplock: that is the question
>>
>> [snip]

>
> Ok, I believe we are *identical* w.r.t. Windows as far as oplocks go. If
> the vendor says disable oplocks with Windows, disable them with Samba
> also. If not, leave them in place.


I was in a hurry to write all of this (as I am always pressed for time)
but what I was trying to convey is that the documentation could probably
be a bit clearer on this. Yes, I will be happy to contribute some
documentation to this specific issue. :)
>
>> - Office file locking workaround(s) were not immediately obvious
>>
>> Buried in the nice (but large) Official Samba Reference and HOWTO is a
>> fix for sharing Word and Excel files through Samba, which involves
>> using the sticky bit for group permissions. [snip]

>
> Can you point that out to me.


Sure. "The Official Samba-3 HOWTO and Reference Guide", Second Edition,
(c) 2006 John H. Terpstra, printed by Prentice-Hall, Professional
Technical Reference. Turn to page 264, last 4 paragraphs on the page
(including 1 inset caption). Heading is 15.6.3, "MS Word with Samba
Changes Owner of File". The description of what to do provided a
significant fix for us.

> We've done more work on ACL compatibility
> with 3.0.28a and I believe that fix may not now be needed.


The vendor's version is samba-3.0.25b-1.el5_1.4. I can't mention the
vendor but I think you could probably guess it by looking at that version
number. ;)

>> - What? You want me to unlock that file?
>>
>> We have had recurring instances where a workstation on the network has
>> seized a DBF file and held onto it, not allowing any other workstation
>> or server to perform writes to the file. [snip]

>
> Sounds like a bug to me. Not sure where, client app or Samba. Need more
> info on this.


The application is ACCPAC Pro Series 7.2 (now relabeled Sage Pro
Series). It is written in Visual FoxPro 8, and uses VFP DBF, CDX, DBC,
VCX, etc. files, almost all of which are really just mutant dBase tables,
so any record or file locking semantics that apply to DBF files will
apply to those files as well.

I used to see this behavior years ago with Win95 workstations talking
with a Win2k file server. The issue disappeared when we migrated the
workstations to Win2k. It might not be so much a Samba bug as it is an
issue with the settings for the workstation redirectors.

>
>> - Speaking of which - just WHO does have that file lock?
>>
>> For some reason, using the computer management tool in a windows
>> workstation shows stale information. [snip]

>
> This seems like a Samba dificiency with that tool. You should be able to
> get that info by running smbstatus on the Samba box.


There's the rub. The existing staff expect to use the in-place GUI
toolset and have no interest in learning command line tools (including
the department head). Yeah, I know, nothing you can do about that
directly, but indirectly, it might be worth looking into making minor
tweaks to function with the Computer Management snap-in.

You can test this easily by openning several files (Excel, Word, Access,
doesn't matter) at several workstations, start making changes but *don't
save them*...let the workstations and server sit for a bit...then open
the Comp. Mgmt. snap-in, right-click on the top of tree, select "Connect
to another computer...", place the server name in the dialog that appears
and click on [OK]. Navigate to Computer Management -> System Tools ->
Shared Folders -> Open Files. You'll see a list of files that are
"open". Note that after a long period of time - say, a few days - that
the file you openned *doesn't appear in the list* after a refresh (press
F5 to refresh). Nothing wrong with that, as I understand that the client
or server may close the connection - but if you do this same operation on
a "stock" Windows box, the file handle is persisent for as long as you
have the file open and both the server and workstation running. In short
- the file semantics being reported are different between a Samba server
and a Windows server when using this tool. If this is a design decision,
you might want to have a small blurb in the docs someplace about how
those semantics differ, so administrators don't feel like they're going
insane when they can't figure out why a file is still in use but it isn't
reported by the snap-in.

Another way to look at this is to open a shell and compare the output of
lsof against smbstatus - you'll see that, over time, there are occasional
discrepencies between the two as far as what files are open, etc.

Using smbstatus was (unfortunately) not effective for us - it showed
different results from the snap-in I mentioned above, but like the snap-
in, it would have discrepencies between what lsof reports and what it
reports. We would also see "no one has that file open" but when we try
to obtain an exclusive lock on the DBF, it would report that it is in use
by someone (and indeed, it was). The final solution in locating a locked
file was to place this in a shell script named 'find-lock':

lsof | grep 'vp' | grep 'u[wW] '

As crude as it is, it works. The "vp" refers to a fixed pathname that is
unique to our installation, so we can narrow down the number of files to
just those files that may contain DBF data. The grep looks for write
locks, either at a table (file) level or a record level. It has been
100% accurate in the 8 times that we have had to use it.

>
>> - You sure you still have that file open? It says you don't even have
>> it!
>>
>> The computer management tool also has an issue with data appearing to
>> be stale. [snip]

>
> Same as above. smbstatus should give you this info.


Addressed above.

>
>> Now, the remaining question(s):
>>
>> - The vendor initially set up our authentication via tdb files and
>> Winbind. [snip]
>> So who's correct, the
>> vendor's original setup which uses tdb files, or the 2nd vendor
>> response which says don't use them, or should we be on LDAP
>> authentication connected to our Win2k3 domain controllers?

>
> It is safe to use tdbbackup on a live system. The vendor is mistaken.


THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU....

That single reply was worth its weight in gold. I can now sleep a little
better at night.

>> - Is there a way to get the Computer Mangement tool to not "lie" to us
>> about the state of file handles and locks? [snip]

>
> Needs more work in Samba on supporting the Computer management tool.
> Currently smbstatus works better for this.


Also addressed above.

>
>> A parting thought as well:
>>
>> It would have been nice to have had a reasonably generic template or
>> example somewhere that pointed this out... [snipped long frustration]

>
> Yep, this is true. We depend on the Linux vendors to do this as we don't
> have the resources (or more accurately haven't spent the resources we
> have) on doing this. Sometimes they do a good job, sometimes not. This
> is why server appliance vendors often are a better choice than a full
> blown Linux solution, as they sell a pre-set up solution.


Long story short, it wasn't on the radar due to other issues - but I'll
keep that in mind. :)

>
> Thanks for your thoughts !


Thanks for the reply!

--
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/listinfo/samba

Reply With Quote
  #6 (permalink)  
Old 05-22-2008
Avery Payne
 
Posts: n/a
Default [Samba] Re: Looking for a set of definitive answers (long)

On Wed, 21 May 2008 15:31:48 -0500, John H Terpstra wrote:

> Avery,
>
> OK - I'll respond too. I see Jeremy has beaten me to it.
>
> Let me tell you up front, if you want the documentation to be improved
> the best thing you can do is contribute changes and updates. Making us
> aware of docuentation problems is a good start, but please take this a
> step further - send us your updates and changes.


More than happy to as soon as I can find the time. :)
'
>
> One other thing, before I get too far into answer or commenting is this:
> The Official Samba3 HOWTO and Reference Guide (TOSHARG) is a document
> (book) that sets out how specific parts of Samba function. It was never
> intended to provide a working template or a scripted recipe.


Understood. I am using it as a tech reference.

> I did write the Samba3-ByExample book with the specific objective to
> provide detailed step-by-step, fully worked, examples of real working
> networks, did you consult that document at any time?


I didn't even know it existed. The majority of web queries resulted in
the online version of TOSHARG being displayed. Thanks for pointing that
out, I'll look for it.

> Are you offering to improve its value and utility by contributing your
> experiences and recommendations?


Yes, as time permits.

>
> On Wednesday 21 May 2008 01:47:52 pm Avery Payne wrote:
>> Question:
>>
>> The goal was to create a file server that had excellent performance
>> while providing Volume Management, but we felt that something like
>> Veritas was overkill for our needs.

>
> A noble goal that can be achieved.


I think we're 99.9% there, it's that 0.1% that's holding up the works.
Overall, everyone is pleased.

> [lots 'o stuff snipped]
>> The proposed solution was a Samba file server running on a pair of
>> redundant servers, with one connected to an eSATA raid box, with LVM
>> and Ext3 providing volume management and journaling.

>
> I would not architect the solution this way. There are way too many
> pitfals with this solution. You have identified one already - the SID
> <=> UID/GID mapping challenge.


The solution is that there are nightly backups of all the tdb's to a
known LVM volume. The idea is that in the even of manual failover, the
volume would be mounted, the tdb's copied into place, some minor settings
changed, and the service started.

Originally I was aiming for a "clustered" approach but it appears that
the software (both the OS and Samba) were not ready for this - yet Samba
4 may still surprise me. :)

>
> I would have used a RAID5 array in each server with rsync to synchronize
> from the master to the slave.


There is no master-slave, the other machine is a cold-standby solution.
The RAID 10 array contains 16 drives on a eSATA box that has redundant
power, redundant connects, etc. A manual failover was chosen by
mangement due to cost and software constraints. The downtime involved
was deemed acceptable - 5 to 10 minutes. Downtime exceeding 15 minutes
however would start creeping costs into the red.

>
>> Our transition was a
>> bit rough, but in the end it has been very stable and fast. We have
>> been really pleased with the performance of the hardware/software
>> combo, seeing sustained throughput of about 250Mbyte/sec with peaks as
>> high as 300Mbyte/sec. But along the way, we encountered some oddities,
>> and I have some remaining questions.

>
> What lab work did you do in a test environment before rolling this life?
> Proper pre-rollout evaluation can save a lot of head-banging later.


3 months. This is an epic story for another time. :)

>
>> - File permissions do not behave as expected (from the viewpoint of
>> other staff working with the server).
>>
>> [snip]

>
> Samba is an engine that sits on top of a host OS. That host OS is NOT
> Windows. Samba has to go along with the rules imposed by the host OS.
> The TOSHARG chapter on "File, Directory, and Share Access Controls"
> should be the red flag that underlying file system semantics are exerted
> by Samba. Windows admins need to be trained to understand that Samba is
> not Windows NT/2Kx, etc.


Point appreciated. As a Linux admin (since '98) and a Windows NT admin
(since '97), I can appreciate the semantical differences between the two,
and the efforts involved by the Samba devs to make things "work". I did
read those sections (repeatedly). Sometimes it's easy to miss things
when the world is at your door screaming for blood - especially when it's
your blood.

As for the admin training side, my co-worker is an MCSE coming from 20
years of VAX/PDP experience, and the department head (my direct boss) is
an OS X fan who uses 10.5 on a daily basis. Which makes for interesting
conversations between us all. :)

>
> Jeremy's notes about the VFS modular work aimed at providing better
> Windows ACLs emulation may provide the solution you are looking for.


I have read about some of the VFS features and will be using the audit
feature in the near future. However, some of what I face may be a
versioning issue due to the vendor (or not).

>
>> After explaining that there
>> would always be three settings no matter what, that they could never be
>> deleted, and that they represented actual filesystem-level bits that
>> wouldn't go away, it was accepted. I didn't notice if this was in the
>> docs or not, but I certainly didn't find it.

>
> It would help me to understand your problem if you can point out how you
> went about searching for answers. What questions did you frame mentally
> in your search?


Q: Why can't I delete these entries inside of the directory/file property
pane? They keep reappearing no matter what I do. (the question phrased
as given to me by both my coworker and my boss)

The issue is that the frame of reference - "this is how we set file
permissions and this is the expected behavior of the vendor-provided GUI
tool" - is somewhat different from the material that is being presented.
I have had to do alot of verbal footwork in translating things. Perhaps
I can help here with some new material...

> Where and how did you look?


"The Official Samba-3 HOWTO and Reference Guide", Second Edition,
(c) 2006 John H. Terpstra, printed by Prentice-Hall, Professional
Technical Reference.

The quickest solution to the issue was found with deductive reasoning
coupled with emprical experimentation. Good old-fashioned 'sit down and
work it out'. :)

> Did you use a hard-copy of the book?


Yes. See above book reference.

> Search online in the HTML web
> pages?


Yes, both through site searches at samba.org and through google.
Unfortunately, they ended up being web versions of the book.

> Or did you download the PDF of the book and use the hotlinked
> pages in the subject and topic indexes?


Yes.

>
>> [snip]
>> We've found that this method has the closest behavior to a
>> "real" Windows server and has satisfied everyone.

>
> Please write this up in a step-by-step form that can be added to one of
> the books.


More than happy to, as time permits. :)

>
>
>> - Permissions don't propigate through the filesystem.
>>
>> [dumb issue that I could have avoided snipped]

>
> You can also add to the smb.conf share definition stanza the following
> parameters that are documented in the smb.conf man page:
>
> inherit owner
> inherit acls
> inherit permissions


Thanks! The reason they were not used initially is that the initial
permissions model didn't account for that (because I didn't know the
settings were there), and on top of that, it changed during the
transition. Some of the filesystem is using the original model - where
domain groups are mapped to a GID on the linux box and the directory/
files are then updated with that GID - while other directories are
following the ACL approach. Throw in some complete confusion by the
vendor's muddled guidence, and it gets messy. As I have time permitting,
the entire filesystem will be migrated to the ACL approach.

>
> Did you consider these?


No (see above). It will be rememdied. Lesson: when in doubt, stick with
your gut, because the vendor usually doesn't get it right on the first
try.

> If so, what problems did they cause you?


N/A (see above)

>
>> This has also
>> caused a bit of grousing as we have several nested directories with a
>> heiarchy of permissions; getting one parent directory wrong means
>> rebuilding permissions for several child directories as well. I have
>> never been able to get a satisfactory answer as to how to resolve this
>> issue, other than the process I described above (which I had to resolve
>> for myself without documentation).

>
> OK - I understand the problem. What did you do to bring about better
> documentation?


I repeatedly hit myself on the head with a baseball bat. Just kidding.

The documentation was created in-house at my employer's expense. I will
attempt to re-write the docs I created on my own time and provide them to
you later.

> Did you consider contributing some guidance
> documentation and then circulation to get positive feedback from other
> Samba users?


Yes, but the time factor involved was prohibitive. Hard to do the right
thing when you're holding off end-users with a pointy stick. See my
other post to Jeremy re: users screaming for blood. That, and it's hard
to think straight after working a 38 hour shift with no sleep, no food,
no breaks, and no rest.

>
> Better documentation is always welcome. Contributions are continually
> sought.


More on that later. I have some ideas that I think would be worthwhile,
and I'm willing to type them up.

>> - To oplock or not to oplock: that is the question
>>
>> The documentation is not entirely clear about when you should and
>> shouldn't use oplocks on shared files. [frustrations snipped]

>
> I have not seen a single installation where DBF files and MDB file
> sharing works acceptably with more than 3-5 concurrent users.


In our prior version of the software we had 50 workstations, of which
half were concurrently active, updating/reading DBF files every day.
Locking is kept to a minimum, which contributes to a very low latency.
The general "gut feel" we have here is that the limit of our system is
probably around 50 concurrent users; on busier days with more than 30
workstations active, the system started to visibly slow, although
performance degraded gracefully. The setup (at the time) was a Win2k
Server with 50 Win2k Workstations on switched 100BaseT, with gigabit
going into the server.

>
> Best advice is do not use file sharing for multiple concurrent access
> database files. Instead, use a SQL backend database.


The ERP package in use allows us to do so for a very prohibitive price.
It would actually be cheaper to employ me for an entire year to develop
an object wrapper to intercept all calls to the DB API and send them to a
PostgreSQL or MySQL backend, working full time on this project and doing
none of my other duties (networking, sysadmin, security, email services,
data warehouse, end-user support, customization of the accounting
package, etc.), while struggling to emulate all of the features with only
the API interface as a document to guide me (there is no source
available). Of course, that isn't going to happen. :(

>
>
>> - Office file locking workaround(s) were not immediately obvious
>>
>> [snip]

>
> Where in the book would you prefer to see this documented? What changes
> would you make to the documentation to make this more prominent and more
> readily capble of being found?


The largest issue encountered revolved around locking semantics and how
the system would behave. This I will fully address later when I write up
my docs and send them to you.

>> - What? You want me to unlock that file?
>>
>> We have had recurring instances where a workstation on the network has
>> seized a DBF file and held onto it, not allowing any other workstation
>> or server to perform writes to the file. This locking issue shows up
>> in random intervals and always requires that we have the person quit
>> the program we are using and log back in. It is not an application
>> issue that we can determine - the rest of the system continues to
>> funciton, it just prevents one of our servers (or anyone else) from
>> locking the file.

>
> This is a client-side caching issue. Samba does not know that the file
> has been released until the client notifies Samba that it has released
> the file. Windows clients can go down without ever releasing the file.
> There are Microsoft KB articles on how to disable client-side caching.
> Should this be more vigorously documented in the HOWTO?


Yes, although I would prefer the term "slightly expanded article". :)

> If so, where should it be documented in TOSHARGs?


The viewpoint comes from a small-to-medium sized LAN installation, using
shared-file databases (dBase, FoxPro, Paradox, Access). This may not be
very common in larger installations, but I can attest (from personal
experience) that it is frequently used in smaller setups.

I think the real issue is that there is a juncture between file locking
and file permissions that are critical to having those environments work
correctly. A small paragraph about shared-file databases would probably
go a long ways towards providing clarity to the implementor as to how
things will work, etc. Again, I'll try to get something to you later.

>> - Speaking of which - just WHO does have that file lock?
>>
>> [snip]

>
> What tool are you using to explore this?


Computer Management Snap-In.

>
>
>> - You sure you still have that file open? It says you don't even have
>> it!
>>
>> The computer management tool also has an issue with data appearing to
>> be stale. Workstations that have been powered down still show a file
>> open.

>
> See comment to previous question about this.
>
>> Or in some cases, the workstation is working with the file, but no file
>> handle appears in the tool! [snip]

>
> This sounds like a bug. How can we reproduce this?


See my posting to Jeremy on this. I'll try to develop a specific test,
but the description I gave is the best I can do for now until I can
catagorize the bug further.

>
>
>> Now, the remaining question(s):
>>
>> - The vendor initially set up our authentication via tdb files and
>> Winbind. We have been using this combination succesfully for some
>> time, but in the Official Samba Guide it talks about regular
>> maintenance of the tdb files via tdbbackup.

>
> Unless I am sadly mistaken, the TOSHARG docs are correct. You really
> should use tdbbackup on a regular basis in every large installation.


Jeremy has confirmed this. Thanks for the 2nd confirmation. :) And I am
backing up all tdb's daily to an LVM volume on the RAID array, so when
the 2nd system goes live, I can simply restore them with tdbbackup.



>
>> [snip]

> You need to set your client
> registry correctly to stop client-side caching for MDB and DBF files. I
> do believe that is documented somewhere in TOSHARG.


I am using both global and share-level "veto oplocks" settings, with a
very detailed match string. :)

>
>
>> A parting thought as well:
>>
>> It would have been nice to have had a reasonably generic template or
>> example somewhere that pointed this out [snip]

>
> Where would you search for this information? Which chapter? Which book?
> How should it be documented? Are you willing to write this up in a
> usable form?


1) it should be part of a section on implementing replacement file
services for Win2k(3) boxen.
2) undetermined. I will have to look at that. I am already almost over
my time limits on this reply today (forgoing lunch to reply).
3) again, undetermined.
4) Yes.


> Everyone can be mistaken, fortunately not everone is always mistaken.


:(

Part of my job is to pull magic rabbits out of the hat. I fear the day
when I reach in the hat and come up empty-handed.


--
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/listinfo/samba

Reply With Quote
  #7 (permalink)  
Old 05-22-2008
Avery Payne
 
Posts: n/a
Default [Samba] Re: Looking for a set of definitive answers (long)

On Thu, 22 May 2008 10:59:08 +0200, Chris Osicki wrote:

> On Wed, 21 May 2008 18:47:52 +0000 (UTC) Avery Payne
> <apayne@pcfruit.com> wrote:
>
>> Question:
>>
>> We recently moved to a Samba-based file server, which holds mission-
>> critical data on it (.dbf files used by our Accounting software, etc.)
>> The goal was to create a file server that had excellent performance
>> while providing Volume Management, but we felt that something like
>> Veritas was overkill for our needs.
>>
>> Design Goals:
>> - Redundant Hardware
>> - Manual Failover (this was an acceptable solution)

> [snip]


> As for the winbind and tdb files: if you fail over to the standby server
> you don't have your SID to UID/GID mappings anymore, unless you copy
> then somehow over.

They "float on a liferaft" that is an LVM partition. The tdb's are
backed up nightly and placed in the partition. Should the server fail,
the tdb's are restored and the smb.conf modified...


--
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/listinfo/samba

Reply With Quote
  #8 (permalink)  
Old 05-22-2008
John H Terpstra
 
Posts: n/a
Default Re: [Samba] Re: Looking for a set of definitive answers (long)

On Thursday 22 May 2008 02:48:14 pm Avery Payne wrote:
> On Wed, 21 May 2008 15:31:48 -0500, John H Terpstra wrote:
> > Avery,
> >
> > OK - I'll respond too. I see Jeremy has beaten me to it.
> >
> > Let me tell you up front, if you want the documentation to be improved
> > the best thing you can do is contribute changes and updates. Making us
> > aware of docuentation problems is a good start, but please take this a
> > step further - send us your updates and changes.

>
> More than happy to as soon as I can find the time. :)


Good. Thanks.

>
> > One other thing, before I get too far into answer or commenting is this:
> > The Official Samba3 HOWTO and Reference Guide (TOSHARG) is a document
> > (book) that sets out how specific parts of Samba function. It was never
> > intended to provide a working template or a scripted recipe.

>
> Understood. I am using it as a tech reference.


Good.

> > I did write the Samba3-ByExample book with the specific objective to
> > provide detailed step-by-step, fully worked, examples of real working
> > networks, did you consult that document at any time?

>
> I didn't even know it existed. The majority of web queries resulted in
> the online version of TOSHARG being displayed. Thanks for pointing that
> out, I'll look for it.


Please check it out and let me know what is missing. Also, since you did not
know it exists, what should we do to make it more prominent? Is it worth
making it more prominent?

You can download it from:
http://www.samba.org/samba/docs/Samba3-ByExample.pdf

> > Are you offering to improve its value and utility by contributing your
> > experiences and recommendations?

>
> Yes, as time permits.


Great. This sort of contribution is necessary.

> ...
> More on that later. I have some ideas that I think would be worthwhile,
> and I'm willing to type them up.
>
> >> - To oplock or not to oplock: that is the question
> >>
> >> The documentation is not entirely clear about when you should and
> >> shouldn't use oplocks on shared files. [frustrations snipped]

> >
> > I have not seen a single installation where DBF files and MDB file
> > sharing works acceptably with more than 3-5 concurrent users.

>
> In our prior version of the software we had 50 workstations, of which
> half were concurrently active, updating/reading DBF files every day.
> Locking is kept to a minimum, which contributes to a very low latency.
> The general "gut feel" we have here is that the limit of our system is
> probably around 50 concurrent users; on busier days with more than 30
> workstations active, the system started to visibly slow, although
> performance degraded gracefully. The setup (at the time) was a Win2k
> Server with 50 Win2k Workstations on switched 100BaseT, with gigabit
> going into the server.


DBF files are a special case. While the client can cache any file, DBF's have
an internal locking method. A DBF application will set a record lock flag and
is responsible for resetting it on completion of write. If the client does
not flush its cache this info can get lost with the result that the record
remains locked. There are some apps that will scan the DBF file for stale
locks and reset them. Corruption of DBFs is usually not as big a problem as
with MDB files.

> > Best advice is do not use file sharing for multiple concurrent access
> > database