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
Legacy_Auth plugin does not connect from FB3 to FB2.5 server when tried after Win_Sspi [CORE4471] #4791
Comments
Commented by: @AlexPeshkoff Please explain - from what firebird version to what do you want to connect. Connection from 3.0 to 2.5 causes no problems, works with default .conf files and does not require additional options in EXECUTE STATEMENT. Connection from 2.5 to 3.0 will work only if you tune fb3 server to accept legacy auth. |
Commented by: @sim1984 execute block FB3.0 FB2.5 firebird.conf don't change databases.conf (FB3) horses = d:\fb\fb30\data\horses.fdb { If so "Connection from 3.0 to 2.5 causes no problems, works with default.conf files and does not require additional options in EXECUTE STATEMENT.", then one it might a bug. Probably occurs only on Windows. |
Commented by: @AlexPeshkoff What build of FB3 do you use? Currently everything works fine:
============ SQL> show version^ |
Commented by: @sim1984 SQL> connect 'localhost:horses' user 'sysdba' password 'masterkey';
============ May be due to the fact that I have Windows. |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @sim1984 This bug appears when you specify a non-standard port. If the port is a standard 3050 (connection string 'server:horses'), there is no problem. |
Commented by: @AlexPeshkoff In that case that's definitely not related with plugins. |
Commented by: @sim1984 I get it. The problem is that the EXECUTE STATEMENT does not understand the connection string indicating the port. But why only Legacy_Auth |
Commented by: @AlexPeshkoff Really strange. Does it mean that exec statement fb3->fb3 on non-default port works fine? |
Commented by: @sim1984 Maybe not. I tried to connect to itself. Port have no standard. execute block It's OK. |
Commented by: @sim1984 It seems about the fact that I lied works. Slightly modify the query to return a version that connects to the server. Use CONNECT or CREATE DATABASE to specify a database I12 SQL> execute block I12 SQL> execute block IStatement failed, SQLSTATE = 42000 |
Commented by: @sim1984 I still managed to connect from the database Firebird 3 to Firebird 2.5, but changes in the configuration file firebird.conf still required. # If so it should be just close this ticket and make a note in the Release Notes. If not, then it is a bug. It is not clear why, if Win_Sspi could not connect, then Legacy_Auth even trying. Maybe due to the fact that the domain network is not configured. |
Commented by: @AlexPeshkoff Yes, this looks like a bug. I've updated a ticket and will fix it. |
Modified by: @AlexPeshkoffdescription: I have a problem with a bunch of 3 and Firebird Firebird 2.5 by operator EXECUTE STATEMENT. "335544472: Your user name and password are not defined. Ask your database administrator to set up a Firebird login." This occurs because the operator EXECUTE STATEMENT ON EXTERNAL DATA SOURCE connected via SRP. Of course, you can change the authentication method, but it will change immediately for the entire database. As I understand MAPPING can solve the inverse problem (connect to Firebird 2.5 Firebird 3.0), but not the one that I described. Maybe expand the operator EXECUTE STATEMENT so that it is possible to specify authorization plugin? EXECUTE STATEMENT {<sql_statement_string> |: <SQL_STMT_VARIABLE>} [(<input_parameters>)] => I have a problem with a bunch of 3 and Firebird Firebird 2.5 by operator EXECUTE STATEMENT. "335544472: Your user name and password are not defined. Ask your database administrator to set up a Firebird login." This occurs because the operator EXECUTE STATEMENT ON EXTERNAL DATA SOURCE summary: Allow to specify plugin authorization statement EXECUTE STATEMENT => Legacy_Auth plugin does not connect from FB3 to FB2.5 server when tried after Win_Sspi |
Modified by: @sim1984issuetype: Improvement [ 4 ] => Bug [ 1 ] |
Commented by: @AlexPeshkoff Client was incorrectly choosing authentication plugin. |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 2 [ 10586 ] |
Modified by: @AlexPeshkoff |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @sim1984
Is duplicated by CORE4649
I have a problem with a bunch of 3 and Firebird Firebird 2.5 by operator EXECUTE STATEMENT.
"335544472: Your user name and password are not defined. Ask your database administrator to set up a Firebird login."
This occurs because the operator EXECUTE STATEMENT ON EXTERNAL DATA SOURCE
Commits: 7006c82 FirebirdSQL/fbt-repository@06657a8
The text was updated successfully, but these errors were encountered: