View Revisions: Issue #6265

Summary 0006265: Registration failing when registering node is remote and SMTP password is set to null in sym_parameter
Revision 2024-02-29 20:49 by emiller
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)
Revision 2024-02-28 17:34 by emiller
Description When a node that is registering is remote from the registration server, and SMTP Mail Server authentication is configured, the loading of the registration batch on the remote server fails.

The SmtpPasswordFilter is looking for parameter metadata for the smtp.password parameter in the open source default parameters, but should be looking for them in the Pro default parameters.

Also, the ParameterConstants class should remove the SMTP parameter name definitions since they were moved to Pro.