Computer House Home PageList of products and servicesDrivers, Utilities, Info and More!Learn more about Computer House

 How do I install mSQL?

 
Answer
 
There are 2 ways to install mSQL on your Computer House Virtual Server. You can do so via the Control Panel, or via telnet. The installation via the Control Panel is point and click and the installation via telnet will require you to configure the server, and the configurations of mSQL.

1. MSQL - Installation via the cpanel
  • Enter the Control Panel by going to http://yourdomain/cpanel/

  • Click on the "Install mSQL" link at the bottom of the page

  • This will install mSQL in the /usr/local/msql directory on your server.

  • You can now access your server via telnet to maintain the mSQL database.


2. MSQL - Installation via telnet

Before beginning:

  • Ensure you have the msql-2.0.5.tar.gz file.

  • Request telnet access from Computer House Technical Support


Installation:

  • FTP msql-2.0.5.tar.gz file to /usr/local/ on your domain.

  • Telnet into your account

  • TYPE cd

  • TYPE pwd
  • Record output i.e. /vs1/vs1/customer. Replace all instances of $HOME below with this output.
  • TYPE cd usr/local

  • TYPE tar -xzvf msql-2.0.5.tar.gz

  • TYPE cd msql-2.0.5

  • TYPE make target

  • TYPE cd targets/Linux[*]

  • TYPE ./setup

  • VI site.mm (edit the file)

  • Make these modifications:
    INST_DIR="$HOME/usr/local/msql"
    PID_DIR="$HOME/usr/local/msql/pid"


  • VI /conf/mmap.c

  • Make the following modifications:
    Change Line 13 "/tmp/MmAp-Test"
    to "MmAp-Test"


  • TYPE mkdir $HOME/usr/local/msql

  • TYPE mkdir $HOME/usr/local/msql/pid

  • TYPE export TMP=$HOME/tmp

  • TYPE make all

  • TYPE make install (** check on the license agreement **)


  • TYPE cd $HOME/usr/local/msql

  • VI msql.conf
    Change msql_user to your username
    Change Admin_user to your username


  • To Calculate TCP_Port:
    Get your IP address (i.e. 208.234.14.255)
    TCP_Port = 2 + 4 (last digit of 3rd quad) + 255 (last quad)

    208 234 14 255
    1st quad 2nd quad 3rd quad 4th quad
    Example: TCP_Port = 24255


  • TYPE $MYDIR/usr/local/msql/bin/msql2d &



**** Other than this information, Computer House Customer Service does not provide Technical Support for mSQL. Please refer to the Related Links below for further information.
 
Related Links
 
MSQL Database Support
http://www.hughes.com.au/library/

License
http://www.hughes.com.au/license/

Tutorial
http://www.blnet.com/msqlpc/tutorials.htm

Manual
http://www.hughes.com.au/library/msql2/manual/

FAQs
http://www.hughes.com.au/library/msql1/faq.htm

MSQL Homepage
http://www.hughes.com.au/
Back to Index

The Computer House Technology Center, Inc.
740 South Sixth Avenue
Galloway, New Jersey 08205
(800) 372-6834 --- FAX: (609) 748-9776

Copyright © 2001 Computer House, Inc. All Rights Reserved.