At 02:38 PM 23/06/2005 +0000, you wrote:

>Hi,
>
>I've just installed a fresh Mandrake, and I am trying to setup a
>firebird on it.
>
>The installation went smoothly, and I can see it starting on launch.
>I've added my user to the firebird group.
>
>and succesfully created a database using isql.
>./isql
> >> create database 'mandrake:/var/firebird/test.fdb';
>
>however when I try to connect with similiar syntax
>./isql
> >> connect 'mandrake:/var/firebird/test.fdb' user 'sysdba' password
>'masterkey';
>
>I am receivign error:
>Statement failed, SQLCODE = -902
>
>Your user name and password are not defined. Ask your database
>administrator to set up a Firebird login.
>
>the same error appear when I try to connect this database with
>flamerobin. or try to do anything with a sysdba user.
>
>can someone hint me what went wrong?

The installed sysdba password on Linux is not 'masterkey'. The password is
randomly generated. To find the password:

cat /opt/firebird/SYSDBA.password

To change it, use gsec (if you know how) otherwise go to /opt/firebird/bin
and run this script:

]$ ./changeDBAPassword.sh

FYI, the same question was asked yesterday. This is not "secret knowledge"
- it is all there in the 1.5 release notes. If you installed SS on Mandrake
10 or higher, also take the time to search the release notes for 'NPTL', as
that will likely be the source of your next problem.

./heLen