[osiris] Re: why would 'purge database' not be working?

[Dave Vasil]

Gregor Mosheh wrote:
>> Gregor Mosheh wrote:
>>> Hi, all. I've been running this Orisis system for a month, and have
>>> noticed that old databases are not being purged.
> 
> Dave Vasil wrote:
>> This sounds like a permissions issue, or possibly a behavior of SELinux.
>>  Make sure the osiris user is able to remove the databases from the
>> command line by 'su - <osiris user>' and then trying to manually remove
>> the database.
> 
> First off, thanks you for the quick reply. I posted this around 3am my
> time, and wokr up the next morning to find the answer. That was
> unexpected!
> 
> I did check the permissions, and it is the case that the files are owned
> by root and mode 0600. So I think my real question now is: which process
> deletes the db files as part of the purge, and which process deletes the
> db files when I call rm-db from the osiris command line? Are those
> processes not running as root? Is there a setuid() call somewhere that's
> dropping privileges?

The process that deletes the databases is the osirismd process that is
spawned to handle the CLI connection.  This process will be owned by the
osiris user that was defined at install time.

Is it possible that someone may have chown'd the osiris data directory
to root?  Or possibly you first installed osiris to run as the root user
and then later installed it to run as a user with lower permissions?

In any case, the way to fix this would be to 'chown -R <osiris
user>:<osiris group> /osiris/data/directory'

-dave