On 10/19/20 5:00 PM, Dimitry Sibiryakov wrote:
Hello All.
With current Firebird 4 snapshot with default firebird.conf (legacy
auth disabled) and no Srp SYSDBA user, the query
create database "localhost:crypt_test" user "SYSDBA" password "masterke";
is much slower than
create database "localhost:crypt_test" user "SYSDBA" password
"masterkey";
What could cause such difference?
If legacy auth is enabled, the difference disappear.
Sooner of all another instance of server running on your box :)
Because in default case one gets something like (no users at all):
# ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database "localhost:crypt_test" user "SYSDBA" password
"masterke";
Statement failed, SQLSTATE = 28000
Install incomplete. To complete security database initialization please
CREATE USER. For details read doc/README.security_database.txt.
SQL>
Or (some user created):
# ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database "localhost:crypt_test" user "SYSDBA" password
"masterke";
Statement failed, SQLSTATE = 28000
Your user name and password are not defined. Ask your database
administrator to set up a Firebird login.
SQL>
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel