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]