en:synchro
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| en:synchro [2026/09/22 04:18] – administrator | en: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. | ||
| Line 20: | 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, | + | |
| + | Skip tables = input the tables that you do not want to sync, separate tables by commas e.g. ngattach, ngattachdtl, | ||
| 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 | ||
| Line 41: | 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. | ||
| Line 52: | 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 57: | 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, | - If no error found after verification, | ||
| + | |||
| - If error found, need to ‘Build’ database from beginning. | - If error found, need to ‘Build’ database from beginning. | ||
| Line 63: | Line 81: | ||
| - 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, | + | - Log file size is limited to 10M. |
| + | |||
| + | If exceed 10M, system will automatic create a new log file e.g. synchro.log, | ||
| + | |||
| + | 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.1790050685.txt.gzip · Last modified: by administrator