view the current root password
Code: Select all
cat /etc/mysql/EFA.cnf
SQLGrey
Install SQLGrey
Code: Select all
apt-get install sqlgrey
Code: Select all
vim /etc/sqlgrey/sqlgrey.conf
Code: Select all
db_type = mysql
db_name = sqlgrey
# Note: the following are not used with SQLite
db_host = localhost
db_port = default
db_user = sqlgrey
db_pass = ******
Create SQLGrey user and database
Connect to the mysql server using the root password
mysql –uroot –ppassword
Run the following SQL statement, replacing the password if need be
Code: Select all
create database sqlgrey; grant usage on sqlgrey.* to sqlgrey@localhost identified by '******'; grant all privileges on sqlgrey.* to sqlgrey@localhost;
Code: Select all
/etc/init.d/sqlgrey restart
vim /etc/postfix/main.cf
Add to the end of smtpd_recipient_restrictions:
, check_policy_service inet:127.0.0.1:2501
Whole line will read:
Code: Select all
smtpd_recipient_restrictions = permit_sasl_authenticated, reject_unknown_recipient_domain, reject_unauth_destination, whitelist_policy, rbl_policy, spf_policy, check_policy_service inet:127.0.0.1:2501
Code: Select all
/etc/init.d/postfix reload
And of course test