Thread: psql proxy
I want build a psql proxy which could deal with the connection request from localhost to psql server which on other machine by type in psql -h localhost -U bob network.
what function should I use to capture these information in my proxy code. I try to print the buf but there is nothing there after the read function.
Cheers!
what function should I use to capture these information in my proxy code. I try to print the buf but there is nothing there after the read function.
Cheers!
On Fri, May 16, 2008 at 01:53:30PM +1000, Linsong GUO wrote: > I want build a psql proxy which could deal with the connection request from > localhost to psql server which on other machine by type in psql -h localhost > -U bob network. Simple solution: use ssh tunneling Without any security: use netcat > what function should I use to capture these information in my proxy code. I > try to print the buf but there is nothing there after the read function. There's nothing special needed for psql, just using a standard network proxy will be fine. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment
in the terminal I input psql -h localhost -U bob network
the problem is I do not know how to capture the user name and password information in my proxy code.
after read function it is seems nothing in the buf
could you suggest some stand proxy example for me
thanks for your help
the problem is I do not know how to capture the user name and password information in my proxy code.
after read function it is seems nothing in the buf
could you suggest some stand proxy example for me
thanks for your help
On Fri, May 16, 2008 at 6:23 PM, Martijn van Oosterhout <kleptog@svana.org> wrote:
On Fri, May 16, 2008 at 01:53:30PM +1000, Linsong GUO wrote:Simple solution: use ssh tunneling
> I want build a psql proxy which could deal with the connection request from
> localhost to psql server which on other machine by type in psql -h localhost
> -U bob network.
Without any security: use netcatThere's nothing special needed for psql, just using a standard network
> what function should I use to capture these information in my proxy code. I
> try to print the buf but there is nothing there after the read function.
proxy will be fine.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFILUR2IB7bNG8LQkwRAsd7AJ9tZxwvb5ZYYQIj0uLUj7Bo1B2IiwCfdF/B
KBXplgDjJXOCgw6lqJvZ2VI=
=Zbvh
-----END PGP SIGNATURE-----
On Friday 16 May 2008 23:34:56 Linsong GUO wrote: > in the terminal I input psql -h localhost -U bob network > > the problem is I do not know how to capture the user name and password > information in my proxy code. > > after read function it is seems nothing in the buf > > could you suggest some stand proxy example for me Martijn pointed you at ssh tunnelling and netcat. You either need something that ssh tunnelling/netcat CANNOT do for you, or you don't understand that ssh tunnelling/netcat are sufficient for what you need to do. It's not clear which of those it is. Why don't you describe the requirement at a lower level (e.g., what are the two computers you've got, what is between the two computers [is there a firewall, is the other computer on the other side of the world from you], etc). As it is, your problem statement is too high level. You're assuming that you need to write your own proxy. Consider lower level solutions. Or are you writing a proxy for fun? If so, how is the proxy supposed to work? you run psql at the local box, it connects to the proxy, and the proxy passes everything over to the remote box? ssh/netcat will do that for you. What other reasons do you have for writing your own proxy? The only thing I can think of is sniffing the passwords of other users, but I'm sure there are other interesting things you might be trying to do. Gerald -- Gerald Timothy Quimpo bopolissimus@gmail.com I'm so miserable without you, it's almost like you're here.