<div>Since the version 2.6 geoserver is using oauth2 i order to authenticate and authorize users. </div><div>It is good for production too. </div><div><br><div class="gmail_quote"><div>Il giorno mer 7 giu 2017 alle 06:56 Naresh N <<a href="mailto:naresh919@gmail.com">naresh919@gmail.com</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><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><<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>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="m_6557742481444681497h5">2017-06-06 13:49 GMT+02:00 Naresh N <span><<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="m_6557742481444681497h5"><div>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><<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>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/master/tutorials/advanced/geonode_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/security/geonode_authorize_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.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\apache-tomcat-7.0.65\conf\Catalina\localhost\geoserver.xml</div><div> </div><div><Context path="/geoserver"<br></div><div><div> antiResourceLocking="false" ></div><div> <Parameter name="org.geonode.security.databaseSecurityClient.url"</div><div> value="jdbc:postgresql://localhost:5454/geonode?user=geonode&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>_______________________________________________<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/mailman/listinfo/geonode-users</a><br>
<br></blockquote></div><span class="m_6557742481444681497HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div class="m_6557742481444681497m_6267390028860902804gmail_signature" data-smartmail="gmail_signature">Simone </div>
</font></span></div>
</blockquote></div><br></div>
</blockquote></div></div><div dir="ltr">-- <br></div><div data-smartmail="gmail_signature">Simone </div>