Package: phpbb3
Followup-For: Bug #497721
Hi,
I managed to set up phpbb3 with Postgres. The following changes were
required:
* some substitions for initial data, see patch to debian/rules below
* in /etc/phpbb3/database.inc.php: change $dbtype from `pgsql'
to `postgres'. This should probably done in config.php.
* also in database.inc.php: change $dbhost to `127.0.0.1' to make
phpbb3 work with Postgres' default configuration
I am not sure how the last point should be addressed in a more general way.
Perhaps it is enough to mention it in README.Debian?
Regards,
Ansgar
diff --git a/debian/rules b/debian/rules
index cf375a7..818c400 100755
--- a/debian/rules
+++ b/debian/rules
@@ -114,7 +114,7 @@ install: build
cp debian/phpbb3/usr/share/phpbb3/schemas/postgres_schema.sql
debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/pgsql
cp debian/phpbb3/usr/share/phpbb3/schemas/sqlite_schema.sql
debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/sqlite
cat debian/phpbb3/usr/share/phpbb3/schemas/schema_data.sql >>
debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/mysql
- cat debian/phpbb3/usr/share/phpbb3/schemas/schema_data.sql | sed "s/#
POSTGRES BEGIN #/BEGIN;/" | sed "s/^#.*//" >>
debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/pgsql ; echo
"COMMIT;" >> debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/pgsql
+ cat debian/phpbb3/usr/share/phpbb3/schemas/schema_data.sql | sed "s/#
POSTGRES BEGIN #/BEGIN;/" | sed "s/^#.*//" | sed -e 's/`/"/g' -e
's/UNIX_TIMESTAMP()/EXTRACT(EPOCH FROM CURRENT_TIMESTAMP(0))/' >>
debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/pgsql ; echo
"COMMIT;" >> debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/pgsql
cat debian/phpbb3/usr/share/phpbb3/schemas/schema_data.sql >>
debian/phpbb3/usr/share/dbconfig-common/data/phpbb3/install/sqlite
gzip -9 debian/phpbb3/usr/share/phpbb3/schemas/*.sql
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
