Internet Servers - iServer Virtual Servers for Reseller Hosting

iServer Virtual Servers

iServer Virtual Server Extensions
iServer Electronic Commerce ComponentsiServer Electronic Commerce Components
Remotely manage your web site with iManager & iRootRemotely manage your web site with iManager & iRoot
Partition your Virtual Server into multiple Virtual HostsPartition your Virtual Server into multiple Virtual Hosts
Generate statistical reports of your web site traffic using WebTrendsGenerate statistical reports of your web site traffic using WebTrends
Web Publishing using HTTP PUTWeb Publishing using HTTP PUT
Remotely author your web site content with Microsoft FrontPageRemotely author your web site content with Microsoft FrontPage
Map your Virtual Server to you Windows 95/NT DesktopMap your Virtual Server to you Windows 95/NT Desktop
Add security to your Virtual Server with Secure Socket Layer (SSL)Add security to your Virtual Server with Secure Socket Layer (SSL)
Create and manage databases with mSQLCreate and manage databases with mSQL
Create and manage databases with MySQLCreate and manage databases with MySQL
Create and manage databases with PostgreSQLCreate and manage databases with PostgreSQL
Add Real Audio/Video streaming capability to your Virtual ServerAdd Real Audio/Video streaming capability to your Virtual Server
Miva/Htmlscript: HTML based web development languageMiva/Htmlscript: HTML based web development language
PHP: HTML based web scripting languagePHP: HTML based web scripting language
Automate information dissemination using AutorespondersAutomate information dissemination using Autoresponders
Customize your Virtual Server to handle any MIME typeCustomize your Virtual Server to handle any MIME type
Build and compile Java Applets using the Java Virtual MachineBuild and compile Java Applets using the Java Virtual Machine
Change passwords remotely using the poppassd serviceChange passwords remotely using the poppassd service
Schedule events to run at periodic intervals with cronSchedule events to run at periodic intervals with cron
Use the virtual finger service to look up user informationUse the virtual finger service to look up user information
Automatically reload daemons at system startup (RealServer, Ewgie, etc)Automatically reload daemons at system startup (RealServer, Ewgie, etc)
Step by step installation instructions for popular third party programsStep by step installation instructions for popular third party programs
iServer Home PageiServer Virtual ServersOrder Your iServer Virtual ServeriServer Technical SupportiServer Reseller ProgramSearch iServer Web Pages
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.

iServer 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). iServer 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 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



Return to the iServer Home Page Review copyright information Contact the iServer Staff Making Money as an iServer Reseller Order your iServer Virtual Server Hosting 12020 Virtual Servers and 60449 Domain Names, iServer is the world leader in Virtual Server Technology Perform a search on the iServer Web Site General information about iServer and iServer web site navigation help Lost? ...View our Web Site Map Rebuild this page (iServer Staff only) Gateway to iManager (iServer Staff only)      This web site is powered by iServer