Installation Failure: Can't create DB Tables

Support Mod Joined: Feb 15, 2004 Posts: 806

If you having database problem when installing Admin Secure, you can create the required db tables manually. Be sure yo edit "includes/asconfig.php" and set both $asec_dbtable and $asec_dbconfig variables to unique name as desired.

Copy/paste the following database schema into a text editor:

Code:

DROP TABLE IF EXISTS #ASEC_DBTABLE#;
CREATE TABLE #ASEC_DBTABLE# (
`aid` varchar(25) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`pwd` varchar(40) NOT NULL default '',
`radminsuper` int(1) NOT NULL default '0',
`lastupdate` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (aid),
KEY aid (aid),
KEY name (name)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#;
CREATE TABLE #ASEC_DBCONFIG# (
`asc_name` varchar(255) NOT NULL default '',
`asc_value` varchar(255) NOT NULL default '',
PRIMARY KEY (asc_name)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_session_logger;
CREATE TABLE #ASEC_DBCONFIG#_session_logger (
`log_addr` int(11) unsigned NOT NULL default '0',
`log_time` int(11) unsigned NOT NULL default '0',
`log_script` varchar(40) NOT NULL default '',
`log_page` varchar(40) NOT NULL default '',
`log_method` varchar(10) NOT NULL default '',
`log_uri` varchar(255) NOT NULL default '',
KEY log_addr (log_addr),
KEY log_time (log_time)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_ban_system;
CREATE TABLE #ASEC_DBCONFIG#_ban_system (
`ban_id` int(11) NOT NULL auto_increment,
`ban_type` int(1) NOT NULL default '0'
`ban_time` int(11) unsigned NOT NULL default '0',
`ban_arg1` int(11) unsigned NOT NULL default '0',
`ban_arg2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (ban_id),
KEY ban_id (ban_id),
KEY ban_type (ban_type)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_ban_module;
CREATE TABLE #ASEC_DBCONFIG#_ban_module (
`ban_id` int(11) NOT NULL default '0',
`ban_expire` int(11) NOT NULL default '0',
`ban_module` varchar(255) NOT NULL default '',
KEY ban_id (ban_id),
KEY ban_expire (ban_expire)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_whois_cache;
CREATE TABLE #ASEC_DBCONFIG#_whois_cache (
`whois_ip1` int(11) unsigned NOT NULL default '0',
`whois_ip2` int(11) unsigned NOT NULL default '0',
`whois_date` int(11) unsigned NOT NULL default '0',
`whois_text` text,
KEY whois_ip1 (whois_ip1),
KEY whois_ip2 (whois_ip2)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_exclude_system;
CREATE TABLE #ASEC_DBCONFIG#_exclude_system (
`excl_id` int(11) NOT NULL auto_increment,
`excl_type` int(1) NOT NULL default '0',
`excl_code` varchar(255) NOT NULL default '',
`excl_flag` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (excl_id),
KEY excl_id (excl_id),
KEY excl_type (excl_type)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_benchmark;
CREATE TABLE #ASEC_DBCONFIG#_benchmark (
`bm_date` int(11) unsigned NOT NULL default '0',
`bm_name` varchar(40) NOT NULL default '',
`bm_slog` varchar(10) NOT NULL default '00:00.0000',
`bm_bsys` varchar(10) NOT NULL default '00:00.0000',
`bm_bmod` varchar(10) NOT NULL default '00:00.0000',
`bm_filt` varchar(10) NOT NULL default '00:00.0000',
`bm_ovrl` varchar(10) NOT NULL default '00:00.0000',
KEY bm_date (bm_date)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_blockinfo;
CREATE TABLE #ASEC_DBCONFIG#_blockinfo (
`bi_id` int(11) NOT NULL auto_increment,
`bi_date` int(11) unsigned NOT NULL default '0',
`bi_type` int(1) NOT NULL default '0',
`bi_addr` int(11) unsigned NOT NULL default '0',
`bi_page` varchar(255) NOT NULL default '',
`bi_nkey` varchar(50) NOT NULL default '',
`bi_kcol` text,
`bi_vcol` text,
PRIMARY KEY (bi_id),
KEY bi_date (bi_date)
) TYPE=MyISAM;

DROP TABLE IF EXISTS #ASEC_DBCONFIG#_user_tracking;
CREATE TABLE #ASEC_DBCONFIG#_user_tracking (
`ut_date` int(11) unsigned NOT NULL default '0',
`ut_addr` int(11) unsigned NOT NULL default '0',
`ut_type` int(1) NOT NULL default '0',
`ut_user` varchar(40) NOT NULL default '',
`ut_sreq` text,
`ut_svar` text,
KEY ut_date (ut_date),
KEY ut_addr (ut_addr)
) TYPE=MyISAM;

#----------------------------------------

INSERT INTO #ASEC_DBCONFIG# VALUES ('check_time', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('check_days', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('last_check', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('auto_sync', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('auto_dboptimize', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('auto_dbcheck', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_notify_check', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_notify_account_change', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('admin_mail_address', 'yourname@yoursite.com');
INSERT INTO #ASEC_DBCONFIG# VALUES ('send_notify_mail_to', 'yourname@yoursite.com');
INSERT INTO #ASEC_DBCONFIG# VALUES ('default_lang', 'english');
INSERT INTO #ASEC_DBCONFIG# VALUES ('login_http_auth', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('confirm_mode', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('smart_ban', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('shutdown_mode', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('log_system', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('log_clean_time', '86400');
INSERT INTO #ASEC_DBCONFIG# VALUES ('log_lines_perpage', '25');
INSERT INTO #ASEC_DBCONFIG# VALUES ('flood_blocker', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('flood_blocker_time', '3');
INSERT INTO #ASEC_DBCONFIG# VALUES ('ban_system_site', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('ban_system_auto', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('ban_system_module', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('exclude_system', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('extended_block_info', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('user_tracking', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('user_tracking_expire', '3600');
INSERT INTO #ASEC_DBCONFIG# VALUES ('user_tracking_max', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_whois_info', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('use_remote_whois', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('bypass_filter_mode', '3');
INSERT INTO #ASEC_DBCONFIG# VALUES ('alternate_block_page', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_safe_request', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_safe_reqtags', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_error_type', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_error_mode', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_dbquery_vars', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_admin_var', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_user_var', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_extern_file', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_script_vars', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('filter_htmltag_url', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('deepscan_dbquery_vars', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('deepscan_htmltag_url', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_notify_dbquery_vars', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_notify_admin_var', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_notify_extern_file', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_notify_script_vars', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('mail_notify_htmltag_url', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('send_notify_mime', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('send_notify_imap', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('robot_system', '0');
INSERT INTO #ASEC_DBCONFIG# VALUES ('robot_reject_bad', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('robot_no_log', '1');
INSERT INTO #ASEC_DBCONFIG# VALUES ('robot_no_flood', '1');

Using your text editor's search/replace function, change the following text:
#ASEC_DBTABLE# to the name you set in $asec_dbtable in asconfig.php
#ASEC_DBCONFIG# to the name you set in $asec_dbconfig in asconfig.php

For example, assuming in asconfig.php you were set both variables as follows:

Code:

$asec_dbtable = "abcdef";
$asec_dbconfig = "yipikaye";

From the above example, search/replace #ASEC_DBTABLE# into abcdef and #ASEC_DBCONFIG# into yipikaye. Forgot to doing this may produce an error when you try to import the db schema directly with your database tool.

Save this database schema into a plain text file, e.g. "asec.sql". Import this file using database tool such as phpMyAdmin.

Upon success, run asec.php from your browser. Try to change some configuration settings to see whether the database tables was created properly. The database schema is compatible with Admin Secure up to version 1.7.

Note:
Perform this task will prevent Admin Secure to generate two emergency security codes. Refer to faq.txt file in Admin Secure package on how to generate emergency security codes manually.

Any problems, don't hesitate to asks. Good luck.