Guest User

Untitled

a guest
Feb 17th, 2018
708
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.20 KB | None | 0 0
  1. virtual_alias_maps = proxy:mysql:/etc/postfix/lookup_aliases.cf
  2. proxy_read_maps = $virtual_alias_maps
  3.  
  4. hosts = mysql-server.domain.tld
  5. user = postfix
  6. password = *****
  7. dbname = mail
  8. table = alias
  9. select_field = goto
  10. where_field = address
  11. additional_conditions = and active = '1'
  12. option_group = client
  13.  
  14. !includedir /etc/my.cnf.d
  15.  
  16. [client]
  17. ssl = true
  18.  
  19. # hostname -f
  20. mail.domain.tld
  21.  
  22. # sudo -u postfix mysql -h mysql-server.domain.tld -u postfix -p mail
  23. Enter password:
  24. Reading table information for completion of table and column names
  25. You can turn off this feature to get a quicker startup with -A
  26.  
  27. Welcome to the MariaDB monitor. Commands end with ; or g.
  28. Your MariaDB connection id is 72
  29. Server version: 5.5.56-MariaDB MariaDB Server
  30.  
  31. Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
  32.  
  33. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  34.  
  35. MariaDB [mail]> s
  36. --------------
  37. mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1
  38.  
  39. Connection id: 72
  40. Current database: mail
  41. Current user: postfix@mail.domain.tld
  42. SSL: Cipher in use is DHE-RSA-AES256-GCM-SHA384
  43. Current pager: stdout
  44. Using outfile: ''
  45. Using delimiter: ;
  46. Server: MariaDB
  47. Server version: 5.5.56-MariaDB MariaDB Server
  48. Protocol version: 10
  49. Connection: mysql-server.domain.tld via TCP/IP
  50. Server characterset: latin1
  51. Db characterset: utf8
  52. Client characterset: utf8
  53. Conn. characterset: utf8
  54. TCP port: 3306
  55. Uptime: 1 hour 27 min 23 sec
  56.  
  57. Threads: 1 Questions: 271 Slow queries: 0 Opens: 13 Flush tables: 2 Open tables: 39 Queries per second avg: 0.051
  58. --------------
  59.  
  60. MariaDB [mail]> q
  61. Bye
  62.  
  63. MariaDB [(none)]> SHOW GRANTS FOR 'postfix'@'10.0.101.%';
  64. +-----------------------------------------------------------------------------------------------------+
  65. | Grants for postfix@10.0.101.% |
  66. +-----------------------------------------------------------------------------------------------------+
  67. | GRANT USAGE ON *.* TO 'postfix'@'10.0.101.%' IDENTIFIED BY PASSWORD '*SOMEPASSWORDHASH' REQUIRE SSL |
  68. | GRANT SELECT ON `mail`.* TO 'postfix'@'10.0.101.%' |
  69. +-----------------------------------------------------------------------------------------------------+
  70. 2 rows in set (0.00 sec)
  71.  
  72. 180217 14:45:15 16 Connect postfix@mail.domain.tld as anonymous on mail
  73. 16 Connect Access denied for user 'postfix'@'mail.domain.tld' (using password: YES)
  74.  
  75. 180217 15:17:21 26 Connect postfix@mail.domain.tld as anonymous on mail
  76. 26 Query show databases
  77. 26 Query show tables
  78. 26 Field List admin
  79. 26 Field List alias
  80. 26 Field List alias_domain
  81. 26 Field List config
  82. 26 Field List domain
  83. 26 Field List domain_admins
  84. 26 Field List fetchmail
  85. 26 Field List log
  86. 26 Field List mailbox
  87. 26 Field List quota
  88. 26 Field List quota2
  89. 26 Field List vacation
  90. 26 Field List vacation_notification
  91. 26 Query select @@version_comment limit 1
Add Comment
Please, Sign In to add comment