Subject Re: [firebird-support] Evaluating FB 1.5 questions
Author Dimitry Sibiryakov
On 16 Jun 2004 at 14:32, rfsoft wrote:

>I'm just evaluating FB 1.5 and FIBPlus for an upcoming product I must
>develop. Now I see three very serious problem with this combination,
>which makes it unusable if it isn't solvable. Here they are:

I'd say that problems are in your application architecture...

>1. FB uses a central user security database. I think I will get much
>of problems if my application gets installed on a system where FB
>already is installed and configured for anyone elses applications.
>That meens it has overriden the SYSDBA password and as such my
>application will not be able to add or modify any user rights for my
>aplications need.

[with a gesture in Jedi-style]

Your application must not use SYSDBA account. This accout for local
DBA only. If your application needs perform some DBA work, ask the
real DBA for his/her password. Or ask DBA to do the work.

> My application should be a "null" configuration
>solution, where the users don't should do anything on the DB server
>configuration. They are normal "idiotic" users who have no idea of DB
>servers. How is this problem handled by others of you?

Every application which requires DBMS server, requires DBA. Point.
If customer organization don't have permanent administrator, there
must be a visiting one.
If you make "null" configuration application for idiots, only
idiots will be able to use it. If an application conflicts with an
administrator, guess what will happened? Probably, they fire
administrator, but I'd bet the admin'll uninstall the application.

>2. For security reasons I want to install the FB server on a
>diffrent port than the standard 3050.

Forget it. Idiotic users and security are incompatible.

> Does someone know how I can setup a second FB instance which runs
>on a different port, if on the target system already a FB server is
>installed? With 1.5 it should somehow be possible to run two
>instances of FB but I didn't find anything about how this can be
>done exactly.

If you can't read release notes, nothing and nobody can help you.
Guy, there is a lot of interesting things in this life. And many
suitable occupations. Why you chose programming?..

>3. Does FB 1.5 have any problems with an already installed Interbase
>Server? So is it installable on such a system at all?

No problems. It is installable and installation process is
described in release notes.

SY, Dimitry Sibiryakov.