Configuring mSQL Database Access Controls

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 Private Servers. 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.