At 03:07 AM 2/02/2006, you wrote:

>I got this problems.. since last 3 weeks... so i came here to find
>helps...
>
>root@itdkel:/home/amir# /usr/lib/firebird2/bin/isql
>61.49.24.54:/opt/data/tiket/hputra.gdb -u SYSDBA -p masterkey
>Statement failed, SQLCODE = -902
>
>Your user name and password are not defined. Ask your database
>administrator to set up a Firebird login.
>Use CONNECT or CREATE DATABASE to specify a database
>SQL> quit;
>root@itdkel:/home/amir# /usr/lib/firebird2/bin/isql
>61.49.24.54:/opt/data/tiket/hputra.gdb -u SYSDBA
>Statement failed, SQLCODE = -902
>
>Your user name and password are not defined. Ask your database
>administrator to set up a Firebird login.
>Use CONNECT or CREATE DATABASE to specify a database
>SQL> quit;
>root@itdkel:/home/amir# /usr/lib/firebird2/bin/isql
>61.49.24.54:/opt/data/tiket/hputra.gdb
>Statement failed, SQLCODE = -923
>
>connection rejected by remote interface
>Use CONNECT or CREATE DATABASE to specify a database
>SQL>
>
>
>Why this appear : Your user name and password are not defined. Ask
>your database administrator to set up a Firebird login.?

It means that the SYSDBA password is not masterkey. Did you change
the password after installing? If not, then you will find the
installed SYSDBA password in a text file in your /opt/firebird
directory. To read the password, go there and type

cat SYSDBA.password

You can change the password using gsec. For example, to change the
password from "bH9&iJFk" to "crazydog":

/opt/firebird/bin/gsec -mo sysdba -pw crazydog -user sysdba -password bH9&iJFk

(There are other ways to do this, too - READ THE RELEASE NOTES!!)

./heLen