Subject Re: [firebird-support] 2 copies of fb_lock_mgr
Author Nick Upson
2008/8/8 Milan Babuskov milanb@...

>
> When you access Classic via xinetd or inted, it always spawns a single
> fb_lock_mgr since system username is 'hardcoded' in (x)inetd config file.
>
> So, if I run:
>
> $ bin/isql localhost:/path/whetever.fdb -user fbuser -pass ****
>
> or as root:
>
> # bin/isql localhost:/path/whetever.fdb -user fbuser -pass ****
>
> I will end up with a single fb_lock_mgr.
>
> However, if you try to access the database file directly (i.e. no
> hostname in the path):
>
> $ bin/isql /path/whetever.fdb
>
> Another fb_lock_mgr might get spawned (depends on the account you are
> using). This second form of attaching to database can work without
> Firebird username and password if you have enough privileges on the
> database file itself as a user.
>
> The sequence of events I had was, I think,

gbak as root using localhost in filepath
rename database filename
connect from several C programs as user1, using localhost in filepath,
programs remain connected
connect from C program & isql as root, may have been using localhost in
filepath, do not remain connected
later I spot 2 copies of lock mgr running

would you expect this to do it?


[Non-text portions of this message have been removed]