summaryrefslogtreecommitdiff
path: root/installer
diff options
context:
space:
mode:
authorthomascube <thomas@roundcube.net>2008-02-26 09:10:07 +0000
committerthomascube <thomas@roundcube.net>2008-02-26 09:10:07 +0000
commit190e97e88624b4b42ad677c7446c0d5a0b7b17a6 (patch)
tree6e1c25eb0d9ce513c70fe77524467d46cf6683e7 /installer
parent2a36163b3c6d43d0fb534368eb9fa4b30e0566c1 (diff)
Fix database initialization and check write access on the DB; update INSTALL instructions
Diffstat (limited to 'installer')
-rw-r--r--installer/config.php2
-rw-r--r--installer/rcube_install.php54
-rw-r--r--installer/styles.css2
-rw-r--r--installer/test.php50
4 files changed, 84 insertions, 24 deletions
diff --git a/installer/config.php b/installer/config.php
index 63031b6b1..0697cc124 100644
--- a/installer/config.php
+++ b/installer/config.php
@@ -5,7 +5,7 @@
ini_set('display_errors', 1);
require_once 'include/rcube_html.inc';
-$RCI->get_defaults();
+$RCI->load_defaults();
if (!empty($_POST['submit'])) {
diff --git a/installer/rcube_install.php b/installer/rcube_install.php
index 136fdd006..f2ab394a1 100644
--- a/installer/rcube_install.php
+++ b/installer/rcube_install.php
@@ -52,7 +52,7 @@ class rcube_install
/**
* Read the default config files and store properties
*/
- function get_defaults()
+ function load_defaults()
{
$this->_load_config('.php.dist');
}
@@ -74,7 +74,7 @@ class rcube_install
{
include '../config/main.inc' . $suffix;
if (is_array($rcmail_config)) {
- $this->config = $rcmail_config;
+ $this->config += $rcmail_config;
}
@include '../config/db.inc'. $suffix;
@@ -238,6 +238,56 @@ class rcube_install
return $out;
}
+
+ /**
+ * Initialize the database with the according schema
+ *
+ * @param object rcube_db Database connection
+ * @return boolen True on success, False on error
+ */
+ function init_db($DB)
+ {
+ $db_map = array('pgsql' => 'postgres', 'mysqli' => 'mysql');
+ $engine = isset($db_map[$DB->db_provider]) ? $db_map[$DB->db_provider] : $DB->db_provider;
+
+ // find out db version
+ if ($engine == 'mysql') {
+ $DB->query('SELECT VERSION() AS version');
+ $sql_arr = $DB->fetch_assoc();
+ $version = floatval($sql_arr['version']);
+
+ if ($version >= 4.1)
+ $engine = 'mysql5';
+ }
+
+ // read schema file from /SQL/*
+ $fname = "../SQL/$engine.initial.sql";
+ if ($lines = @file($fname, FILE_SKIP_EMPTY_LINES)) {
+ $buff = '';
+ foreach ($lines as $i => $line) {
+ if (eregi('^--', $line))
+ continue;
+
+ $buff .= $line . "\n";
+ if (eregi(';$', trim($line))) {
+ $DB->query($buff);
+ $buff = '';
+ }
+ }
+ }
+ else {
+ $this->fail('DB Schema', "Cannot read the schema file: $fname");
+ return false;
+ }
+
+ if ($err = $this->get_error()) {
+ $this->fail('DB Schema', "Error creating database schema: $err");
+ return false;
+ }
+
+ return true;
+ }
+
/**
* Handler for RoundCube errors
*/
diff --git a/installer/styles.css b/installer/styles.css
index de4a9ca4d..1290696f8 100644
--- a/installer/styles.css
+++ b/installer/styles.css
@@ -123,7 +123,7 @@ textarea.configfile {
font-family: monospace;
font-size: 9pt;
width: 100%;
- height: 40em;
+ height: 30em;
}
dt.propname {
diff --git a/installer/test.php b/installer/test.php
index 783cf3c1b..b782a5c44 100644
--- a/installer/test.php
+++ b/installer/test.php
@@ -49,12 +49,14 @@ if (!empty($RCI->config)) {
$DB->db_connect('w');
if (!($db_error_msg = $DB->is_error())) {
$RCI->pass('DSN (write)');
+ echo '<br />';
$db_working = true;
}
else {
- $RCI->fail('DSN (write)', "Error: $db_error_msg");
+ $RCI->fail('DSN (write)', $db_error_msg);
+ echo '<p class="hint">Make sure that the configured database extists and that the user as write privileges<br />';
+ echo 'DSN: ' . $RCI->config['db_dsnw'] . '</p>';
}
- echo '<br />';
}
else {
$RCI->fail('DSN (write)', 'not set');
@@ -66,34 +68,43 @@ else {
// initialize db with schema found in /SQL/*
if ($db_working && $_POST['initdb']) {
- $engine = preg_match('/^([a-z]+):/i', $RCI->config['db_dsnw'], $regs) ? $regs[1] : 'mysql';
- $fname = '../SQL/' . ($engine == 'pgsql' ? 'postgres' : $engine) . '.initial.sql';
- if ($sql = @file_get_contents($fname)) {
- $DB->query($sql);
- }
- else {
- $RCI->fail('DB Schema', "Cannot read the schema file: $fname");
- }
-
- if ($err = $RCI->get_error()) {
- $RCI->fail('DB Schema', "Error creating database schema: $err");
+ if (!($success = $RCI->init_db($DB))) {
$db_working = false;
- echo '<p class="warning">Please try to inizialize the database manually as described in the INSTALL guide.</p>';
- echo '<br />';
+ echo '<p class="warning">Please try to inizialize the database manually as described in the INSTALL guide.
+ Make sure that the configured database extists and that the user as write privileges</p>';
}
}
+// test database
if ($db_working) {
- $success = $DB->query("SELECT count(*) FROM {$RCI->config['db_table_users']}");
- if (!$success) {
+ $db_read = $DB->query("SELECT count(*) FROM {$RCI->config['db_table_users']}");
+ if (!$db_read) {
$RCI->fail('DB Schema', "Database not initialized");
+ $db_working = false;
echo '<p><input type="submit" name="initdb" value="Initialize database" /></p>';
}
else {
$RCI->pass('DB Schema');
}
echo '<br />';
+}
+
+// more database tests
+if ($db_working) {
+ // write test
+ $db_write = $DB->query("INSERT INTO {$RCI->config['db_table_cache']} (session_id, cache_key, data, user_id) VALUES (?, ?, ?, 0)", '1234567890abcdef', 'test', 'test');
+ $insert_id = $DB->insert_id($RCI->config['db_sequence_cache']);
+ if ($db_write && $insert_id) {
+ $RCI->pass('DB Write');
+ $DB->query("DELETE FROM {$RCI->config['db_table_cache']} WHERE cache_id=?", $insert_id);
+ }
+ else {
+ $RCI->fail('DB Write', $RCI->get_error());
+ }
+ echo '<br />';
+
+ // check timezone settings
$tz_db = 'SELECT ' . $DB->unixtimestamp($DB->now()) . ' AS tz_db';
$tz_db = $DB->query($tz_db);
$tz_db = $DB->fetch_assoc($tz_db);
@@ -104,13 +115,12 @@ if ($db_working) {
// sometimes db and web servers are on separate hosts, so allow a 30 minutes delta
if (abs($tz_diff) > 1800) {
$RCI->fail('DB Time', "Database time differs {$td_ziff}s from PHP time");
- } else {
+ }
+ else {
$RCI->pass('DB Time');
}
-
}
-
?>
<p>[@todo Add tests for IMAP and SMTP settings]</p>