![\"Public](\"images/logo.gif\"){kind=logo}
';
include("include/header.inc.php");
?>
PKP Open Archives Harvester: Installation
',
'© 2003-2004 Public Knowledge Project')")) {
installForm($vars, "Error: unable to insert into table \"harvester_config\".");
return;
}
if(!$db->query("CREATE TABLE archives (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
repositoryname VARCHAR(255) NOT NULL DEFAULT '',
email VARCHAR(60) NOT NULL DEFAULT '',
url VARCHAR(255) NOT NULL,
oai VARCHAR(255) NOT NULL,
protocol VARCHAR(12) NOT NULL DEFAULT '',
description TEXT NOT NULL DEFAULT '',
rst VARCHAR(32) NOT NULL DEFAULT '',
index_method VARCHAR(1) NOT NULL DEFAULT 'R',
num_records INT NOT NULL DEFAULT 0,
datestamp datetime NOT NULL,
UNIQUE(oai)
)")) {
installForm($vars, "Error: unable to create table \"archives\".");
return;
}
if(!$db->query("CREATE TABLE metadata (
id INT AUTO_INCREMENT PRIMARY KEY,
archive INT NOT NULL,
oai_identifier VARCHAR(255) NOT NULL DEFAULT '',
identifier VARCHAR(255) NOT NULL DEFAULT '',
datestamp DATE NOT NULL,
author VARCHAR(90) NOT NULL DEFAULT '',
email VARCHAR(60) NOT NULL DEFAULT '',
affiliation VARCHAR(60) NOT NULL DEFAULT '',
add_authors TEXT NOT NULL DEFAULT '',
add_emails TEXT NOT NULL DEFAULT '',
add_affiliations TEXT NOT NULL DEFAULT '',
title VARCHAR(255) NOT NULL DEFAULT '',
abstract TEXT NOT NULL DEFAULT '',
discipline VARCHAR(255) NOT NULL DEFAULT '',
topic VARCHAR(255) NOT NULL DEFAULT '',
publisher VARCHAR(255) NOT NULL DEFAULT '',
contributors VARCHAR(255) NOT NULL DEFAULT '',
date DATE,
type VARCHAR(255) NOT NULL DEFAULT '',
approach VARCHAR(255) NOT NULL DEFAULT '',
format VARCHAR(255) NOT NULL DEFAULT '',
source VARCHAR(255) NOT NULL DEFAULT '',
language VARCHAR(30) NOT NULL DEFAULT '',
relation VARCHAR(255) NOT NULL DEFAULT '',
coverage VARCHAR(255) NOT NULL DEFAULT '',
rights TEXT NOT NULL DEFAULT '',
fulltext(title),
fulltext(author, add_authors),
fulltext(affiliation, add_affiliations),
fulltext(author, add_authors, affiliation, add_affiliations),
fulltext(abstract),
fulltext(discipline),
fulltext(topic),
fulltext(approach),
fulltext(coverage),
fulltext(discipline, topic, publisher, contributors, approach, format, source, language, relation, coverage),
UNIQUE(archive, oai_identifier)
)")) {
installForm($vars, "Error: unable to create table \"metadata\".");
return;
}
if(!$db->query("CREATE TABLE links (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(90) NOT NULL DEFAULT '',
url VARCHAR(255) NOT NULL DEFAULT '',
annotation TEXT NOT NULL DEFAULT ''
)")) {
installForm($vars, "Error: unable to create table \"links\".");
return;
}
if(!$db->query("INSERT INTO links
(title, url, annotation)
VALUES
('Public Knowledge Project', 'http://www.pkp.ubc.ca/', 'Sponsor of this and other research systems, including Open Journal Systems, Open Conference Systems, the Research Support Tool, and the UBC ETD.')")) {
installForm($vars, "Error: unable to insert into table \"links\".");
return;
}
if(!$db->query("CREATE TABLE oai_resumption_tokens (
token VARCHAR(32) PRIMARY KEY,
expiration_date BIGINT NOT NULL DEFAULT 0,
record_offset INT NOT NULL DEFAULT 0,
params TEXT NOT NULL DEFAULT ''
)")) {
installForm($vars, "Error: unable to create table \"oai_resumption_tokens\".");
return;
}
} else {
if(!$db->query("UPDATE harvester_config SET admin_username = '$vars[admin_username]', admin_password = '" . md5($vars['admin_password']) . "'")) {
installForm($vars, "Error: unable to update table \"harvester_config\".");
return;
}
}
// read current database configuration file
$db_file = join("", file("include/db.inc.php"));
// values to replace in configuration file
$db_config = array(
"type" => 'mysql',
"name" => $vars['db_name'],
"host" => $vars['db_host'],
"port" => $vars['db_port'],
"uname" => $vars['db_username'],
"password" => $vars['db_password']
);
// replace values
foreach($db_config as $k => $v) {
$db_file = preg_replace('/\$db_config\[\'' . $k . '\'\] = "[^\r\n]*";/', "\$db_config['$k'] = \"$v\";", $db_file);
}
// replace pconnect value
$db_file = preg_replace('/\$db_config\[\'pconnect\'\] = \d+;/', "\$db_config['pconnect'] = " . (int) $vars[pconnect] . ";", $db_file);
if(is_writeable("include/db.inc.php")) {
// write the new database configuration file
$fp = fopen("include/db.inc.php", "w");
if($fp) {
fwrite($fp, $db_file);
fclose($fp);
$db_written = 1;
}
}
?>
The PKP OAI Harvester has been installed successfully.