Advertisement
Guest User

Untitled

a guest
May 13th, 2017
555
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.34 KB | None | 0 0
  1. mysql> select
  2.     ->   emails.endereco as user,
  3.     ->   emails.password,
  4.     ->   '/var/spool/mail/nonlocaluser@nonlocaldomain.com.br' as userdb_home,
  5.     ->   'maildir:/var/spool/mail/nonlocaluser@nonlocaldomain.com.br' as userdb_mail,
  6.     ->   8 as userdb_uid,
  7.     ->   12 as userdb_gid,
  8.     ->   concat('*:storage=', emails.quota) as userdb_quota_rule,
  9.     ->   'Trash:storage=100M' as userdb_quota_rule2,
  10.     ->   'Y' as proxy_maybe,
  11.     ->   NULL as host
  12.     ->   from emails
  13.     ->   where emails.endereco = 'nonlocaluser@nonlocaldomain.com.br' and emails.ativa = 1
  14.     -> union
  15.     -> select
  16.     ->   NULL as user,
  17.     ->   NULL as password,
  18.     ->   NULL as userdb_home,
  19.     ->   NULL as userdb_mail,
  20.     ->   NULL as userdb_uid,
  21.     ->   NULL as userdb_gid,
  22.     ->   NULL as userdb_quota_rule,
  23.     ->   NULL as userdb_quota_rule2,
  24.     ->   'Y' as proxy_maybe,
  25.     ->   imapproxy.host as host
  26.     ->   from imapproxy
  27.     ->   where imapproxy.dominio = 'nonlocaldomain.com.br'\G
  28. *************************** 1. row ***************************
  29.               user: NULL
  30.           password: NULL
  31.        userdb_home: NULL
  32.        userdb_mail: NULL
  33.         userdb_uid: NULL
  34.         userdb_gid: NULL
  35.  userdb_quota_rule: NULL
  36. userdb_quota_rule2: NULL
  37.        proxy_maybe: Y
  38.               host: 10.252.25.2
  39. 1 row in set (0.00 sec)
  40.  
  41. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement