This is my first crack at Linux and Pervasive on Linux. I am having a
problem with network rights and PSQL errors 46 and 94. When you
install PSQL V8.5 on the Linux Box. It creates a PSQL login to start
the service with and a PVSW group. In order to access PSQL data files,
if you make the folder and files owner PSQL and the PVSW group, then
all is well. No errors, even if you make new PSQL files, they inherit
the correct rights. However, our software allows us to create
multiple databases with one database per folder, and when it creates a
new folder under its root folder, it assigns your network login as the
owner of the folder and the same to all files underneath. This is
regardless of the fact that the Parent folder is set to PSQL and PVSW
with the Sticky attribute. I would have expected any new sub folders
to inherit the rights from its parent like Windows. If you create a
folder manually in explorer from the workstation, it also does the
same thing. Does Linux not do this, or have I set it up wrong somehow.
Its a brand new Linux box and a new PC running Windows XP Pro using
Samba as its share.

Thanks
Rowland G J Costin
Technical Support Manager
Selven Group plc

The Pervasive engiine creates new files with the systems default 644
attribute, which appears to be fine. If a user creates a new file or
folder that is to be accessed by Pervasive you'll have to make sure
the Pervasive engine has access. To achieve this you have several
options:
- make user psql a member of each of the samba users groups
- set create mask to 0666 and directory mask to 0777 (iiiekkk)
- set force group to pvsw
Obviously whatever a user creates has to be at least group-writable,
either to pvsw or whatever group psql has been made an additional
member of.



On 10 Dec 2003 04:04:34 -0800, tech (AT) selven (DOT) co.uk (Rowland Costin)
wrote:


Gordon Bos
Q-RY Solutions
+31-(0)15-2564035

http://www.q-ry.nl/

From what you describe:
Files created through the database engine are correct.
Files copied via the OS are not.

My guess is that the software does a file copy to create a new empty
data set. (There is no create directory call.)

Samba controls files copied from the client including who they are
created as. It might just be easy enough to set the "force user" and
or "force group" options in the smb.conf file. The Pervasive install
should have put in a sample share that you can copy these settings out
of.

Leonard

On Fri, 12 Dec 2003 21:21:38 +0100, Gordon
<grafzerk (AT) bigfoot (DOT) no.spam.please.com> wrote: