AlpineWeb Home
Search: For:   ~ Advanced Search  
  Support Home     Documentation     Knowledgebase     Help Desk     Blog 
Support Home > VPS v1 > Extensions > Sunday, July 20, 2008

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.


Technical Support
° Getting Started Guides
  FreeBSD
° Basic Hosting Help
° Signature Hosting Help
° VPS v1 Help
° VPS v2/3 Help
° MPS v2/3 Help
  Linux
° VPS v3 Help
° MPS v3 Help
  SaaS
° Sugar CRM
  DNS
° Domain Name Service
° Domain Registration
° Help Desk
° Knowledgebase
° Support Policies
° Disclaimer

° AlpineWeb Home
° Compare Hosting Plans
° Network Topology

° Rates & Fees
° Order Center


  ALSO  SEE
· About mSQL
· Installing mSQL
· Using W3-mSQL
· Database Solutions
· Server Extension Help


  Home | Site Map | Customer Backroom Copyright  ©  1997-2008  AlpineWeb Design