Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot connect to firebird #2

Open
cmohanc opened this issue Nov 20, 2018 · 13 comments
Open

Cannot connect to firebird #2

cmohanc opened this issue Nov 20, 2018 · 13 comments
Assignees
Labels
question Further information is requested

Comments

@cmohanc
Copy link

cmohanc commented Nov 20, 2018

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
Copy link
Owner

mvitlov commented Nov 24, 2018

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!

@mvitlov mvitlov self-assigned this Nov 24, 2018
@mvitlov mvitlov added the question Further information is requested label Nov 24, 2018
@cmohanc
Copy link
Author

cmohanc commented Dec 2, 2018

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 cmohanc closed this as completed Dec 2, 2018
@cmohanc
Copy link
Author

cmohanc commented Dec 21, 2018

Hi Can you suggest ? Iam still unable to connect

@cmohanc cmohanc reopened this Dec 21, 2018
@mvitlov
Copy link
Owner

mvitlov commented Feb 28, 2019

@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
Copy link
Author

cmohanc commented Feb 28, 2019 via email

@mrotteveel
Copy link

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

@cmohanc
Copy link
Author

cmohanc commented Mar 28, 2019

How to create a legacy-auth user.?

@cmohanc cmohanc closed this as completed Mar 28, 2019
@cmohanc cmohanc reopened this Mar 28, 2019
@mrotteveel
Copy link

mrotteveel commented Mar 29, 2019

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
Copy link

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
Copy link

@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
Copy link

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

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

@mariuz
Copy link

mariuz commented Jul 14, 2020

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
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

7 participants