{"action":"created","issue":{"url":"https://api.github.com/repos/r00t-3xp10it/venom/issues/2","repository_url":"https://api.github.com/repos/r00t-3xp10it/venom","labels_url":"https://api.github.com/repos/r00t-3xp10it/venom/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/r00t-3xp10it/venom/issues/2/comments","events_url":"https://api.github.com/repos/r00t-3xp10it/venom/issues/2/events","html_url":"https://github.com/r00t-3xp10it/venom/issues/2","id":194663188,"number":2,"title":"Error Connecting to Posgresql Database (metasploit)","user":{"login":"r00t-3xp10it","id":23490060,"avatar_url":"https://avatars.githubusercontent.com/u/23490060?v=3","gravatar_id":"","url":"https://api.github.com/users/r00t-3xp10it","html_url":"https://github.com/r00t-3xp10it","followers_url":"https://api.github.com/users/r00t-3xp10it/followers","following_url":"https://api.github.com/users/r00t-3xp10it/following{/other_user}","gists_url":"https://api.github.com/users/r00t-3xp10it/gists{/gist_id}","starred_url":"https://api.github.com/users/r00t-3xp10it/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/r00t-3xp10it/subscriptions","organizations_url":"https://api.github.com/users/r00t-3xp10it/orgs","repos_url":"https://api.github.com/users/r00t-3xp10it/repos","events_url":"https://api.github.com/users/r00t-3xp10it/events{/privacy}","received_events_url":"https://api.github.com/users/r00t-3xp10it/received_events","type":"User","site_admin":false},"labels":[{"id":482709792,"url":"https://api.github.com/repos/r00t-3xp10it/venom/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-09T18:20:53Z","updated_at":"2016-12-10T03:31:09Z","closed_at":null,"body":"# bug description\r\n    New upgrade in postgresql-9.6 have changed the default access port from 5432 to 5433\r\n    and stoped the support of postgresql in localhost (127.0.0.1), this article explains\r\n    how to fix the postgresql database connection issue of metasploit in kali linux distros.\r\n\r\n> Metasploit database error connecting to postgresql service/port(5432)\r\n![postgresql error](https://dl.dropboxusercontent.com/u/21426454/github/error4.png)\r\n![postgresql error](https://dl.dropboxusercontent.com/u/21426454/github/error5.png)\r\n\r\n<br /><br /><br />\r\n# msfdb connection Fix\r\n\r\n> 1º - Locate postgresql configuration files (9.5 and 9.6)\r\n\r\n    locate postgresql.conf\r\n\r\n> 2º - Edit configuration files\r\n\r\n    nano /etc/postgresql/9.6/main/postgresql.conf\r\n\r\n> 3º - Search for '''port''' inside the postgresql.conf \r\n> And change the next values: [ listen_addresses | port | unix_socket_permissions ] \r\n![postgresql error](https://dl.dropboxusercontent.com/u/21426454/github/error6.png)\r\n\r\n> 4º - Start postgresql service\r\n\r\n    service postgresql start\r\n    service postgresql status\r\n![postgresql error](https://dl.dropboxusercontent.com/u/21426454/github/error2.png)\r\n\r\n> 5º - Check if port 5432(postgresql) its listenning on 'localhost'\r\n\r\n    ss -ant | grep 5432\r\n![postgresql error](https://dl.dropboxusercontent.com/u/21426454/github/lis.png)\r\n\r\n> 6º - Delele old database (database.yml) configurations\r\n> \"This next step will delete all hosts/creds/etc current stored into current db\"\r\n\r\n    msfdb delete\r\n\r\n> 7º - Creating new database.yml\r\n> \"No need to enter any value (username:password), all proccess its automatized\"\r\n\r\n    msfdb init\r\n![postgresql error](https://dl.dropboxusercontent.com/u/21426454/github/error8.png)\r\n\r\n> 8º - Start metasploit console\r\n\r\n    msfconsole\r\n\r\n> 9º - Check connection to database\r\n\r\n    db_status\r\n![postgresql error](https://dl.dropboxusercontent.com/u/21426454/github/error9.png)\r\n\r\n<br /><br />\r\n\r\n# Final notes:\r\n> 1º - In some ocasions we need to restart system for the changes make effect..\r\n> 2º - In some distros postegresql its started this way: /etc/init.d/postgresql start\r\n> 3º - In some distros metasploit sevice needed to be started: /etc/init.d/metasploit start\r\n\r\n<br />\r\n_EOF"},"comment":{"url":"https://api.github.com/repos/r00t-3xp10it/venom/issues/comments/266175961","html_url":"https://github.com/r00t-3xp10it/venom/issues/2#issuecomment-266175961","issue_url":"https://api.github.com/repos/r00t-3xp10it/venom/issues/2","id":266175961,"user":{"login":"spiritedwolf","id":18477824,"avatar_url":"https://avatars.githubusercontent.com/u/18477824?v=3","gravatar_id":"","url":"https://api.github.com/users/spiritedwolf","html_url":"https://github.com/spiritedwolf","followers_url":"https://api.github.com/users/spiritedwolf/followers","following_url":"https://api.github.com/users/spiritedwolf/following{/other_user}","gists_url":"https://api.github.com/users/spiritedwolf/gists{/gist_id}","starred_url":"https://api.github.com/users/spiritedwolf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spiritedwolf/subscriptions","organizations_url":"https://api.github.com/users/spiritedwolf/orgs","repos_url":"https://api.github.com/users/spiritedwolf/repos","events_url":"https://api.github.com/users/spiritedwolf/events{/privacy}","received_events_url":"https://api.github.com/users/spiritedwolf/received_events","type":"User","site_admin":false},"created_at":"2016-12-10T03:31:09Z","updated_at":"2016-12-10T03:31:09Z","body":"cool :D hope it will help us in future. "}}
{"actor":{"display_login":"spiritedwolf"}}