Subject Re: [IBPP-DISCUSS] [firebird-support] FB Embedded on Linux without need for root account
Author Milan Babuskov
Helen Borrie wrote:
>>>http://sotu.berlios.de/Firebird-Embedded-Linux-HOWTO.html
>
> Nice paper Milan....are you aware of the Firebird documentation project?

Yes. However, at this time I'm not really ready to learn DocBook or
whatever is used.

> I have taken the html from your site and plonked it provisionally
> into the "papers" section of my local copy of the "manual" section of
> the CVS tree. It needs a little work to get it into Docbook format,
> which I'm willing to do if you can't do it yourself...

Thanks.

> I wonder whether you (and Milan) know that you can set up the Linux
> user in the Firebird security database so that, if the Linux user is
> already logged in, it won't have to endure separate authentication
> when connecting to Firebird?

I am aware, but it is not really applicable to IBPP side of story as it
requires username anyway. Besides, it still leaves us in need of
security.fdb file, and it complicates setup: My intention was to provide
the simplest and shortest possible way to accomplish the goal.

There is also problem when deploying application, as the Linux username
running on target computer would probably not be the same as on
development machine (I haven't tested if this matters, but I think it does).

In fact, in first versions I had added bin/gsec to the list of needed
files, and wrote how to setup account, but later I removed it in order
to simplify things as much as possible.

> Milan, this would be worth adding to
> your paper, with perhaps some reference to SQL privileges and Roles...

Perhaps, in some future version, I'll add an "Advanced" section
discussing users, explanation of fb_lock_mgr, things to watch when full
server is installed on the computer, etc.

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org