search

mvitlov / vscode-db-explorer-firebird

Explore and run queries against your Firebird® databases without leaving VS Code.
MIT License
21 stars 11 forks source link

Cannot connect to firebird #2

Open cmohanc opened 5 years ago

cmohanc commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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 ?

image

cmohanc commented 5 years ago

Hi Can you suggest ? Iam still unable to connect

mvitlov commented 5 years ago

@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 commented 5 years ago

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, notifications@github.com 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 commented 5 years ago

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

cmohanc commented 5 years ago

How to create a legacy-auth user.?

mrotteveel commented 5 years ago

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 commented 4 years ago

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 commented 4 years ago

@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 commented 4 years ago

20190918114923

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

mariuz commented 3 years ago

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 commented 2 years ago

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