Spatialite error with course vm. Linux

[korvinos]

TASK [geospaas_catalog : Setup DB | Run makemigrations on django-geo-spaas project] ***
task path: /vagrant/provisioning/roles/geospaas_catalog/tasks/setup_db.yml:2
Using module file /usr/local/lib/python2.7/dist-packages/ansible/modules/web_infrastructure/django_manage.py
<192.168.33.10> ESTABLISH LOCAL CONNECTION FOR USER: vagrant
<192.168.33.10> EXEC /bin/sh -c 'echo ~ && sleep 0'
<192.168.33.10> EXEC /bin/sh -c '( umask 77 && mkdir -p "` echo /home/vagrant/.ansible/tmp/ansible-tmp-1513717508.43-226667677386440 `" && echo ansible-tmp-1513717508.43-226667677386440="` echo /home/vagrant/.ansible/tmp/ansible-tmp-1513717508.43-226667677386440 `" ) && sleep 0'
<192.168.33.10> PUT /tmp/tmpRtKDaL TO /home/vagrant/.ansible/tmp/ansible-tmp-1513717508.43-226667677386440/django_manage.py
<192.168.33.10> EXEC /bin/sh -c 'chmod u+x /home/vagrant/.ansible/tmp/ansible-tmp-1513717508.43-226667677386440/ /home/vagrant/.ansible/tmp/ansible-tmp-1513717508.43-226667677386440/django_manage.py && sleep 0'
<192.168.33.10> EXEC /bin/sh -c 'GDAL_DATA=/home/vagrant/miniconda/share/gdal PATH=/home/vagrant/miniconda/bin:/usr/sbin:/usr/bin:/sbin:/bin LC_ALL=en_US.UTF-8 /usr/bin/python /home/vagrant/.ansible/tmp/ansible-tmp-1513717508.43-226667677386440/django_manage.py; rm -rf "/home/vagrant/.ansible/tmp/ansible-tmp-1513717508.43-226667677386440/" > /dev/null 2>&1 && sleep 0'
fatal: [192.168.33.10]: FAILED! => {
    "changed": false, 
    "cmd": "./manage.py makemigrations --settings=geospaas_project.settings --pythonpath=/vagrant/shared/course_vm/geospaas_project", 
    "invocation": {
        "module_args": {
            "app_path": "/vagrant/shared/course_vm/geospaas_project", 
            "apps": null, 
            "cache_table": null, 
            "clear": null, 
            "command": "makemigrations", 
            "database": null, 
            "failfast": false, 
            "fixtures": null, 
            "link": null, 
            "liveserver": null, 
            "merge": null, 
            "pythonpath": "/vagrant/shared/course_vm/geospaas_project", 
            "settings": "geospaas_project.settings", 
            "skip": null, 
            "testrunner": null, 
            "virtualenv": null
        }
    }, 
    "msg": "\n:stderr: Traceback (most recent call last):\n  File \"./manage.py\", line 22, in <module>\n    execute_from_command_line(sys.argv)\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/core/management/__init__.py\", line 364, in execute_from_command_line\n    utility.execute()\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/core/management/__init__.py\", line 356, in execute\n    self.fetch_command(subcommand).run_from_argv(self.argv)\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/core/management/base.py\", line 283, in run_from_argv\n    self.execute(*args, **cmd_options)\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/core/management/base.py\", line 330, in execute\n    output = self.handle(*args, **options)\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/core/management/commands/makemigrations.py\", line 110, in handle\n    loader.check_consistent_history(connection)\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/migrations/loader.py\", line 282, in check_consistent_history\n    applied = recorder.applied_migrations()\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/migrations/recorder.py\", line 65, in applied_migrations\n    self.ensure_schema()\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/migrations/recorder.py\", line 52, in ensure_schema\n    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 254, in cursor\n    return self._cursor()\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 229, in _cursor\n    self.ensure_connection()\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 213, in ensure_connection\n    self.connect()\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/backends/base/base.py\", line 189, in connect\n    self.connection = self.get_new_connection(conn_params)\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/base.py\", line 65, in get_new_connection\n    six.reraise(ImproperlyConfigured, ImproperlyConfigured(new_msg), sys.exc_info()[2])\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/base.py\", line 60, in get_new_connection\n    cur.execute(\"SELECT load_extension(%s)\", (self.spatialite_lib,))\n  File \"/home/vagrant/miniconda/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py\", line 328, in execute\n    return Database.Cursor.execute(self, query, params)\ndjango.core.exceptions.ImproperlyConfigured: Unable to load the SpatiaLite library extension \"/home/vagrant/miniconda/lib/libspatialite.so.7\" because: /home/vagrant/miniconda/lib/./libspatialite.so.7: undefined symbol: sqlite3_spatialite_init\n", 
    "path": "/home/vagrant/miniconda/bin:/usr/sbin:/usr/bin:/sbin:/bin", 
    "state": "absent", 
    "syspath": [
        "/tmp/ansible_iPIMPH", 
        "/tmp/ansible_iPIMPH/ansible_modlib.zip", 
        "/tmp/ansible_iPIMPH/ansible_modlib.zip", 
        "/usr/lib/python2.7", 
        "/usr/lib/python2.7/plat-x86_64-linux-gnu", 
        "/usr/lib/python2.7/lib-tk", 
        "/usr/lib/python2.7/lib-old", 
        "/usr/lib/python2.7/lib-dynload", 
        "/usr/local/lib/python2.7/dist-packages", 
        "/usr/lib/python2.7/dist-packages"
    ]
}

[mortenwh]

I think I solved this one in e789025856aec8caddad400a2e15acd5259a5403 - can you pull and retry?

[korvinos]

@mortenwh I found this solution as well and tried locally. It did not work, I have tried now with pull and unfortunately is still does not work .

[korvinos]

I suppose that the problem is because of the ansible somehow can not install the spatialite at all (we install that as to the system as to the python environment) . If I go to the vm after error I won't be able to find that. As well as that path which you added to the settings.py does not exists.