Cannot connect to firebird

[cmohanc]

I have installed firebird 3. This is the connection string from flamerobin - localhost/3050:D:\FireBirdData\BPR.FDB Can you tell me how to connect in vscode?

[mvitlov]

Hi there! Thanks for trying out the extension.

To add a new connection, simply click the "Add New Connection" icon inside Firebird DB Explorer view (VS Code activity bar). From there, simply follow the wizard and provide the information asked.

Also, please note that for Firebird 3.0 you must add the following info inside firebird.conf file:

AuthServer = Legacy_Auth  
WireCrypt = Disabled

Good luck!

[cmohanc]

Hi mvitlov , Thanks for your response. I modified and tried . It doesn't work. Even Flame robin fails to work if i add the line WireCrypt = Disabled. My file path is D:\FireBirdData\BPR.FDB What should be the enter in the path ?

[cmohanc]

Hi Can you suggest ? Iam still unable to connect

[mvitlov]

@cmohanc Sorry for the late response. Did you manage to resolve the connection issues? Unfortunately, due to lack of spare time, the extension hasn't been tested yet with the Firebird 3.0. There's a strong possibility of an issue with third-party client (node-firebird) that this extension uses.

I'll try to test it myself when I get some spare time.

Cheers!

[cmohanc]

Thanks for the reply. Please let me know if you update for firebird 3.0 Best regards C.Mohan

On Thu 28 Feb, 2019, 13:57 Marin Vitlov, [email protected] wrote:

@cmohanc https://github.com/cmohanc Sorry for the late response. Did you manage to resolve the connection issues? Unfortunately, due to lack of spare time, the extension hasn't been tested yet with the Firebird 3.0. There's a strong possibility of an issue with third-party client (node-firebird) https://www.npmjs.com/package/node-firebird that this extension uses.

I'll try to test it myself when I get some spare time.

Cheers!

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/mvitlov/vscode-db-explorer-firebird/issues/2#issuecomment-468182288, or mute the thread https://github.com/notifications/unsubscribe-auth/AHiblxg_vJF51oJMng1K6G4KhSUCZF8lks5vR5LagaJpZM4Yrk65 .

[mrotteveel]

You need to make sure your user is created as a legacy-auth user.

[cmohanc]

How to create a legacy-auth user.?

[mrotteveel]

The firebird.conf needs to have the following settings:

AuthServer = Srp, Legacy_Auth
WireCrypt = Enabled
UserManager = Srp, Legacy_UserManager

Other plugins or a different order is possible as long as Legacy_Auth is present in AuthServer, and Legacy_UserManager in UserManager, and you must downgrade the WireCrypt setting from its default of Required to Enabled (or even Disabled).

You can then create a legacy authentication user using:

create user <username> password '<password>' using plugin Legacy_UserManager;

The using plugin clause is what discerns between the different user types.

By default the security database already has a legacy_auth SYSDBA (with password masterkey), keep this in mind if you don't want to leave your Firebird install insecure (change it with alter user sysdba set password '<password>' using plugin Legacy_UserManager).

Alternatively, you can read Compatibility Issues → Legacy Authentication in the Firebird 3 release notes. Following those instructions however will disallow you to manage SRP users, which is not advisable in my opinion.

[silvioprog]

Hi @mrotteveel ,

I've got the same problem reported by @cmohanc . I have been trying to connect using the steps you shared above, but the plugin still not able to connect. :-/

Could you try it on your machine? Thank you!

[mrotteveel]

@silvioprog I tried it when I wrote my comment. I know it works. If it doesn't work for you then I would guess that you either didn't restart Firebird after changing these settings, or you did not remove the # comment mark before some of those settings in firebird.conf, or you are trying to connect with a Srp user instead of a Legacy_Auth user.

[MrBenWang]

I've tried many times, but it still don't show any table. It doesn't show any information，only the vscode notice: Active connection: lst_debug:LNO_CLIENT.FDB

• OS: [Win10]
• VS Code version: [v1.38.1]
• Firebird version: [2.5.4]

[mariuz]

I can confirm that driver should work with

AuthServer = Srp, Legacy_Auth WireCrypt = Enabled UserManager = Srp, Legacy_UserManager so maybe is port connection related issue , so this can be closed

[michaelsync]

I am having the same issue. I think it should show some error message or something when it can't connect to the database.

[CyberT33N]

https://github.com/CyberT33N/firebird-cheat-sheet/blob/main/README.md#docker-compose

[mrotteveel]

@CyberT33N That doesn't really seem related to this question. Also, if you're starting out with using Firebird using Docker, I'd suggest using the firebirdsql/firebird image, not jacobalberty/firebird, as that one was retired when firebirdsql/firebird was released.

In any case, the VS Code extension this discusses no longer works (see also #10 and others).