Configuring mSQL Database Access Controls

When accessing an mSQL database from a CGI, it is important to configure access controls for the database. This can be done by making some additions to the ~/usr/local/msql2/msql.acl file on your Virtual Private 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.

Please note: the information on this page applies to ITS web hosting plans. It may or may not apply to other environments. If you are looking for a feature described here, or better support from your hosting provider, please consider hosting your site with ITS!

Contact ITS	Search	Site Map	StartCenter	Privacy Policy	Terms/Legal

Copyright © 1996-2024, Integrated Technical Solutions, Inc., all rights reserved. See Terms/Legal for trademarks, copyright, and terms of use.