[phpBB] svn: r67 - trunk/phpbb2

jeroen at wolffelaar.nl jeroen at wolffelaar.nl
Thu Feb 19 01:21:01 CET 2004


Author: jeroen
Date: 2004-02-19 01:20:04 +0100 (Thu, 19 Feb 2004)
New Revision: 67

Removed:
   trunk/phpbb2/mysql-ifnot-exec.sh
   trunk/phpbb2/phpbb2-conf-mysql.install
Modified:
   trunk/phpbb2/
   trunk/phpbb2/README.Debian
   trunk/phpbb2/phpbb2-conf-mysql.postinst
Log:
- Update README to be much more descriptive of what you need to do
- Revert the mysql-ifnot-exec packaging as wwwconfig-common has accepted my
  patch



Property changes on: trunk/phpbb2
___________________________________________________________________
Name: svn:ignore
   - build
*.debhelper
*.substvars
phpbb2
phpbb2-conf-mysql
phpbb2-l10n
files

   + build
*.debhelper
*.substvars
phpbb2
phpbb2-conf-mysql
phpbb2-languages
files


Modified: trunk/phpbb2/README.Debian
===================================================================
--- trunk/phpbb2/README.Debian	2004-02-10 11:21:18 UTC (rev 66)
+++ trunk/phpbb2/README.Debian	2004-02-19 00:20:04 UTC (rev 67)
@@ -1,32 +1,39 @@
 phpbb2 for Debian
 -----------------
 
+****** First use
+
+1) If you have not installed phpbb2-conf-mysql, please see the 'setup
+   database' section first.
+2) Go to the URL of your board, usually http://yourserver.example.com/phpbb
+3) Click 'login', login with user 'admin' and password 'admin'
+4) Click 'administration panel'
+5) Goto 'General Admin / Configuration'
+6) Review all settings, probably set 'Disable board' to 'No' to enable the
+   board, and submit
+7) Go to your own profile, and fill in your emailadress, and change your login
+   name and password.
+8) You now have a functional phpbb board with yourself as admin!
+
 ****** Upgrading, converting old posts
 
 If you have used phpBB before, and want to set over the users, forums and
 post from your old installation, see UPGRADING.Debian
 
-****** Configuring
+****** Setup database
 
-In order for phpBB to work, you need three things:
+If you don't want to use phpbb2-conf-mysql, for example if you want to have
+full control yourself or want to use an other database system, you need to
+setup the database yourself.
 
-1) A database with the correct tables set up
-2) A correctly configured webserver
-3) Edit your site-specific parameters in the board config
-
-Steps 1 and 3 can be done automatically, install phpbb2-conf-mysql for the
-if you want to use a MySQL database as backend.
-
-This is a short pointwise howto for step 1, in case you want to it yourself
-(or want to do it on a non-standard way)
-
-- login to your Databaserver (running MySQL or PostgreSQL) as the database
+- login to your databaseserver (running MySQL or PostgreSQL) as the database
   administrator (normally root)
 - create a database 'phpbb2'
-- execute the create table commands from /usr/share/doc/phpbb2/database.sql
 - create a user 'phpbb2' with random password, and give it
   SELECT/INSERT/UPDATE/DELETE rights for the phpbb database (rights to
   alter the tables is not needed)
+- execute the create table commands and the staring table content from
+  /usr/share/doc/phpbb2/schemas/$dbms_{schema,basic}.sql
 - Add the correct server-details and user-credentials in
   /etc/phpbb2/config.php (see /usr/share/doc/phpbb2/examples/config.php for an
   example)
@@ -38,17 +45,4 @@
 
 Don't forget to reload the webserver config after installation of phpbb2!
 
-****** logging in for the first time
-
-If the database is setup properly, you can login with username 'admin' and
-password 'admin'. Change this immediately!
-
-Then, go to the administration panel to enable the board, and change
-preferences at will.
-
-****** MOD's
-
-I'll include any useful mod found on phpbb's site, ensuring it's features can
-be enabled/disabled by the administrator at will.
-
  -- Jeroen van Wolffelaar <jeroen at wolffelaar.nl>, Thu,  8 Jan 2004 00:02:43 +0100

Deleted: trunk/phpbb2/mysql-ifnot-exec.sh
===================================================================
--- trunk/phpbb2/mysql-ifnot-exec.sh	2004-02-10 11:21:18 UTC (rev 66)
+++ trunk/phpbb2/mysql-ifnot-exec.sh	2004-02-19 00:20:04 UTC (rev 67)
@@ -1,63 +0,0 @@
-#!/bin/sh
-# File:		mysql-if-exec.sh
-# Changes:
-#	20010322 Ola Lundqvist <opal at debian.org>
-#	20011022 Luca De Vitis <luca at debian.org>
-#		Introduced the error variable.
-#	20020116 Ola Lundqvist <opal at debian.org>
-#		Documented the error variable.
-#	20020125 Ola Lundqvist <opal at debian.org>
-#		Removed the dbadmpass check part.
-#	20020125 Ola Lundqvist <opal at debian.org>
-#		Added new status code.
-#	20031219 Thomas Viehmann <tv at beamnet.de>
-#		Patch to use eval in order to not break.
-#	20040205 Jeroen van Wolffelaar <jeroen at wolffelaar.nl>
-#		Relax access check to work for non-root users too
-# Needs:	$dbname    - the database that user should have access to (optional)
-#		$dbserver  - the server to connect to.
-#		$dbadmin   - the administrator name.
-#		$dbadmpass - the administrator password.
-#		$statement - the statement to test if it can get data.
-#		which
-#		mysql
-#		/usr/share/wwwconfig-coomon/mysql.get
-# Description:	First checks a statement. If that statement is not ok it executes the
-#		script.
-# Sets:		$status = {error, nothing, exec, execerror}
-#		$error = error message (if $status = error)
-
-status=error
-error=""
-
-. /usr/share/wwwconfig-common/mysql.get
-
-if [ -z "$dbserver" ] ; then
-    error="No database server specified."
-elif [ -z "$dbadmin" ] ; then
-    error="No database administrator specified."
-elif [ -z "$statement" ] ; then
-    error="No statement to test for."
-elif [ -z "$sqlfile" ] ; then
-    error="No sqlfile to execute."
-elif [ ! -e "$sqlfile" ] ; then
-    error="Sqlfile $sqlfile not found."
-elif [ ! -x $(which mysql) ] ; then
-    error="No mysql client to execute, install the mysql client package and
-    run 'dpkg-reconfigure -plow packagename'."
-elif ! eval $mysqlcmd </dev/null >/dev/null 2>&1 ; then
-    error="Error when trying to connect to the mysql database.
-    This error can occur if you have no database to connect to, or
-    if the password was incorrect.
-	use: dpkg-reconfigure -plow packagename to reconfigure."
-elif ! eval $mysqlcmd -f $dbname -e "\"$statement\"" >/dev/null 2>&1 ; then
-    log="${log}Executing command to mysql."
-    if eval $mysqlcmd -f $dbname < $sqlfile > /dev/null 2>&1 ; then
-	status=exec
-    else
-	status=execerror
-	error="Unable to run the sql script ($sqlfile)."
-    fi
-else
-    status=nothing
-fi

Deleted: trunk/phpbb2/phpbb2-conf-mysql.install
===================================================================
--- trunk/phpbb2/phpbb2-conf-mysql.install	2004-02-10 11:21:18 UTC (rev 66)
+++ trunk/phpbb2/phpbb2-conf-mysql.install	2004-02-19 00:20:04 UTC (rev 67)
@@ -1 +0,0 @@
-debian/mysql-ifnot-exec.sh /usr/share/phpbb2-conf-mysql

Modified: trunk/phpbb2/phpbb2-conf-mysql.postinst
===================================================================
--- trunk/phpbb2/phpbb2-conf-mysql.postinst	2004-02-10 11:21:18 UTC (rev 66)
+++ trunk/phpbb2/phpbb2-conf-mysql.postinst	2004-02-19 00:20:04 UTC (rev 67)
@@ -89,7 +89,7 @@
 			zcat /usr/share/doc/phpbb2/schemas/mysql_basic.sql.gz \
 				>> $sqlfile
 			echo "Creating MySQL tables if they don't exist yet..."
-			. /usr/share/phpbb2-conf-mysql/mysql-ifnot-exec.sh
+			. /usr/share/wwwconfig-common/mysql-ifnot-exec.sh
 			rm -f $sqlfile
 			case "$status" in
 			*error)





More information about the phpBB-l mailing list