We-Host.com Main Web Site
Web Development
Support

Installing Options/Software
mSQL
mSQL Database
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 your Virtual Server.

Additional information about mSQL can be obtained at the mSQL web site or from the mSQL FAQ.

We-Host is pleased to announce that there is currently no cost for use of mSQL- it is provided to our Virtual Server Administrators free of charge (no installation fee or monthly fees). We-Host has obtained a fully site-licensed version of the mSQL database version 2.0.3 for our Virtual Servers. Therefore, you need not purchase an individual license for mSQL insofar as you use mSQL on our Virtual Server Systems.

Installing mSQL v2.0.3
Please use the steps delimited below as your guideline to install mSQL v2.0.3. 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 relshow2

    Some "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 programmatic 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

Contents Copyright 1997-2003  We-Host Web Hosting. See our copyright page for additional copyright and disclaimer information.

Last Updated: 11 June, 2000  · Email support web site errors to webmaster@we-host.com

We-Host Web Hosting