Skip to content

Instantly share code, notes, and snippets.

@sibok
Created March 26, 2014 20:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sibok/ef6a417d10ddf20bd242 to your computer and use it in GitHub Desktop.
Save sibok/ef6a417d10ddf20bd242 to your computer and use it in GitHub Desktop.
1028 Connect mail@localhost on maildb
1028 Query select crypt from users where id='ws@example.com' and enabled = 1
1028 Quit
1029 Connect mail@localhost on maildb
1029 Quit
1030 Connect mail@localhost on maildb
1030 Query SELECT transport FROM domains WHERE domain='*' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='*' and enabled = 1
1031 Connect mail@localhost on maildb
1031 Query SELECT destination FROM aliases WHERE mail = 'blog.example.com' AND enabled IS TRUE
1032 Connect mail@localhost on maildb
1032 Query SELECT id FROM users WHERE id='blog.example.com' AND enabled IS TRUE
1033 Connect mail@localhost on maildb
1033 Query SELECT domain FROM domains WHERE domain = 'blog.example.com' AND enabled IS TRUE
1030 Query SELECT transport FROM domains WHERE domain='ws@blog.example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='blog.example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='.example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='.com' and enabled = 1
1034 Connect mail@localhost on maildb
1034 Query SELECT newadr FROM relocated WHERE oldadr='ws@blog.example.com'
1034 Query SELECT newadr FROM relocated WHERE oldadr='@blog.example.com'
1031 Query SELECT destination FROM aliases WHERE mail = 'example.com' AND enabled IS TRUE
1032 Query SELECT id FROM users WHERE id='example.com' AND enabled IS TRUE
1033 Query SELECT domain FROM domains WHERE domain = 'example.com' AND enabled IS TRUE
1030 Query SELECT transport FROM domains WHERE domain='pau@example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='example.com' and enabled = 1
1034 Query SELECT newadr FROM relocated WHERE oldadr='pau@example.com'
1034 Query SELECT newadr FROM relocated WHERE oldadr='@example.com'
1035 Connect mail@localhost on maildb
1035 Query SELECT destination FROM aliases WHERE mail = 'pau@example.com' AND enabled IS TRUE
1036 Connect mail@localhost on maildb
1036 Query SELECT id FROM users WHERE id='pau@example.com' AND enabled IS TRUE
918 Query SELECT id, crypt, clear, uid, gid, home, concat(home,'/',maildir), "", name, "" FROM users WHERE id = 'ws@example.com' AND (enabled=1)
1027 Quit
1031 Query SELECT destination FROM aliases WHERE mail = 'blog.example.com' AND enabled IS TRUE
1032 Query SELECT id FROM users WHERE id='blog.example.com' AND enabled IS TRUE
1033 Query SELECT domain FROM domains WHERE domain = 'blog.example.com' AND enabled IS TRUE
1030 Query SELECT transport FROM domains WHERE domain='ws@blog.example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='blog.example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='.example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='.com' and enabled = 1
1034 Query SELECT newadr FROM relocated WHERE oldadr='ws@blog.example.com'
1034 Query SELECT newadr FROM relocated WHERE oldadr='@blog.example.com'
1031 Query SELECT destination FROM aliases WHERE mail = 'example.com' AND enabled IS TRUE
1032 Query SELECT id FROM users WHERE id='example.com' AND enabled IS TRUE
1033 Query SELECT domain FROM domains WHERE domain = 'example.com' AND enabled IS TRUE
1030 Query SELECT transport FROM domains WHERE domain='pau@example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='example.com' and enabled = 1
1034 Query SELECT newadr FROM relocated WHERE oldadr='pau@example.com'
1034 Query SELECT newadr FROM relocated WHERE oldadr='@example.com'
1040 Connect mail@localhost on maildb
1040 Query SELECT destination FROM aliases WHERE mail = 'pau@example.com' AND enabled IS TRUE
1041 Connect mail@localhost on maildb
1041 Query SELECT id FROM users WHERE id='pau@example.com' AND enabled IS TRUE
1031 Query SELECT destination FROM aliases WHERE mail = 'example.com' AND enabled IS TRUE
1032 Query SELECT id FROM users WHERE id='example.com' AND enabled IS TRUE
1033 Query SELECT domain FROM domains WHERE domain = 'example.com' AND enabled IS TRUE
1030 Query SELECT transport FROM domains WHERE domain='pau@example.com' and enabled = 1
1030 Query SELECT transport FROM domains WHERE domain='example.com' and enabled = 1
1034 Query SELECT newadr FROM relocated WHERE oldadr='pau@example.com'
1034 Query SELECT newadr FROM relocated WHERE oldadr='@example.com'
1042 Connect mail@localhost on maildb
1042 Query SELECT maildir FROM users WHERE id = 'pau@example.com'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment