[GeoNode-devel] [GeoNode-users] GeoNode-Project CenTOS7 Installation

1520 gis juliermeopensourcedeveloper at gmail.com
Wed Jul 17 11:52:47 PDT 2019


Thank you for the update @francesco bartoli <xbartolone at gmail.com>. And
please, @Ran L. <kula009 at gmail.com> do not consider the previous e-mail, I
was on the wrong server. I will try on the right one and I will send the
response.



On Wed, Jul 17, 2019 at 3:46 PM 1520 gis <
juliermeopensourcedeveloper at gmail.com> wrote:

> Yes, you are right. We got close, but still an issue. See bellow please
> with django-admin and manage.py
>
> root at bdeea2347fe6:/usr/src/my_geonode# django-admin updatelayers
> Traceback (most recent call last):
>   File "/usr/local/bin/django-admin", line 10, in <module>
>     sys.exit(execute_from_command_line())
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
> line 364, in execute_from_command_line
>     utility.execute()
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
> line 356, in execute
>     self.fetch_command(subcommand).run_from_argv(self.argv)
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 283, in run_from_argv
>     self.execute(*args, **cmd_options)
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 330, in execute
>     output = self.handle(*args, **options)
>   File
> "/usr/local/lib/python2.7/site-packages/geonode/geoserver/management/commands/updatelayers.py",
> line 98, in handle
>     owner = get_valid_user(user)
>   File "/usr/local/lib/python2.7/site-packages/geonode/people/utils.py",
> line 44, in get_valid_user
>     theuser = get_default_user()
>   File "/usr/local/lib/python2.7/site-packages/geonode/people/utils.py",
> line 31, in get_default_user
>     if superusers.count() > 0:
>   File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py",
> line 364, in count
>     return self.query.get_count(using=self.db)
>   File
> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/query.py",
> line 499, in get_count
>     number = obj.get_aggregation(using, ['__count'])['__count']
>   File
> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/query.py",
> line 480, in get_aggregation
>     result = compiler.execute_sql(SINGLE)
>   File
> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
> line 899, in execute_sql
>     raise original_exception
> django.db.utils.OperationalError: no such table: people_profile
> root at bdeea2347fe6:/usr/src/my_geonode# python manage.py updatelayers
> Traceback (most recent call last):
>   File "manage.py", line 31, in <module>
>     execute_from_command_line(sys.argv)
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
> line 364, in execute_from_command_line
>     utility.execute()
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
> line 356, in execute
>     self.fetch_command(subcommand).run_from_argv(self.argv)
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 283, in run_from_argv
>     self.execute(*args, **cmd_options)
>   File
> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
> line 330, in execute
>     output = self.handle(*args, **options)
>   File
> "/usr/local/lib/python2.7/site-packages/geonode/geoserver/management/commands/updatelayers.py",
> line 98, in handle
>     owner = get_valid_user(user)
>   File "/usr/local/lib/python2.7/site-packages/geonode/people/utils.py",
> line 44, in get_valid_user
>     theuser = get_default_user()
>   File "/usr/local/lib/python2.7/site-packages/geonode/people/utils.py",
> line 31, in get_default_user
>     if superusers.count() > 0:
>   File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py",
> line 364, in count
>     return self.query.get_count(using=self.db)
>   File
> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/query.py",
> line 499, in get_count
>     number = obj.get_aggregation(using, ['__count'])['__count']
>   File
> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/query.py",
> line 480, in get_aggregation
>     result = compiler.execute_sql(SINGLE)
>   File
> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
> line 899, in execute_sql
>     raise original_exception
> django.db.utils.OperationalError: no such table: people_profile
>
> On Wed, Jul 17, 2019 at 2:59 PM Ran L. <kula009 at gmail.com> wrote:
>
>> But you are getting a different error message this time. Could you try
>> the simple command:
>>
>> 'django-admin updatelayers'
>>
>> And see how it goes?
>>
>> Ran
>>
>> On Wed, Jul 17, 2019 at 10:30 AM 1520 gis <
>> juliermeopensourcedeveloper at gmail.com> wrote:
>>
>>> Thank you very much Ran, but the issue remains.
>>>
>>> mkdir -p /usr/src/app/; \
>>> > source $HOME/.override_env; \
>>> > echo DATABASE_URL=$DATABASE_URL; \
>>> > echo GEODATABASE_URL=$GEODATABASE_URL; \
>>> > echo SITEURL=$SITEURL; \
>>> > echo ALLOWED_HOSTS=$ALLOWED_HOSTS; \
>>> > echo GEOSERVER_PUBLIC_LOCATION=$GEOSERVER_PUBLIC_LOCATION;
>>> DATABASE_URL=postgres://geonode:geonode@db:5432/geonode
>>> GEODATABASE_URL=postgis://geonode_data:geonode_data@db:5432/geonode_data
>>> SITEURL=http://cgticgeo.sipam.gov.br/
>>> ALLOWED_HOSTS=['cgticgeo.sipam.gov.br', 'cgticgeo.sipam.gov.br', '
>>> cgticgeo.sipam.gov.br:80', 'geonode', 'django']
>>> GEOSERVER_PUBLIC_LOCATION=http://cgticgeo.sipam.gov.br/geoserver/
>>> root at 2ff53eacb7e9:/usr/src/my_geonode# python manage.py updatelayers -w
>>> geonode -f previsao_meteorologica_aml
>>> JSONField implementation is: <class 'jsonfield.fields.JSONField'>
>>> Inspecting the available layers in GeoServer ...
>>> Found 1 layers, starting processing
>>> Could not retrieve GeoFence Rules count.
>>> Could not retrieve GeoFence Rules count.
>>> ... Creating Thumbnail for Layer [geonode:previsao_meteorologica_aml]
>>> Could not retrieve GeoFence Rules count.
>>> Could not retrieve GeoFence Rules count.
>>> Stopping process because --ignore-errors was not set and an error was
>>> found.
>>> Traceback (most recent call last):
>>>   File "manage.py", line 31, in <module>
>>>     execute_from_command_line(sys.argv)
>>>   File
>>> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>> line 354, in execute_from_command_line
>>>     utility.execute()
>>>   File
>>> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>> line 346, in execute
>>>     self.fetch_command(subcommand).run_from_argv(self.argv)
>>>   File
>>> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
>>> line 394, in run_from_argv
>>>     self.execute(*args, **cmd_options)
>>>   File
>>> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
>>> line 445, in execute
>>>     output = self.handle(*args, **options)
>>>   File
>>> "/usr/src/geonode/geonode/geoserver/management/commands/updatelayers.py",
>>> line 124, in handle
>>>     execute_signals=True)
>>>   File "/usr/src/geonode/geonode/geoserver/helpers.py", line 630, in
>>> gs_slurp
>>>     layer.set_permissions(perm_spec)
>>>   File "/usr/src/geonode/geonode/security/models.py", line 205, in
>>> set_permissions
>>>     sync_geofence_with_guardian(self.layer, perms, user=geofence_user)
>>>   File "/usr/src/geonode/geonode/decorators.py", line 48, in wrapper
>>>     return func(*args, **kwargs)
>>>   File "/usr/src/geonode/geonode/security/utils.py", line 448, in
>>> sync_geofence_with_guardian
>>>     _update_geofence_rule(layer.name, layer.workspace, service,
>>> user=_user)
>>>   File "/usr/src/geonode/geonode/security/utils.py", line 592, in
>>> _update_geofence_rule
>>>     raise RuntimeError(msg)
>>> Exception: ('Failed to process previsao_meteorologica_aml',
>>> RuntimeError('Could not ADD GeoServer User \'admin\' Rule for Layer
>>> u\'previsao_meteorologica_aml\': \'u\'<!doctype html><html
>>> lang="en"><head><title>HTTP Status 404 \\u2013 Not Found</title><style
>>> type="text/css">h1
>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;}
>>> h2
>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;}
>>> h3
>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;}
>>> body
>>> {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} b
>>> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;}
>>> p
>>> {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}
>>> a {color:black;} a.name {color:black;} .line
>>> {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP
>>> Status 404 \\u2013 Not Found</h1><hr class="line" /><p><b>Type</b> Status
>>> Report</p><p><b>Description</b> The origin server did not find a current
>>> representation for the target resource or is not willing to disclose that
>>> one exists.</p><hr class="line" /><h3>Apache
>>> Tomcat/9.0.19</h3></body></html>\'\'',))
>>>
>>> Kind regards
>>>
>>> Julierme
>>>
>>> On Wed, Jul 17, 2019 at 2:23 PM Ran L. <kula009 at gmail.com> wrote:
>>>
>>>> Hi Julierme,
>>>>
>>>> I had the problem you described before. The reason you are getting this
>>>> is because the env variables are not set properly. Run this command before
>>>> running any other commands:
>>>>
>>>> mkdir -p /usr/src/app/; \
>>>> source $HOME/.override_env; \
>>>> echo DATABASE_URL=$DATABASE_URL; \
>>>> echo GEODATABASE_URL=$GEODATABASE_URL; \
>>>> echo SITEURL=$SITEURL; \
>>>> echo ALLOWED_HOSTS=$ALLOWED_HOSTS; \
>>>> echo GEOSERVER_PUBLIC_LOCATION=$GEOSERVER_PUBLIC_LOCATION;
>>>>
>>>> You should be able to run the commands then.
>>>>
>>>> I
>>>>
>>>>
>>>>
>>>> On Wed, Jul 17, 2019 at 10:19 AM 1520 gis <
>>>> juliermeopensourcedeveloper at gmail.com> wrote:
>>>>
>>>>> Hi Ran,
>>>>>
>>>>> Thank you very much for your reply. Yes, I just installed a brand new
>>>>> version of GeoNode-Project at 2.8 and updatelayers did not work. See the
>>>>> response in [1]. I then ran
>>>>>
>>>>> python manage.py makemigrations
>>>>> python manage.py migrate
>>>>>
>>>>> However, the problem remains. I am now asked for a superuser [2]. I
>>>>> did create a superuser for GeoNode-Project in a CenTOS7, but did not solve
>>>>> the problem. The issue also happens in GeoNode-Project at 2.10.
>>>>> Any help would be appreciated.
>>>>>
>>>>> Kind regards
>>>>>
>>>>> Julierme
>>>>>
>>>>> [1]
>>>>> root at 2ff53eacb7e9:/usr/src/my_geonode# python manage.py updatelayers
>>>>> -s metoc -f previsao_meteorologica_aml
>>>>> JSONField implementation is: <class 'jsonfield.fields.JSONField'>
>>>>> Traceback (most recent call last):
>>>>>   File "manage.py", line 31, in <module>
>>>>>     execute_from_command_line(sys.argv)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>> line 354, in execute_from_command_line
>>>>>     utility.execute()
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>> line 346, in execute
>>>>>     self.fetch_command(subcommand).run_from_argv(self.argv)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
>>>>> line 394, in run_from_argv
>>>>>     self.execute(*args, **cmd_options)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
>>>>> line 445, in execute
>>>>>     output = self.handle(*args, **options)
>>>>>   File
>>>>> "/usr/src/geonode/geonode/geoserver/management/commands/updatelayers.py",
>>>>> line 98, in handle
>>>>>     owner = get_valid_user(user)
>>>>>   File "/usr/src/geonode/geonode/people/utils.py", line 44, in
>>>>> get_valid_user
>>>>>     theuser = get_default_user()
>>>>>   File "/usr/src/geonode/geonode/people/utils.py", line 31, in
>>>>> get_default_user
>>>>>     if superusers.count() > 0:
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/models/query.py", line
>>>>> 318, in count
>>>>>     return self.query.get_count(using=self.db)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/query.py",
>>>>> line 466, in get_count
>>>>>     number = obj.get_aggregation(using, ['__count'])['__count']
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/query.py",
>>>>> line 447, in get_aggregation
>>>>>     result = compiler.execute_sql(SINGLE)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
>>>>> line 840, in execute_sql
>>>>>     cursor.execute(sql, params)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py", line
>>>>> 79, in execute
>>>>>     return super(CursorDebugWrapper, self).execute(sql, params)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py", line
>>>>> 64, in execute
>>>>>     return self.cursor.execute(sql, params)
>>>>>   File "/usr/local/lib/python2.7/site-packages/django/db/utils.py",
>>>>> line 98, in __exit__
>>>>>     six.reraise(dj_exc_type, dj_exc_value, traceback)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/backends/utils.py", line
>>>>> 64, in execute
>>>>>     return self.cursor.execute(sql, params)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py",
>>>>> line 318, in execute
>>>>>     return Database.Cursor.execute(self, query, params)
>>>>> django.db.utils.OperationalError: no such table: people_profile
>>>>>
>>>>> [2]
>>>>> root at 2ff53eacb7e9:/usr/src/my_geonode# python manage.py updatelayers
>>>>> -f previsao_meteorologica_aml
>>>>> JSONField implementation is: <class 'jsonfield.fields.JSONField'>
>>>>> Traceback (most recent call last):
>>>>>   File "manage.py", line 31, in <module>
>>>>>     execute_from_command_line(sys.argv)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>> line 354, in execute_from_command_line
>>>>>     utility.execute()
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/__init__.py",
>>>>> line 346, in execute
>>>>>     self.fetch_command(subcommand).run_from_argv(self.argv)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
>>>>> line 394, in run_from_argv
>>>>>     self.execute(*args, **cmd_options)
>>>>>   File
>>>>> "/usr/local/lib/python2.7/site-packages/django/core/management/base.py",
>>>>> line 445, in execute
>>>>>     output = self.handle(*args, **options)
>>>>>   File
>>>>> "/usr/src/geonode/geonode/geoserver/management/commands/updatelayers.py",
>>>>> line 98, in handle
>>>>>     owner = get_valid_user(user)
>>>>>   File "/usr/src/geonode/geonode/people/utils.py", line 44, in
>>>>> get_valid_user
>>>>>     theuser = get_default_user()
>>>>>   File "/usr/src/geonode/geonode/people/utils.py", line 35, in
>>>>> get_default_user
>>>>>     raise GeoNodeException('You must have an admin account configured '
>>>>> geonode.GeoNodeException: You must have an admin account configured
>>>>> before importing data. Try: django-admin.py createsuperuser
>>>>>
>>>>> On Wed, Jul 17, 2019 at 2:06 PM Ran L. <kula009 at gmail.com> wrote:
>>>>>
>>>>>> Hello Julierme,
>>>>>>
>>>>>> I also had issues with the geonode "updatelayers" command yesterday,
>>>>>> and might have found a possible solution for it:
>>>>>>
>>>>>> I'm also using geonode-project with docker on a Ubuntu machine. I
>>>>>> couldn't run the command successfully after building the service. You can
>>>>>> see the details here: https://github.com/GeoNode/geonode/issues/4650
>>>>>>
>>>>>> *A fix: *I took my own customized files (templates, python files,
>>>>>> statics, etc.) and dump them into a newly created geonode-project. The
>>>>>> command worked after that.
>>>>>>
>>>>>> My speculation is that the geonode-project files I had were not
>>>>>> compatible with the current geonode, since I haven't updated them for a
>>>>>> long while.
>>>>>>
>>>>>> Hope this provides some insights.
>>>>>>
>>>>>> Thanks!
>>>>>>
>>>>>> Ran
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Jul 17, 2019 at 9:47 AM 1520 gis <
>>>>>> juliermeopensourcedeveloper at gmail.com> wrote:
>>>>>>
>>>>>>> Dear users and developers,
>>>>>>>
>>>>>>> I am not sure if it is on the scope of future work, but I have
>>>>>>> already started a tutorial to install GeoNode-Project via Docker on a
>>>>>>> CentOS7 server. I got it installed, but not sure that I got all required
>>>>>>> geonode packages on a CenTOS7. Also, I had an issue while using python
>>>>>>> manage.py updatelayers.
>>>>>>>
>>>>>>> I am making myself a volunteer to help on this theme. I would like
>>>>>>> to share the command lines and have someones' contribution to improve what
>>>>>>> I got so far.
>>>>>>>
>>>>>>> Kind regards,
>>>>>>>
>>>>>>> Julierme
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> geonode-users mailing list
>>>>>>> geonode-users at lists.osgeo.org
>>>>>>> https://lists.osgeo.org/mailman/listinfo/geonode-users
>>>>>>>
>>>>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geonode-devel/attachments/20190717/73ba07b7/attachment-0001.html>


More information about the geonode-devel mailing list