[GeoNode-users] Database and user "geonode" do not exist after apt-get installation [fixed]

Thu Feb 2 09:29:04 PST 2017

Hello,

Yes that would be insteresting !

Today I realized that I cannot upload shapefiles. The error seems to be
related with Postgis:

An exception occurred loading data to PostGIS- java.io.IOException
[Thu Feb 02 10:56:05.899620 2017] [:error] [pid 28766:tid 139806268286720]
Traceback (most recent call last):
[Thu Feb 02 10:56:05.899625 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/local/lib/python2.7/dist-packages/geonode/layers/views.py", line 160,
in layer_upload
[Thu Feb 02 10:56:05.899631 2017] [:error] [pid 28766:tid
139806268286720]     title=form.cleaned_data["layer_title"],
[Thu Feb 02 10:56:05.899635 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/local/lib/python2.7/dist-packages/geonode/layers/utils.py", line 470,
in file_upload
[Thu Feb 02 10:56:05.899640 2017] [:error] [pid 28766:tid
139806268286720]     defaults=defaults
[Thu Feb 02 10:56:05.899644 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/lib/python2.7/dist-packages/django/db/models/manager.py", line 154,
in get_or_create
[Thu Feb 02 10:56:05.899649 2017] [:error] [pid 28766:tid
139806268286720]     return self.get_queryset().get_or_create(**kwargs)
[Thu Feb 02 10:56:05.899653 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/lib/python2.7/dist-packages/modeltranslation/manager.py", line 341,
in get_or_create
[Thu Feb 02 10:56:05.899658 2017] [:error] [pid 28766:tid
139806268286720]     return super(MultilingualQuerySet,
self).get_or_create(**kwargs)
[Thu Feb 02 10:56:05.899662 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 383, in
get_or_create
[Thu Feb 02 10:56:05.899667 2017] [:error] [pid 28766:tid
139806268286720]     obj.save(force_insert=True, using=self.db)
[Thu Feb 02 10:56:05.899671 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/lib/python2.7/dist-packages/polymorphic/polymorphic_model.py", line
90, in save
[Thu Feb 02 10:56:05.899676 2017] [:error] [pid 28766:tid
139806268286720]     return super(PolymorphicModel, self).save(*args,
**kwargs)
[Thu Feb 02 10:56:05.899680 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 545, in
save
[Thu Feb 02 10:56:05.899685 2017] [:error] [pid 28766:tid
139806268286720]     force_update=force_update, update_fields=update_fields)
[Thu Feb 02 10:56:05.899689 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 569, in
save_base
[Thu Feb 02 10:56:05.899693 2017] [:error] [pid 28766:tid
139806268286720]     update_fields=update_fields)
[Thu Feb 02 10:56:05.899697 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/lib/python2.7/dist-packages/django/dispatch/dispatcher.py", line 185,
in send
[Thu Feb 02 10:56:05.899702 2017] [:error] [pid 28766:tid
139806268286720]     response = receiver(signal=self, sender=sender,
**named)
[Thu Feb 02 10:56:05.899707 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/local/lib/python2.7/dist-packages/geonode/geoserver/signals.py", line
74, in geoserver_pre_save
[Thu Feb 02 10:56:05.899711 2017] [:error] [pid 28766:tid
139806268286720]     charset=instance.charset)
[Thu Feb 02 10:56:05.899715 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/local/lib/python2.7/dist-packages/geonode/geoserver/helpers.py", line
1121, in geoserver_upload
[Thu Feb 02 10:56:05.899720 2017] [:error] [pid 28766:tid
139806268286720]     workspace=workspace)
[Thu Feb 02 10:56:05.899724 2017] [:error] [pid 28766:tid
139806268286720]   File
"/usr/local/lib/python2.7/dist-packages/geonode/geoserver/helpers.py", line
998, in _create_db_featurestore
[Thu Feb 02 10:56:05.899729 2017] [:error] [pid 28766:tid
139806268286720]     raise GeoNodeException(msg)
[Thu Feb 02 10:56:05.899733 2017] [:error] [pid 28766:tid 139806268286720]
GeoNodeException: An exception occurred loading data to PostGIS-
java.io.IOException

Best regards !

George
On 01/02/2017 05:11 μμ, Simone Dalmasso wrote:

Hi, this is interesting. I would be curious to see what the original error
is, it should appear in the terminal during the geonode installation.

2017-02-01 16:06 GMT+01:00 Gi Petrak <gkpetrak at gmail.com>:

> I 'd like to post an issue that I had with apt-get Installation of GeoNode
> 2.4
> and I fixed with the hope of helping someone else with the same problem.
> After creating a clean and fresh Ubuntu 14.04 remote VM, I installed
> geonode with apt-get:
>
> sudo add-apt-repository ppa:geonode/stable
> sudo apt-get update
> sudo apt-get install geonode
>
> But when I executed the following commands:
> geonode createsuperuser
> sudo geonode-updateip 127.0.0.1
>
> I had errors like:
> 2017-01-31 22:15:58 EET FATAL:  password authentication failed for user
> "geonode"
> 2017-01-31 22:15:58 EET DETAIL:  Connection matched pg_hba.conf line 94:
> "host
> 2017-01-31 22:54:31 EET FATAL:  role "user" does not exist
> 2017-01-31 22:54:49 EET FATAL:  database "geonode" does not exist
>
> So, I realized that geonode user and database didn't exist. Thus, I
> followed the custom procedure of creating GeoNode DB:
> http://docs.geonode.org/en/master/tutorials/install_and_admi
> n/geonode_install/create_geonode_db.html
>
> and finally I ran: sudo python manage.py syncdb -noinput
>
> After these steps, problem solved.
>
>
>
>
>
> _______________________________________________
> geonode-users mailing list
> geonode-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/geonode-users
>
>

-- 
Simone
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-users/attachments/20170202/e6ad0fc3/attachment.html>