|
mSQL,
or Mini SQL, is a lightweight database engine created to allow fast
support and access of stored data without requiring large amounts
of memory. This database engine provides a powerful capability for
accessing databases within the Virtual Server environment.
The
mSQL package includes the powerful database engine, a terminal "monitor"
program, a database admin program, a schema viewer, and a C language
API. The API and the database engine have both been designed to
work in a client/server environment over a TCP/IP network. This
makes mSQL the ideal database for operating within our Virtual Server
enviroment.
Additional
information about mSQL can be obtained at the mSQL web site (http://www.Hughes.com.au/)
or
from the mSQL FAQ:
(http://www.Hughes.com.au/library/msql1/faq.htm)
Installing mSQL v3.0
If
you are a web hosting customer, please contact 
we will do the install of mSQL for you, there is a one time set
up fee of $150.00 please allow 24 to 48 hours . If you are a Virtual
Server administrator, please refer to the documentaion below and
there is no set up fee because you will be doing this yourself.
If you were using a previous version of mSQL (v1.0.x), you will
want to pay careful attention to the instructions below as they
explain the additional steps needed to upgrade to mSQL v2.0.3.
1. Connect to your Virtual Server using Telnet or SSH and run the
mSQL version 2 installation script by typing:
installmsql2
The mSQL version 2 installation script will perform the following
tasks:
* Create a "~/msql2db" directory (and a "~/msql2db/.tmp" directory)
* Determine if you have msql version 1.0.x installed. If you do
have msql version 1.0.x installed, the mSQL version 2 installation
script will attempt to convert your existing database files to version
2.x database format. Note: the script will not destroy your version
1.0.x database directory, "~/msqldb".
* Create a msql.acl file with some "intelligent" defaults.
2. Version 2.0 of mSQL uses different command-line commands than
version 1.0.x of mSQL. The following table summarizes the differences:
mSQL v1.0.x mSQL v2.x
msql msql2
msqladmin msql2admin
msqldump msql2dump
relshow relshow2Some "aliases" will also be created in your "~/.cshrc"
file to help you remember. You will need to do the following at
the command prompt before these aliases take affect:
source ~/.cshrc
You
only need to do this the first time. When you log in again the changes
will be in effect.
3. Your version 2.0 databases are stored in your "~/msql2db" directory.
You will eventually want to remove the mSQL v1.0.x directory "~/msqldb"
manually when you are certain the upgrade worked. You can do this
by typing the following at a command prompt:
rm -rf ~/msqldb
Make sure your databases are working correctly before doing this.
4. Customers upgrading from version 1.0.x will need to also upgrade
their mSQL client interfaces. You will note that we have replaced
all the client interfaces in the "/usr/local/contrib" directory
with mSQL v2.x equivalents. These files include the "w3-msql.tar",
"php-2.0-msql_logging.tar", and "perl5.004.tar" files. You will
notice that the mSQL v1.0.x tar files are still available in the
"/usr/local/contrib/msql1". Please note that the only Perl5 tar
file archive that includes support for mSQL v2.x is the "perl5.004.tar"
tar archive.
W3-mSQL: The mSQL WWW Interface Package
W3-mSQL
provides a programatic interface to the mSQL database system from
within an HTML document. It enables the development of entire programs
within a WWW page while offering comprehensive access control and
security features.
W3-mSQL achieves this by providing a complete programming language
embedded within an HTML document. The language, called Lite, is
similar is style and syntax to the C programming language and the
ESL scripting language. Using W3-mSQL and the embedded Lite language,
you can generate HTML code "on-the-fly" in the same way you do when
you write custom CGI programs. What's more, you can mix normal HTML
code with W3-mSQL code so that you only need to use the CGI styled
approach where you actually have to.
To install W3-mSQL on your virtual server, connect to your Virtual
Server using Telnet or SSH and untar the W3-mSQL archive file into
your virtual server directory structure:
% cd (this will put you in your home directory)
% tar xvf /usr/local/contrib/w3-msql.tar
There is W3-mSQL documentation, including detailed examples, available
at the mSQL web site. A sample W3-mSQL application is also available
for installation on the virtual servers. You can install the simple
example by untarring an archive file onto your virtual server.
% cd (this will put you in your home directory)
% tar xvf /usr/local/contrib/w3-msql-demo.tar
Once the files are in place run the install script.
% cd ~/www/htdocs/bookmarks
% ./setup_bookmark
You can then access the Bookmark Database example at:
http://YOUR-DOMAIN.com/bookmarks/Welcome.html
|
