Subject Re: [firebird-support] Re: User Security for multiple servers
Author David Johnson
Are there plans to add LDAP support in FB2 or Vulcan?

On Fri, 2005-06-10 at 07:58 -0400, Steve Wiser wrote:
> Hi Mick,
>
> We are lucky enough to have a fairly stable backup window when the
> gdbs are put into shutdown which is when we rsync them over a T1 to the
> backup site. There definitely are days when the gdbs still sometimes in
> use and do result in a bad rsync copy which is something we are still
> working on...
> I was hoping that it would be magically possible to nfs mount a shared
> location on 1 server to host the isc4.gdb and point all of the other
> servers to it, but that definitely doesn't work as the lock managers
> seem to step on each other... Our UserManager app already posts each
> request into all of the dbs, but we sometimes run into problems were it
> didn't post properly in 1, but did in the other 22, so do we commit the
> rest? I guess I will keep on working on a solution for this. Just
> wanted to know how other Interbase/Firebird users handle this
> synchronization task.
>
> -steve
>
> On Fri, 2005-06-10 at 03:44 +0000, mikcaau wrote:
>
> > Steve,
> > I think (am sure) that you'll have problems with rsync.
> > rsync on databases will (almost) always catch the database in an
> > unstable state, some parts of a transaction will have been posted and
> > other parts will be yet to be posted. This is a recipe for disaster.
> > GBak works, GBak + zip or tar makes a small backup.
> >
> > To keep all your passwords in sync,
> > All I can suggest is that your usermanager be an additional
> > application that receives manage user activities and posts them onto
> > each of your servers.
> > Perhaps it would be possible to establish events on isc4.gdb and
> > intercept these events with a script that send the information to your
> > other servers - but I think you'd find that the password is already
> > encrypted.
> >
> > The first solution lokks easier.
> >
> > Mick
> >
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>