[GeoNode-users] Security Integration Optimization section - GeoNode in Production

[Naresh N]

Dear All,
Please see the my post and Kindly help to resolve the issue

On Mon, Jun 5, 2017 at 4:45 PM, Naresh N <naresh919 at gmail.com> wrote:

> Dear All,
>
> *ISSUE-1*
>  I have deployed GeNode in RHEL 7.2 64 bit machine. Now I am configuring
> for production environment by following the steps mentioned in
> http://docs.geonode.org/en/master/tutorials/advanced/
> geonode_production/production.html.
>  But not able to complete the  *Security Integration Optimization section*
> steps. The following is the issue
>
>  *WEB-INF/classes/org/geonode/security/geonode_authorize_layer.sql* not
> able to found in my system.  And also not able to fine geoserver.xml
>
> Please help me to over come this issue.
>
>
> *ISSUE-2 :*
> To understand the Database security, I have deployed GeoNode 2.4 in
> Windows and  here i could able to find the  file
> *geonode_authorize_layer.sql. * But when I executed this file though
> pgadmin-3(Geonode database) it showed following error
>
> ERROR:  "$1" is declared CONSTANT
> CONTEXT:  compilation of PL/pgSQL function "geonode_authorize_layer" near
> line 23
> ( if (user_name IS NULL or user_name = '') then
>         user_name = 'AnonymousUser';
> end if;)
>
> Then I have modified the code - one temp variable is declared in Declare
> setion and the above code is modified like as follows
>   ( 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.
>
> Now modified  updated psql command  was successfully executed.
>
> 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
>
> <Context path="/geoserver"
>     antiResourceLocking="false" >
>   <Parameter name="org.geonode.security.databaseSecurityClient.url"
>     value="jdbc:postgresql://localhost:5454/geonode?user=
> geonode&password=geonode"/>
> </Context>
>
> But now my *geoserver *is not working.  Please kindly suggest to over
> come this issue.
>
>
> Thanks&Regards,
> Naresh
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20170606/9fa2c1ab/attachment.html>