{"action":"created","issue":{"url":"https://api.github.com/repos/mapnik/mapnik/issues/3656","repository_url":"https://api.github.com/repos/mapnik/mapnik","labels_url":"https://api.github.com/repos/mapnik/mapnik/issues/3656/labels{/name}","comments_url":"https://api.github.com/repos/mapnik/mapnik/issues/3656/comments","events_url":"https://api.github.com/repos/mapnik/mapnik/issues/3656/events","html_url":"https://github.com/mapnik/mapnik/issues/3656","id":221794316,"number":3656,"title":"Using mapnik 3.5.14 on Heroku with PostGIS - stylesheet.xml SSL issue","user":{"login":"woudsma","id":6162978,"avatar_url":"https://avatars0.githubusercontent.com/u/6162978?v=3","gravatar_id":"","url":"https://api.github.com/users/woudsma","html_url":"https://github.com/woudsma","followers_url":"https://api.github.com/users/woudsma/followers","following_url":"https://api.github.com/users/woudsma/following{/other_user}","gists_url":"https://api.github.com/users/woudsma/gists{/gist_id}","starred_url":"https://api.github.com/users/woudsma/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/woudsma/subscriptions","organizations_url":"https://api.github.com/users/woudsma/orgs","repos_url":"https://api.github.com/users/woudsma/repos","events_url":"https://api.github.com/users/woudsma/events{/privacy}","received_events_url":"https://api.github.com/users/woudsma/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-14T11:43:28Z","updated_at":"2017-04-14T11:49:18Z","closed_at":null,"body":"It took me some time to get mapnik 3.5.14 to work on Heroku yesterday.\r\nMy steps to get it working:\r\n- Change Heroku stack to use Ubuntu 16.04 `heroku stack:set heroku-16`\r\n- Add apt-buildpack `heroku buildpacks:add --index 1 https://github.com/heroku/heroku-buildpack-apt`\r\n- Create `Aptfile` in project root to get rid of `Error: /usr/lib/x86_64-linux-gnu/libstdc++.so.6: version 'GLIBCXX_3.4.21' not found`, content:\r\n```\r\nlibc6\r\nlibgcc1\r\nlibstdc++6\r\nhttp://mirrors.kernel.org/ubuntu/pool/main/g/gcc-4.9/gcc-4.9_4.9.2-10ubuntu13_amd64.deb\r\nhttp://mirrors.kernel.org/ubuntu/pool/main/g/gcc-4.9/libstdc%2b%2b6_4.9.2-10ubuntu13_amd64.deb\r\n```\r\n\r\nProbably don't need all packages, but no time to test..\r\nUsing node.js to connect to Postgres requires a SSL connection to the Heroku Postgres addon. `heroku config:set PGSSLMODE=require`\r\nMy issue is that mapnik isn't able to connect to the PostGIS database through SSL.\r\n```\r\nError: Postgis Plugin: sslmode value \"require\" invalid when SSL support is not compiled in Connection string: 'host=my-heroku-ec2-host dbname=name etc..\r\nencountered during parsing of layer 'layer' in Layer of '/app/src/resources/stylesheet.xml'\r\n```\r\n\r\nIs there a way to connect to the database using SSL? I've tried adding a parameter to `<Datasource>`, like `<Parameter name='sslmode'>require</Parameter>`. That didn't work. Also read https://github.com/mapnik/mapnik/issues/2550 but i'm not sure if i'm able to compile from source on Heroku. Help is much appreciated!"},"comment":{"url":"https://api.github.com/repos/mapnik/mapnik/issues/comments/294141174","html_url":"https://github.com/mapnik/mapnik/issues/3656#issuecomment-294141174","issue_url":"https://api.github.com/repos/mapnik/mapnik/issues/3656","id":294141174,"user":{"login":"tomhughes","id":147741,"avatar_url":"https://avatars3.githubusercontent.com/u/147741?v=3","gravatar_id":"","url":"https://api.github.com/users/tomhughes","html_url":"https://github.com/tomhughes","followers_url":"https://api.github.com/users/tomhughes/followers","following_url":"https://api.github.com/users/tomhughes/following{/other_user}","gists_url":"https://api.github.com/users/tomhughes/gists{/gist_id}","starred_url":"https://api.github.com/users/tomhughes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tomhughes/subscriptions","organizations_url":"https://api.github.com/users/tomhughes/orgs","repos_url":"https://api.github.com/users/tomhughes/repos","events_url":"https://api.github.com/users/tomhughes/events{/privacy}","received_events_url":"https://api.github.com/users/tomhughes/received_events","type":"User","site_admin":false},"created_at":"2017-04-14T11:49:18Z","updated_at":"2017-04-14T11:49:18Z","body":"Well it appears you are using a libpq that has been compiled without SSL support so no, you won't be able to connect using SSL until you fix that."}}
{"actor":{"display_login":"tomhughes"}}