Difference between revisions of "Replikwando/Installation"

From ISoft Wiki
Jump to navigationJump to search
(lolassumptions)
(Moving page to another namespace)
 
(26 intermediate revisions by 5 users not shown)
Line 1: Line 1:
==Windows Server==
#REDIRECT [[Internal:Replikwando/Installation]]
 
Service version of Replikwando, which will backup database in case of hard drive failure in addition to updating inventory on heavytruckparts.net automatically.
 
-Need SSL keys from Brian
 
#Connect to server thru VNC
#Create Replikwando account on [http://www.heavytruckparts.net/tools/rreport.php Replikwando Records] website
#:Update Kungfu to show the new HTP account informatoin
#Download Replikwando Install pack from [http://tools.isoftdata.com tools.isoftdata.com]
#Copy certificates over to C:\Program Files\Isoft Data Systems\Certificates
#Run "install as service" bat file
#Edit Replication.ini file
##Check sqlyog that the following matches the clients:
##:Use frontend to check the username and password
##:[fromServer]
##:Host
##:Database
##:Username
##:Password
##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 (Can be found Replikwando Records)
##Set prefix = company name
##:Copy company name from certs, everything before -cert
##:Ex. for ABC-Company-cert  prefix=ABC-Company
#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
##in command prompt:
##:net stop mysql
##:net start mysql
#Set up Task Schedule to run Replikwando once after business hours.
#:Only need to set up schedule if installing during business hours so that you don't lock up clients database
#Tell Brian user and Product code so he can set up triggers on HTP.net
 
*Note: Replikwando will lock up the entire database during the initial push, so it may be a good idea to run it at the end of the work day.
 
==Linux Sever==
 
Replikwando on Linux using Wine
 
#Connect to the customer's server using sftp (it's a *nix app, may need to install Cygwin-X)
#:Do `put “Replikwando with Wine.tar.gz” .` to put the install files on their server
#:You can also put the customer's key and cert now, as well
#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.
#:Put in the required values for replication.ini
#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':
# start replikwando
#sudo -H -u isoft /home/isoft/replikwando_startup.sh
#Done!
<br>
*Some quick tips:<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!
: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.
:All normal Replikwando caveats apply (initial push db lock, query error logs, so on so forth)
 
If you have any additional questions, ask Justin.
 
[[Category:Replikwando]]
[[Category:ITrack/Support]]

Latest revision as of 16:36, 8 December 2011