Difference between revisions of "Replikwando/Installation"

From ISoft Wiki
Jump to navigationJump to search
(Moving page to another namespace)
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Windows Server==
#REDIRECT [[Internal:Replikwando/Installation]]
 
Service version of [[Replikwando]], which will copy a customers database to ISoft's server so their inventory can eventually be updated on heavytruckparts.net.
 
#Connect to the server thru VNC
#Check their local itrackpro/itrackenterprise database for their company produce code (companyinfo.productcode or settings.location=CompanyInfo) and use it when creating their account
#Create Replikwando account on [http://www.heavytruckparts.net/tools/rreport_addaccount.php Replikwando Records - Add New Company] website
#:Update Kungfu to include the new HTP account information
#Download Replikwando Install pack from [http://tools.isoftdata.com tools.isoftdata.com]
#Copy SSL Certificates over to %PROGRAMFILES%\Isoft Data Systems\Certificates
#:SSL Certs can be found in <svndir>\itrack2\trunk\Certificates\<companyname>-cert.  If certs don't exist for the company, ask Dayton or Brian to generate them.
#[[#Configuring the replication.ini file|Edit Replication.ini file]]
#Edit my.ini file (default location %PROGRAMFILES%\MySQL\MySQL server 5.1\my.ini)
##Add the following under [mysqld]:
##:log-bin
##:expire-logs-days=10
#Stop and Start the MySQL service
#:Either
##Restart service in control panel -> Admin tools -> Services
##:OR
##in command prompt:
##:sc stop mysql
##:sc start mysql
#Run replikwando_service_install.bat
#:This will install replikwando as a service and start it up (which does NOT start the initial push immediately)
#:If you wish to do an initial push sooner, use the Replikwando Message Interface
#:If the service fails to start, but Replikwando2 (the GUI version of replikwando) works fine, then change the user the service runs as to one with permissions to run
 
==Linux Sever==
 
Replikwando on Linux using Wine
 
#Connect to the customer's server using sftp (Filezilla and others support this, and it comes with cygwin and linux)
#:Do `put “Replikwando with Wine.tar.gz” .` to put the install files on their server
#:You should also put the customer's key and cert over as well (ca-cert.pem is included in the gz)
#Connect to the customer's server using SSH/putty
#:Extract the files using `tar -zxf “Repikwando with Wine.tar.gz”`
#:If that fails, use `gunzip “Replikwando with Wine.tar.gz”`, `tar -xf “Replikwando with Wine.tar”
#You will now have two new files in your directory, replikwando_install.sh and ISoft/*
#:Type ./replikwando_install.sh
#:Depending on the system configuration, several prompts may show up.  Just read them and follow what they tell you to do.
#:The script will tell you when it is done running.
#Navigate to ~/.wine/drive_c/Program\ Files/Replikwando
#:This directory will contain the error logs, sqlite file, and so on when Replikwando is started.
#:Put in the required values for replication.ini (see above)
#Type `vi replication.ini` to edit the replication file`
#*This is a long section, found [[#Configuring the replication.ini file|lower down]]
#Type ~/replikwando_startup.sh to start Replikwando for the first time.
#:Confirm that Replikwando is running correctly using the error logs here
#:Type `vi <filename>` to open the file in an editor to read it.  Type :q<enter> to quit.
#To connect to the mysql server, type `mysql -utestuser -hlocalhost -p`
#:You'll have to type a 'use <database>' command before running queries
#Once Replikwando is confirmed running, type `sudo vi /etc/rc.local` and place the following lines just above the last line that says 'exit 0':
#:<nowiki># start replikwando</nowiki>
#:<nowiki>sudo -H -u isoft /home/isoft/replikwando_startup.sh</nowiki>
#Done!
<br>
Quick linux commands:
*ls : shows you what is in the directory
*sudo : lets you run powerful & dangerous commands (requires password)
*cd : change directory
*rm : deletes a file (use rm -r to delete a folder)
**deletes cannot be undone!<br>
You can't open Replikwando's UI to see if it's pushing data, so you have to rely on the error logs and test database changes.<br>
All normal Replikwando caveats apply (initial push db lock, query error logs, so on so forth)
 
== Configuring the replication.ini file ==
Use ITEncrypter Frontend.exe to generate an encrypted username and password (Get it from File::Tech Support)
#[FromServer]
#:Host
#:Database
#:Username
#:Password
#:binlogpath - Should be the path to their MySQL 'data' directory
#:mysqlbinpath - Should be the path to their MySQL 'bin' directory
#:blacklist_count=<number of blacklisted tables>
#:blacklist<n>=<table_name>
#:graylist_count=<number of graylisted tables>
#:graylist<n>=<table_name>
#Set Username and Password for [ToDatabase] with same account info setup on Replikwando Records
#:Use Frontend to convert pass to hash
#:Add "Z" in front of hash
#Set database = product code (Company product code can be found in their companyinfo table.  If one doesn't exist there, you can create a new one when you create their account.)
#[SSL]
#:Set path = path to the folder where the SSL Certificates are stored
#:Set prefix = everything before -cert
#*:Ex. for ABC-Company-cert.pem, prefix=ABC-Company
#[Heartbeat]
#:Set the Process ID (for heartbeat) to the company's product code
#Set use_compression=True if the connection uses the internet, False if it's on the local network (or same machine)
 
If you have any additional questions, ask Justin.
 
[[Category:Replikwando]]
[[Category:HeavyTruckParts.net]]
[[Category:ITrack/Support]]

Latest revision as of 16:36, 8 December 2011