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

Problems connecting to firebird 3 #65

Closed
choallin opened this issue Nov 12, 2018 · 8 comments
Closed

Problems connecting to firebird 3 #65

choallin opened this issue Nov 12, 2018 · 8 comments

Comments

@choallin
Copy link

Since it seems that issue #58 seems to be merged I make a new issue here.

I am trying to connect to a firebird 3 and am always getting an error (Firebird error unknown ISC error 335545106) which, after some research seems to be an authentication error. The firebird.log is also telling me, that the auth plugin not supported by network protocol
I have configured the db to use legacy_auth but still nothing changed. Do I have to configure something else as well?

@woblavobla
Copy link

@choallin check your configuration and security3.fdb. On clean Firebird you should initialize security db. Try to google on issues with connecting to clean firebird 3.

@choallin
Copy link
Author

@woblavobla I am very new to Firebird (but I know postrges and mysql). Where do I find the security3.fdb? Or how can I configure it?

@woblavobla
Copy link

woblavobla commented Nov 12, 2018

@choallin First of all you should uninstall any previous versions of Firebird and gem 'fb'. Then install Firebird 3 and gem fb. This is needed to build gem with firebird 3 header files. And try to connect again.

@choallin
Copy link
Author

I did this already, but it didn't change. (Now I have th fb gem version 0.9.0)

@woblavobla
Copy link

@choallin you can only login with users that have been created for legacy authentication; the new Srp authentication is not supported; You should google how to correctly config legacy auth for Firebird 3.

@choallin
Copy link
Author

I configured the db according to this: https://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-compat-legacyauth.html
Do I need to create a new user for the legacy auth or should the sysdba user be allowed to log in via legacy?

@choallin
Copy link
Author

I installed the firebird server now on my host and everything works.
Honestly I don't know why it didn't work in a vm...

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

No branches or pull requests

2 participants