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

SQLCMD v1.0.0 can't connect to Azure SQL Database due to SSL handshake error #226

Closed
ahammond-prft opened this issue Jun 11, 2024 · 0 comments · Fixed by #232
Closed

SQLCMD v1.0.0 can't connect to Azure SQL Database due to SSL handshake error #226

ahammond-prft opened this issue Jun 11, 2024 · 0 comments · Fixed by #232
Labels
bug Something isn't working P0 Action not working
Milestone

Comments

@ahammond-prft
Copy link

Connection attempts to Azure SQL Database fail with an SSL handshake error.

SQLCMD version 1.0.0 is hard coded in the action and is automatically downloaded to the tool cache.

Manually replacing the sqlcmd file in the "/_work/_tool/go-sqlcmd/1.0.0/x64" directory with version 1.5.0 of the tool corrects the issue and results in a successful connection and the execution of the SQL script.

Run azure/sql-action@v2.2.1
##[debug]isExplicit: 1.0.0
##[debug]explicit? true
##[debug]checking cache: /home/xxxxxx/actions-runner/_work/_tool/go-sqlcmd/1.0.0/x64
##[debug]not found
##[debug]Downloading https://github.com/microsoft/go-sqlcmd/releases/download/v1.0.0/sqlcmd-v1.0.0-linux-x64.tar.bz2
##[debug]Destination /home/xxxxxx/actions-runner/_work/_temp/7d56208e-339b-4d15-84cd-240697cf2277
##[debug]download complete
##[debug]Checking tar --version
##[debug]tar (GNU tar) 1.34
##[debug]Copyright (C) 2021 Free Software Foundation, Inc.
##[debug]License GPLv3+: GNU GPL version 3 or later https://gnu.org/licenses/gpl.html.
##[debug]This is free software: you are free to change and redistribute it.
##[debug]There is NO WARRANTY, to the extent permitted by law.
##[debug]
##[debug]Written by John Gilmore and Jay Fenlason.
tar xj -v --warning=no-unknown-keyword --overwrite -C /home/xxxxxx/actions-runner/_work/_temp/1741cab9-3291-4dc9-a304-895447f58cdc -f /home/xxxxxx/actions-runner/_work/_temp/7d56208e-339b-4d15-84cd-240697cf2277
NOTICE.md
sqlcmd
sqlcmd_debug
##[debug]Caching tool go-sqlcmd 1.0.0 x64
##[debug]source dir: /home/xxxxxx/actions-runner/_work/_temp/1741cab9-3291-4dc9-a304-895447f58cdc
##[debug]destination /home/xxxxxx/actions-runner/_work/_tool/go-sqlcmd/1.0.0/x64
##[debug]finished caching tool
##[debug]Get action inputs.
::add-mask::***
::add-mask::***
##[debug]Validating if client has access to 'master' on 'server.database.windows.net'.
The process 'sqlcmd' failed with exit code 1
SqlCmd stderr: TLS Handshake failed: cannot read handshake packet: EOF
TLS Handshake failed: cannot read handshake packet: EOF

##[debug]Validating if client has access to 'database' on 'server.database.windows.net'.
The process 'sqlcmd' failed with exit code 1
SqlCmd stderr: TLS Handshake failed: cannot read handshake packet: EOF
TLS Handshake failed: cannot read handshake packet: EOF

Error: Failed to add firewall rule. Unable to detect client IP Address. TLS Handshake failed: cannot read handshake packet: EOF
TLS Handshake failed: cannot read handshake packet: EOF

@ahammond-prft ahammond-prft added the need-to-triage Requires investigation label Jun 11, 2024
@dzsquared dzsquared added bug Something isn't working P0 Action not working and removed need-to-triage Requires investigation labels Jun 14, 2024
@dzsquared dzsquared added this to the v2.3 milestone Jun 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working P0 Action not working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants