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

Reply via email to