build dada with mysql interface

new for version 3.0.3 –

the following had to be changed (shown here via diff)

110c110
< $PROGRAM_ROOT_PASSWORD = ‘egYHCOq6sDzJQ’;
—-
> $PROGRAM_ROOT_PASSWORD = ‘root_password’;
142c142
< $FILES = ‘/home/oscarsfl/dada’;
—-
> $FILES = ‘/home/youraccount/dada_files’;
178c178
< $PROGRAM_URL =‘http://www.customrvint.com/cgi-bin/dada/mail.cgi’;
—-
> $PROGRAM_URL =‘http://www.changetoyoursite.com/cgi-bin/dada/mail.cgi’;
220,224c220,224
< $SUBSCRIBER_DB_TYPE ||= ‘SQL’;
< $ARCHIVE_DB_TYPE ||= ‘SQL’;
< $SETTINGS_DB_TYPE ||= ‘SQL’;
< $SESSION_DB_TYPE ||= ‘SQL’;
< $BOUNCE_SCORECARD_DB_TYPE ||= ‘SQL’;
—-
> $SUBSCRIBER_DB_TYPE ||= ‘PlainText’;
> $ARCHIVE_DB_TYPE ||= ‘Db’;
> $SETTINGS_DB_TYPE ||= ‘Db’;
> $SESSION_DB_TYPE ||= ‘Db’;
> $BOUNCE_SCORECARD_DB_TYPE ||= ‘Db’;
299c299
< database => ‘oscarsfl_dada’,
—-
> database => ‘’,
310,311c310,311
< user => ‘oscarsfl_dada’,
< pass => ‘dada’,
—-
> user => ‘’,
> pass => ‘’,
796c796
< $ROOT_PASS_IS_ENCRYPTED ||= 1;
—-
> $ROOT_PASS_IS_ENCRYPTED ||= 0;

===obsolete script for earlier versions:

#! /usr/bash

# # this script builds a dada mail system # # 2008-05-27 # #

VERSION=2_10_16;

root_password=‘yy2WIU6S3.eaI’ ; ## can create at http://webnet77.com/cgi-bin/helpers/htaccess.cgi
dada_location=’/home/o7m11/public_html/dada’ ;
program_url=‘http://www.omega-computer-graphics.com/dada/mail.cgi’ ;
mysql=‘MySQL’ ;
database_name=‘o7m11_omegadada’ ;
dbserver=‘localhost’ ;
port=3306 ;
dbtype=‘mysql’ ;
dbuser=‘o7m11_omegada’ ;
dbpass=‘omegadada’ ;

wget http://prdownloads.sourceforge.net/mojomail/dada-$VERSION.tar.gz?download ;

gzip d dada$VERSION.tar.gz ;

tar xvf dada$VERSION.tar ;

mv ./dada/DADA/Config.pm ./dada/DADA/Config.pm.original;

#

1. next time read the instructions and create a .dada_config file rather than
2. going to all this trouble to modify the Config.pm file
3. read “Making the Outside Configuration File”

#

1. but please at least note that every sed dollar-sign had to be escaped \$ to make this work!

sed -e “ \
s?^\$PROGRAM_ROOT_PASSWORD = ‘root_password’;\$?\$PROGRAM_ROOT_PASSWORD = ‘$root_password’;? ; \
s?^\$FILES = ‘/home/youraccount/dada_files’;\$?\$FILES = ‘$dada_location’;? ; \
s?^\$PROGRAM_URL =‘http://www.changetoyoursite.com/cgi-bin/dada/mail.cgi’;\$?\$PROGRAM_URL =’$program_url’;? ; \
s?^\$SUBSCRIBER_DB_TYPE ||= ‘PlainText’; \$?\$SUBSCRIBER_DB_TYPE ||= ‘$mysql’;? ; \
s?^\$ARCHIVE_DB_TYPE ||= ‘Db’; \$?\$ARCHIVE_DB_TYPE ||= ‘$mysql’; ? ; \
s?^\$SETTINGS_DB_TYPE ||= ‘Db’; \$?\$SETTINGS_DB_TYPE ||= ‘$mysql’; ? ; \
s?^\$SESSION_DB_TYPE ||= ‘PlainText’; \$?\$SESSION_DB_TYPE ||= ‘$mysql’; ? ; \
s?^database => ‘’,?database => ‘$database_name’,? ; \
s?^dbserver => ‘’,?dbserver => ‘$dbserver’,? ; \
s?^port => ‘’,?port => ‘$port’,? ; \
s?^dbtype => ‘’,?dbtype => ‘$dbtype’,? ; \
s?^user => ‘’,?user => ‘$dbuser’,? ; \
s?^pass => ‘’,?pass => ‘$dbpass’,? ; \
s?^\$ROOT_PASS_IS_ENCRYPTED ||= 0;?\$ROOT_PASS_IS_ENCRYPTED ||= 1;? ; \
“ <./dada/DADA/Config.pm.original >./dada/DADA/Config.pm ;

diff ./dada/DADA/Config.pm.original ./dada/DADA/Config.pm ;

mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ -e ‘drop table if exists dada_archives’ ;
mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ < ./dada/extras/SQL/dada_archives.mysql ;

mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ -e ‘drop table if exists dada_subscribers’ ;
mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ < ./dada/extras/SQL/dada_subscribers.mysql ;

mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ -e ‘drop table if exists dada_sessions’ ;
mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ < ./dada/extras/SQL/dada_sessions.mysql ;

mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ -e ‘drop table if exists dada_settings’ ;
mysql —verbose —host=$dbserver —port=$port —user=$dbuser —password=$dbpass $database_name \ < ./dada/extras/SQL/dada_settings.mysql ;

chmod 755 ./dada/mail.cgi ;

#
echo ‘finished!’ ;
echo ‘’;
echo ‘this is your sql insert command!’ ;

echo “ mysql_connect(’$dbserver’, ‘$dbuser’, ‘$dbpass’) or die(mysql_error()); mysql_select_db(’$database_name’) or die(mysql_error()); mysql_query ( \“INSERT INTO dada_subscribers (email, list, list_type, list_status ) VALUES (’\$email’, ‘contacts’, ‘list’, ‘1’ ) \” ) or die(mysql_error()); mysql_close() or die(mysql_error());
“

echo ‘’;

echo ‘visit ‘ $program_url ‘ next!’; #