<div dir="ltr"><span style="font-size:12.8px">Dear Simone,</span><br style="font-size:12.8px"><span style="font-size:12.8px"> Thanks for responding. That means in production environment there is no</span><br style="font-size:12.8px"><span style="font-size:12.8px">requirement of database level security of Geoserver? . If we are not</span><br style="font-size:12.8px"><span style="font-size:12.8px">configuring authorization of Geoserver with database level, will this</span><br style="font-size:12.8px"><span style="font-size:12.8px">create any possible attacks to Geoserver by user?</span><br style="font-size:12.8px"><br style="font-size:12.8px"><span style="font-size:12.8px">Thanks&Regards,</span><br style="font-size:12.8px"><span style="font-size:12.8px">Naresh</span><br style="font-size:12.8px"></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jun 6, 2017 at 5:21 PM, Simone Dalmasso <span dir="ltr"><<a href="mailto:simone.dalmasso@gmail.com" target="_blank">simone.dalmasso@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">Hi, sorry, that is not needed anymore in GeoNode and we will update the doc soon.<div><br></div><div>Best</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">2017-06-06 13:49 GMT+02:00 Naresh N <span dir="ltr"><<a href="mailto:naresh919@gmail.com" target="_blank">naresh919@gmail.com</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><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/ma<wbr>ster/tutorials/advanced/geonod<wbr>e_production/production.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/s<wbr>ecurity/geonode_authorize_laye<wbr>r.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\apac<wbr>he-tomcat-7.0.65\conf\Catalina<wbr>\localhost\geoserver.xml</div><div> </div><div><Context path="/geoserver"<br></div><div><div> antiResourceLocking="false" ></div><div> <Parameter name="org.geonode.security.dat<wbr>abaseSecurityClient.url"</div><div> value="jdbc:postgresql://local<wbr>host:5454/geonode?user=geonode<wbr>&password=geonode"/></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>
<br></div></div>______________________________<wbr>_________________<br>
geonode-users mailing list<br>
<a href="mailto:geonode-users@lists.osgeo.org" target="_blank">geonode-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/geonode-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/geonode-users</a><br>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div class="m_6267390028860902804gmail_signature" data-smartmail="gmail_signature">Simone </div>
</font></span></div>
</blockquote></div><br></div>