Skip to Content.
Sympa Menu

freetds - Re: [freetds] Proxy-Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Proxy-Server
  • Date: Sat, 24 Apr 2010 19:17:17 +0200

Why not using a VPN and proper user with correct rigths? You could create views to disallow columns. If you need a proxy you should check server code (not that advanced as client code but is a start)

Frediano Ziglio

Il giorno 21/apr/2010, alle ore 15.47, "Andi Clemens" <Andi.Clemens AT gmx.net > ha scritto:

Hi,

I need to implement some proxy server that will filter all SQLBatch packages and check for invalid SQL statements (for example SELECT on columns in a table that are not allowed).
I then need to sent an error package telling the user / client that this operation is not allowed.
This works fine for now, but another feature should be "auto-login": The user types in some database unrelated information (the user shouldn't know the database IP, username and password), and the proxy server will examine this "fake" login and open a connection to the real SQLServer.
Setting up the connection is not the problem that I'm facing right now, but the login process is totally mystical to me ;-)

I looked for packages that start with 0x02, but I can not see them. I see the prelogin packages (0x12) and also the SQLBatch packages (0x01), but the login packages are "invisible".

I then read somewhere in the MS-SSTDS.pdf that the credentials are sent encrypted? Via TLS / SSL?

After looking through thousands of Google result pages I finally came across FreeTDS and now I hope that there is some simple login function that can handle the login for me :-)

Do you think it is possible to be a proxy server AND setup my own login (which makes the proxy a client)?
I mean do you think it is possible to login via the proxy server and have the client accept the connection? The client would be "SQLServer Management Studio" and "sqlcmd" in my case.

Has anybody done something like this before?
Maybe you can help me with ideas here. I took a look at the FreeTDS API, but the only login function I found so far was in the ODBC module?

Andi

--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




Archive powered by MHonArc 2.6.24.

Top of Page