Hello,

I installed Firebird 2.1 from sources on another Linux box of mine. Here is the problem:

rp:~$ gsec -user sysdba -password <deleted>
GSEC> display
user name uid gid full name
------------------------------------------------------------------------------------------
SYSDBA 0 0 Sql Server Administrator
TRAD 0 0
GSEC> add ognen -pw 'testpass'
Warning - maximum 8 significant bytes of password used
GSEC> display
user name uid gid full name
------------------------------------------------------------------------------------------
SYSDBA 0 0 Sql Server Administrator
TRAD 0 0
OGNEN 0 0
GSEC>

rp:~$ isql -u ognen -p 'testpass'
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database '/db/testdb1.fdb' user 'ognen' password 'testpass';
Statement failed, SQLCODE = -902
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
SQL>

rp:~$ gsec -user sysdba -password <deleted>
GSEC> display
user name uid gid full name
------------------------------------------------------------------------------------------
SYSDBA 0 0 Sql Server Administrator
TRAD 0 0
OGNEN 0 0
GSEC> delete ognen;
The user name specified was not found in the security database

rp:~$ ls -ld /db
drwxrwxrwx 2 firebird firebird 4096 2010-02-26 15:58 /db

It is superserver v2.1 built from sources.
rp:~$ ls -l `which isql`
lrwxrwxrwx 1 root root 28 2010-02-25 13:40 /usr/bin/isql -> /usr/local/firebird/bin/isql
rp:~$ ls -l `which gsec`
lrwxrwxrwx 1 root root 28 2010-02-25 13:40 /usr/bin/gsec -> /usr/local/firebird/bin/gsec

rp:~$ locate *.fdb
/usr/local/firebird/security2.fdb
/usr/local/firebird/examples/empbuild/employee.fdb
/usr/local/firebird/help/help.fdb

Any input is appreciated.

Thanks,
Ognen

[Non-text portions of this message have been removed]