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

Next revision		Previous revision
en:synchro [2026/06/03 08:25] – created administratoren:synchro [2026/09/22 08:25] (current) – administrator
Line 1: Line 1:
-Synchro+=====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. 
 + 
 +2. Download mariadb-10.11 from internet and install it. 
 + 
 +3. Add/Modify below lines in my.ini. 
 + 
 +[mysqld] 
 +sql_mode=NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER 
 +max_allowed_packet = 128M 
 +  Connect_timeout = 86400 
 + 
 +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. 
 + 
 +6. Run Synchro.exe & set Configuration as below:- 
 + 
 +{{:en:synchro_manual_1.png?500|}} 
 + 
 +Company = database name 
 + 
 +Server IP = iGarment server IP (input the fastest ip no. in your factory location) 
 + 
 +Server Port = 7001 
 + 
 +User Name = login user name for Data Sync program (cannot include Chinese character) 
 + 
 +Password = if required (cannot include Chinese character) 
 + 
 +Encrypt Key = ‘n=’ value in id.co file 
 + 
 +Local Server IP = 127.0.0.1 
 + 
 +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) 
 + 
 +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. 
 + 
 +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 Position = system will automatic update this position number e.g. 318819 
 + 
 + 
 +7. Click ‘Build’ to create the database from beginning 
 + 
 +Message ‘Are you sure to rebuild database?’ will be shown. Click ‘Yes’. 
 + 
 +{{:en:synchro_manual_2.png?500|}} 
 + 
 +- 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. 
 +  
 +8. After database initialization is completed, click ‘Replicate’ to start the data sync process. 
 + 
 +{{:en:synchro_manual_3.png?500|}} 
 + 
 +9. If you want to verify tables, click Verify. 
 + 
 +{{:en:synchro_manual_4.png?500|}} 
 + 
 +- 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. 
 + 
 +{{:en:synchro_manual_5.png?500|}} 
 + 
 +- 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 error found, need to ‘Build’ database from beginning. 
 + 
 +10. Automatic upgrade data sync program 
 + 
 +- Update.exe and update.ini are added 
 + 
 +[Configuration] 
 + 
 +Product=synchro 
 + 
 +Force=1 
 + 
 +If Force is set to 1, it means that you must upgrade the program before you can start the data sync process. 
 + 
 +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 
 +  
 +Internal Note: 
 +-For iWorkPMS customers, below error will be found when ‘Build’. 
 + 
 +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’. 
 + 
en/synchro.1780475144.txt.gzip · Last modified: by administrator