From owner-freebsd-database@FreeBSD.ORG  Tue Dec  6 04:36:59 2005
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id BE71C16A41F
	for <freebsd-database@freebsd.org>;
	Tue,  6 Dec 2005 04:36:59 +0000 (GMT)
	(envelope-from janm@transactionware.com)
Received: from mail.transactionware.com (mail.transactionware.com
	[203.14.245.7]) by mx1.FreeBSD.org (Postfix) with SMTP id 7CB6943D5D
	for <freebsd-database@freebsd.org>;
	Tue,  6 Dec 2005 04:36:57 +0000 (GMT)
	(envelope-from janm@transactionware.com)
Received: (qmail 71215 invoked from network); 6 Dec 2005 04:37:14 -0000
Received: from new.transactionware.com (192.168.1.55)
	by dm.transactionware.com with SMTP; 6 Dec 2005 04:37:14 -0000
Received: (qmail 72483 invoked by uid 1026); 6 Dec 2005 04:37:14 -0000
Received: from 192.168.1.32 by new.transactionware.com (envelope-from
	<janm@transactionware.com>, uid 1003) with qmail-scanner-1.25 
	(spamassassin: 3.0.2.  Clear:RC:1(192.168.1.32):. 
	Processed in 2.644378 secs); 06 Dec 2005 04:37:14 -0000
Received: from janm.transactionware.com (HELO ?192.168.1.32?) (192.168.1.32)
	by new.transactionware.com with SMTP; 6 Dec 2005 04:37:10 -0000
Message-ID: <439515AC.6010801@transactionware.com>
Date: Tue, 06 Dec 2005 15:38:04 +1100
From: Jan Mikkelsen <janm@transactionware.com>
User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050822)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Julesg <julesg@shilohyrc.com>
References: <fa33f4d3f535840db5ca7620426d327a@shilohyrc.com>
In-Reply-To: <fa33f4d3f535840db5ca7620426d327a@shilohyrc.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-database@freebsd.org
Subject: Re: a problem with the btree facility in FreeBSD
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 06 Dec 2005 04:36:59 -0000

Julesg wrote:
> During processing the permissions line on the file is all ZERO's (a horizontal line of dashes) and is unchanged after the file is closed (we do a DB-close, not our own close, nor do we simply exit the application.)
> 
> But the permissions don't change, and we can't (in a subsequent application,) running another job, open the DB and either read or write the existing DB file.

It sounds like you are doing something like "open(fspec, flags, 0)".

You probably want to do something like "open(fspec, flags, 0600)".

See open(2) and chmod(2).

Regards,

Jan Mikkelsen
Transactionware