Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- virtual_alias_maps = proxy:mysql:/etc/postfix/lookup_aliases.cf
- proxy_read_maps = $virtual_alias_maps
- hosts = mysql-server.domain.tld
- user = postfix
- password = *****
- dbname = mail
- table = alias
- select_field = goto
- where_field = address
- additional_conditions = and active = '1'
- option_group = client
- !includedir /etc/my.cnf.d
- [client]
- ssl = true
- # hostname -f
- mail.domain.tld
- # sudo -u postfix mysql -h mysql-server.domain.tld -u postfix -p mail
- Enter password:
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Welcome to the MariaDB monitor. Commands end with ; or g.
- Your MariaDB connection id is 72
- Server version: 5.5.56-MariaDB MariaDB Server
- Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
- Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
- MariaDB [mail]> s
- --------------
- mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1
- Connection id: 72
- Current database: mail
- Current user: postfix@mail.domain.tld
- SSL: Cipher in use is DHE-RSA-AES256-GCM-SHA384
- Current pager: stdout
- Using outfile: ''
- Using delimiter: ;
- Server: MariaDB
- Server version: 5.5.56-MariaDB MariaDB Server
- Protocol version: 10
- Connection: mysql-server.domain.tld via TCP/IP
- Server characterset: latin1
- Db characterset: utf8
- Client characterset: utf8
- Conn. characterset: utf8
- TCP port: 3306
- Uptime: 1 hour 27 min 23 sec
- Threads: 1 Questions: 271 Slow queries: 0 Opens: 13 Flush tables: 2 Open tables: 39 Queries per second avg: 0.051
- --------------
- MariaDB [mail]> q
- Bye
- MariaDB [(none)]> SHOW GRANTS FOR 'postfix'@'10.0.101.%';
- +-----------------------------------------------------------------------------------------------------+
- | Grants for postfix@10.0.101.% |
- +-----------------------------------------------------------------------------------------------------+
- | GRANT USAGE ON *.* TO 'postfix'@'10.0.101.%' IDENTIFIED BY PASSWORD '*SOMEPASSWORDHASH' REQUIRE SSL |
- | GRANT SELECT ON `mail`.* TO 'postfix'@'10.0.101.%' |
- +-----------------------------------------------------------------------------------------------------+
- 2 rows in set (0.00 sec)
- 180217 14:45:15 16 Connect postfix@mail.domain.tld as anonymous on mail
- 16 Connect Access denied for user 'postfix'@'mail.domain.tld' (using password: YES)
- 180217 15:17:21 26 Connect postfix@mail.domain.tld as anonymous on mail
- 26 Query show databases
- 26 Query show tables
- 26 Field List admin
- 26 Field List alias
- 26 Field List alias_domain
- 26 Field List config
- 26 Field List domain
- 26 Field List domain_admins
- 26 Field List fetchmail
- 26 Field List log
- 26 Field List mailbox
- 26 Field List quota
- 26 Field List quota2
- 26 Field List vacation
- 26 Field List vacation_notification
- 26 Query select @@version_comment limit 1
Add Comment
Please, Sign In to add comment