bounceHammer has been EOL'ed on February 29, 2016

EOL on February 29, 2016

bounceHammer have been downloaded and used by many users and companies since the first release on March 2010 and has been EOL: End Of Life on February 29, 2016. Thanks for using bounceHammer for a long time. We are now providing Sisimai (the successor of bounceHammer, more faster, more higher precision of analysis) as a bounce mail parser library in BSD 2-Clause License.

Sisimai
Commercial Support

  • 1Setting Up Sisimai Your Server
  • 2Support developmenet using Sisimai
  • 3Support via Email
  • 4Support bounce management
  • 5Parsing your bounced emails

5. Setting Up Database

 

Setting Up the database for storing parsed data

After bounceHammer has been installed into /usr/local/bouncehammer successfully, Next, set up a database for storing parsed data created by bounceHammer.

If you use bin/mailboxparser command (Parsing) and bin/loggercommand (Accumulating) ONLY, No database is needed.

Parameters in this section

In this section, We use MySQL 5.1 or PostgreSQL 8.4.4 on the host 127.0.0.1, database name is bouncehammer, database username is bouncehammer ( same as db name), database password is 794-uguisu-heiankyo.

Create user and tables

 

use MySQL

Create an empty database and a user on the database previously. The database host can be located anywhere in your network.

If the database exists on the host that bounceHammer is running, You can use UNIX Domain socket to connect to the database.

# /usr/local/bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1537
Server version: 5.1.44 Source distribution
...
mysql> CREATE DATABASE bouncehammer;
Query OK, 1 row affected (0.01 sec)
 
mysql> GRANT ALL PRIVILEGES ON bouncehammer.* TO bouncehammer@127.0.0.1 IDENTIFIED BY '794-uguisu-heiankyo';
Query OK, 0 rows affected (0.04 sec)
 
mysql> FLUSH PRIVILEGES;

use PostgreSQL

Operation is the same as the previous paragraph(MySQL), Create an empty database and a user on the database previously. The database host can be located anywhere in your network.

If the database exists on the host that bounceHammer is running, You can use UNIX Domain socket to connect to the database.

# su - postgres
$ cd /usr/local/pgsql
$ ./bin/createuser bouncehammer
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) y
 
$ ./bin/createdb -Obouncehammer bouncehammer
$ ./bin/psql
psql (8.4.4)
Type 'help' for help.
 
postgres=# ALTER USER bouncehammer password ' 794-uguisu-heiankyo';
ALTER ROLE

CREATE TABLE

After you have created the empty database and the database user, Next, Create database tables which are used by bounceHammer. SQL script files located in /usr/local/bouncehammer/share/script are useful to create database tables.

# cd /usr/local/bouncehammer/share/script
 
If you selected MySQL
# cat ./MySQL*.sql | /usr/local/mysql/bin/mysql -ubouncehammer -Dbouncehammer -h127.0.0.1 -p
Enter password: 794-uguisu-heiankyo
 
Insert records into each master table
# cat ./mastertable-* | /usr/local/mysql/bin/mysql -ubouncehammer -Dbouncehammer -h127.0.0.1 -p
Enter password: 794-uguisu-heiankyo
 
 
If you selected PostgreSQL
# cat ./PostgreSQL*.sql | /usr/local/pgsq/bin/psql -Ubouncehammer -dbouncehammer
...
Insert records into each master table
# cat ./mastertable-* | /usr/local/pgsq/bin/psql -Ubouncehammer -dbouncehammer

If you need example records in the database, insert records saved in the script /usr/local/bouncehammer/share/script/records-example.sql into the database.

After you have set up the database, proceed to 7. Create bouncehammer.cf for creating main configuration file of bounceHammer.