Difference between revisions of "Replikwando/Installation"

From ISoft Wiki
Jump to: navigation, search
(Another one bites the dust)
Line 1: Line 1:
== Server Side ==
+
Service version of Replikwando, which will backup database in case of hard drive failure in addition to updating inventory on heavytruckparts.net automatically.
# Create a database on Fonseca where the database name equals the customer's product code
 
# Create a '''MySQL user''' for the customer
 
# Setup full privileges for that user to access the the database just created
 
# Go to the '''mysql''' database and give the user '''"Super" privileges''' in the '''user table'''
 
# Run the '''flush privileges''' query.
 
  
== Client Side ==
+
-Need SSL keys from Brian
# Turn on '''binary logging'''
 
## Open the my.ini ('''C:\Program Files\mysql\MySQL Server 5.x''') and enter '''log-bin''' under the '''mysqld''' section
 
## Beneath the '''log-bin''' line, enter the line '''expire-logs-days=10'''
 
## Restart the mysql service
 
# Download Replikwando from [http://dl.isoftdata.com dl.isoftdata.com]
 
# Place the files in '''"C:\ISoft Data Systems\Replikwando\"'''
 
# Open '''Replication.ini''' and change '''binologpath''' and '''mysqlbinpath''' if needed.
 
# Setup the '''[todatabase1]''' section to correspond to the server side setting just setup (host should be '''backup.isoftdata.com''', '''port: 3306''')
 
# Save '''replication.ini'''
 
# Make sure Replikwando is set to run when the user logs into Windows
 
# Create a Replikwando shortcut in '''C:\Documents and Settings\All Users\Start Menu\Programs\Startup'''
 
  
== Finishing Up==
+
#Connect to server thru VNC
* Check the server side database to confirm things are getting replicated
+
#Create Replikwando account on [http://www.heavytruckparts.net/tools/rreport.php Replikwando Records] website
* Continually check the [http://www.heavytruckparts.net/tools/rreport.php Replikwando Records] page to make sure nothing has broken.
+
#:Update Kungfu to show the new HTP account informatoin
 +
#Download Replikwando Install pack from [http://dl.isoftdata.com dl.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 ARA-Truck-Parts-cert  prefix=ARA-Truck-Parts
 +
#Edit my.ini file (C:\Program Files\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.
 
*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.
  
 
[[Category:Replikwando]]
 
[[Category:Replikwando]]

Revision as of 14:19, 14 August 2009

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

  1. Connect to server thru VNC
  2. Create Replikwando account on Replikwando Records website
    Update Kungfu to show the new HTP account informatoin
  3. Download Replikwando Install pack from dl.isoftdata.com
  4. Copy certificates over to C:\Program Files\Isoft Data Systems\Certificates
  5. Run "install as service" bat file
  6. Edit Replication.ini file
    1. Check sqlyog that the following matches the clients:
      Use frontend to check the username and password
      [fromServer]
      Host
      Database
      Username
      Password
    2. 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
    3. Set database = product code (Can be found Replikwando Records)
    4. Set prefix = company name
      Copy company name from certs, everything before -cert
      Ex. for ARA-Truck-Parts-cert prefix=ARA-Truck-Parts
  7. Edit my.ini file (C:\Program Files\MySQL\MySQL server 5.1\my.ini)
    1. Add the following under [mysqld]:
      log-bin
      expire-logs-days=10
  8. Stop and Start the MySQL service
    Either
    1. Restart service in control panel -> Admin tools -> services
    2. in command prompt:
      net stop mysql
      net start mysql
  9. 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
  10. 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.