Hi Hugo thanks for the detailed report. We are trying to improve the performances when there are a lot of users, although for this case ( detail template) there might be a way to avoid such a big query. <div><br></div><div>I think we still have one open ticket, could you check and integrate/create it in case? I'll take a look asap. </div><div><br></div><div>Ciao. <span></span><br><br>Il venerdì 7 agosto 2015, FERRARI Hugo <<a href="mailto:ferrari_hugo@yahoo.fr">ferrari_hugo@yahoo.fr</a>> ha scritto:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Hello everybody<br>
as my geonode database gets bigger, displaying layer details
template goes very slow.<br>
It takes more than 10 seonds to display layer template.<br>
<br>
found in postgres log, here's a big request that takes almost 5
seconds to execute <br>
<br>
SELECT distinct "people_profile"."id",
"people_profile"."password", "people_profile"."last_login",
"people_profile"."is_superuser", "people_profile"."username",
"people_profile"."first_name", "people_profile"."last_name",
"people_profile"."email", "people_profile"."is_staff",
"people_profile"."is_active", "people_profile"."date_joined",
"people_profile"."organization", "people_profile"."profile",
"people_profile"."position", "people_profile"."voice",
"people_profile"."fax", "people_profile"."delivery",
"people_profile"."city", "people_profile"."area",
"people_profile"."zipcode", "people_profile"."country" <br>
FROM "people_profile" <br>
LEFT OUTER JOIN "guardian_userobjectpermission" ON (
"people_profile"."id" = "guardian_userobjectpermission"."user_id"
) <br>
LEFT OUTER JOIN "people_profile_groups" ON (
"people_profile"."id" = "people_profile_groups"."profile_id" ) <br>
LEFT OUTER JOIN "auth_group" ON (
"people_profile_groups"."group_id" = "auth_group"."id" ) <br>
LEFT OUTER JOIN "guardian_groupobjectpermission" ON (
"auth_group"."id" = "guardian_groupobjectpermission"."group_id" )
<br>
WHERE (("guardian_userobjectpermission"."object_pk" = '1015' AND
"guardian_userobjectpermission"."content_type_id" = 38 ) OR
("guardian_groupobjectpermission"."object_pk" = '1015' AND
"guardian_groupobjectpermission"."content_type_id" = 38 ) )<br>
<br>
Is it the usual request ?<br>
<br>
Thank you for your advices<br>
Hugo<br>
<br>
</div>
<blockquote type="cite">
<div>Hello Geonode community.<br>
<br>
Usually if you want to retrieve OWS data from a geoserver
instance<br>
you can simply add your credentials before the dn name in the
http request (even if it is not a secure way), for exemple<br>
<pre><code><a href="http://user:password@dn_site:8080/geoserver/" target="_blank">http://user:password@dn_site:8080/geoserver/</a><link to the service ex:wms?request=GetCapabilities></code></pre>
But it does not work with geonode<br>
I guess it is because authentication has been delegated to
geonode proxy, doesn't it ?<br>
how can I get through this, do I have to open a session first
and then querying geoserver ?<br>
<br>
I can't find it in the documentation.<br>
Thank you for your advices.<br>
Hugo FERRARI<br>
<br>
<br>
<br>
Le 30/07/2015 17:18, <a href="javascript:_e(%7B%7D,'cvml','geonode-users-request@lists.osgeo.org');" target="_blank">geonode-users-request@lists.osgeo.org</a>
a écrit :<br>
</div>
<blockquote type="cite">
<pre>Send geonode-users mailing list submissions to
<a href="javascript:_e(%7B%7D,'cvml','geonode-users@lists.osgeo.org');" target="_blank">geonode-users@lists.osgeo.org</a>
To subscribe or unsubscribe via the World Wide Web, visit
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/geonode-users</a>
or, via email, send a message with subject or body 'help' to
<a href="javascript:_e(%7B%7D,'cvml','geonode-users-request@lists.osgeo.org');" target="_blank">geonode-users-request@lists.osgeo.org</a>
You can reach the person managing the list at
<a href="javascript:_e(%7B%7D,'cvml','geonode-users-owner@lists.osgeo.org');" target="_blank">geonode-users-owner@lists.osgeo.org</a>
When replying, please edit your Subject line so it is more specific
than "Re: Contents of geonode-users digest..."
Today's Topics:
1. Internal Server Error (Leonardo Jauregui)
2. Re: Internal Server Error (Simone Dalmasso)
3. need help resetting psql geonode password (Charles Coss?)
4. Re: need help resetting psql geonode password (Paolo Corti)
5. Re: Internal Server Error (Leonardo Jauregui)
6. Re: Internal Server Error (Ariel Nunez)
----------------------------------------------------------------------
Message: 1
Date: Wed, 29 Jul 2015 15:26:47 -0400
From: Leonardo Jauregui <a href="javascript:_e(%7B%7D,'cvml','leojauregui.geog@gmail.com');" target="_blank"><leojauregui.geog@gmail.com></a>
To: <a href="javascript:_e(%7B%7D,'cvml','geonode-users@lists.osgeo.org');" target="_blank">geonode-users@lists.osgeo.org</a>
Subject: [GeoNode-users] Internal Server Error
Message-ID:
<a href="javascript:_e(%7B%7D,'cvml','CA%2BSjRdEzZ0i%5Cx3dridubKvTh9DBKUxCpodfuNxb0hdA0sjBdNt3FA@mail.gmail.com');" target="_blank"><CA+SjRdEzZ0i=ridubKvTh9DBKUxCpodfuNxb0hdA0sjBdNt3FA@mail.gmail.com></a>
Content-Type: text/plain; charset="utf-8"
500
Internal Server Error
that is the mesage after I installed geonode 2.4 un Ubuntu 14.04,
What is mising ?
Leonardo from Bolivia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a href="http://lists.osgeo.org/pipermail/geonode-users/attachments/20150729/8e1f78da/attachment-0001.html" target="_blank"><http://lists.osgeo.org/pipermail/geonode-users/attachments/20150729/8e1f78da/attachment-0001.html></a>
------------------------------
Message: 2
Date: Wed, 29 Jul 2015 21:40:27 +0200
From: Simone Dalmasso <a href="javascript:_e(%7B%7D,'cvml','simone.dalmasso@gmail.com');" target="_blank"><simone.dalmasso@gmail.com></a>
To: Leonardo Jauregui <a href="javascript:_e(%7B%7D,'cvml','leojauregui.geog@gmail.com');" target="_blank"><leojauregui.geog@gmail.com></a>
Cc: <a href="javascript:_e(%7B%7D,'cvml','geonode-users@lists.osgeo.org');" target="_blank">"geonode-users@lists.osgeo.org"</a> <a href="javascript:_e(%7B%7D,'cvml','geonode-users@lists.osgeo.org');" target="_blank"><geonode-users@lists.osgeo.org></a>
Subject: Re: [GeoNode-users] Internal Server Error
Message-ID:
<a href="javascript:_e(%7B%7D,'cvml','CAAHAC%2Bf2fUE0nMndb2R59GkgudiRjz%2BHm6meYwoVqozYq2yH3A@mail.gmail.com');" target="_blank"><CAAHAC+f2fUE0nMndb2R59GkgudiRjz+Hm6meYwoVqozYq2yH3A@mail.gmail.com></a>
Content-Type: text/plain; charset="utf-8"
Hi did you run the Geonode createduperuser and the geonode-updateip
commands.
If you take a look at the Apache error log you might get more info.
Il mercoled? 29 luglio 2015, Leonardo Jauregui <a href="javascript:_e(%7B%7D,'cvml','leojauregui.geog@gmail.com');" target="_blank"><leojauregui.geog@gmail.com></a>
ha scritto:
</pre>
<blockquote type="cite">
<pre>500
Internal Server Error
that is the mesage after I installed geonode 2.4 un Ubuntu 14.04,
What is mising ?
Leonardo from Bolivia
</pre>
</blockquote>
</blockquote>
<br>
</blockquote>
<br>
</div>
</blockquote></div><br><br>-- <br>Simone <br>