0039259: Support Store Server state which allows replication but prevents webpos access

Description

This special state can be used to let the store server be in passive/hidden mode only receiving replication requests but no webpos requests.

The document here [1] describes different approaches. This mantis issue will develop the approach in which the webpos systems will not receive the hidden server information. So the hidden servers are unknown to webpos

[1]
https://docs.google.com/document/d/1F4VKKrREDCfllMNiCdCJF164szazQlCqbOQYw89DPQI/edit [^]

Steps To Reproduce

Run multi-server with SS higher prio than CS
Use CS url, see that SS is accessed
Set SS as hidden, see that no requests are done to SS

Proposed Solution

See document referred to in description

Tags

No tags attached.

Attached Files

39259.diff [^] (10,157 bytes) 2018-09-12 21:58 [Show Content] [Hide Content]

diff --git a/src-db/database/model/tables/OBMOBC_SERVER_DEFINITION.xml b/src-db/database/model/tables/OBMOBC_SERVER_DEFINITION.xml
--- a/src-db/database/model/tables/OBMOBC_SERVER_DEFINITION.xml
+++ b/src-db/database/model/tables/OBMOBC_SERVER_DEFINITION.xml
@@ -97,6 +97,10 @@
         <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
+      <column name="HIDDEN_MODE" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="OBMOBC_SERV_DEF_AD_CLNT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -980,7 +980,7 @@
 <!--4FFE3405421B4551BE5C663AF9B52457-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
 <!--4FFE3405421B4551BE5C663AF9B52457-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--4FFE3405421B4551BE5C663AF9B52457-->  <AD_MODULE_ID><![CDATA[08943B85ADF64E708797A753E5B6AAEE]]></AD_MODULE_ID>
-<!--4FFE3405421B4551BE5C663AF9B52457-->  <POSITION><![CDATA[32]]></POSITION>
+<!--4FFE3405421B4551BE5C663AF9B52457-->  <POSITION><![CDATA[24]]></POSITION>
 <!--4FFE3405421B4551BE5C663AF9B52457-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
 <!--4FFE3405421B4551BE5C663AF9B52457-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
 <!--4FFE3405421B4551BE5C663AF9B52457-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
@@ -2170,6 +2170,44 @@
 <!--A9E3CB06A1FB4E6F867D7FADAEF0D368-->  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
 <!--A9E3CB06A1FB4E6F867D7FADAEF0D368--></AD_COLUMN>
 
+<!--AC85A2F785E84E0BB7E268FEA847B435--><AD_COLUMN>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <AD_COLUMN_ID><![CDATA[AC85A2F785E84E0BB7E268FEA847B435]]></AD_COLUMN_ID>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <NAME><![CDATA[Hidden_Mode]]></NAME>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <HELP><![CDATA[If flagged hides the server for WebPOS systems. Backend services can still contact the server.]]></HELP>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <COLUMNNAME><![CDATA[Hidden_Mode]]></COLUMNNAME>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <AD_TABLE_ID><![CDATA[9A030632C0FC4C4AA8A58EC59BE2D116]]></AD_TABLE_ID>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <SEQNO><![CDATA[330]]></SEQNO>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <AD_ELEMENT_ID><![CDATA[1974AA3D4B454FC78046B44181BCDE1F]]></AD_ELEMENT_ID>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <AD_MODULE_ID><![CDATA[08943B85ADF64E708797A753E5B6AAEE]]></AD_MODULE_ID>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <POSITION><![CDATA[32]]></POSITION>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--AC85A2F785E84E0BB7E268FEA847B435-->  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--AC85A2F785E84E0BB7E268FEA847B435--></AD_COLUMN>
+
 <!--ADC3C18156DD4EF58F08CA8C7EF3E6D0--><AD_COLUMN>
 <!--ADC3C18156DD4EF58F08CA8C7EF3E6D0-->  <AD_COLUMN_ID><![CDATA[ADC3C18156DD4EF58F08CA8C7EF3E6D0]]></AD_COLUMN_ID>
 <!--ADC3C18156DD4EF58F08CA8C7EF3E6D0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/AD_ELEMENT.xml b/src-db/database/sourcedata/AD_ELEMENT.xml
--- a/src-db/database/sourcedata/AD_ELEMENT.xml
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml
@@ -48,6 +48,19 @@
 <!--182FD651C020405DB1BD65E863D61D24-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--182FD651C020405DB1BD65E863D61D24--></AD_ELEMENT>
 
+<!--1974AA3D4B454FC78046B44181BCDE1F--><AD_ELEMENT>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <AD_ELEMENT_ID><![CDATA[1974AA3D4B454FC78046B44181BCDE1F]]></AD_ELEMENT_ID>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <COLUMNNAME><![CDATA[Hidden_Mode]]></COLUMNNAME>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <NAME><![CDATA[Hidden Mode]]></NAME>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <PRINTNAME><![CDATA[Hidden Mode]]></PRINTNAME>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <HELP><![CDATA[If flagged hides the server for WebPOS systems. Backend services can still contact the server.]]></HELP>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <AD_MODULE_ID><![CDATA[08943B85ADF64E708797A753E5B6AAEE]]></AD_MODULE_ID>
+<!--1974AA3D4B454FC78046B44181BCDE1F-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--1974AA3D4B454FC78046B44181BCDE1F--></AD_ELEMENT>
+
 <!--2E923953D5644CF0A73FE7C4A0219565--><AD_ELEMENT>
 <!--2E923953D5644CF0A73FE7C4A0219565-->  <AD_ELEMENT_ID><![CDATA[2E923953D5644CF0A73FE7C4A0219565]]></AD_ELEMENT_ID>
 <!--2E923953D5644CF0A73FE7C4A0219565-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/AD_FIELD.xml b/src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml
+++ b/src-db/database/sourcedata/AD_FIELD.xml
@@ -1074,6 +1074,34 @@
 <!--9F937F37ABA64DCB9CF0FE31AF9484A3-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--9F937F37ABA64DCB9CF0FE31AF9484A3--></AD_FIELD>
 
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6--><AD_FIELD>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <AD_FIELD_ID><![CDATA[A5A7DB80DF8C4CAFB560E26EA8FECDD6]]></AD_FIELD_ID>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <NAME><![CDATA[Hidden Mode]]></NAME>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <HELP><![CDATA[If flagged hides the server for WebPOS systems. Backend services can still contact the server.]]></HELP>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <AD_TAB_ID><![CDATA[DDA291351EB54782A20860A6A6E6FDCC]]></AD_TAB_ID>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <AD_COLUMN_ID><![CDATA[AC85A2F785E84E0BB7E268FEA847B435]]></AD_COLUMN_ID>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <SEQNO><![CDATA[67]]></SEQNO>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <AD_MODULE_ID><![CDATA[08943B85ADF64E708797A753E5B6AAEE]]></AD_MODULE_ID>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <GRID_SEQNO><![CDATA[57]]></GRID_SEQNO>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--A5A7DB80DF8C4CAFB560E26EA8FECDD6--></AD_FIELD>
+
 <!--A6F92DF687F74F1790F615893EC93F4D--><AD_FIELD>
 <!--A6F92DF687F74F1790F615893EC93F4D-->  <AD_FIELD_ID><![CDATA[A6F92DF687F74F1790F615893EC93F4D]]></AD_FIELD_ID>
 <!--A6F92DF687F74F1790F615893EC93F4D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>

39259-retail.diff [^] (573 bytes) 2018-09-12 23:44 [Show Content] [Hide Content]

diff --git a/src/org/openbravo/retail/posterminal/LoginUtilsServlet.java b/src/org/openbravo/retail/posterminal/LoginUtilsServlet.java
--- a/src/org/openbravo/retail/posterminal/LoginUtilsServlet.java
+++ b/src/org/openbravo/retail/posterminal/LoginUtilsServlet.java
@@ -444,6 +444,9 @@
 
     List<MobileServerDefinition> serversList = servers.list();
     for (MobileServerDefinition server : serversList) {
+      if (server.isHiddenMode()) {
+        continue;
+      }
       if (server.isAllorgs()) {
         respArray.put(createServerJSON(server));
       } else {

39259-retail-sync.diff [^] (905 bytes) 2018-09-13 14:13 [Show Content] [Hide Content]

diff --git a/src/org/openbravo/retail/storeserver/synchronization/RetailSynchronizationRequestHandler.java b/src/org/openbravo/retail/storeserver/synchronization/RetailSynchronizationRequestHandler.java
--- a/src/org/openbravo/retail/storeserver/synchronization/RetailSynchronizationRequestHandler.java
+++ b/src/org/openbravo/retail/storeserver/synchronization/RetailSynchronizationRequestHandler.java
@@ -105,6 +105,16 @@
       return false;
     }
 
+    if (thisServerDefinition.isHiddenMode()) {
+      // always forward to CS
+      if (forwardedToCentralServer(request, response)) {
+        return true;
+      } else {
+        log.error("Hidden Mode Trying to forward to CS but failed, " + request.getRequestURI());
+        return true;
+      }
+    }
+
     // handle mandatory reload here
     if (isMandatoryReload(thisServerDefinition)) {
       writeResponseJSON(response, "RELOADING");

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of	feature request	0040225		closed	mtaal	Introduce hidden mode for webpos for store server
has duplicate	feature request	0037636		closed	mtaal	Make it possible to de-activate a store server for POS usage but still replicate data to it

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2018-09-11 09:06	mtaal	New Issue
2018-09-11 09:06	mtaal	Assigned To	=> mtaal
2018-09-11 09:06	mtaal	Triggers an Emergency Pack	=> No
2018-09-12 21:58	mtaal	File Added: 39259.diff
2018-09-12 23:44	mtaal	File Added: 39259-retail.diff
2018-09-13 14:13	mtaal	File Added: 39259-retail-sync.diff
2018-09-24 14:47	mtaal	Relationship added	has duplicate 0037636
2019-02-18 18:43	mtaal	Relationship added	duplicate of 0040225
2019-02-18 18:43	mtaal	Status	new => closed
2019-02-18 18:43	mtaal	Resolution	open => duplicate