
Configuring Access Controls for mSQL Databases |
When accessing an mSQL database from a CGI, it is important to
configure access controls for the database. That can be done by
making some additions to the ~/usr/local/msql2/msql.acl
file on your Virtual Server. Here is what it looks like:
# # Access control for mSQL # # Entries are of the form # # For the bookmark database, I let anyone # read it but only I can write it: #database=bookmarks #read=* #write=USERNAME #access=local #host=*
This is an entry for
the bookmarks demo database that comes with the installation of w3-msql. To get this to work remove all
the #'s from the bookmarks section so
that it looks like this:
# # Access control for mSQL # # Entries are of the form # # For the bookmark database, I let anyone # read it but only I can write it: database=bookmarks read=* write=USERNAME access=local host=*
Now you can access the bookmarks database from a CGI.