{"action":"created","issue":{"url":"https://api.github.com/repos/Mailu/Mailu/issues/612","repository_url":"https://api.github.com/repos/Mailu/Mailu","labels_url":"https://api.github.com/repos/Mailu/Mailu/issues/612/labels{/name}","comments_url":"https://api.github.com/repos/Mailu/Mailu/issues/612/comments","events_url":"https://api.github.com/repos/Mailu/Mailu/issues/612/events","html_url":"https://github.com/Mailu/Mailu/pull/612","id":364465501,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE4NjQzODg4","number":612,"title":"Abstract db access from Postfix and Dovecot","user":{"login":"kaiyou","id":847861,"node_id":"MDQ6VXNlcjg0Nzg2MQ==","avatar_url":"https://avatars0.githubusercontent.com/u/847861?v=4","gravatar_id":"","url":"https://api.github.com/users/kaiyou","html_url":"https://github.com/kaiyou","followers_url":"https://api.github.com/users/kaiyou/followers","following_url":"https://api.github.com/users/kaiyou/following{/other_user}","gists_url":"https://api.github.com/users/kaiyou/gists{/gist_id}","starred_url":"https://api.github.com/users/kaiyou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaiyou/subscriptions","organizations_url":"https://api.github.com/users/kaiyou/orgs","repos_url":"https://api.github.com/users/kaiyou/repos","events_url":"https://api.github.com/users/kaiyou/events{/privacy}","received_events_url":"https://api.github.com/users/kaiyou/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-09-27T13:02:02Z","updated_at":"2018-10-06T20:13:39Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/Mailu/Mailu/pulls/612","html_url":"https://github.com/Mailu/Mailu/pull/612","diff_url":"https://github.com/Mailu/Mailu/pull/612.diff","patch_url":"https://github.com/Mailu/Mailu/pull/612.patch"},"body":"This is a work in progress but I guess the review can start already as 90% of it is testable.\r\n\r\nMost of the original work is discussed in #420 and #445. The general idea is that  \r\n\r\n- Podop (https://github.com/mailu/podop) is a proxy framework between Postfix/Dovecot and any Python available service, including notably a REST API\r\n- A fairly simple (and still a bit too tightly dependent on Postfix/Dovecot structures) API was written as part of the internal REST API already leveraged for authentication, the API includes transparent authentication for Dovecot, domain, alias, mailbox and transport resolution for Postfix, quotas, sieve scripts.\r\n- A simple sieve script as a Jinja template was written, removing the need for extdata in sieve.\r\n- Dovecot and Postfix were bound to the admin container API using Podop, embedded as a side process in both start scripts.\r\n- Fetchmail was bound to a simple internal API on the admin container.\r\n\r\nNo change should be required in a standard compose environment. There are still a lot of tests to run before declaring this equivalent to the current database queries."},"comment":{"url":"https://api.github.com/repos/Mailu/Mailu/issues/comments/427603045","html_url":"https://github.com/Mailu/Mailu/pull/612#issuecomment-427603045","issue_url":"https://api.github.com/repos/Mailu/Mailu/issues/612","id":427603045,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNzYwMzA0NQ==","user":{"login":"kaiyou","id":847861,"node_id":"MDQ6VXNlcjg0Nzg2MQ==","avatar_url":"https://avatars0.githubusercontent.com/u/847861?v=4","gravatar_id":"","url":"https://api.github.com/users/kaiyou","html_url":"https://github.com/kaiyou","followers_url":"https://api.github.com/users/kaiyou/followers","following_url":"https://api.github.com/users/kaiyou/following{/other_user}","gists_url":"https://api.github.com/users/kaiyou/gists{/gist_id}","starred_url":"https://api.github.com/users/kaiyou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaiyou/subscriptions","organizations_url":"https://api.github.com/users/kaiyou/orgs","repos_url":"https://api.github.com/users/kaiyou/repos","events_url":"https://api.github.com/users/kaiyou/events{/privacy}","received_events_url":"https://api.github.com/users/kaiyou/received_events","type":"User","site_admin":false},"created_at":"2018-10-06T20:13:39Z","updated_at":"2018-10-06T20:13:39Z","author_association":"MEMBER","body":"1. I am working on fixing incoming and outgoing email on this branch\r\n2. -\r\n3. Redis was used for storing current quota and was replaced by API calls for this purpose. It is still used as a transient database for authentication rate limiting and greylisting though, so it should not be removed from the compose file.\r\n4. The test file is a very basic stub used to send an email, which I committed for the purpose of manual testing but is not ready yet for automated testing.\r\n5. Indeed, the general idea is that once this is working, I will test the actual support of other databases (we might have some sqlite specific tricks in the data model still) and then add a configuration value for specifying the database location plus related documentation."}}
{"actor":{"display_login":"kaiyou"}}