NAME

Apache::MsqlProxy - Translate URI's into mSQL database queries

SYNOPSIS

 #httpd.conf or srm.conf
 PerlTransHandler Apache::MsqlProxy::translate
 PerlHandler      Apache::MsqlProxy::handler
 PerlModule       Apache::MsqlProxy

Configure your browser's HTTP proxy to point at the host running Apache configured with this module:

  http://hostname.domain/

When connecting to the server via normal HTTP (not proxy), URLs are not translated.

URL's are translated as follows:

 http://hostname/database_name/table_name

Connect to hostname via TCP, select database database_name, query table <table_name> with:

 SELECT * from table_name

 http://hostname/database_name/table_name?login_name=dougm

Same as above with query:

 SELECT login_name from table where login_name=dougm

 http://hostname/database_name/table_name/*?login_name=dougm

Same as above with query:

 SELECT * from table where login_name=dougm

Of course,

 http:///database_name/table_name

A null hostname connects via UNIX socket

 http://hostname:9876/database_name/table_name

Connect via TCP to hostname and port 9876

DESCRIPTION

This module is meant as an example to show how one can use Apache + mod_perl to handle HTTP proxy requests, or simply translating a URL.

It may not be very useful other than as an example, but feel free to change that.

SEE ALSO

Apache(3), Msql(3)

AUTHOR

Doug MacEachern <dougm@osf.org>