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>