{"action":"created","issue":{"url":"https://api.github.com/repos/brianc/node-postgres/issues/553","repository_url":"https://api.github.com/repos/brianc/node-postgres","labels_url":"https://api.github.com/repos/brianc/node-postgres/issues/553/labels{/name}","comments_url":"https://api.github.com/repos/brianc/node-postgres/issues/553/comments","events_url":"https://api.github.com/repos/brianc/node-postgres/issues/553/events","html_url":"https://github.com/brianc/node-postgres/issues/553","id":30458054,"node_id":"MDU6SXNzdWUzMDQ1ODA1NA==","number":553,"title":"can't connect to heroku db server with SSL","user":{"login":"tedjt","id":455611,"node_id":"MDQ6VXNlcjQ1NTYxMQ==","avatar_url":"https://avatars1.githubusercontent.com/u/455611?v=4","gravatar_id":"","url":"https://api.github.com/users/tedjt","html_url":"https://github.com/tedjt","followers_url":"https://api.github.com/users/tedjt/followers","following_url":"https://api.github.com/users/tedjt/following{/other_user}","gists_url":"https://api.github.com/users/tedjt/gists{/gist_id}","starred_url":"https://api.github.com/users/tedjt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tedjt/subscriptions","organizations_url":"https://api.github.com/users/tedjt/orgs","repos_url":"https://api.github.com/users/tedjt/repos","events_url":"https://api.github.com/users/tedjt/events{/privacy}","received_events_url":"https://api.github.com/users/tedjt/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2014-03-30T03:07:07Z","updated_at":"2018-09-17T02:49:07Z","closed_at":"2014-04-08T18:41:49Z","author_association":"NONE","body":"I'm probably doing something wrong.\n\nI can connect to a DB hosted by Heroku from an EC2 box with`psql`, but the application crashes on startup attempting to make the SSL connection to the database.\n\nWhat's odd is that the application runs fine from my machine.\n\n``` js\nError: The server does not support SSL connections\n    at Socket.<anonymous> (/home/bitnami/source/server/node_modules/pg.js/lib/connection.js:70:33)\n    at g (events.js:175:14)\n    at EventEmitter.emit (events.js:117:20)\n    at Socket.<anonymous> (_stream_readable.js:746:14)\n    at EventEmitter.emit (events.js:92:17)\n    at emitReadable_ (_stream_readable.js:408:10)\n    at emitReadable (_stream_readable.js:404:5)\n    at readableAddChunk (_stream_readable.js:165:9)\n    at Readable.push (_stream_readable.js:127:10)\n    at TCP.onread (net.js:526:21)\n```\n\nlooking at the code there - the response looks like this:\n\n```\n< RESPONSE CODE: 51S7����~vK8Uv\\w�V����`1|��#�� �#����0��0��    �v�\\��-�0\n<       *�H��\n< 0'1%0#Uip-<redacted-IP>.ec2.internal0\n< 140318000523Z\n< 240315000523Z0'1%0#Uip-<redacted-IP>.ec2.internal0�\"0\n<       *�H��\n< �0�\n< ��/�6�`1�޹�JJ/�Y ��kw:%Ί��4\\����\"ҹ~�v��&d�>�������}Y��ZCɰ�p�{�����Z6���\"$�%3d�Q���<��&|7�Ýb�sf+\n< :QwC�X6�%~�����,��0���T�).��*82�SXa�w�~ا����/g��w{�l@�>Q��j�X����i��P�����������Ε�m���&۞�����!�h/�     ��SJ�a�z�)� ff�Y&~C�0\n<       *�H��\n< ��]��\"�0LSk#k��.��L����F�]\"%Z_�\n< ��Ic���|��6���~ٽ�2%3n0 ���    �3��m�����R5�!M`�,�SJ��W~�cm;~+�\n< LnJaL�k���`X�Hc�a\n< R�x����Z{���M����{�kK;�{��|,���#.-��š�I�w6����v�)���1r�������˞l����1a��&���<�4{@�����3�~X�zj�꽎z���X�#��d�W�����XNI�� ����6k3l8\n< E|��|[-����#�C��[���U��]8�4�|WC�l�3!,�*�<��)@�|��\n< rֆ��)zʕٖ���\n< P�F=f�]A��|��K\"&���^�U�/x����F��^��UP��տ�����%\")ύ;�3zs��r^&����dT�f�xM�}�B���<�g���,�l{Y�d��GHw9a�\"|���Z`�9��g�N���ɠ\n< �u����Ӗz ����3w��ԅ��?.�q�Ol�n��%5�0��L(�u9�����;����k͍�Zv ���k����K�����Ns�FP�)%4�2�ABsg����&��mOA�X��C!D�]���d�I��iP\"��8���*��5.s��J��Γ������e>B�GW������]�NO�2�\n< �t��U$�NMV'%���V0�Z���Ǖq��HsG��CK�y�b5%���]2c��K�ۊzc.�%��~5y?2�9������\n```\n"},"comment":{"url":"https://api.github.com/repos/brianc/node-postgres/issues/comments/421879835","html_url":"https://github.com/brianc/node-postgres/issues/553#issuecomment-421879835","issue_url":"https://api.github.com/repos/brianc/node-postgres/issues/553","id":421879835,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMTg3OTgzNQ==","user":{"login":"sevensfive","id":34802161,"node_id":"MDQ6VXNlcjM0ODAyMTYx","avatar_url":"https://avatars2.githubusercontent.com/u/34802161?v=4","gravatar_id":"","url":"https://api.github.com/users/sevensfive","html_url":"https://github.com/sevensfive","followers_url":"https://api.github.com/users/sevensfive/followers","following_url":"https://api.github.com/users/sevensfive/following{/other_user}","gists_url":"https://api.github.com/users/sevensfive/gists{/gist_id}","starred_url":"https://api.github.com/users/sevensfive/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sevensfive/subscriptions","organizations_url":"https://api.github.com/users/sevensfive/orgs","repos_url":"https://api.github.com/users/sevensfive/repos","events_url":"https://api.github.com/users/sevensfive/events{/privacy}","received_events_url":"https://api.github.com/users/sevensfive/received_events","type":"User","site_admin":false},"created_at":"2018-09-17T02:49:07Z","updated_at":"2018-09-17T02:49:07Z","author_association":"NONE","body":"> I know this is an old closed issue but google leads me here when I tried to solve the same problem.\r\n> I noticed that the error will be raised if the heroku instance is in sleep (free tier insance), after wake it up, the error will be gone. Hope this comment can help.\r\n\r\nIs there any way to solve this problem?"}}
{"actor":{"display_login":"sevensfive"}}