{"action":"created","issue":{"url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts/issues/53","repository_url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts","labels_url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts/issues/53/labels{/name}","comments_url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts/issues/53/comments","events_url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts/issues/53/events","html_url":"https://github.com/UCL-RITS/rcps-buildscripts/issues/53","id":163368869,"number":53,"title":"Postgis bug","user":{"login":"willu47","id":3727919,"avatar_url":"https://avatars.githubusercontent.com/u/3727919?v=3","gravatar_id":"","url":"https://api.github.com/users/willu47","html_url":"https://github.com/willu47","followers_url":"https://api.github.com/users/willu47/followers","following_url":"https://api.github.com/users/willu47/following{/other_user}","gists_url":"https://api.github.com/users/willu47/gists{/gist_id}","starred_url":"https://api.github.com/users/willu47/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/willu47/subscriptions","organizations_url":"https://api.github.com/users/willu47/orgs","repos_url":"https://api.github.com/users/willu47/repos","events_url":"https://api.github.com/users/willu47/events{/privacy}","received_events_url":"https://api.github.com/users/willu47/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2016-07-01T10:38:54Z","updated_at":"2016-07-01T14:35:53Z","closed_at":null,"body":"When trying to create the postgis extension within a new postgres database, I get the following error:\r\n```\r\nTraceback (most recent call last):\r\n  File \"superpyrate/db_setup.py\", line 18, in <module>\r\n    main()\r\n  File \"superpyrate/db_setup.py\", line 15, in main\r\n    db.create()\r\n  File \"/home/ucftpw2/pyrate/pyrate/repositories/aisdb.py\", line 159, in create\r\n    tb.create()\r\n  File \"/home/ucftpw2/pyrate/pyrate/repositories/aisdb.py\", line 271, in create\r\n    cur.execute(\"CREATE EXTENSION IF NOT EXISTS postgis\")\r\npsycopg2.InternalError: could not load library \"/shared/ucl/apps/postgres+postgis/9.5.3+2.2.2/gnu-4.9.2/lib/postgis-2.2.so\": libimf.so: cannot open shared object file: No such file or directory\r\n```"},"comment":{"url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts/issues/comments/229963378","html_url":"https://github.com/UCL-RITS/rcps-buildscripts/issues/53#issuecomment-229963378","issue_url":"https://api.github.com/repos/UCL-RITS/rcps-buildscripts/issues/53","id":229963378,"user":{"login":"ikirker","id":479061,"avatar_url":"https://avatars.githubusercontent.com/u/479061?v=3","gravatar_id":"","url":"https://api.github.com/users/ikirker","html_url":"https://github.com/ikirker","followers_url":"https://api.github.com/users/ikirker/followers","following_url":"https://api.github.com/users/ikirker/following{/other_user}","gists_url":"https://api.github.com/users/ikirker/gists{/gist_id}","starred_url":"https://api.github.com/users/ikirker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ikirker/subscriptions","organizations_url":"https://api.github.com/users/ikirker/orgs","repos_url":"https://api.github.com/users/ikirker/repos","events_url":"https://api.github.com/users/ikirker/events{/privacy}","received_events_url":"https://api.github.com/users/ikirker/received_events","type":"User","site_admin":false},"created_at":"2016-07-01T14:35:53Z","updated_at":"2016-07-01T14:35:53Z","body":"I've fixed the `postgres+postgis/9.5.3+2.2.2/gnu-4.9.2` module to add the `geos` dependency, but that won't fix your Intel math libraries issue."}}
{"actor":{"display_login":"ikirker"}}