Toolpack prerequisite Windows XP 2-5

From TBwiki
(Difference between revisions)
Jump to: navigation, search
(add a ruby installation check)
(Adding max_allowed_packet to mysqld to support bigger binary blobs)
Line 62: Line 62:
 
   log-bin
 
   log-bin
 
   server-id=[UniqueId]      <--- [UniqueId] must be a non-zero value, and must be unique when used one each host of an HA system
 
   server-id=[UniqueId]      <--- [UniqueId] must be a non-zero value, and must be unique when used one each host of an HA system
 +
 +
Add max_allowed_packet to increase the maximum size of binary blobs in the database.
 +
Make sure it is in the [mysqld] section AND [mysqldump] section
 +
  max_allowed_packet = 200MB
  
 
Example:
 
Example:
Line 73: Line 77:
 
   log-bin
 
   log-bin
 
   server-id=132
 
   server-id=132
 +
  max_allowed_packet = 200MB
 
   #
 
   #
 
   sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
 
   sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
Line 81: Line 86:
 
   tmp_table_size=18M
 
   tmp_table_size=18M
 
   thread_cache_size=8
 
   thread_cache_size=8
 +
 
 +
  [mysqldump]
 +
  max_allowed_packet = 200MB
  
 
6) Disable virus scanning  
 
6) Disable virus scanning  

Revision as of 14:19, 16 May 2011

This page shows the Toolpack 2-5 prerequisites for Windows XP.

Contents

Toolpack Prerequisite

Toolpack Basic packages

The software listed below is required by the host machines.

1) Go to http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/ and download: 

  iconv-1.9.2.win32.zip
  libxml2-2.7.3.win32.zip
  zlib-1.2.3.win32.zip

2) Decompress and copy the DLL files to C:\Windows\System32 

  iconv.dll
  libxml2.dll
  zlib1.dll

MSVC8 Redistributable

If you plan on using TBToolPack-x.y.zz-msvc8-Setup.exe, then you need to install the following:

Microsoft MSVC8 Redistributables 8.0.50727.4053 after kb973923 automatic update

Toolpack System Database

The Toolpack system database is used by the main host and requires mySQL database server version 5.1 or later. It can be downloaded from the following location:

1) Go to http://www.mysql.com/ and download MySQL Community Server 5.1 installer

2) Install MySQL 5.1

  • Choose complete installation
  • Run MySQL Server Instance Configuration Wizard. (You should be prompted to do so after selecting complete installation.)
  • Choose standard configuration
  • Install as a Windows service and check, Launch Automatically.
  • Choose Include Bin Directory in Windows PATH.
  • Enter a User Name and Password, and note them down on paper as you will need them later in the installation process.
  • Enable access from remote machines if you plan to run Tmedia Toolpack on more than one host machine.

3) Create new database user (tbdb) with all privilege access

  • Log in mysql and create a new user with priviledge 
 mysql -u root
 CREATE USER '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 GRANT ALL privileges ON *.* TO '[DatabaseUsername]'@'%' IDENTIFIED BY '[DatabasePassword]';
 exit

Example 

 mysql -u root
 CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 exit

4) Install Mysql ODBC driver

5) Enable mysql database replication

  • Open configuration file at location similar to c:\Program Files\MySQL\MySQL Server 5.1\my.ini
  • Add 2 new variable in the mysql config file, and make sure it is in the [mysqld] section: 
 log-bin
 server-id=[UniqueId]       <--- [UniqueId] must be a non-zero value, and must be unique when used one each host of an HA system

Add max_allowed_packet to increase the maximum size of binary blobs in the database. Make sure it is in the [mysqld] section AND [mysqldump] section 

 max_allowed_packet = 200MB

Example: 

 [mysqld]
 port=3306
 basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
 datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
 default-character-set=latin1
 default-storage-engine=INNODB
 # Enable mysql database replication
 log-bin
 server-id=132
 max_allowed_packet = 200MB
 #
 sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
 max_connections=100
 
 # section [mysqld_safe]
 table_cache=256
 tmp_table_size=18M
 thread_cache_size=8
 
 [mysqldump]
 max_allowed_packet = 200MB

6) Disable virus scanning

It is mandatory to disable the anti-virus software’s on access scan on the MYSQL database directory (generally C:\Program Files\MySQL\MySQL Server 5.0\data) and the Windows temporary directory(typically identified by the TEMP environmental variable), as this will prevent database backup operation to complete properly upon Toolpack System Update.

7) Restart the mysql service 

 net stop MySQL51
 net start MySQL51
  • Warning: You may have a different service name in your system (ex. MySQL51, MySQL50, etc.). To open the service control panel, run: 
 services.msc

Toolpack System Web Portal

1) Install Ruby

2) Install Mongrel using the following commands.

  • gem install mongrel --include-dependencies
  • choose option 4. mongrel 1.1.5 (x86-mswin32-60)

Toolpack Stream Server

The Tmedia Toolpack Stream Server requires WinPCAP 4.0 or later. It can be downloaded from the following location:

1) Go to http://www.winpcap.org/ and download WinPcap_4_0_2.exe

2) Install WinPCAP 4.0


Toolpack Development Prerequisite

Available soon.

Validation Guide (Optional)

If you would like to verify your installation go to the Toolpack Validation Guide


Toolpack System installation

Now that the prerequisite are installed, now it is time to install the Toolpack system

Retrieved from "https://docs.telcobridges.com/mediawiki/index.php?title=Toolpack_prerequisite_Windows_XP_2-5&oldid=9066"
Personal tools