At 08:31 PM 18/02/2009, you wrote:

>Hi.
>
>I'm really new to Firebird.
>
>Situation: customer used some IS based on firebird and he wants to
>migrate to our IS based on another DB. He provided us the datafile
>something.fdb, so we can read old data from it.
>
>Problem: I've downloaded and installed FirebirdCS-2.1.1.17910-0.i686
>on Linux. The installation script asked me for SYSDBA password. When I
>try to connect to this datafile via iSQL (./isql and then connect
>/full/path.fdb;) it returns:
>Statement failed, SQLCODE = -902
>Your login SYSDBA is same as one of the SQL role name. Ask your
>database administrator to set up a valid Firebird login.
>
>I've found, that this is some kind of security feature - there is a
>role called sysdba, which isn't allowed to connect. The work-around
>should be to drop this role.

On Linux, you should be able to open the database with isql while logged into the server as root, with no user name and password. Then you can DROP ROLE SYSDBA.

>Question: (finally) Althrough i've found that I should drop this role
>to be able to connect and read data from FDB, I've never found how to
>do this.

Well, then, if you're not normally operating as root on the server, you can log in as SYSDBA (once you have dropped the role).

./hb