[GeoNode-users] Cannot access GeoNode 2.4 RC1 after istalling and updating IP (500 internal server error)

[Jeffrey Johnson]

This is probably a permissions error in postgres. You need to make
sure the database user you are connecting with has permission to
create tables in the database you are using. Use pgadmin3 or psql for
this. http://www.postgresql.org/docs/9.1/static/sql-grant.html ...
grant all on database database_name to rolename;

On Mon, Nov 9, 2015 at 2:26 AM, Simone Dalmasso
<simone.dalmasso at gmail.com> wrote:
> The geoserver logs may give you more information about this. You an read
> them through the geoserver interface.
>
> 2015-11-09 11:03 GMT+01:00 Shah Md. Rajibul Islam
> <rajibul.islam at cdmp.org.bd>:
>>
>> Thank a lot. I can now access geonode using browser, but it gives error
>> “An exception occurred loading data to PostGIS- java.io.IOException: Error
>> occurred creating table” while uploading shapefiles.
>>
>>
>>
>> Regards
>>
>>
>>
>> Shah Md. Rajibul Islam
>>
>> GIS Analyst
>> CDMP – II, UNDP
>> Disaster Management & Relief Bhaban
>> 92-93, Mohakhali C/A, Dhaka - 1212
>> Tel # 989 0937; 882 1255; 882 1459, Ext - 303
>> Mobile: +88 01716 027389, E-mail: rajibul.islam at cdmp.org.bd
>> Web: www.cdmp.org.bd
>>
>>
>>
>> From: Simone Dalmasso [mailto:simone.dalmasso at gmail.com]
>> Sent: 09 November 2015 15:06
>> To: Shah Md. Rajibul Islam
>> Cc: geonode-users at lists.osgeo.org
>> Subject: Re: [GeoNode-users] Cannot access GeoNode 2.4 RC1 after istalling
>> and updating IP (500 internal server error)
>>
>>
>>
>> There's no operations.py file in GeoNode, it is a django file and should
>> not be modified.
>>
>>
>>
>> you can add it to /etc/geonode/local_settings.py then restart your server
>>
>>
>>
>> regards
>>
>>
>>
>> 2015-11-09 9:47 GMT+01:00 Shah Md. Rajibul Islam
>> <rajibul.islam at cdmp.org.bd>:
>>
>> Do you mean to add it into operations.py or where? I am using putty to
>> connect to the server, if possible could you please check my geonode using
>> team viewer?
>>
>>
>>
>> Shah Md. Rajibul Islam
>>
>> GIS Analyst
>> CDMP – II, UNDP
>> Disaster Management & Relief Bhaban
>> 92-93, Mohakhali C/A, Dhaka - 1212
>> Tel # 989 0937; 882 1255; 882 1459, Ext - 303
>> Mobile: +88 01716 027389, E-mail: rajibul.islam at cdmp.org.bd
>> Web: www.cdmp.org.bd
>>
>>
>>
>> From: Simone Dalmasso [mailto:simone.dalmasso at gmail.com]
>> Sent: 09 November 2015 13:53
>> To: Shah Md. Rajibul Islam
>> Cc: geonode-users at lists.osgeo.org
>> Subject: Re: [GeoNode-users] Cannot access GeoNode 2.4 RC1 after istalling
>> and updating IP (500 internal server error)
>>
>>
>>
>> ok, you can add
>>
>>
>>
>> POSTGIS_VERSION = (2,1,0)
>>
>>
>>
>> to your geonode settings.
>>
>>
>> Regards
>>
>>
>>
>> 2015-11-09 8:49 GMT+01:00 Shah Md. Rajibul Islam
>> <rajibul.islam at cdmp.org.bd>:
>>
>> Dear Ciao,
>>
>>
>>
>> Thank you for your reply. I found the followings-
>>
>>
>>
>> geonode at geonode:~$ tail -f /etc/apache2/logs/error.log
>>
>> tail: cannot open ‘/etc/apache2/logs/error.log’ for reading: No such file
>> or directory
>>
>> geonode at geonode:~$ tail -f /var/log/apache2/error.log
>>
>> [Mon Nov 09 00:48:14.620992 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]     conn = backend.DatabaseWrapper(db, alias)
>>
>> [Mon Nov 09 00:48:14.621022 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]   File
>> "/usr/lib/python2.7/dist-packages/django/contrib/gis/db/backends/postgis/base.py",
>> line 11, in __init__
>>
>> [Mon Nov 09 00:48:14.621065 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]     self.ops = PostGISOperations(self)
>>
>> [Mon Nov 09 00:48:14.621095 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]   File
>> "/usr/lib/python2.7/dist-packages/django/contrib/gis/db/backends/postgis/operations.py",
>> line 158, in __init__
>>
>> [Mon Nov 09 00:48:14.621136 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]     if self.spatial_version < (1, 3, 4):
>>
>> [Mon Nov 09 00:48:14.621190 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]   File
>> "/usr/lib/python2.7/dist-packages/django/utils/functional.py", line 49, in
>> __get__
>>
>> [Mon Nov 09 00:48:14.621232 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]     res = instance.__dict__[self.func.__name__] =
>> self.func(instance)
>>
>> [Mon Nov 09 00:48:14.621263 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]   File
>> "/usr/lib/python2.7/dist-packages/django/contrib/gis/db/backends/postgis/operations.py",
>> line 258, in spatial_version
>>
>> [Mon Nov 09 00:48:14.621306 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831]     'template?' % self.connection.settings_dict['NAME']
>>
>> [Mon Nov 09 00:48:14.621354 2015] [:error] [pid 2175] [remote
>> 192.168.0.42:27831] ImproperlyConfigured: Cannot determine PostGIS version
>> for database "geonode_data". GeoDjango requires at least PostGIS version
>> 1.3. Was the database created from a spatial database template?
>>
>>
>>
>> Regards
>>
>> Rajib
>>
>>
>>
>> Shah Md. Rajibul Islam
>>
>> GIS Analyst
>> CDMP – II, UNDP
>> Disaster Management & Relief Bhaban
>> 92-93, Mohakhali C/A, Dhaka - 1212
>> Tel # 989 0937; 882 1255; 882 1459, Ext - 303
>> Mobile: +88 01716 027389, E-mail: rajibul.islam at cdmp.org.bd
>> Web: www.cdmp.org.bd
>>
>>
>>
>> From: Simone Dalmasso [mailto:simone.dalmasso at gmail.com]
>> Sent: 09 November 2015 13:19
>> To: Shah Md. Rajibul Islam
>> Cc: geonode-users at lists.osgeo.org
>> Subject: Re: [GeoNode-users] Cannot access GeoNode 2.4 RC1 after istalling
>> and updating IP (500 internal server error)
>>
>>
>>
>> Hi,
>>
>> you can see what specific error is by reading the apache logs
>>
>>
>>
>> $ tail -f /etc/apache2/logs/error.log
>>
>>
>>
>> let us know so that we can better help you.
>>
>>
>>
>> Ciao
>>
>>
>>
>> 2015-11-08 7:05 GMT+01:00 Shah Md. Rajibul Islam
>> <rajibul.islam at cdmp.org.bd>:
>>
>> Dear Geonode users,
>>
>>
>>
>> I have installed GeoNode 2.4 RC1/GeoNode version 2.4c2 on
>> ubuntu-14.04-server-i386. First I have installed it in a virtual machine
>> using VMware workstation and successfully installed and accessed it with the
>> configured local IP. Later on, I have installed the same version of Geonode
>> on the same version of Ubuntu server 14.04. I don’t have a real IP and hence
>> I have configured the geonode with the local IP of the server. But I cannot
>> access it through the web browser. It gives 500 internal server error:
>>
>>
>>
>> Internal Server Error
>>
>> The server encountered an internal error or misconfiguration and was
>> unable to complete your request.
>>
>> Please contact the server administrator at webmaster at localhost to inform
>> them of the time this error occurred, and the actions you performed just
>> before this error.
>>
>> More information about this error may be available in the server error
>> log.
>>
>> ________________________________
>>
>> Apache/2.4.7 (Ubuntu) Server at 192.168.0.101 Port 80
>>
>>
>>
>> Could you please suggest if it is related with the Local IP or I need a
>> real IP to access it through web browser.
>>
>>
>>
>> Best regards
>>
>> Rajib
>>
>>
>>
>> Shah Md. Rajibul Islam
>>
>> GIS Analyst
>> CDMP – II, UNDP
>> Disaster Management & Relief Bhaban
>> 92-93, Mohakhali C/A, Dhaka - 1212
>> Tel # 989 0937; 882 1255; 882 1459, Ext - 303
>> Mobile: +88 01716 027389, E-mail: rajibul.islam at cdmp.org.bd
>> Web: www.cdmp.org.bd
>>
>>
>>
>>
>> _______________________________________________
>> geonode-users mailing list
>> geonode-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/geonode-users
>>
>>
>>
>>
>>
>> --
>>
>> Simone
>>
>>
>>
>>
>>
>> --
>>
>> Simone
>>
>>
>>
>>
>>
>> --
>>
>> Simone
>
>
>
>
> --
> Simone
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geonode-users
>