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

Secretless faithfully propagates MSSQL Login Response from server #1106

Closed
2 tasks
doodlesbykumbi opened this issue Jan 24, 2020 · 0 comments
Closed
2 tasks

Comments

@doodlesbykumbi
Copy link
Contributor

doodlesbykumbi commented Jan 24, 2020

Description

Secretless faithfully propagates MSSQL Login Response from server.

At present, Secretless decodes the LoginResponse from the server and extracts the LoginAck token then sends that with a Done token. This is bad because it strips many important other tokens. e.g. see how in this example there are other tokens such as EnvChange present in the Response => https://docs.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/517a62a2-7448-47b6-81eb-c0c5027826ca

AC:

  • Unit tests exists to validate any translation layer
  • Integration tests exist, covering a variety of client and server combinations
This was referenced Jan 24, 2020
diverdane pushed a commit that referenced this issue Jan 28, 2020
This change removes any handling and translation of login responses
from the server in the secretless broker. Instead, secretless will
now "call it a day" after sending a translated version of the client's
login request to the MSSQL server. Login responses from the server
will now be passed transparently (from the perspective of secretless)
from the server to the client.

This is a Work-in-Progress. There is one integration test that is
failing, and I need to do more investigation: The test for whether
secretless is faithfully passing a bad database name in a login
request from the client to the server is failing. In this scenario,
the server is sending a "Cannot open database" error, but the client
is somehow not detecting the error.

Fixes Issue #1106.
diverdane pushed a commit that referenced this issue Jan 28, 2020
This change removes any handling and translation of login responses
from the server in the secretless broker. Instead, secretless will
now "call it a day" after sending a translated version of the client's
login request to the MSSQL server. Login responses from the server
will now be passed transparently (from the perspective of secretless)
from the server to the client.

This is a Work-in-Progress. There is one integration test that is
failing, and I need to do more investigation: The test for whether
secretless is faithfully passing a bad database name in a login
request from the client to the server is failing. In this scenario,
the server is sending a "Cannot open database" error, but the client
is somehow not detecting the error.

Fixes Issue #1106.
diverdane pushed a commit that referenced this issue Jan 28, 2020
This change removes any handling and translation of login responses
from the server in the secretless broker. Instead, secretless will
now "call it a day" after sending a translated version of the client's
login request to the MSSQL server. Login responses from the server
will now be passed transparently (from the perspective of secretless)
from the server to the client.

This is a Work-in-Progress. There is one integration test that is
failing, and I need to do more investigation: The test for whether
secretless is faithfully passing a bad database name in a login
request from the client to the server is failing. In this scenario,
the server is sending a "Cannot open database" error, but the client
is somehow not detecting the error.

Fixes Issue #1106.
diverdane pushed a commit that referenced this issue Jan 28, 2020
This change removes any handling and translation of login responses
from the server in the secretless broker. Instead, secretless will
now "call it a day" after sending a translated version of the client's
login request to the MSSQL server. Login responses from the server
will now be passed transparently (from the perspective of secretless)
from the server to the client.

This is a Work-in-Progress. There is one integration test that is
failing, and I need to do more investigation: The test for whether
secretless is faithfully passing a bad database name in a login
request from the client to the server is failing. In this scenario,
the server is sending a "Cannot open database" error, but the client
is somehow not detecting the error.

Fixes Issue #1106.
diverdane pushed a commit that referenced this issue Jan 28, 2020
This change removes any handling and translation of login responses
from the server in the secretless broker. Instead, secretless will
now "call it a day" after sending a translated version of the client's
login request to the MSSQL server. Login responses from the server
will now be passed transparently (from the perspective of secretless)
from the server to the client.

This is a Work-in-Progress. There is one integration test that is
failing, and I need to do more investigation: The test for whether
secretless is faithfully passing a bad database name in a login
request from the client to the server is failing. In this scenario,
the server is sending a "Cannot open database" error, but the client
is somehow not detecting the error.

Fixes Issue #1106.
@izgeri izgeri closed this as completed Jan 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants