{"action":"created","issue":{"url":"https://api.github.com/repos/balderdashy/sails-postgresql/issues/211","labels_url":"https://api.github.com/repos/balderdashy/sails-postgresql/issues/211/labels{/name}","comments_url":"https://api.github.com/repos/balderdashy/sails-postgresql/issues/211/comments","events_url":"https://api.github.com/repos/balderdashy/sails-postgresql/issues/211/events","html_url":"https://github.com/balderdashy/sails-postgresql/issues/211","id":120853396,"number":211,"title":"Cant connect to production database","user":{"login":"karlclement","id":539188,"avatar_url":"https://avatars.githubusercontent.com/u/539188?v=3","gravatar_id":"","url":"https://api.github.com/users/karlclement","html_url":"https://github.com/karlclement","followers_url":"https://api.github.com/users/karlclement/followers","following_url":"https://api.github.com/users/karlclement/following{/other_user}","gists_url":"https://api.github.com/users/karlclement/gists{/gist_id}","starred_url":"https://api.github.com/users/karlclement/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karlclement/subscriptions","organizations_url":"https://api.github.com/users/karlclement/orgs","repos_url":"https://api.github.com/users/karlclement/repos","events_url":"https://api.github.com/users/karlclement/events{/privacy}","received_events_url":"https://api.github.com/users/karlclement/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-12-07T19:53:51Z","updated_at":"2015-12-07T20:33:14Z","closed_at":null,"body":"I have been at this all day, and found absolutely nothing online to help. When sails lift on my server, I get this for trying to connect to my production database. I tried 3 different postgres DB locations. There is probably something wrong with my settings but I have no idea where to look since the error message gives me nothing. Here is the error:\r\n\r\n```\r\n/var/www/url.com/releases/1449515660/node_modules/sails-postgresql/lib/adapter.js:393\r\n        Object.keys(collection.schema).forEach(function(schemaKey) {\r\n               ^\r\nTypeError: Object.keys called on non-object\r\n    at Function.keys (native)\r\n    at __CREATE__ (/var/www/url.com/releases/1449515660/node_modules/sails-postgresql/lib/adapter.js:393:16)\r\n    at after (/var/www/url.com/releases/1449515660/node_modules/sails-postgresql/lib/adapter.js:1208:7)\r\n    at /var/www/url.com/releases/1449515660/node_modules/sails-postgresql/lib/adapter.js:1102:7\r\n    at /var/www/url.com/releases/1449515660/node_modules/sails-postgresql/node_modules/pg/lib/pool.js:82:9\r\n    at /var/www/url.com/releases/1449515660/node_modules/sails-postgresql/node_modules/pg/node_modules/generic-pool/lib/generic-pool.js:281:11\r\n    at /var/www/url.com/releases/1449515660/node_modules/sails-postgresql/node_modules/pg/lib/pool.js:56:18\r\n    at null.<anonymous> (/var/www/url.com/releases/1449515660/node_modules/sails-postgresql/node_modules/pg/lib/client.js:149:7)\r\n    at g (events.js:199:16)\r\n    at emit (events.js:129:20)\r\n    at Socket.<anonymous> (/var/www/url.com/releases/1449515660/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:109:12)\r\n    at Socket.emit (events.js:107:17)\r\n    at readableAddChunk (_stream_readable.js:163:16)\r\n    at Socket.Readable.push (_stream_readable.js:126:10)\r\n    at TCP.onread (net.js:538:20)\r\n```\r\n\r\nHere is my connections.js file:\r\n```\r\ndevPostgresqlServer: {\r\n    adapter: 'sails-postgresql',\r\n    host: 'localhost',\r\n    user: 'username',\r\n    password: '',\r\n    database: 'databasename',\r\n    ssl: false,\r\n    schema: true\r\n  },\r\n\r\n  herokuPostgresqlServer: {\r\n    adapter: 'sails-postgresql',\r\n    host: '**************.amazonaws.com',\r\n    user: '********',\r\n    password: '*********',\r\n    database: '*************',\r\n    ssl: true,\r\n    schema: true\r\n  },\r\n\r\n  prodAmazonPostgresqlServer: {\r\n    adapter: 'sails-postgresql',\r\n    host: '*********.amazonaws.com',\r\n    user: '********',\r\n    password: '*************',\r\n    database: '********',\r\n    autoPK: false,\r\n    ssl: false,\r\n    poolSize: 0,\r\n    schema: true\r\n  },\r\n\r\n  prodPostgresqlServer: {\r\n    adapter: 'sails-postgresql',\r\n    host: 'localhost',\r\n    user: '**********',\r\n    password: '************',\r\n    database: '***************',\r\n    ssl: false,\r\n    schema: true\r\n  }\r\n```\r\n\r\nMy local connection works perfectly fine, all 3 other prod versions do not work. PLEASEEEEEE help me!!!! Thanks so much"},"comment":{"url":"https://api.github.com/repos/balderdashy/sails-postgresql/issues/comments/162652733","html_url":"https://github.com/balderdashy/sails-postgresql/issues/211#issuecomment-162652733","issue_url":"https://api.github.com/repos/balderdashy/sails-postgresql/issues/211","id":162652733,"user":{"login":"kevinburkeshyp","id":10735057,"avatar_url":"https://avatars.githubusercontent.com/u/10735057?v=3","gravatar_id":"","url":"https://api.github.com/users/kevinburkeshyp","html_url":"https://github.com/kevinburkeshyp","followers_url":"https://api.github.com/users/kevinburkeshyp/followers","following_url":"https://api.github.com/users/kevinburkeshyp/following{/other_user}","gists_url":"https://api.github.com/users/kevinburkeshyp/gists{/gist_id}","starred_url":"https://api.github.com/users/kevinburkeshyp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kevinburkeshyp/subscriptions","organizations_url":"https://api.github.com/users/kevinburkeshyp/orgs","repos_url":"https://api.github.com/users/kevinburkeshyp/repos","events_url":"https://api.github.com/users/kevinburkeshyp/events{/privacy}","received_events_url":"https://api.github.com/users/kevinburkeshyp/received_events","type":"User","site_admin":false},"created_at":"2015-12-07T20:33:13Z","updated_at":"2015-12-07T20:33:13Z","body":"what is the `collection` object? can you trace that, when the connection is\nsuccessful vs. unsuccessful?\n\nOn Mon, Dec 7, 2015 at 12:29 PM, Karl Clement <notifications@github.com>\nwrote:\n\n> @kevinburkeshyp <https://github.com/kevinburkeshyp> it returns undefined\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/balderdashy/sails-postgresql/issues/211#issuecomment-162651325>\n> .\n>\n\n\n\n-- \nkevin\n"}}