SQL Grey howto
Posted: 07 Dec 2012 06:41
MySQL
view the current root password
This will show the current root password
SQLGrey
Install SQLGrey
Configure
Set up the database configuration:
SQLGrey creates it’s table structure itself.
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
Restart sqlgrey
Configure Postfix
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:
Restart Postfix:
And of course test
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