|
C o n f i g u r i n g A c c e s s C o n t r o l s
f o r m S Q L D a t a b a s e s
|
|
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.