How do I setup my msql.acl?

When accessing an mSQL database from a CGI it is important to edit the msql.acl file that comes with the installation of mSQL 2.0 (type "installmsql2" in a telnet session to install mSQL 2.0). The msql.acl file is setup in the base directory for your virtual server (cd ~). Here is what it will look 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 http://www.Hughes.com.au/library/msql1/manual/#marker0100.