iGarment Wiki

User Tools

Site Tools

Trace:
en:synchro

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:synchro [2026/09/22 04:14] – administratoren:synchro [2026/09/22 08:25] (current) – administrator
Line 1: Line 1:
-====Data Sync Server Installation Manual====+=====Data Sync Server Installation Manual=====
 1. Recommend to use a dedicated computer for Data Sync server. Suggest to use SSD hard disk instead of HDD. 1. Recommend to use a dedicated computer for Data Sync server. Suggest to use SSD hard disk instead of HDD.
 +
 2. Download mariadb-10.11 from internet and install it. 2. Download mariadb-10.11 from internet and install it.
 +
 3. Add/Modify below lines in my.ini. 3. Add/Modify below lines in my.ini.
 +
 [mysqld] [mysqld]
 sql_mode=NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER sql_mode=NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
 max_allowed_packet = 128M max_allowed_packet = 128M
   Connect_timeout = 86400   Connect_timeout = 86400
 +
 4. Unzip the data sync programs provided by iGarment. 4. Unzip the data sync programs provided by iGarment.
 +
 5. Create folder \Company under \synchro folder & put your company’s id.co in this folder. 5. Create folder \Company under \synchro folder & put your company’s id.co in this folder.
 +
 6. Run Synchro.exe & set Configuration as below:- 6. Run Synchro.exe & set Configuration as below:-
  
Line 14: Line 20:
  
 Company = database name Company = database name
 +
 Server IP = iGarment server IP (input the fastest ip no. in your factory location) Server IP = iGarment server IP (input the fastest ip no. in your factory location)
 +
 Server Port = 7001 Server Port = 7001
 +
 User Name = login user name for Data Sync program (cannot include Chinese character) User Name = login user name for Data Sync program (cannot include Chinese character)
 +
 Password = if required (cannot include Chinese character) Password = if required (cannot include Chinese character)
 +
 Encrypt Key = ‘n=’ value in id.co file Encrypt Key = ‘n=’ value in id.co file
 +
 Local Server IP = 127.0.0.1 Local Server IP = 127.0.0.1
 +
 Local Username = root Local Username = root
 +
 Local Password = root password (If you have set root password when installing mariadb, you need to input the password here. If no password set, just leave this field blank) Local Password = root password (If you have set root password when installing mariadb, you need to input the password here. If no password set, just leave this field blank)
-Skip tables = input the tables that you do not want to sync, separate tables by commas e.g. ngattach, ngattachdtl, ngbackup, ngclicklog, ngdoclock, t_%,+ 
 +Skip tables = input the tables that you do not want to sync, separate tables by commas e.g. ngattach, ngattachdtl, ngbackup, ngclicklog, ngdoclock, t_% 
 Need to add ‘t_%’ in order to skip all temporary tables. Need to add ‘t_%’ in order to skip all temporary tables.
 +
 Verify tables = input the tables that you want to verify between local and SaaS database Verify tables = input the tables that you want to verify between local and SaaS database
 +
 Log File = system will automatic update this file name e.g. db135-master-log.062 Log File = system will automatic update this file name e.g. db135-master-log.062
 +
 Log Position = system will automatic update this position number e.g. 318819 Log Position = system will automatic update this position number e.g. 318819
 +
 +
 7. Click ‘Build’ to create the database from beginning 7. Click ‘Build’ to create the database from beginning
 +
 Message ‘Are you sure to rebuild database?’ will be shown. Click ‘Yes’. Message ‘Are you sure to rebuild database?’ will be shown. Click ‘Yes’.
  
Line 33: Line 55:
  
 - System will download the backup zip file (xxx.gz) to \archive folder. - System will download the backup zip file (xxx.gz) to \archive folder.
-- After download, system will unzip the backup file (xxx.db), then init database. + 
 +- After download, system will unzip the backup file (xxx.db), then init database. 
 + 
 8. After database initialization is completed, click ‘Replicate’ to start the data sync process. 8. After database initialization is completed, click ‘Replicate’ to start the data sync process.
  
Line 43: Line 67:
  
 - System will show the tables that you have inputted in Configuration with their corresponding log file and position. - System will show the tables that you have inputted in Configuration with their corresponding log file and position.
 +
 - Then click ‘Replicate’ after verify tables have been set. - Then click ‘Replicate’ after verify tables have been set.
  
Line 48: Line 73:
  
 - System will start the verification process when verify log file is reached. - System will start the verification process when verify log file is reached.
 +
 - If no error found after verification, it will show ‘OK’ under ‘Note’ column. - If no error found after verification, it will show ‘OK’ under ‘Note’ column.
 +
 - If error found, need to ‘Build’ database from beginning. - If error found, need to ‘Build’ database from beginning.
 +
 10. Automatic upgrade data sync program 10. Automatic upgrade data sync program
 +
 - Update.exe and update.ini are added - Update.exe and update.ini are added
 +
 [Configuration] [Configuration]
 +
 Product=synchro Product=synchro
 +
 Force=1 Force=1
 +
 If Force is set to 1, it means that you must upgrade the program before you can start the data sync process. If Force is set to 1, it means that you must upgrade the program before you can start the data sync process.
  
-Note:- +Note: 
-Log file size is limited to 10M. If exceed 10M, system will automatic create a new log file e.g. synchro.log, synchro.log.187, synchro.log.186 … etc. The latest log is synchro.log+- Log file size is limited to 10M.  
 + 
 +If exceed 10M, system will automatic create a new log file e.g. synchro.log, synchro.log.187, synchro.log.186 … etc.  
 + 
 +The latest log is synchro.log
    
-Internal Note:- +Internal Note: 
-For iWorkPMS customers, below error will be found when ‘Build’. +-For iWorkPMS customers, below error will be found when ‘Build’. 
-Error: Table ‘pyxxxxx.nguser’ doesn’t exist+ 
 +Error: Table ‘pyxxxxx.nguser’ doesn’t exist. 
 Need to manually create table ‘nguser’ in iWorkPMS database because iWorkPMS user table is ‘pyuser’. Create a login user in ‘nguser’. Need to manually create table ‘nguser’ in iWorkPMS database because iWorkPMS user table is ‘pyuser’. Create a login user in ‘nguser’.
  
  
en/synchro.1790050467.txt.gzip · Last modified: by administrator