You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@subversion.apache.org by Joerg Hessdoerfer <Jo...@sea-gmbh.com> on 2006/06/19 17:16:46 UTC

Re: User File Access from Mysql DB... (correction)

Memory didn't serve - 
> (or newer svnserve, 1.3.X if memory serves?)

it's 1.4, which is not yet released. I use apache ;-)

Greetings,
	Jörg
-- 
Leiter Softwareentwicklung - S.E.A GmbH
Mail: joerg.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

Re: User File Access from Mysql DB... (correction)

Posted by Joerg Hessdoerfer <Jo...@sea-gmbh.com>.
Hi,

On Monday 19 June 2006 19:30, bruce wrote:
> hi joerg...
>
> do you write to the ACL db/file everytime a user changes their access
> requirements regarding a given file... do you also write to the ACL db/file
> everytime a file moves from folder to folder...
>
> for my app, the file moves between processes, and since a user might have
> access to one process and not another.. i need to solve this.
>
> the only way i can see is to add/delete the users within the ACL file as
> the "file" moves along the process, which is going to require a lot of
> update hits to the ACL by my app..
>
> another approach would be to simply rewrite a new ACL file from a db on
> every file/process change...
>
> -bruce
[...]

yep, that's what we do - re-write it on every databse change. But we only do 
have user's access rights changes, and we don't track individual file 
locations, as they usually don't move.

Re-writing the ACL is really fast in our case - and can probably be done from 
a cron job every couple of minutes. Just create some trigger file when the DB 
changes, an re-generate from cron if the file exits.

Greetings,
	Jörg
-- 
Leiter Softwareentwicklung - S.E.A GmbH
Mail: joerg.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

RE: User File Access from Mysql DB... (correction)

Posted by bruce <be...@earthlink.net>.
hi joerg...

do you write to the ACL db/file everytime a user changes their access
requirements regarding a given file... do you also write to the ACL db/file
everytime a file moves from folder to folder...

for my app, the file moves between processes, and since a user might have
access to one process and not another.. i need to solve this.

the only way i can see is to add/delete the users within the ACL file as the
"file" moves along the process, which is going to require a lot of update
hits to the ACL by my app..

another approach would be to simply rewrite a new ACL file from a db on
every file/process change...

-bruce


-----Original Message-----
From: Joerg Hessdoerfer [mailto:Joerg.Hessdoerfer@sea-gmbh.com]
Sent: Monday, June 19, 2006 10:17 AM
To: users@subversion.tigris.org; bedouglas@earthlink.net
Subject: Re: User File Access from Mysql DB... (correction)


Memory didn't serve -
> (or newer svnserve, 1.3.X if memory serves?)

it's 1.4, which is not yet released. I use apache ;-)

Greetings,
	Jörg
--
Leiter Softwareentwicklung - S.E.A GmbH
Mail: joerg.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org