Distributed Library Project
From http://www.thoughtcrime.org/software/dlp/index.html
Install
- I got it from http://www.thoughtcrime.org/software/dlp/dlp-0.6.tar.gz
- Uncompress it in /tmp
- Create e.g. /var/www/dlp
- Run install.sh and point installation to /var/www/dpl
- Create a writable (666) /var/www/dpl/include/config.inc
- Go to http://.../dlp/setup.php
I had to solve 2 issues:
DLP assumes your sql server is on localhost
DLP is broken with Mysql 5
This patch solves both issues, my_remote_sql_server is the host name of your sql server and my_www_server is the host name of the www server as seen by the sql server
diff -Naur dlp.orig/include/database.inc dlp/include/database.inc
--- dlp.orig/include/database.inc 2007-01-08 23:30:36.000000000 +0100
+++ dlp/include/database.inc 2007-01-09 00:52:17.000000000 +0100
@@ -21,7 +21,7 @@
$context =& getApplicationContext();
if ($_database_db !== NULL) return $_database_db;
- $_database_db = mysql_connect("localhost", $context->getDatabaseUser(), $context->getDatabasePassword());
+ $_database_db = mysql_connect("my_remote_sql_server", $context->getDatabaseUser(), $context->getDatabasePassword());
mysql_select_db($context->getDatabaseName(), $_database_db);
return $_database_db;
}
diff -Naur dlp.orig/include/database_schema.inc dlp/include/database_schema.inc
--- dlp.orig/include/database_schema.inc 2004-02-21 02:15:16.000000000 +0100
+++ dlp/include/database_schema.inc 2007-01-09 00:52:00.000000000 +0100
@@ -337,7 +337,7 @@
function createDatabaseTables($db) {
$dlp_user_definition =
"CREATE TABLE dlp_user (
- id MEDIUMINT DEFAULT '0' NOT NULL AUTO_INCREMENT,
+ id MEDIUMINT NOT NULL AUTO_INCREMENT,
verify VARCHAR(50),
username VARCHAR(15) UNIQUE NOT NULL,
password VARCHAR(32) NOT NULL,
@@ -388,14 +388,14 @@
$dlp_interests_definition =
"CREATE TABLE dlp_interests (
- id MEDIUMINT DEFAULT '0' NOT NULL AUTO_INCREMENT,
+ id MEDIUMINT NOT NULL AUTO_INCREMENT,
interest VARCHAR(255) NOT NULL,
count MEDIUMINT DEFAULT '0' NOT NULL,
PRIMARY KEY(id), UNIQUE id(id), INDEX(interest(255)))";
$dlp_library_definition =
"CREATE TABLE dlp_library (
- id MEDIUMINT DEFAULT '0' NOT NULL AUTO_INCREMENT,
+ id MEDIUMINT NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT NOT NULL,
authorlast VARCHAR(30) NOT NULL,
authorfirst VARCHAR(30) NOT NULL,
@@ -411,7 +411,7 @@
$dlp_video_definition =
"CREATE TABLE dlp_video (
- id MEDIUMINT DEFAULT '0' NOT NULL AUTO_INCREMENT,
+ id MEDIUMINT NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT NOT NULL,
title VARCHAR(255) NOT NULL,
genre VARCHAR(50) NOT NULL,
@@ -425,7 +425,7 @@
$dlp_music_definition =
"CREATE TABLE dlp_music (
- id MEDIUMINT DEFAULT '0' NOT NULL AUTO_INCREMENT,
+ id MEDIUMINT NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT NOT NULL,
title VARCHAR(255) NOT NULL,
artist VARCHAR(255) NOT NULL,
@@ -478,7 +478,7 @@
$dlp_lists_definition =
"CREATE TABLE dlp_lists (
- id MEDIUMINT DEFAULT '0' NOT NULL AUTO_INCREMENT,
+ id MEDIUMINT NOT NULL AUTO_INCREMENT,
owner MEDIUMINT NOT NULL,
title VARCHAR(255) NOT NULL,
created DATE NOT NULL,
diff -Naur dlp.orig/setup.php dlp/setup.php
--- dlp.orig/setup.php 2004-02-21 02:15:16.000000000 +0100
+++ dlp/setup.php 2007-01-09 00:51:44.000000000 +0100
@@ -275,7 +275,7 @@
return;
}
- if (($db = @mysql_connect("localhost", $existingDatabaseUser, $existingDatabasePassword)) == FALSE) {
+ if (($db = @mysql_connect("my_remote_sql_server", $existingDatabaseUser, $existingDatabasePassword)) == FALSE) {
echo '<span class="error">' . $lang['error_connecting_to_database'] . mysql_error() . '</span><p>';
displayStepTwo();
return;
@@ -316,20 +316,20 @@
return;
}
- if (($db = @mysql_connect("localhost", $databaseRootUser, $databaseRootPass)) == FALSE) {
+ if (($db = @mysql_connect("my_remote_sql_server", $databaseRootUser, $databaseRootPass)) == FALSE) {
echo '<span class="error">' . $lang['error_connecting_to_database'] . mysql_error() . '</span><p>';
displayStepTwo();
return;
}
$sql = "CREATE DATABASE $databaseName";
if (!@mysql_query($sql, $db)) {
echo '<span class="error">' . $lang['error_creating_database'] . mysql_error() . '</span><p>';
displayStepTwo();
return;
}
- $sql = "GRANT ALL ON $databaseName.* TO $databaseUser@localhost IDENTIFIED BY '$databasePassword'";
+ $sql = "GRANT ALL ON $databaseName.* TO $databaseUser@my_www_server IDENTIFIED BY '$databasePassword'";
if (!@mysql_query($sql, $db)) {
echo '<span class="error">' . $lang['error_granting_permissions'] . mysql_error() . '</span><p>';
displayStepTwo();