# Verzeker onszelf ervan dat we niet vanuit de webserver uitgevoerd worden
if (isset($_SERVER['SERVER_PROTOCOL'])) {
die("Sorry, db-upgrade.php kan enkel vanuit de server zelf uitgevoerd worden, niet via de webbrowser!");
} # if
# Risky warning, might trip up some stuff
if (@!file_exists(getcwd() . '/' . basename($argv[0]))) {
chdir(__DIR__);
} # if
try {
echo "Updating schema..(" . $settings['db']['engine'] . ")" . PHP_EOL;
$spotUpgrader = new SpotUpgrader($settings['db']);
$spotUpgrader->database();
echo "Schema update done" . PHP_EOL;
echo "Updating settings" . PHP_EOL;
$spotUpgrader->settings($settings);
echo "Settings update done" . PHP_EOL;
$spotUpgrader->users($settings);
echo "Updating users" . PHP_EOL;
echo "Users' update done" . PHP_EOL;
echo "Performing basic analysis of database tables" . PHP_EOL;
$spotUpgrader->analyze($settings);
echo "Basic database optimalisation done" . PHP_EOL;
} catch(Exception $x) {
echo "Database schema of settings upgrade mislukt:" . PHP_EOL;
echo " " . $x->getMessage() . PHP_EOL;
function createSystem()
{
global $settings;
global $_testInstall_Ok;
try {
/*
* The settings system is used to create a lot of output,
* we swallow it all
*/
ob_start();
/*
* Now create the database ...
*/
$settings['db'] = $_SESSION['spotsettings']['db'];
$spotUpgrader = new SpotUpgrader($settings['db'], $settings);
$spotUpgrader->database();
/*
* and create all the different settings (only the default) ones
*/
$spotUpgrader->settings();
/*
* Create the users
*/
$spotUpgrader->users();
/*
* print all the output as HTML comment for debugging
*/
$dbCreateOutput = ob_get_contents();
ob_end_clean();
/*
* Now it is time to do something with
* the information the user has given to us
*/
$db = new SpotDb($_SESSION['spotsettings']['db']);
$db->connect();
/*
* add the database settings to the main settings array for now
*/
$settings['db'] = $_SESSION['spotsettings']['db'];
/* and create the database settings */
$spotSettings = SpotSettings::singleton($db, $settings);
/*
* Update the NNTP settings in the databas
*/
$spotSettings->set('nntp_nzb', $_SESSION['spotsettings']['nntp']['nzb']);
$spotSettings->set('nntp_hdr', $_SESSION['spotsettings']['nntp']['hdr']);
$spotSettings->set('nntp_post', $_SESSION['spotsettings']['nntp']['post']);
/*
* Create the given user
*/
$spotUserSystem = new SpotUserSystem($db, $spotSettings);
$spotUser = $_SESSION['spotsettings']['adminuser'];
/*
* Create a private/public key pair for this user
*/
$spotSigning = Services_Signing_Base::newServiceSigning();
$userKey = $spotSigning->createPrivateKey($spotSettings->get('openssl_cnf_path'));
$spotUser['publickey'] = $userKey['public'];
$spotUser['privatekey'] = $userKey['private'];
/*
* and actually add the user
*/
$userId = $spotUserSystem->addUser($spotUser);
# Change the administrators' account password to that of this created user
$adminUser = $spotUserSystem->getUser(SPOTWEB_ADMIN_USERID);
$adminUser['newpassword1'] = $spotUser['newpassword1'];
$spotUserSystem->setUserPassword($adminUser);
# update the settings with our system type and our admin id
$spotSettings->set('custom_admin_userid', $userId);
$spotSettings->set('systemtype', $spotUser['systemtype']);
# Set the system type
$spotUpgrader->resetSystemType($spotUser['systemtype']);
/*
* Create the necessary database connection information
*/
$dbConnectionString = '';
switch ($_SESSION['spotsettings']['db']['engine']) {
case 'mysql':
$dbConnectionString .= "\$dbsettings['engine'] = 'mysql';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['host'] = '" . $_SESSION['spotsettings']['db']['host'] . "';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['dbname'] = '" . $_SESSION['spotsettings']['db']['dbname'] . "';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['user'] = '******'spotsettings']['db']['user'] . "';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['pass'] = '******'spotsettings']['db']['pass'] . "';" . PHP_EOL;
break;
# mysql
# mysql
case 'postgresql':
$dbConnectionString .= "\$dbsettings['engine'] = 'pdo_pgsql';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['host'] = '" . $_SESSION['spotsettings']['db']['host'] . "';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['dbname'] = '" . $_SESSION['spotsettings']['db']['dbname'] . "';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['user'] = '******'spotsettings']['db']['user'] . "';" . PHP_EOL;
$dbConnectionString .= "\$dbsettings['pass'] = '******'spotsettings']['db']['pass'] . "';" . PHP_EOL;
break;
# postgresql
}
# switch
# Try to create the dbsettings.inc.php file for the user
@file_put_contents("dbsettings.inc.php", "<?php" . PHP_EOL . $dbConnectionString);
$createdDbSettings = file_exists("dbsettings.inc.php");
?>
<table summary="PHP settings">
<tr> <th colspan='2'> Installation succesful </th> </tr>
<tr> <td colspan='2'> Spotweb has been installed succesfuly! </td> </tr>
<tr> <td colspan='2'> </td> </tr>
<?php
if (!$createdDbSettings) {
?>
<tr>
<td> → </td>
<td>
You need to create a textfile with the database settings in it. Please copy & paste the below
exactly in a file called <i>dbsettings.inc.php</i>.
<pre><?php
echo "<?php " . PHP_EOL . $dbConnectionString;
?>
</pre>
</td>
</tr>
<?php
}
?>
<tr>
<td> → </td>
<td>
Spotweb retrieves its information from the newsservers, this is called "retrieving" or retrieval of Spots.
You need to schedule a retrieval job to run <i>retrieve.php</i> on a regular basis. The first time retrieval
is run this can take up to several hours before completion.
</td>
</tr>
</table>
<?php
echo '<!-- ' . $dbCreateOutput . ' -->';
} catch (Exception $x) {
?>
<div id='error'><?php
echo $x->getMessage();
?>
<?php
echo $x->getTraceAsString();
?>
<br /><br />
</div>
<?php
}
# exception
}
chdir(dirname(__FILE__));
}
# if
require_once "lib/SpotClassAutoload.php";
require_once "settings.php";
/*
* Make sure we are not run from the server, an db upgrade can take too much time and
* will easily be aborted by either a database, apache or browser timeout
*/
SpotCommandline::initialize(array('reset-groupmembership', 'reset-securitygroups', 'reset-filters'), array('reset-groupmembership' => false, 'reset-securitygroups' => false, 'reset-filters' => false, 'set-systemtype' => false, 'reset-password' => false));
if (!SpotCommandline::isCommandline()) {
die("upgrade-db.php can only be run from the console, it cannot be run from the web browser");
}
# if
echo "Updating schema..(" . $settings['db']['engine'] . ")" . PHP_EOL;
$spotUpgrader = new SpotUpgrader($settings['db'], $settings);
$spotUpgrader->database();
echo "Schema update done" . PHP_EOL;
echo "Updating settings" . PHP_EOL;
$spotUpgrader->settings();
echo "Settings update done" . PHP_EOL;
$spotUpgrader->users($settings);
echo "Updating users" . PHP_EOL;
echo "Users' update done" . PHP_EOL;
/*
* If the user asked to change the system type..
*/
if (SpotCommandline::get('set-systemtype')) {
echo "Resetting the system type of Spotweb to " . SpotCommandline::get('set-systemtype') . PHP_EOL;
$spotUpgrader->resetSystemType(SpotCommandline::get('set-systemtype'));
echo "System type changed" . PHP_EOL;
