<div dir="ltr">Dear All,<div>Please see the my post and Kindly help to resolve the issue</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Jun 5, 2017 at 4:45 PM, Naresh N <span dir="ltr"><<a href="mailto:naresh919@gmail.com" target="_blank">naresh919@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Dear All,<div> </div><div><b>ISSUE-1</b></div><div><span style="font-size:12.8px"> I have deployed GeNode in RHEL 7.2 64 bit machine. Now I am configuring for production environment by following the steps mentioned in <a href="http://docs.geonode.org/en/master/tutorials/advanced/geonode_production/production.html" target="_blank">http://docs.geonode.org/en/<wbr>master/tutorials/advanced/<wbr>geonode_production/production.<wbr>html</a>.</span><br></div><div><span style="font-size:12.8px"> But not able to complete the <b>Security Integration Optimization section</b> steps. The following is the issue </span></div><div><br></div><div> <b>WEB-INF/classes/org/geonode/<wbr>security/geonode_authorize_<wbr>layer.sql</b> not able to found in my system. And also not able to fine geoserver.xml</div><div><br></div><div>Please help me to over come this issue.</div><div><br></div><div><br></div><div><b>ISSUE-2 :</b></div><div>To understand the Database security, I have deployed GeoNode 2.4 in Windows and here i could able to find the file <b>geonode_authorize_layer.<wbr>sql. </b> But when I executed this file though pgadmin-3(Geonode database) it showed following error</div><div><br></div><div><div>ERROR: "$1" is declared CONSTANT</div><div>CONTEXT: compilation of PL/pgSQL function "geonode_authorize_layer" near line 23 </div><div>( if (user_name IS NULL or user_name = '') then</div><div> user_name = 'AnonymousUser';</div><div>end if;)</div></div><div><br></div><div>Then I have modified the code - one temp variable is declared in Declare setion and the above code is modified like as follows</div><div> ( if (user_name IS NULL or user_name = '') then temp = 'AnonymousUser'; else temp=user_nameend if;) and After that rest of the section user_name is replaced with temp. </div><div><br></div><div>Now modified updated psql command was successfully executed.</div><div><br></div><div>After that not able to find geoserver.xml and created the new xml with as follows and placed in following location C:\GeoNode-2.4.x\<wbr>apache-tomcat-7.0.65\conf\<wbr>Catalina\localhost\geoserver.<wbr>xml</div><div> </div><div><Context path="/geoserver"<br></div><div><div> antiResourceLocking="false" ></div><div> <Parameter name="org.geonode.security.<wbr>databaseSecurityClient.url"</div><div> value="jdbc:postgresql://<wbr>localhost:5454/geonode?user=<wbr>geonode&password=geonode"/<wbr>></div><div></Context></div></div><div><br></div><div>But now my <b>geoserver </b>is not working. Please kindly suggest to over come this issue.</div><div><br></div><div><br></div><div>Thanks&Regards,</div><div>Naresh</div><div><br></div><div><br></div><div> </div><div><br></div><div><span style="font-size:12.8px"><br></span></div></div>
</blockquote></div><br></div>