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
connection/login issue after migrating from 6.3.2 to 7.3.0 #1346
Comments
Can you connect using msnodesqlv8 directly? |
I have the same issue in a NestJS application with a MS SQL servier with a self signed certificate, it works with v6.4.0, but not with v7.3.0. |
Thanks @thorsten. Have you been able to do any debugging or testing to see what the problem is? I assume you're using msnodesqlv8 driver too? |
@dhensby I will debug it on Monday. How can I check which driver I'm using? |
If you don't know what driver you're using then you're probably using tedious. Do you import |
We import |
Then it is the tedious driver. Interesting this is affecting both. Can you both supply the actual config being used (sensitive details redacted) |
|
It looks like you're using typeorm, so I'm not sure what their support is regarding v7 (I can see their tests run against v6) The only thing I can see is you have encrypt set to false when maybe it should be true? I'd encourage you to attempt to authenticate directly with tedious and see if they works, then with mssql and then typeorm to see if there are any errors that are being produced from each of these layers. |
Switched "encrypt" to "true" and tried 7.3.0 again:
|
TypeORM doesn't support the new |
@thorsten - now I'm confused; are you trying to use the msnodesqlv8 driver? If you are, then you've had to edit the underlying typreorm coffee as per your linked issue, do your question about how you know if you're using it is not is unusual (I'd have expected it be obvious to you as you were needing coffee changes to typeorm to force the use of it). As for the error with self-signed certificates, is that when you trust the certificate too? I think you're going to need to supply me with a reproduction example... |
@farrukh-normuradov - let me know how you get on |
I still on installing the driver on my MacOS. I think I am not stuck but not focussed enough and thus got lost in the "but-s" of installation instructions. |
Ok, I managed to install the driver, but now I have an issue with OpenSSL. At this point I still do not expect the help from you, as I attribute the errors - among other things - to my lack of focus, just wanted to share my progress here. |
I'm a bit confused as to why you're having to go through all the setup for the msnodesqlv8 driver if you were already using it through |
Yes, you are right, it looks like we were not using the driver and the connection string attribute was ignored by the package and Would you have recommendation for just using |
Using tedious directly is fairly straightforward. It's all documented against the driver https://github.com/tediousjs/tedious |
I think I found the issue. |
So for the version |
Interesting, that should work. What happens if you used |
Looking at the string, this |
First of all, we were using Yesterday I found the issue. I removed the wrong dependency and the issue was solved. |
I'm glad you got to the bottom of it! |
After migrating to the 7.3.0 the connection was failing to get established.
Expected behaviour:
Connection is established and fetching works as usual.
Actual behaviour:
Connection fails with:
ConnectionError: Failed to connect to [SERVER_IP]4:1433 - self signed certificate at
Interestingly, when
TrustServerCertificate=True
flag is used, the error changes toLogin failed for user
.Configuration:
Software versions
The text was updated successfully, but these errors were encountered: