GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Configuring mSQL Database Access Controls

bullet 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.


Toll Free 1-866-GSP-4400 • 1-301-464-9363 • service@gsp.com
Copyright © 1994-2016 GSP Services, Inc.