[Sun Aug 4 14:18:57 2024] install.cgi: Pro Dada v11.22.0 stable 2023-09-18 warning! Could not create, ' /.tmp/_screen_cache - No such file or directory - disabling screen cache. at ..//DADA/App/ScreenCache.pm line 74. [Sun Aug 4 14:18:57 2024] install.cgi: DBI connect('dbname=;host=localhost;port=3306','',...) failed: Access denied for user 'herpconb'@'localhost' (using password: NO) at ..//DADA/App/DBIHandle.pm line 127. [Sun Aug 4 14:18:57 2024] install.cgi: CAUGHT Error with Sessioning: can't connect to db: Access denied for user 'herpconb'@'localhost' (using password: NO) at ..//DADA/Profile/Session.pm line 36. [Sun Aug 4 14:18:57 2024] install.cgi: at ..//DADA/Template/HTML.pm line 1018. [Sun Aug 4 14:20:27 2024] install.cgi: Pro Dada v11.22.0 stable 2023-09-18 warning! Could not create, ' /.tmp/_screen_cache - No such file or directory - disabling screen cache. at ../DADA/App/ScreenCache.pm line 74. [Sun Aug 4 14:20:27 2024] install.cgi: DBI connect('dbname=;host=localhost;port=3306','',...) failed: Access denied for user 'herpconb'@'localhost' (using password: NO) at ../DADA/App/DBIHandle.pm line 137. [Sun Aug 4 14:20:27 2024] install.cgi: CAUGHT Error with Sessioning: can't connect to db: Access denied for user 'herpconb'@'localhost' (using password: NO) at ../DADA/Profile/Session.pm line 36. [Sun Aug 4 14:20:27 2024] install.cgi: at ../DADA/Template/HTML.pm line 1018. [Sun Aug 4 14:20:32 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:20:32 2024] install.cgi: installer_rmdir, dir: '/home2/herpconb/.dada_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5730. [Sun Aug 4 14:20:32 2024] install.cgi: DBI connect('dbname=;host=localhost;port=3306','',...) failed: Access denied for user 'herpconb'@'localhost' (using password: NO) at ../DADA/App/DBIHandle.pm line 137. [Sun Aug 4 14:20:32 2024] install.cgi: CAUGHT Error with Sessioning: can't connect to db: Access denied for user 'herpconb'@'localhost' (using password: NO) at ../DADA/Profile/Session.pm line 36. [Sun Aug 4 14:20:32 2024] install.cgi: at ../DADA/Template/HTML.pm line 1018. [Sun Aug 4 14:20:32 2024] install.cgi: CGI::param called in list context from ../DADA/perllib/HTML/FillInForm/Lite.pm line 373, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at ../DADA/perllib/CGI.pm line 415. [Sun Aug 4 14:20:51 2024] install.cgi: CGI::param called in list context from /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 4944, this can lead to vulnerabilities. See the warning in "Fetching the value or values of a single named parameter" at ../DADA/perllib/CGI.pm line 415. DBI 1.643-nothread default trace level set to 0x0/1 (pid 36504 pi 0) at DadaMailInstaller.pm line 1696 via DadaMailInstaller.pm line 5378 -> DBI->connect(dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306, herpconb_dada, ****) -> DBI->install_driver(mysql) for linux perl=5.036000 pid=36504 ruid=1974 euid=1974 install_driver: DBD::mysql version 4.050 loaded from /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/DBD/mysql.pm <- install_driver= DBI::dr=HASH(0x32fb320) !! The warn '0' was CLEARED by call to connect method <- connect('dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( DBI::db=HASH(0x3472480) ) [1 items] at DBI.pm line 703 <- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('Username', 'herpconb_dada')= ( 1 ) [1 items] at DBI.pm line 758 $h->{'mysql_conn_attrs'}=HASH(0x3472660) ignored for invalid driver-specific attribute <- STORE('mysql_conn_attrs', HASH(0x3472660))= ( '' ) [1 items] at DBI.pm line 758 <- connected('dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( undef ) [1 items] at DBI.pm line 765 <- connect= DBI::db=HASH(0x3472480) <- STORE('dbi_connect_closure', CODE(0x3436260))= ( 1 ) [1 items] at DBI.pm line 774 <- DESTROY(DBI::db=HASH(0x34726d8))= ( undef ) [1 items] at DadaMailInstaller.pm line 5378 <- disconnect_all= ( ) [0 items] (not implemented) at DBI.pm line 782 ! <- DESTROY(DBI::dr=HASH(0x32fb320))= ( undef ) [1 items] during global destruction DBI 1.643-nothread default trace level set to 0x0/1 (pid 37480 pi 0) at DadaMailInstaller.pm line 1696 via DadaMailInstaller.pm line 5378 -> DBI->connect(dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306, herpconb_dada, ****) -> DBI->install_driver(mysql) for linux perl=5.036000 pid=37480 ruid=1974 euid=1974 install_driver: DBD::mysql version 4.050 loaded from /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/DBD/mysql.pm <- install_driver= DBI::dr=HASH(0x3097da8) !! The warn '0' was CLEARED by call to connect method <- connect('dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( DBI::db=HASH(0x31f23f0) ) [1 items] at DBI.pm line 703 <- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 755 $h->{'mysql_conn_attrs'}=HASH(0x31f25d0) ignored for invalid driver-specific attribute <- STORE('mysql_conn_attrs', HASH(0x31f25d0))= ( '' ) [1 items] at DBI.pm line 758 <- STORE('Username', 'herpconb_dada')= ( 1 ) [1 items] at DBI.pm line 758 <- connected('dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( undef ) [1 items] at DBI.pm line 765 <- connect= DBI::db=HASH(0x31f23f0) <- STORE('dbi_connect_closure', CODE(0x31ad170))= ( 1 ) [1 items] at DBI.pm line 774 <- DESTROY(DBI::db=HASH(0x31f2648))= ( undef ) [1 items] at DadaMailInstaller.pm line 5378 -> DBI->connect(dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306, herpconb_dada, ****) <- connect('dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( DBI::db=HASH(0x31f2558) ) [1 items] at DBI.pm line 703 <- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 755 $h->{'mysql_conn_attrs'}=HASH(0x31f2630) ignored for invalid driver-specific attribute <- STORE('mysql_conn_attrs', HASH(0x31f2630))= ( '' ) [1 items] at DBI.pm line 758 <- STORE('Username', 'herpconb_dada')= ( 1 ) [1 items] at DBI.pm line 758 <- connected('dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( undef ) [1 items] at DBI.pm line 765 <- connect= DBI::db=HASH(0x31f2558) <- STORE('dbi_connect_closure', CODE(0x3021338))= ( 1 ) [1 items] at DBI.pm line 774 -> DBI->connect(DBI:Sponge:, , ****) -> DBI->install_driver(Sponge) for linux perl=5.036000 pid=37480 ruid=1974 euid=1974 install_driver: DBD::Sponge version 12.010003 loaded from /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/x86_64-linux/DBD/Sponge.pm <- install_driver= DBI::dr=HASH(0x302d6b8) <- connect('', '', ...)= ( DBI::db=HASH(0x32908a0) ) [1 items] at DBI.pm line 703 <- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('Username', '')= ( 1 ) [1 items] at DBI.pm line 758 <- connected('DBI:Sponge:', '', ...)= ( undef ) [1 items] at DBI.pm line 765 <- connect= DBI::db=HASH(0x32908a0) <- STORE('dbi_connect_closure', CODE(0x31e0dc8))= ( 1 ) [1 items] at DBI.pm line 774 <- DESTROY(DBI::st=HASH(0x3290b88))= ( undef ) [1 items] at mysql.pm line 356 <- DESTROY(DBI::st=HASH(0x32a9e78))= ( undef ) [1 items] at mysql.pm line 379 <- prepare('table_info', HASH(0x32a9e78))= ( DBI::st=HASH(0x32a9d10) ) [1 items] at mysql.pm line 396 <- fetchall_arrayref= ( [ ] ) [1 items] row-1 at DBI.pm line 1792 <- DESTROY(DBI::st=HASH(0x32a9d70))= ( undef ) [1 items] at DBI.pm line 1813 <- DESTROY(DBI::db=HASH(0x3290810))= ( undef ) [1 items] at DBI.pm line 1813 <- tables= ( ) [0 items] at DadaMailInstaller.pm line 5447 <- DESTROY(DBI::db=HASH(0x311f280))= ( undef ) [1 items] at DadaMailInstaller.pm line 5463 [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_rmdir, dir: '/home2/herpconb/.dada_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5730. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/public_html/lists/dada_mail_support_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_rm: file: '/home2/herpconb/public_html/lists/dada_mail_support_files/test_file.wpTAT8oB.1722802886.txt' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5691. [Sun Aug 4 14:21:26 2024] install.cgi: installer_rmdir, dir: '/home2/herpconb/public_html/lists/dada_mail_support_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5730. [Sun Aug 4 14:21:26 2024] install.cgi: * Attempting to make Pro Dada Files at, /home2/herpconb/.dada_files [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/.dada_files/.htaccess at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.archives' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.backups' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.configs' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.lists' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.logs' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.templates' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.tmp' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: * Success! [Sun Aug 4 14:21:26 2024] install.cgi: * Attempting to create .dada_config file... [Sun Aug 4 14:21:26 2024] install.cgi: * Success! [Sun Aug 4 14:21:26 2024] install.cgi: * Attempting to create SQL Tables... -> DBI->connect(dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306, herpconb_dada, ****) <- connect('dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( DBI::db=HASH(0x32a4db8) ) [1 items] at DBI.pm line 703 <- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 755 $h->{'mysql_conn_attrs'}=HASH(0x311f280) ignored for invalid driver-specific attribute <- STORE('mysql_conn_attrs', HASH(0x311f280))= ( '' ) [1 items] at DBI.pm line 758 <- STORE('Username', 'herpconb_dada')= ( 1 ) [1 items] at DBI.pm line 758 <- connected('dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( undef ) [1 items] at DBI.pm line 765 <- connect= DBI::db=HASH(0x32a4db8) <- STORE('dbi_connect_closure', CODE(0x32a9e78))= ( 1 ) [1 items] at DBI.pm line 774 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: CREATE TABLE IF NOT EXISTS dada_settings ( [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: setting varchar(64), [Sun Aug 4 14:21:26 2024] install.cgi: value text [Sun Aug 4 14:21:26 2024] install.cgi: ) CHARACTER SET utf8 COLLATE utf8_bin <- prepare("CREATE TABLE IF NOT EXISTS dada_settings ( list varchar(16), setting varchar(64), value text ) CHARACTER SET utf8 COLLATE utf8_bin")= ( DBI::st=HASH(0x32a4728) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4c80))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_subscribers ( [Sun Aug 4 14:21:26 2024] install.cgi: email_id int not null primary key auto_increment, [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: list_type varchar(64), [Sun Aug 4 14:21:26 2024] install.cgi: list_status char(1), [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW() [Sun Aug 4 14:21:26 2024] install.cgi: ) CHARACTER SET utf8 COLLATE utf8_bin <- prepare(" CREATE TABLE IF NOT EXISTS dada_subscribers ( email_id int not null primary key auto_increment, email varchar(80), list varchar(16), list_type varchar(64), list_status char(1), timestamp TIMESTAMP DEFAULT NOW() ) CHARACTER SET utf8 COLLATE utf8_bin")= ( DBI::st=HASH(0x32e5ed0) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a48a8))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_confirmation_tokens ( [Sun Aug 4 14:21:26 2024] install.cgi: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: token varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: data text, [Sun Aug 4 14:21:26 2024] install.cgi: UNIQUE (token) [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_confirmation_tokens ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, timestamp TIMESTAMP DEFAULT NOW(), token varchar(255), email varchar(80), data text, UNIQUE (token) )")= ( DBI::st=HASH(0x32a9bf0) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a47d0))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_profiles ( [Sun Aug 4 14:21:26 2024] install.cgi: profile_id int not null primary key auto_increment, [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80) not null, [Sun Aug 4 14:21:26 2024] install.cgi: password text(16), [Sun Aug 4 14:21:26 2024] install.cgi: auth_code varchar(64), [Sun Aug 4 14:21:26 2024] install.cgi: update_email_auth_code varchar(64), [Sun Aug 4 14:21:26 2024] install.cgi: update_email varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: activated char(1), [Sun Aug 4 14:21:26 2024] install.cgi: CONSTRAINT UNIQUE (email) [Sun Aug 4 14:21:26 2024] install.cgi: ) CHARACTER SET utf8 COLLATE utf8_bin <- prepare(" CREATE TABLE IF NOT EXISTS dada_profiles ( profile_id int not null primary key auto_increment, email varchar(80) not null, password text(16), auth_code varchar(64), update_email_auth_code varchar(64), update_email varchar(80), activated char(1), CONSTRAINT UNIQUE (email) ) CHARACTER SET utf8 COLLATE utf8_bin")= ( DBI::st=HASH(0x32e5fd8) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4728))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_profile_fields ( [Sun Aug 4 14:21:26 2024] install.cgi: fields_id int not null primary key auto_increment, [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80) not null, [Sun Aug 4 14:21:26 2024] install.cgi: CONSTRAINT UNIQUE (email) [Sun Aug 4 14:21:26 2024] install.cgi: ) CHARACTER SET utf8 COLLATE utf8_bin <- prepare(" CREATE TABLE IF NOT EXISTS dada_profile_fields ( fields_id int not null primary key auto_increment, email varchar(80) not null, CONSTRAINT UNIQUE (email) ) CHARACTER SET utf8 COLLATE utf8_bin")= ( DBI::st=HASH(0x32e5f48) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32e5ed0))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_profile_fields_attributes ( [Sun Aug 4 14:21:26 2024] install.cgi: attribute_id int not null primary key auto_increment, [Sun Aug 4 14:21:26 2024] install.cgi: field varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: label varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: fallback_value text, [Sun Aug 4 14:21:26 2024] install.cgi: required char(1) DEFAULT 0 NOT NULL, [Sun Aug 4 14:21:26 2024] install.cgi: -- I haven't made the following, but it seems like a pretty good idea... [Sun Aug 4 14:21:26 2024] install.cgi: -- sql_col_type text(16), [Sun Aug 4 14:21:26 2024] install.cgi: -- default mediumtext, [Sun Aug 4 14:21:26 2024] install.cgi: -- html_form_widget varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: -- public char(1), [Sun Aug 4 14:21:26 2024] install.cgi: CONSTRAINT UNIQUE (field) [Sun Aug 4 14:21:26 2024] install.cgi: ) CHARACTER SET utf8 COLLATE utf8_bin <- prepare(" CREATE TABLE IF NOT EXISTS dada_profile_fields_attributes ( attribute_id int not null primary key auto_increment, field varchar(80), label varchar(80), fallback_value text, required char(1) DEFAULT 0 NOT NULL, -- I haven't made the following, but it seems like a pretty good idea... -- sql_col_type text(16), -- default mediumtext, -- html_form_widget varchar(80), -- public char(1), CONSTRAINT UNIQUE (field) ) CHARACTER SET utf8 COLLATE utf8_bin")= ( DBI::st=HASH(0x32a4740) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a9bf0))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_profile_settings ( [Sun Aug 4 14:21:26 2024] install.cgi: id int not null primary key auto_increment, [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: setting varchar(64), [Sun Aug 4 14:21:26 2024] install.cgi: value text [Sun Aug 4 14:21:26 2024] install.cgi: ) CHARACTER SET utf8 COLLATE utf8_bin <- prepare(" CREATE TABLE IF NOT EXISTS dada_profile_settings ( id int not null primary key auto_increment, email varchar(80), list varchar(16), setting varchar(64), value text ) CHARACTER SET utf8 COLLATE utf8_bin")= ( DBI::st=HASH(0x32a4170) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32e5fd8))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_archives ( [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: archive_id varchar(32), [Sun Aug 4 14:21:26 2024] install.cgi: subject text, [Sun Aug 4 14:21:26 2024] install.cgi: message mediumtext, [Sun Aug 4 14:21:26 2024] install.cgi: format text, [Sun Aug 4 14:21:26 2024] install.cgi: raw_msg mediumtext [Sun Aug 4 14:21:26 2024] install.cgi: ) CHARACTER SET utf8 COLLATE utf8_bin <- prepare(" CREATE TABLE IF NOT EXISTS dada_archives ( list varchar(16), archive_id varchar(32), subject text, message mediumtext, format text, raw_msg mediumtext ) CHARACTER SET utf8 COLLATE utf8_bin")= ( DBI::st=HASH(0x32a4188) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32e5f48))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_bounce_scores ( [Sun Aug 4 14:21:26 2024] install.cgi: id int not null primary key auto_increment, [Sun Aug 4 14:21:26 2024] install.cgi: email text, [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: score int [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_bounce_scores ( id int not null primary key auto_increment, email text, list varchar(16), score int )")= ( DBI::st=HASH(0x32a4158) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4740))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_sessions ( [Sun Aug 4 14:21:26 2024] install.cgi: id CHAR(32) NOT NULL PRIMARY KEY, [Sun Aug 4 14:21:26 2024] install.cgi: a_session TEXT NOT NULL [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_sessions ( id CHAR(32) NOT NULL PRIMARY KEY, a_session TEXT NOT NULL )")= ( DBI::st=HASH(0x32a4128) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4170))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_clickthrough_urls ( [Sun Aug 4 14:21:26 2024] install.cgi: url_id int not null primary key auto_increment, [Sun Aug 4 14:21:26 2024] install.cgi: redirect_id varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: msg_id text, [Sun Aug 4 14:21:26 2024] install.cgi: url text [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_clickthrough_urls ( url_id int not null primary key auto_increment, redirect_id varchar(16), msg_id text, url text )")= ( DBI::st=HASH(0x32a4200) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4188))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_mass_mailing_event_log ( [Sun Aug 4 14:21:26 2024] install.cgi: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: remote_addr varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: msg_id varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: event varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: details varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: user_agent varchar(255) [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_mass_mailing_event_log ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, list varchar(16), timestamp TIMESTAMP DEFAULT NOW(), remote_addr varchar(255), msg_id varchar(255), event varchar(255), details varchar(255), email varchar(80), user_agent varchar(255) )")= ( DBI::st=HASH(0x32a4218) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4158))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_clickthrough_url_log ( [Sun Aug 4 14:21:26 2024] install.cgi: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: remote_addr varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: msg_id text, [Sun Aug 4 14:21:26 2024] install.cgi: url text, [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: user_agent varchar(255) [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_clickthrough_url_log ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, list varchar(16), timestamp TIMESTAMP DEFAULT NOW(), remote_addr varchar(255), msg_id text, url text, email varchar(80), user_agent varchar(255) )")= ( DBI::st=HASH(0x32a41b8) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4128))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_password_protect_directories ( [Sun Aug 4 14:21:26 2024] install.cgi: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: name text, [Sun Aug 4 14:21:26 2024] install.cgi: url text, [Sun Aug 4 14:21:26 2024] install.cgi: path text, [Sun Aug 4 14:21:26 2024] install.cgi: use_custom_error_page char(1), [Sun Aug 4 14:21:26 2024] install.cgi: custom_error_page text, [Sun Aug 4 14:21:26 2024] install.cgi: default_password text, [Sun Aug 4 14:21:26 2024] install.cgi: always_use_default_password char(1) [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_password_protect_directories ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, list varchar(16), name text, url text, path text, use_custom_error_page char(1), custom_error_page text, default_password text, always_use_default_password char(1) )")= ( DBI::st=HASH(0x32a41a0) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4200))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_message_drafts ( [Sun Aug 4 14:21:26 2024] install.cgi: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: created_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP, [Sun Aug 4 14:21:26 2024] install.cgi: last_modified_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, [Sun Aug 4 14:21:26 2024] install.cgi: name varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: screen varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: role varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: draft mediumtext [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_message_drafts ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, list varchar(16), created_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP, last_modified_timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, name varchar(80), screen varchar(80), role varchar(80), draft mediumtext )")= ( DBI::st=HASH(0x32a41d0) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4218))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_rate_limit_hits ( [Sun Aug 4 14:21:26 2024] install.cgi: user_id VARCHAR(225) NOT NULL, [Sun Aug 4 14:21:26 2024] install.cgi: action VARCHAR(225) NOT NULL, [Sun Aug 4 14:21:26 2024] install.cgi: timestamp INT UNSIGNED NOT NULL [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_rate_limit_hits ( user_id VARCHAR(225) NOT NULL, action VARCHAR(225) NOT NULL, timestamp INT UNSIGNED NOT NULL )")= ( DBI::st=HASH(0x32a41e8) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a41b8))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_email_message_previews ( [Sun Aug 4 14:21:26 2024] install.cgi: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: created_timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: vars text, [Sun Aug 4 14:21:26 2024] install.cgi: plaintext mediumtext, [Sun Aug 4 14:21:26 2024] install.cgi: html mediumtext [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_email_message_previews ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, list varchar(16), created_timestamp TIMESTAMP DEFAULT NOW(), vars text, plaintext mediumtext, html mediumtext )")= ( DBI::st=HASH(0x32a4230) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a41a0))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_privacy_policies ( [Sun Aug 4 14:21:26 2024] install.cgi: privacy_policy_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: privacy_policy mediumtext [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_privacy_policies ( privacy_policy_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, timestamp TIMESTAMP DEFAULT NOW(), list varchar(16), privacy_policy mediumtext )")= ( DBI::st=HASH(0x32a4248) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a41d0))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_consents ( [Sun Aug 4 14:21:26 2024] install.cgi: consent_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: consent mediumtext [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_consents ( consent_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, timestamp TIMESTAMP DEFAULT NOW(), list varchar(16), consent mediumtext )")= ( DBI::st=HASH(0x32a42d8) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a41e8))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_consent_activity ( [Sun Aug 4 14:21:26 2024] install.cgi: consent_activity_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: remote_addr varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: email varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: list varchar(16), [Sun Aug 4 14:21:26 2024] install.cgi: action varchar(80), [Sun Aug 4 14:21:26 2024] install.cgi: source varchar(225), [Sun Aug 4 14:21:26 2024] install.cgi: source_location varchar(225), [Sun Aug 4 14:21:26 2024] install.cgi: list_type varchar(64), [Sun Aug 4 14:21:26 2024] install.cgi: consent_session_token varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: consent_id int, [Sun Aug 4 14:21:26 2024] install.cgi: privacy_policy_id int, [Sun Aug 4 14:21:26 2024] install.cgi: FOREIGN KEY(consent_id) REFERENCES dada_consents(consent_id), [Sun Aug 4 14:21:26 2024] install.cgi: FOREIGN KEY(privacy_policy_id) REFERENCES dada_privacy_policies(privacy_policy_id) [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_consent_activity ( consent_activity_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, remote_addr varchar(255), timestamp TIMESTAMP DEFAULT NOW(), email varchar(80), list varchar(16), action varchar(80), source varchar(225), source_location varchar(225), list_type varchar(64), consent_session_token varchar(255), consent_id int, privacy_policy_id int, FOREIGN KEY(consent_id) REFERENCES dada_consents(consent_id), FOREIGN KEY(privacy_policy_id) REFERENCES dada_privacy_policies(privacy_policy_id) )")= ( DBI::st=HASH(0x32a42c0) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4230))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE TABLE IF NOT EXISTS dada_simple_auth_str ( [Sun Aug 4 14:21:26 2024] install.cgi: id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, [Sun Aug 4 14:21:26 2024] install.cgi: timestamp TIMESTAMP DEFAULT NOW(), [Sun Aug 4 14:21:26 2024] install.cgi: remote_addr varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: auth_str varchar(255), [Sun Aug 4 14:21:26 2024] install.cgi: CONSTRAINT UAS UNIQUE (auth_str) [Sun Aug 4 14:21:26 2024] install.cgi: ) <- prepare(" CREATE TABLE IF NOT EXISTS dada_simple_auth_str ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, timestamp TIMESTAMP DEFAULT NOW(), remote_addr varchar(255), auth_str varchar(255), CONSTRAINT UAS UNIQUE (auth_str) )")= ( DBI::st=HASH(0x32a42a8) ) [1 items] at DadaMailInstaller.pm line 3250 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3251 <- DESTROY(DBI::st=HASH(0x32a4248))= ( undef ) [1 items] at DadaMailInstaller.pm line 3251 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE INDEX dada_settings_list_index ON dada_settings (list) <- prepare(" CREATE INDEX dada_settings_list_index ON dada_settings (list)")= ( DBI::st=HASH(0x32a42a8) ) [1 items] at DadaMailInstaller.pm line 3242 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3243 <- DESTROY(DBI::st=HASH(0x32a42d8))= ( undef ) [1 items] at DadaMailInstaller.pm line 3243 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE INDEX [Sun Aug 4 14:21:26 2024] install.cgi: _all_index ON dada_subscribers (email(80), list, list_type, list_status, timestamp) <- prepare(" CREATE INDEX _all_index ON dada_subscribers (email(80), list, list_type, list_status, timestamp)")= ( DBI::st=HASH(0x32a1ca8) ) [1 items] at DadaMailInstaller.pm line 3242 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3243 <- DESTROY(DBI::st=HASH(0x32a42f0))= ( undef ) [1 items] at DadaMailInstaller.pm line 3243 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE INDEX dada_confirmation_tokens_index ON dada_confirmation_tokens (id, timestamp, token(80), email(80)) <- prepare(" CREATE INDEX dada_confirmation_tokens_index ON dada_confirmation_tokens (id, timestamp, token(80), email(80))")= ( DBI::st=HASH(0x32a4278) ) [1 items] at DadaMailInstaller.pm line 3242 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3243 <- DESTROY(DBI::st=HASH(0x32a9e48))= ( undef ) [1 items] at DadaMailInstaller.pm line 3243 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE INDEX dada_archives_list_archive_id_index ON dada_archives (list, archive_id) <- prepare(" CREATE INDEX dada_archives_list_archive_id_index ON dada_archives (list, archive_id)")= ( DBI::st=HASH(0x32a4260) ) [1 items] at DadaMailInstaller.pm line 3242 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3243 <- DESTROY(DBI::st=HASH(0x32a42a8))= ( undef ) [1 items] at DadaMailInstaller.pm line 3243 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE INDEX dada_mass_mailing_event_log_index ON dada_mass_mailing_event_log (list,remote_addr(80), msg_id(80), event(80), timestamp) <- prepare(" CREATE INDEX dada_mass_mailing_event_log_index ON dada_mass_mailing_event_log (list,remote_addr(80), msg_id(80), event(80), timestamp)")= ( DBI::st=HASH(0x32a1c78) ) [1 items] at DadaMailInstaller.pm line 3242 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3243 <- DESTROY(DBI::st=HASH(0x32a1ca8))= ( undef ) [1 items] at DadaMailInstaller.pm line 3243 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE INDEX dada_rate_limit_hits_all_index ON dada_rate_limit_hits (user_id, action(80), timestamp) <- prepare(" CREATE INDEX dada_rate_limit_hits_all_index ON dada_rate_limit_hits (user_id, action(80), timestamp)")= ( DBI::st=HASH(0x32a1d20) ) [1 items] at DadaMailInstaller.pm line 3242 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3243 <- DESTROY(DBI::st=HASH(0x32a4278))= ( undef ) [1 items] at DadaMailInstaller.pm line 3243 [Sun Aug 4 14:21:26 2024] install.cgi: Running statement: [Sun Aug 4 14:21:26 2024] install.cgi: [Sun Aug 4 14:21:26 2024] install.cgi: CREATE INDEX dada_consent_activity_index ON dada_consent_activity (email, list, action) <- prepare(" CREATE INDEX dada_consent_activity_index ON dada_consent_activity (email, list, action)")= ( DBI::st=HASH(0x32a1d08) ) [1 items] at DadaMailInstaller.pm line 3242 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3243 <- DESTROY(DBI::st=HASH(0x32a4260))= ( undef ) [1 items] at DadaMailInstaller.pm line 3243 [Sun Aug 4 14:21:26 2024] install.cgi: Statement too short to run: [Sun Aug 4 14:21:26 2024] install.cgi: <- DESTROY(DBI::db=HASH(0x31cfd98))= ( undef ) [1 items] at DadaMailInstaller.pm line 3235 [Sun Aug 4 14:21:26 2024] install.cgi: * Success! [Sun Aug 4 14:21:26 2024] install.cgi: * Clearing Session Data... -> DBI->connect(dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306, herpconb_dada, ****) <- connect('dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( DBI::db=HASH(0x32a98d8) ) [1 items] at DBI.pm line 703 <- STORE('PrintError', 1)= ( 1 ) [1 items] at DBI.pm line 755 <- STORE('AutoCommit', 1)= ( 1 ) [1 items] at DBI.pm line 755 $h->{'mysql_conn_attrs'}=HASH(0x32a9620) ignored for invalid driver-specific attribute <- STORE('mysql_conn_attrs', HASH(0x32a9620))= ( '' ) [1 items] at DBI.pm line 758 <- STORE('Username', 'herpconb_dada')= ( 1 ) [1 items] at DBI.pm line 758 <- connected('dbi:mysql:dbname=herpconb_dada;host=localhost;port=3306', 'herpconb_dada', ...)= ( undef ) [1 items] at DBI.pm line 765 <- connect= DBI::db=HASH(0x32a98d8) <- STORE('dbi_connect_closure', CODE(0x32d1748))= ( 1 ) [1 items] at DBI.pm line 774 <- prepare('TRUNCATE dada_sessions')= ( DBI::st=HASH(0x3290a08) ) [1 items] at DadaMailInstaller.pm line 3333 <- execute= ( '0E0' ) [1 items] at DadaMailInstaller.pm line 3334 <- DESTROY(DBI::st=HASH(0x31f2d38))= ( undef ) [1 items] at DadaMailInstaller.pm line 3337 <- DESTROY(DBI::db=HASH(0x32a5058))= ( undef ) [1 items] at DadaMailInstaller.pm line 3337 [Sun Aug 4 14:21:26 2024] install.cgi: * Success! [Sun Aug 4 14:21:26 2024] install.cgi: * Attempting to backup original ../DADA/Config.pm file... [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:511, $file:../DADA at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:493, $file:../DADA/Config.pm-backup.1722802886 at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:493, $file:../DADA at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: * Success! [Sun Aug 4 14:21:26 2024] install.cgi: * Attempting to edit ../DADA/Config.pm file... [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:511, $file:../DADA at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: installer_rm: file: '../DADA/Config.pm' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5691. [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:420, $file:../DADA/Config.pm at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:493, $file:../DADA at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: * Success! [Sun Aug 4 14:21:26 2024] install.cgi: * Setting up Support Files Directory... [Sun Aug 4 14:21:26 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/public_html/lists/dada_mail_support_files' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/.htaccess at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/index.html at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:26 2024] install.cgi: installer_mv: source: '../static', target: '/home2/herpconb/public_html/lists/dada_mail_support_files/static' [Sun Aug 4 14:21:27 2024] install.cgi: installer_mv: source: '../extras/packages/themes', target: '/home2/herpconb/public_html/lists/dada_mail_support_files/themes' [Sun Aug 4 14:21:27 2024] install.cgi: * Success! [Sun Aug 4 14:21:27 2024] install.cgi: * Installing plugins/extensions... [Sun Aug 4 14:21:27 2024] install.cgi: working on: blog_index at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: installer_chmod $octet:493, $file:../extensions/blog_index.cgi at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00e50) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: bounce_handler at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00c70) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: tracker at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00bb0) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: global_config at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00d90) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: bridge at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00c10) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: change_root_password at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2dd5568) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: change_list_shortname at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00d30) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: screen_cache at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00af0) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: log_viewer at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00b50) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: usage_log_to_consent_activity at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00eb0) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: password_protect_directories at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00cd0) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: working on: multiple_subscribe at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: installer_chmod $octet:493, $file:../extensions/multiple_subscribe.cgi at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:27 2024] install.cgi: working on: HASH(0x2e00df0) at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 3635. [Sun Aug 4 14:21:27 2024] install.cgi: installer_chmod $octet:511, $file:/home2/herpconb/.dada_files/.configs/.dada_config at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:27 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/.dada_files/.configs/.dada_config at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:27 2024] install.cgi: * Success! [Sun Aug 4 14:21:27 2024] install.cgi: * Installing WYSIWYG Editors... [Sun Aug 4 14:21:27 2024] install.cgi: installer_mv: source: '../extras/packages/ckeditor', target: '/home2/herpconb/public_html/lists/dada_mail_support_files/ckeditor' [Sun Aug 4 14:21:27 2024] install.cgi: installer_mv: source: '../extras/packages/tinymce', target: '/home2/herpconb/public_html/lists/dada_mail_support_files/tinymce' [Sun Aug 4 14:21:27 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/tinymce/dada_mail_config.js at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:27 2024] install.cgi: installer_mv: source: '../extras/packages/RichFilemanager', target: '/home2/herpconb/public_html/lists/dada_mail_support_files/RichFilemanager' [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:511, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/ckeditor/dada_mail_config.js at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/ckeditor/dada_mail_config.js at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:511, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/tinymce/dada_mail_config.js at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/tinymce/dada_mail_config.js at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/.dada_files/.tmp/php_sessions' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/RichFilemanager/connectors/php/vendor/servocoder/richfilemanager-php/src/config/config.local.php at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:511, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/RichFilemanager/config/filemanager.config.json at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/RichFilemanager/config/filemanager.config.json at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:511, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/RichFilemanager/connectors/php/filemanager.php at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/public_html/lists/dada_mail_support_files/RichFilemanager/connectors/php/filemanager.php at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_mkdir, dir: '/home2/herpconb/public_html/lists/dada_mail_support_files/file_uploads' at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5717. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:511, $file:/home2/herpconb/.dada_files/.configs/.dada_config at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:420, $file:/home2/herpconb/.dada_files/.configs/.dada_config at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: * Success! [Sun Aug 4 14:21:28 2024] install.cgi: * Setting up CGI/FastCGI/PSGI Deployment... [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:420, $file:../mail.cgi at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: installer_mv: source: '../mail.cgi', dest: '../mail.cgi-fR4eahjb.1722802888' [Sun Aug 4 14:21:28 2024] install.cgi: installer_chmod $octet:493, $file:../mail.cgi at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703. [Sun Aug 4 14:21:28 2024] install.cgi: * Done! [Sun Aug 4 14:21:28 2024] install.cgi: * Checking for needed CPAN modules to install... [Sun Aug 4 14:21:28 2024] install.cgi: * Done! [Sun Aug 4 14:21:28 2024] install.cgi: * Removing old Screen Cache... [Sun Aug 4 14:21:28 2024] install.cgi: * Success! [Sun Aug 4 14:21:28 2024] install.cgi: * Removing Old Backups in, dada_mail_support_files dir... [Sun Aug 4 14:21:28 2024] install.cgi: * Success! [Sun Aug 4 14:21:28 2024] install.cgi: * Installation and Configuration Complete! -> DBI->connect_cached(dbi:mysql:dbname=;host=localhost;port=3306, , ****) ERROR: 1045 'Access denied for user 'herpconb'@'localhost' (using password: NO)' (err#0) <- DESTROY(DBI::db=HASH(0x3642218))= ( undef ) [1 items] at mysql.pm line 161 !! ERROR: 1045 'Access denied for user 'herpconb'@'localhost' (using password: NO)' (err#0) <- connect_cached('dbname=;host=localhost;port=3306', '', ...)= ( undef ) [1 items] at DBI.pm line 703 <- $DBI::errstr= 'Access denied for user 'herpconb'@'localhost' (using password: NO)' DBI connect('dbname=;host=localhost;port=3306','',...) failed: Access denied for user 'herpconb'@'localhost' (using password: NO) [Sun Aug 4 14:21:28 2024] install.cgi: DBI connect('dbname=;host=localhost;port=3306','',...) failed: Access denied for user 'herpconb'@'localhost' (using password: NO) at ../DADA/App/DBIHandle.pm line 137. <- $DBI::errstr= 'Access denied for user 'herpconb'@'localhost' (using password: NO)' [Sun Aug 4 14:21:28 2024] install.cgi: CAUGHT Error with Sessioning: can't connect to db: Access denied for user 'herpconb'@'localhost' (using password: NO) at ../DADA/Profile/Session.pm line 36. [Sun Aug 4 14:21:28 2024] install.cgi: at ../DADA/Template/HTML.pm line 1018. !! The ERROR '1045' was CLEARED by call to disconnect_all method <- disconnect_all= ( ) [0 items] (not implemented) at DBI.pm line 782 <- disconnect_all= ( ) [0 items] (not implemented) at DBI.pm line 782 ! <- DESTROY(DBI::dr=HASH(0x302d6b8))= ( undef ) [1 items] during global destruction ! <- DESTROY(DBI::dr=HASH(0x3097da8))= ( undef ) [1 items] during global destruction [Sun Aug 4 14:21:33 2024] install.cgi: installer_mv: source: '../installer', dest: '../installer-disabled.Yx6HyJRI.1722802893' [Sun Aug 4 14:21:33 2024] install.cgi: installer_chmod $octet:420, $file:install.cgi at /home2/herpconb/public_html/lists/dada/installer/lib/DadaMailInstaller.pm line 5703, line 1.