Need to write (or find) a network proxy

I have a server, running on a linux system (its a database, as it happens).
The clients are windows machines. I want to close the connection after a
certain amount of idle time (yes, I AM aware of issues with rollback &
integrity!). The server doesn't have such an option. I reckon a proxy for
the server, listening on the same port, and forwarding to a new port that
the server will listen on, could be written to handle the connections, but
maintain an idle time. What do you think - good idea, bad (please no
comments on the database integrity !) possible, not, how difficult, and is
there something which I could adapt to the purpose?

Thanks

Graham Nicholls
--
Rock Computer Consultancy: Problems solved.


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Graham Nicholls wrote:
> I have a server, running on a linux system (its a database, as it happens).
> The clients are windows machines. I want to close the connection after a
> certain amount of idle time (yes, I AM aware of issues with rollback &
> integrity!). The server doesn't have such an option. I reckon a proxy for
> the server, listening on the same port, and forwarding to a new port that
> the server will listen on, could be written to handle the connections, but
> maintain an idle time. What do you think - good idea, bad (please no
> comments on the database integrity !) possible, not, how difficult, and is
> there something which I could adapt to the purpose?
>
> Thanks
>
> Graham Nicholls

Gday Graham,

If you're using a fair dinkum database server (and not just a shared
file), you should be able to specify a connection timeout value when you
create the connection to the database server.

For example, in PostgreSQL, the "PQconnectdb" function creates a
connection from the client to the server, and "conect_timeout" is the
parameter controlling the connection timeout.

Controlling your timeout in this way should cause the DBMS server to
rollback any incomplete transactions on closing a connection, assuring
your data integrity!

HTH,
Pat