[GeoNode-users] Failure to connect to postgres store in geonode 2.5

admire addloe at gmail.com
Thu Sep 29 02:54:54 PDT 2016


Hi

I have installed docker geonode 2.5 but I am however failing to create a 
postgis store in geonode geoserver.

The containers are linked fine but when you exec into the container 
looking at the /etc/hosts shows that no entry for the linked containers 
is visible.

When I do a docker inspect on the geoserver container I can see the 
containers are linked but I cannot publish a postgis store in geonode 
geoserver

docker-compose -p gfdrr_oondra exec django django-admin.py migrate 
account --noinput
Traceback (most recent call last):
   File "/usr/local/bin/django-admin.py", line 5, in <module>
     management.execute_from_command_line()
   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/local/lib/python2.7/site-packages/django/core/management/commands/migrate.py", 
line 93, in handle
     executor = MigrationExecutor(connection, 
self.migration_progress_callback)
   File 
"/usr/local/lib/python2.7/site-packages/django/db/migrations/executor.py", 
line 19, in __init__
     self.loader = MigrationLoader(self.connection)
   File 
"/usr/local/lib/python2.7/site-packages/django/db/migrations/loader.py", 
line 47, in __init__
     self.build_graph()
   File 
"/usr/local/lib/python2.7/site-packages/django/db/migrations/loader.py", 
line 191, in build_graph
     self.applied_migrations = recorder.applied_migrations()
   File 
"/usr/local/lib/python2.7/site-packages/django/db/migrations/recorder.py", 
line 59, in applied_migrations
     self.ensure_schema()
   File 
"/usr/local/lib/python2.7/site-packages/django/db/migrations/recorder.py", 
line 49, in ensure_schema
     if self.Migration._meta.db_table in 
self.connection.introspection.table_names(self.connection.cursor()):
   File 
"/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", 
line 162, in cursor
     cursor = self.make_debug_cursor(self._cursor())
   File 
"/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", 
line 135, in _cursor
     self.ensure_connection()
   File 
"/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", 
line 130, in ensure_connection
     self.connect()
   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/base/base.py", 
line 130, in ensure_connection
     self.connect()
   File 
"/usr/local/lib/python2.7/site-packages/django/db/backends/base/base.py", 
line 119, in connect
     self.connection = self.get_new_connection(conn_params)
   File 
"/usr/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", 
line 176, in get_new_connection
     connection = Database.connect(**conn_params)
   File "/usr/local/lib/python2.7/site-packages/psycopg2/__init__.py", 
line 164, in connect
     conn = _connect(dsn, connection_factory=connection_factory, 
async=async)
django.db.utils.OperationalError: FATAL:  no pg_hba.conf entry for host 
"172.19.0.7", user "postgres", database "postgres", SSL on
FATAL:  no pg_hba.conf entry for host "172.19.0.7", user "postgres", 
database "postgres", SSL off


Regards



More information about the geonode-users mailing list