Hello.
I have been reading the /Base guide/, and in chapter 2, I have been able to see, what, under my point of view, are several errors, all of them related to the external connection to a Firebird database.
The first of them, although certainly not really an error, but an outdated one, can be found on page 73 of the PDF file of the Base Guide 7.2. *Create a database user*. The whole procedure is based on the use of */gsec/* though, in the Firebird 3 quick start guide says:
“/5.1. User management/
/In Firebird 3, user management is done entirely through SQL commands. Users of previous versions are probably familiar with the //*gsec*//utility for this task. //*It is still present, but deprecated*//…”/
So it would be more correct to use the SQL procedure from isql or isql-fb to create and authorize users, and also to change the sysdba password.
According to the Firebird 3 quick install guide, the procedure to change the administrator password is as follows:
/If the password is masterkey and your server is exposed to the Internet at all - or even to a local network, unless you trust every user with the SYSDBA password - you should change it immediately./
/Fire up isql or another Firebird client and connect to a database. In this example, the "employee" example database is used, because its alias is always present in a freshly installed Firebird setup:/
connect localhost:employee user sysdba password masterkey;
/If you do this in isql, it should respond with:/
Database: localhost:employee, User: SYSDBA
/Now alter the sysdba password:/
alter user sysdba set password 'Zis4_viZuna83YoYoYo';
And the procedure to create a new user is:
/Assuming you are connected to a database as SYSDBA, you can add a user account as follows:/
create user billyboy password 'TooLongFor8099Comfort';
On the other hand the Direct connection to Firebird procedure is completely wrong, it seems that it is a copy-paste of the connection to PostgreSQL, but that in Firebird it does not work. The procedure would be: