|
W3-mSQL
W3-mSQL
provides a programmatic interface to the mSQL
database system from
within an HTML document. It enables the development of entire
programs within a WWW page while offering comprehensive access control
and security features.
W3-mSQL achieves this by providing a complete programming language
embedded within an HTML document. The language, called Lite, is similar
is style and
syntax to the C programming language and the ESL scripting language.
Using W3-mSQL and the embedded Lite language, you can generate HTML code
"on-the-fly" in the same way you do when you write custom CGI programs.
What's more, you can mix normal HTML code with W3-mSQL code so that you
only need to use the CGI styled approach where you actually have to.
Installation
To install W3-mSQL on your Virtual Server, connect to your Virtual Server via
Telnet or SSH and
run the commands that match your Virtual Server O/S:
|
FreeBSD
% vinstall w3-msql
|
BSD/OS
% cd
% tar xvf /usr/local/contrib/w3-msql.tar
|
|
NOTE:
If your Virtual Server was ordered after Nov 22, 1999, you are likely
running FreeBSD. To find out which O/S your Virtual Server is running, use the
uname command:
% uname
If your Virtual Server is not already running FreeBSD,
Upgrade to a New FreeBSD Virtual Server
today!
|
Configuration
W3-mSQL enhanced HTML files must be pre-processed by the ~/www/cgi-bin/w3-msql
CGI before the web server sends the results to the requesting client.
Normally, this pre-processing requires the ~/www/cgi-bin/w3-msql CGI to
appear in the URL of each W3-mSQL file on your site. For example:
http://YOUR-DOMAIN.NAME/cgi-bin/w3-msql/file.msql
The Apache Web Server
can be configured to automatically pre-process W3-mSQL
files with the .msql file extension. To setup W3-mSQL redirection, add
the following lines to the ~/www/conf/httpd.conf file on your Virtual Server
(or the ~/www/conf/srm.conf file, if you Virtual Server was configured
before Dec. 8, 1998):
AddHandler htmsql msql
Action htmsql /cgi-bin/w3-msql
After doing this, it is possible to access W3-mSQL files this way:
http://YOUR-DOMAIN.NAME/file.msql
The .msql files are automatically pre-processed by the ~/www/cgi-bin/w3-msql
CGI without the ~/www/cgi-bin/w3-msql CGI appearing in the URL
path.
Sample Application
A sample W3-mSQL application is also available for installation
on the Virtual Servers. You can install the simple
example by unpacking an archive file onto your Virtual Server.
|
NOTE:
The sample application is only available on Virtual Servers running
BSD/OS.
|
% cd
% tar xvf /usr/local/contrib/w3-msql-demo.tar
Once the files are in place run the install script.
% cd ~/www/htdocs/bookmarks
% ./setup_bookmark
You can then access the sample application at:
http://YOUR-DOMAIN.NAME/bookmarks/Welcome.html
| 
