|
|
| (16 intermediate revisions by 3 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 %PROGRAMFILES%\Isoft Data Systems\Certificates
| |
| #Edit Replication.ini file
| |
| ##Check sqlyog that the following matches the clients:
| |
| ##:Use frontend to check the username and password (like, not Duff's converter, but the thing you can find on File)
| |
| ##:[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
| |
| ##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)
| |
| ##[ssl]
| |
| ##:Set path = path to the folder where the SSL Certificates are stored
| |
| ##:Set prefix = company name
| |
| ##:Copy company name from certs, everything before -cert
| |
| ##:Ex. for ABC-Company-cert 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)
| |
| #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 (see above)
| |
| #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)
| |
| | |
| After the initial push, be sure to copy over functions and stored procedures as necessary, as replikwando doesn't do this automatically.
| |
| | |
| If you have any additional questions, ask Justin.
| |
| | |
| [[Category:Replikwando]]
| |
| [[Category:HeavyTruckParts.net]]
| |
| [[Category:ITrack/Support]]
| |
