Comments (4)
Do you have any example applications that talk to Azure SQL DB through this same proxy?
The TDS protocol uses tcp
but not http
so I'm not sure what the expectation is here.
I am not a networking expert at all, though.
from go-sqlcmd.
Do you have any example applications that talk to Azure SQL DB through this same proxy? The TDS protocol uses
tcp
but nothttp
so I'm not sure what the expectation is here. I am not a networking expert at all, though.
No I did not found any application talking to Azure SQL DB through this proxy.
If for example I would like to connect to an SSH Server from this same environment (behind proxy) I need to configure this:
"ProxyCommand nc -X connect -x $PROXY_IP:$PROXY_PORT %h %p" >> ~/.ssh/config
You're probably pointing me into right direction. How to check if our proxy is also handling tcp traffic?
from go-sqlcmd.
afaik you have to get your proxy owner to let port 1433 requests through instead of being redirected by the proxy.
The server requires the name in the connection string match the DNS name of the server too.
from go-sqlcmd.
Hi @shueybubbles,
thanks for your help. I finally got it working with help of this comment: dbeaver/dbeaver#4741 (comment)
It looks like if you're going through a tunnel you need to specify the username like this: export SQLCMDUSER=user@serverFQDN
If someone else finds this issue because of tunneling go-sqlcmd
through a proxy this is the ncat command I used:
ncat --sh-exec "ncat --ssl $SQLCMDSERVER 1433 --proxy-type http --proxy $PROXY_IP:$PROXY_PORT" -l 14333 --keep-open &
Afterwards you should be able to connect like this:
./sqlcmd -S tcp:localhost:14333 -d $SQLCMDDATABASE -i query.sql
Envrionments Variables which need to be set:
- SQLCMDSERVER
- SQLCMDDATABASE
- SQLCMDUSER
- SQLCMDPASSWORD
from go-sqlcmd.
Related Issues (20)
- SqlCmd 1.5.0 Access Denied in Elevation mode against WID - Work fine with old SqlCmd 15 (SQL2019) HOT 4
- The image has the following vulnerability: CVE-2024-24557 BaseSeverity: high; BaseScore: 7.8. HOT 1
- What jdbc connection string property corresponds with the `-G` flag? HOT 1
- Release v1.6.0 missing msi HOT 1
- Double exclamation within text expression with some parenthesis deal as sqlcmd instruction
- Service Principal that is Azure AD admin cannot connect to database HOT 2
- Unable to connect to remote docker host when using SSH HOT 2
- EXIT command not parsed in powershell using -Q
- Scripting variables are not expanded in :out and :r commands HOT 2
- RHEL 8 repo misses v1.6.0 HOT 1
- No package available in RHEL 9 repo HOT 3
- Crash when use q and Q HOT 1
- BCP supports with ODBC Driver 18 HOT 2
- Ubuntu 22.04 repo: v1.6.0 not available
- wixproj needs to consume wix from nuget HOT 1
- Ubuntu 24.04 repo: sqlcmd not available
- Pull in latest go-mssqldb for fix to az-cli resource name
- Output data is not easy to parse HOT 5
- Variable substitution not disabled when using -x HOT 3
- :SETVAR with a comment on the same line throws syntax error HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from go-sqlcmd.