Configuring mSQL Database Access Controls

When accessing an mSQL database from a CGI script, 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 section on bookmarks so that 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=*