Firebird3 stucks in Linux Virtural machine.

[zheyxu]

Hi, Firebird stucks in the command CREATE DATABASE or CONNECT. It worked well before but when I ran the command sudo gsec -database. It stucks at CREATW or CONNECT DATABASE. Thanks for any hints! ~$ sudo isql-fb Use CONNECT or CREATE DATABASE to specify a database SQL> CREATE DATABASE 'test.fdb' USER 'test' PASSWORD 'test';

[mrotteveel]

Did you exit gsec? What server mode is your Firebird instance configured? It sounds like either gsec has an exclusive lock on the security database, or that the embedded connection from isql tries to get an exclusive lock, and thus waits.

As an aside, gsec is deprecated since Firebird 3.0. It is highly recommended to use the SQL user management statements instead.

[AlexPeshkoff]

On 5/31/22 02:20, Zheyuan-Robert-Xu wrote:

Hi, Firebird stucks in the command CREATE DATABASE or CONNECT. It worked well before but when I ran the command sudo gsec -database. It stucks at CREATW or CONNECT DATABASE. Thanks for any hints! ~$ sudo isql-fb Use CONNECT or CREATE DATABASE to specify a database SQL> CREATE DATABASE 'test.fdb' USER 'test' PASSWORD 'test';

Support questions to be asked here: https://groups.google.com/g/firebird-support

[zheyxu]

Thanks Alex, I exited gsec and I use Ubuntu. And the command sudo killall gsec fixes it.