{"action":"created","issue":{"url":"https://api.github.com/repos/OpenSMTPD/OpenSMTPD/issues/552","labels_url":"https://api.github.com/repos/OpenSMTPD/OpenSMTPD/issues/552/labels{/name}","comments_url":"https://api.github.com/repos/OpenSMTPD/OpenSMTPD/issues/552/comments","events_url":"https://api.github.com/repos/OpenSMTPD/OpenSMTPD/issues/552/events","html_url":"https://github.com/OpenSMTPD/OpenSMTPD/issues/552","id":66583420,"number":552,"title":"Configurable lookup in query for *sql backend","user":{"login":"mischapeters","id":7456624,"avatar_url":"https://avatars.githubusercontent.com/u/7456624?v=3","gravatar_id":"","url":"https://api.github.com/users/mischapeters","html_url":"https://github.com/mischapeters","followers_url":"https://api.github.com/users/mischapeters/followers","following_url":"https://api.github.com/users/mischapeters/following{/other_user}","gists_url":"https://api.github.com/users/mischapeters/gists{/gist_id}","starred_url":"https://api.github.com/users/mischapeters/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mischapeters/subscriptions","organizations_url":"https://api.github.com/users/mischapeters/orgs","repos_url":"https://api.github.com/users/mischapeters/repos","events_url":"https://api.github.com/users/mischapeters/events{/privacy}","received_events_url":"https://api.github.com/users/mischapeters/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-04-06T11:16:12Z","updated_at":"2015-04-29T05:23:29Z","closed_at":"2015-04-29T05:13:24Z","body":"Currently the question marks are statically defined to either use the left hand side to the right hand side of an email address for the SQL lookup.\r\n\r\nWhen hosting a lot of domains virtually it would be great if this could be configurable so the complete email address can be used as well. All my user information is currently stored as ```user@domain.tld``` and not ```user```.\r\n\r\nThis makes db maintenance also a lot easier imo. With the current query option with a lot of domains you would have a lot of duplicate entries. For example with a 100+ domains you would have 100 times \"postmaster\", \"hostmaster\", \"abuse\", \"info\", in the db tables.\r\n\r\nWhen using the complete email address these entries would be:\r\n- ```hostmaster@domain1.tld```\r\n- ```hostmaster@domain2.tld```\r\n- ...\r\n- ```hostmaster@domain100.tld```\r\n\r\nStoring it this way would prevent a lot of complicated queries. :)\r\n"},"comment":{"url":"https://api.github.com/repos/OpenSMTPD/OpenSMTPD/issues/comments/97310365","html_url":"https://github.com/OpenSMTPD/OpenSMTPD/issues/552#issuecomment-97310365","issue_url":"https://api.github.com/repos/OpenSMTPD/OpenSMTPD/issues/552","id":97310365,"user":{"login":"mischapeters","id":7456624,"avatar_url":"https://avatars.githubusercontent.com/u/7456624?v=3","gravatar_id":"","url":"https://api.github.com/users/mischapeters","html_url":"https://github.com/mischapeters","followers_url":"https://api.github.com/users/mischapeters/followers","following_url":"https://api.github.com/users/mischapeters/following{/other_user}","gists_url":"https://api.github.com/users/mischapeters/gists{/gist_id}","starred_url":"https://api.github.com/users/mischapeters/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mischapeters/subscriptions","organizations_url":"https://api.github.com/users/mischapeters/orgs","repos_url":"https://api.github.com/users/mischapeters/repos","events_url":"https://api.github.com/users/mischapeters/events{/privacy}","received_events_url":"https://api.github.com/users/mischapeters/received_events","type":"User","site_admin":false},"created_at":"2015-04-29T05:23:29Z","updated_at":"2015-04-29T05:23:29Z","body":"No problem. What confused you? Useful to know for the next time."}}