I have to use ACCESSRULE.
This is my source goldengate and I have following two statements in mgr.prm
ACCESSRULE, PROG *,IPADDR <actual ip address of source > , ALLOW
ACCESSRULE, PROG *, IPADDR *, DENY
When I have the last statement on, I get connection problem to mgr process. I am able to start mgr process but not able to stop it. I am not able to start jagent as it is not able to connect to mgr.
Here is what I see.
GGSCI (meo00ajf) 2> start jagent
Sending START request to MANAGER ...
ERROR: Access denied
2018-04-19 05:53:12 WARNING OGG-01742 Command sent to MGR MGR returned with an ERROR response.
GGSCI (meo00ajf) 3> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
ERROR: Access denied
2018-04-19 05:53:40 WARNING OGG-01742 Command sent to MGR MGR returned with an ERROR response.
Once I comment out the statement [ ACCESSRULE, PROG *, IPADDR *, DENY] everything works fine.
Can someone please explain what is happening here and how to fix this ? I have tried localhost things too but didnt work.
So following entries in mgr.prm too do not help.
ACCESSRULE, PROG *,IPADDR <actual ip address of source > , ALLOW
accessrule, prog *,ipaddr localhost, ALLOW
accessrule, prog *,ipaddr 127.0.0.1, ALLOW
ACCESSRULE, PROG *, IPADDR *, DENY
Thanks,
Vibha