View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006265 | SymmetricDS Pro | Bug | public | 2024-02-28 17:34 | 2024-02-29 21:46 |
| Reporter | emiller | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.12 | ||||
| Target Version | 3.14.13 | Fixed in Version | 3.14.13 | ||
| Summary | 0006265: Registration failing when registering node is remote and SMTP password is set to null in sym_parameter | ||||
| Description | When a node that is registering is remote from the registration server, and the SMTP password is set to null in sym_parameter, the loading of the registration batch on the remote server fails due to the following NullPointerException: org.jumpmind.symmetric.io.data.transform.TransformColumnException: Beanshell script error on line 2 for target column param_value on transform null at org.jumpmind.symmetric.io.data.transform.BshColumnTransform.transform(BshColumnTransform.java:161) at org.jumpmind.symmetric.io.data.transform.BshColumnTransform.transform(BshColumnTransform.java:53) at org.jumpmind.symmetric.io.data.writer.TransformWriter.transformColumn(TransformWriter.java:439) at org.jumpmind.symmetric.io.data.writer.TransformWriter.perform(TransformWriter.java:278) at org.jumpmind.symmetric.io.data.writer.TransformWriter.transform(TransformWriter.java:229) at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:174) at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:194) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:160) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:108) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1069) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1045) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.NullPointerException at org.jumpmind.security.SecurityService.encrypt(SecurityService.java:278) at com.jumpmind.symmetric.security.SmtpPasswordFilter.onSmtpPasswordSave(SmtpPasswordFilter.java:24) | ||||
| Steps To Reproduce | 1. Configure SMTP Mail Server authentication, defining the smtp password as null in sym_parameter 2. Create a remote node (remote from the registration server). 3. Registration will fail because of a null pointer exception in the remote node when attempting to load the registration batch. | ||||
| Tags | data sync, registration | ||||
|
|
The change I committed was for SymmetricDS Pro, but I was able to create a patch by adding the null check to TransformService.SMTP_PASSWORD_BSH instead of SmtpPasswordFilter: https://downloads.jumpmind.com/symmetricds/patches/3.14/patch-0006265.jar |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-02-28 17:34 | emiller | New Issue | |
| 2024-02-28 17:34 | emiller | Status | new => assigned |
| 2024-02-28 17:34 | emiller | Assigned To | => emiller |
| 2024-02-28 17:34 | emiller | Tag Attached: data sync | |
| 2024-02-28 17:34 | emiller | Tag Attached: registration | |
| 2024-02-28 17:34 | emiller | Issue generated from: 0006250 | |
| 2024-02-28 17:34 | emiller | Relationship added | related to 0006250 |
| 2024-02-28 17:53 | emiller | Target Version | => 3.14.13 |
| 2024-02-29 20:49 | emiller | Summary | Registration failing when registering node is remote and SMTP Mail Server authentication is configured => Registration failing when registering node is remote and SMTP password is set to null in sym_parameter |
| 2024-02-29 20:49 | emiller | Description Updated | View Revisions |
| 2024-02-29 20:49 | emiller | Steps to Reproduce Updated | View Revisions |
| 2024-02-29 20:49 | emiller | Relationship deleted | related to 0006250 |
| 2024-02-29 20:50 | emiller | Issue cloned: 0006268 | |
| 2024-02-29 20:50 | emiller | Relationship added | related to 0006268 |
| 2024-02-29 20:56 | emiller | Status | assigned => resolved |
| 2024-02-29 20:56 | emiller | Resolution | open => fixed |
| 2024-02-29 20:56 | emiller | Fixed in Version | => 3.14.13 |
| 2024-02-29 21:46 | emiller | Note Added: 0002416 | |
| 2024-03-19 16:20 | admin | Status | resolved => closed |