Toolpack prerequisite Windows XP 2-5
From TBwiki
(Difference between revisions)
(Adding max_allowed_packet to mysqld to support bigger binary blobs) |
(→Toolpack System Database) |
||
| (23 intermediate revisions by 9 users not shown) | |||
| Line 1: | Line 1: | ||
| − | This page shows the Toolpack 2-5 prerequisites for Windows XP. | + | This page shows the Toolpack 2-5, 2-6, 2-7 prerequisites for Windows XP. |
== Toolpack Prerequisite == | == Toolpack Prerequisite == | ||
| + | |||
| + | <span style="color:#B22222">'''WARNINGS:'''</span> | ||
| + | * <span style="color:#B22222">Do not run toolpack with a mySQL server version other than 5.1. There are known problems with other versions and Toolpack.</span> | ||
| + | * <span style="color:#B22222">Do not run toolpack with a ODBC connector other than 3.51, as other versions (such as 5.2) are known to cause memory leak or other problems running Toolpack.</span> | ||
| Line 8: | Line 12: | ||
The software listed below is required by the host machines. | The software listed below is required by the host machines. | ||
| − | 1) Go to http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/ | + | 1) Go to TelcoBridges download site and get: |
| − | + | http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/iconv-1.9.2.win32.zip | |
| − | + | http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/libxml2-2.7.3.win32.zip | |
| − | + | http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/zlib-1.2.3.win32.zip | |
2) Decompress and copy the DLL files to C:\Windows\System32 | 2) Decompress and copy the DLL files to C:\Windows\System32 | ||
| − | + | iconv.dll | |
| − | + | libxml2.dll | |
| − | + | zlib1.dll | |
==== MSVC8 Redistributable ==== | ==== MSVC8 Redistributable ==== | ||
| − | If you plan on using TBToolPack-x.y.zz-<b>msvc8</b>-Setup.exe, then you need to install the following: | + | If you plan on using TBToolPack-x.y.zz-<b>msvc8</b>-Setup.exe, then you need to apply all windows updates from MicroSoft AND install the following: |
[http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/vcredist_x86.exe Microsoft MSVC8 Redistributables 8.0.50727.4053 after kb973923 automatic update] | [http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/vcredist_x86.exe Microsoft MSVC8 Redistributables 8.0.50727.4053 after kb973923 automatic update] | ||
| + | |||
| + | [http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/vcredist_msdev2005_x86_KB2467175.exe Microsoft MSVC8 Redistributables 8.0.50727.5592 after kb2467175 automatic update] | ||
=== Toolpack System Database === | === Toolpack System Database === | ||
| − | The Toolpack system database is used by the main host and requires mySQL database server version 5.1 | + | The Toolpack system database is used by the main host and requires mySQL database server version 5.1, and ODBC driver 3.51. It can be downloaded from the following location: |
| + | |||
| + | 1) Go to TelcoBridges download site and get: | ||
| + | http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/mysql-5.1.56-win32.msi | ||
| + | |||
| − | + | <span style="color:#B22222"> | |
| + | '''*** WARNING: Do not run toolpack with a mySQL server version other than 5.1. There are known problems with other versions and Toolpack.''' | ||
| + | </span> | ||
2) Install MySQL 5.1 | 2) Install MySQL 5.1 | ||
| Line 41: | Line 53: | ||
*Log in mysql and create a new user with priviledge | *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 | 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 | 4) Install Mysql ODBC driver | ||
| − | *Get and install Mysql ODBC connector | + | *Get and install Mysql ODBC connector at: |
| + | http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/mysql-connector-odbc-3.51.27-win32.zip | ||
*Install Mysql ODBC connector | *Install Mysql ODBC connector | ||
| + | |||
| + | <span style="color:#B22222"> | ||
| + | '''*** WARNING: Do not run toolpack with a ODBC connector other than 3.51, as other versions (such as 5.2) are known to cause memory leak or other problems running Toolpack.''' | ||
| + | </span> | ||
5) Enable mysql database replication | 5) Enable mysql database replication | ||
*Open configuration file at location similar to c:\Program Files\MySQL\MySQL Server 5.1\my.ini | *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: | *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. | 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 | + | Make sure it is in the [mysqld] section AND [mysqldump] section (create the [mysqldump] section if it doesn't exist) |
| − | + | max_allowed_packet = 200MB | |
Example: | 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 | 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. | + | 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 or C:\ProgramData\MySQL\MySQL Server 5.1\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 | 7) Restart the mysql service | ||
| − | net stop | + | net stop MySQL |
| − | net start | + | net start MySQL |
*Warning: You may have a different service name in your system (ex. MySQL51, MySQL50, etc.). To open the service control panel, run: | *Warning: You may have a different service name in your system (ex. MySQL51, MySQL50, etc.). To open the service control panel, run: | ||
services.msc | services.msc | ||
| Line 103: | Line 120: | ||
1) Install Ruby | 1) Install Ruby | ||
| − | *Go to http:// | + | *Go to TelcoBridges download site and get: |
| − | *Install Ruby 1.8. | + | http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/ruby186-27_rc2.exe |
| + | *Install Ruby 1.8.6, check the option "Enable RubyGems", make sure the ''Add Ruby Executable to your path'' option is checked | ||
2) Install Mongrel using the following commands. | 2) Install Mongrel using the following commands. | ||
*gem install mongrel --include-dependencies | *gem install mongrel --include-dependencies | ||
*choose option 4. mongrel 1.1.5 (x86-mswin32-60) | *choose option 4. mongrel 1.1.5 (x86-mswin32-60) | ||
| + | 3) Install additional ruby gems | ||
| + | * gem install json | ||
=== Toolpack Stream Server === | === Toolpack Stream Server === | ||
| Line 120: | Line 140: | ||
=== Toolpack Development Prerequisite === | === Toolpack Development Prerequisite === | ||
| − | + | ==== Cygwin ==== | |
| + | Telcobridges source package is compiled using unix Make application. For this you need to install Cygwin (Linux API layer for Windows). | ||
| + | |||
| + | 1) install the latest release of cygwin. | ||
| + | http://www.cygwin.com/ | ||
| + | |||
| + | 2) The "make" package must be manually selected, it is not part of the standard cygwin installation. | ||
| + | *In the installer view, change to the "Full" view, search for the "make" package, click to install the latest version. | ||
| + | |||
| + | ==== MSDEV ==== | ||
| + | The Makefiles uses Visual Studio C++ compiler and linker. '''The result compiled code has no dependency on the cygwin.dll library.''' | ||
| + | |||
| + | The following Microsoft Visual Studio product could be be installed: | ||
| + | * Visual Studio 6.0 (1998) - MSVC6 | ||
| + | * Visual Studio 2005 - MSVC8 | ||
| + | |||
| + | ==== Folder "BashPrompt" Menu item ==== | ||
| + | This small registry entry will add a folder command to the Explorer application. This helper command can be used by right-clicking on a folder where you want to launch a compilation, it will open a console window and setup the proper compiling environment. | ||
| + | |||
| + | For Visual Studio 6.0 user, create a file named "BashPrompt1998.reg" with the following content: | ||
| + | |||
| + | <pre> | ||
| + | Windows Registry Editor Version 5.00 | ||
| + | [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt1998] | ||
| + | [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt1998\command] | ||
| + | @="cmd.exe /k pushd \"%L\" && \"C:\\Program Files\\Microsoft Visual Studio\\VC98\\Bin\\VCVARS32.BAT\" && bash" | ||
| + | </pre> | ||
| + | |||
| + | *Make sure the path is the same as your installation path. | ||
| + | *Double click on the file to install in the registry. | ||
| + | |||
| + | For Visual Studio 2005 user, create a file named "BashPrompt2005.reg" with the following content: | ||
| + | |||
| + | <pre> | ||
| + | Windows Registry Editor Version 5.00 | ||
| + | [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt2005] | ||
| + | [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt2005\command] | ||
| + | @="cmd.exe /k pushd \"%L\" && \"C:\\Program Files\\Microsoft Visual Studio 8\\VC\\Bin\\VCVARS32.BAT\" && bash" | ||
| + | </pre> | ||
| + | |||
| + | *Make sure the path is the same as your installation path. | ||
| + | *Double click on the file to install in the registry. | ||
| + | |||
| + | ==== Environment variable ==== | ||
| + | To finalize the compiling environment, you must set the following system variable environment ('''Start->Settings->Control Panel->System->Advanced Tab->Environment variables'''): | ||
| + | |||
| + | 1) add the following path to the "PATH" environment variable, each is separated by a semi-column (;) | ||
| + | * C:\cygwin\bin; | ||
| + | * C:\Ruby\bin; | ||
| + | |||
| + | 2) add the following variable: | ||
| + | {| cellpadding="5" border="1" class="wikitable" | ||
| + | |- | ||
| + | ! width="80" style="background: none repeat scroll 0% 0% rgb(255, 255, 255);" | Name | ||
| + | ! width="80" style="background: none repeat scroll 0% 0% rgb(255, 255, 255);" | Value | ||
| + | |- | ||
| + | ! width="80" style="background: none repeat scroll 0% 0% rgb(255, 255, 255);" | MAKE_MODE | ||
| + | ! width="80" style="background: none repeat scroll 0% 0% rgb(255, 255, 255);" | unix | ||
| + | |} | ||
== Validation Guide (Optional) == | == Validation Guide (Optional) == | ||
| Line 128: | Line 206: | ||
== Toolpack System installation == | == Toolpack System installation == | ||
| − | Now that the prerequisite are installed, now it is time to install the [[ | + | Now that the prerequisite are installed, now it is time to install the [[Toolpack_installer_2-4|Toolpack system]] |
Latest revision as of 06:54, 1 May 2019
This page shows the Toolpack 2-5, 2-6, 2-7 prerequisites for Windows XP.
Contents |
Toolpack Prerequisite
WARNINGS:
- Do not run toolpack with a mySQL server version other than 5.1. There are known problems with other versions and Toolpack.
- Do not run toolpack with a ODBC connector other than 3.51, as other versions (such as 5.2) are known to cause memory leak or other problems running Toolpack.
Toolpack Basic packages
The software listed below is required by the host machines.
1) Go to TelcoBridges download site and get:
http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/iconv-1.9.2.win32.zip http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/libxml2-2.7.3.win32.zip http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/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 apply all windows updates from MicroSoft AND install the following:
Microsoft MSVC8 Redistributables 8.0.50727.4053 after kb973923 automatic update
Microsoft MSVC8 Redistributables 8.0.50727.5592 after kb2467175 automatic update
Toolpack System Database
The Toolpack system database is used by the main host and requires mySQL database server version 5.1, and ODBC driver 3.51. It can be downloaded from the following location:
1) Go to TelcoBridges download site and get:
http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/mysql-5.1.56-win32.msi
*** WARNING: Do not run toolpack with a mySQL server version other than 5.1. There are known problems with other versions and Toolpack.
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
- Get and install Mysql ODBC connector at:
http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/mysql-connector-odbc-3.51.27-win32.zip
- Install Mysql ODBC connector
*** WARNING: Do not run toolpack with a ODBC connector other than 3.51, as other versions (such as 5.2) are known to cause memory leak or other problems running Toolpack.
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 (create the [mysqldump] section if it doesn't exist)
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 or C:\ProgramData\MySQL\MySQL Server 5.1\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 MySQL net start MySQL
- 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
- Go to TelcoBridges download site and get:
http://download.distribution.telcobridges.com/3rdparty/prerequisite/bin/windows/ruby186-27_rc2.exe
- Install Ruby 1.8.6, check the option "Enable RubyGems", make sure the Add Ruby Executable to your path option is checked
2) Install Mongrel using the following commands.
- gem install mongrel --include-dependencies
- choose option 4. mongrel 1.1.5 (x86-mswin32-60)
3) Install additional ruby gems
- gem install json
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
Cygwin
Telcobridges source package is compiled using unix Make application. For this you need to install Cygwin (Linux API layer for Windows).
1) install the latest release of cygwin. http://www.cygwin.com/
2) The "make" package must be manually selected, it is not part of the standard cygwin installation.
- In the installer view, change to the "Full" view, search for the "make" package, click to install the latest version.
MSDEV
The Makefiles uses Visual Studio C++ compiler and linker. The result compiled code has no dependency on the cygwin.dll library.
The following Microsoft Visual Studio product could be be installed:
- Visual Studio 6.0 (1998) - MSVC6
- Visual Studio 2005 - MSVC8
Folder "BashPrompt" Menu item
This small registry entry will add a folder command to the Explorer application. This helper command can be used by right-clicking on a folder where you want to launch a compilation, it will open a console window and setup the proper compiling environment.
For Visual Studio 6.0 user, create a file named "BashPrompt1998.reg" with the following content:
Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt1998] [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt1998\command] @="cmd.exe /k pushd \"%L\" && \"C:\\Program Files\\Microsoft Visual Studio\\VC98\\Bin\\VCVARS32.BAT\" && bash"
- Make sure the path is the same as your installation path.
- Double click on the file to install in the registry.
For Visual Studio 2005 user, create a file named "BashPrompt2005.reg" with the following content:
Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt2005] [HKEY_CLASSES_ROOT\Folder\shell\BashPrompt2005\command] @="cmd.exe /k pushd \"%L\" && \"C:\\Program Files\\Microsoft Visual Studio 8\\VC\\Bin\\VCVARS32.BAT\" && bash"
- Make sure the path is the same as your installation path.
- Double click on the file to install in the registry.
Environment variable
To finalize the compiling environment, you must set the following system variable environment (Start->Settings->Control Panel->System->Advanced Tab->Environment variables):
1) add the following path to the "PATH" environment variable, each is separated by a semi-column (;)
- C:\cygwin\bin;
- C:\Ruby\bin;
2) add the following variable:
| Name | Value |
|---|---|
| MAKE_MODE | unix |
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
