Blue Reef Technical Support ResellersAbout Blue Reef Consulting, Inc.

EcommerceSearch
Return to Blue Reef Virtual Servers Home Page
Order virtual servers, software, computers, and more!
Return to Blue Reef Main Home Page
Specials
Site Map
Support Solutions to help you do business with your Virtual Server.



Virtual Servers Home Page
Virtual Server Support
Virtual Server Addons
Database Solutions
Database Overview
mSQL Overview
mSQL and MS Access
mSQL and W3-msql
mySQL Overview
MySQL and MS AccessMySQL and MS Access
MySQL and ColdFusionMySQL and ColdFusion
PostreSQL Overview
Request help using our Problem Tracking System
Order a Blue Reef Virtual Server now!


Configuring mSQL Database Access Controls

When accessing an mSQL database from a CGI script, 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 section on bookmarks so that 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=*


Now you can access the "bookmarks" database from a CGI. To find out more about the msql.acl file please see the msql website.

SEE ALSO:

PHP Development

Miva/HTMLScript

mSQL User's Guide

mySQL User's Guide

PostgreSQL User's Guide

CGI Scriptorium

Server Add-ons


BOOKS TO HELP YOU:

The Data Webhouse Toolkit
The Data Webhouse Toolkit : Building the Web-Enabled Data Warehouse

$34.99

Amazon.com logo
Search for :
Enter keywords...