• Edit /etc/postgresql/8.3/main/pg_hba.conf

$ sudo /etc/init.d/postgresql-8.3 stop</ode>
<code>$ sudo vi /etc/postgresql/8.3/main/pg_hba.conf

Find this line:

#"local" is for Unix domain socket connections only
          local   all         all                              ident sameuser

Comment it out and add the following line:

           local   all         all                               md5

• Restart Postgresql

$ sudo /etc/init.d/postgresql-8.3 start

• Create the mailman user in the database

$ sudo su postgres
$ createuser mailman
 -> 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) n

• Assign a password to the DB mailman user

$ psql (this drops you into the sql interface for modifying the postgres db)
postgres=# alter user mailman password 'mailman';
ALTER ROLE

ctrl-D (to exit psql)
ctrl-D (to go back to original user shell)

Change to superuser:

 su 

Change to superuser postgres:

 su postgres 

Create database 'mailman_members'

 psql
 create database mailman_members owner mailman; 
 \c mailman_members

Create the table for storing mailman membership data

CREATE TABLE mailman_test (listname varchar(100) NOT NULL, address varchar(255) NOT NULL,password varchar(255) NOT NULL default '!', lang varchar(255) NOT NULL default 'en',name varchar(255) default NULL, delivery_status int NOT NULL default 0, user_options bigint NOT NULL default 0, digest char NOT NULL default 'N', topics_userinterest varchar(255) default NULL, bounce_info varchar(255) default NULL, delivery_status_timestamp timestamp default NULL, PRIMARY KEY  (listname, address));

ssh into your abiwt account. Type the following commands

psql -d mailman_members -U mailman
password: <enter the password>
\d (to list the tables in the database)
select * from mailman_test;

• Bug ###### (specific test instructions - URL here)
• Bug ######