{"action":"created","issue":{"url":"https://api.github.com/repos/pypa/warehouse/issues/1423","repository_url":"https://api.github.com/repos/pypa/warehouse","labels_url":"https://api.github.com/repos/pypa/warehouse/issues/1423/labels{/name}","comments_url":"https://api.github.com/repos/pypa/warehouse/issues/1423/comments","events_url":"https://api.github.com/repos/pypa/warehouse/issues/1423/events","html_url":"https://github.com/pypa/warehouse/issues/1423","id":170776150,"number":1423,"title":"Access directly warehouse Docker DB from pypi-legacy ?","user":{"login":"Carreau","id":335567,"avatar_url":"https://avatars.githubusercontent.com/u/335567?v=3","gravatar_id":"","url":"https://api.github.com/users/Carreau","html_url":"https://github.com/Carreau","followers_url":"https://api.github.com/users/Carreau/followers","following_url":"https://api.github.com/users/Carreau/following{/other_user}","gists_url":"https://api.github.com/users/Carreau/gists{/gist_id}","starred_url":"https://api.github.com/users/Carreau/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Carreau/subscriptions","organizations_url":"https://api.github.com/users/Carreau/orgs","repos_url":"https://api.github.com/users/Carreau/repos","events_url":"https://api.github.com/users/Carreau/events{/privacy}","received_events_url":"https://api.github.com/users/Carreau/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-12T00:21:28Z","updated_at":"2016-08-12T14:09:06Z","closed_at":null,"body":"Hi there, \r\n\r\nI'm trying to get legacy-pypi to work locally, to implement pep-503 (the data-python-requires attributes). \r\nThe information to run pypi-legacy are quite out of date, but IIUC current deployed warehouse and PyPI are sharing a DB; so I guess it is possible to start a legacy-pypi and set-it up to use the docker-db... \r\n\r\nSo far I **think** I understood that the db ip is the docker one, usename is `warehouse` so config.ini should be something like... :\r\n``\r\n[database]\r\n\r\n;Postgres Database\r\nhost = 192.168.99.100; ? db ?\r\n;port = 5432 ; ?? is that the right port \r\nname = warehouse\r\nuser = postgres\r\npassword = ??; \r\n```\r\n\r\nI've commented / wrapped in try/except all the boto connexions in pypi-legacy that are trying to connect ... and end ran `python pypi.wsgi` which ends up showing this on the main page : \r\n\r\n```\r\nDatabase connection failed\r\n\r\nPlease try again later.\r\n<!-- could not connect to server: Connection refused\r\n\tIs the server running on host \"192.168.99.100\" and accepting\r\n\tTCP/IP connections on port 5432?\r\n -->\r\n```\r\n\r\nNow I'm stuck. \r\n\r\nI'm happy to improve the documentation to tell people how to do that, which I've [started with a PR](https://github.com/pypa/pypi-legacy/pull/497), so would gladely get some help/pointers !\r\n\r\nThanks !\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/pypa/warehouse/issues/comments/239456074","html_url":"https://github.com/pypa/warehouse/issues/1423#issuecomment-239456074","issue_url":"https://api.github.com/repos/pypa/warehouse/issues/1423","id":239456074,"user":{"login":"dstufft","id":145979,"avatar_url":"https://avatars.githubusercontent.com/u/145979?v=3","gravatar_id":"","url":"https://api.github.com/users/dstufft","html_url":"https://github.com/dstufft","followers_url":"https://api.github.com/users/dstufft/followers","following_url":"https://api.github.com/users/dstufft/following{/other_user}","gists_url":"https://api.github.com/users/dstufft/gists{/gist_id}","starred_url":"https://api.github.com/users/dstufft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dstufft/subscriptions","organizations_url":"https://api.github.com/users/dstufft/orgs","repos_url":"https://api.github.com/users/dstufft/repos","events_url":"https://api.github.com/users/dstufft/events{/privacy}","received_events_url":"https://api.github.com/users/dstufft/received_events","type":"User","site_admin":false},"created_at":"2016-08-12T14:09:06Z","updated_at":"2016-08-12T14:09:06Z","body":"Generally when working on legacy PyPI is just use ``example.sql.xz`` like @berkerpeksag to restore to a new database. Sometimes I have to run the migrations on it and such but genreally that's what I Do.\r\n\r\nYou could adjust ``docker-compose.yml`` so that it exposes the PostgreSQL port though."}}
{"actor":{"display_login":"dstufft"}}