From a8c22829d8e8845cd4ddf4ef8b61a1ed79edfffc Mon Sep 17 00:00:00 2001 From: Olivier Gayot Date: Mon, 12 Mar 2018 22:57:42 +0100 Subject: Imported from the SVN repository http://svn.wolffelaar.nl/wsvn/phpbb/branches/jessie/ Signed-off-by: Olivier Gayot --- debian/README.postgresql | 57 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 debian/README.postgresql (limited to 'debian/README.postgresql') diff --git a/debian/README.postgresql b/debian/README.postgresql new file mode 100644 index 0000000..66fb388 --- /dev/null +++ b/debian/README.postgresql @@ -0,0 +1,57 @@ +How to setup the postgresql database +==================================== + +As far as postgresql is concerned, dbconfig-common is still limited, +meaning authentication to the postgresql server has to be setup +manually. + +We show a typical postgresql default config +(/etc/postgresql/x.y/zz/pg_hba.conf), where the line that is to be +added and allows access to phpbb as it is configured by this package +is prepended with a plus (+) sign. (The plus sign is NOT to be copied +to the config!) + + # TYPE DATABASE USER CIDR-ADDRESS METHOD + local all postgres ident sameuser ++local phpbb3 phpbb3 md5 + local all all ident sameuser + host all all 127.0.0.1/32 md5 + host all all ::1/128 md5 + +Note that the entry has to be made at the shown location and not +simply at the end of the file. + +Reload postgresql for the changes to take effect. The password that +you entered during installation will be used by phpbb to authenticate +to the database; you don't need to put it anywhere else. + +To give more users access to more databases just add other lines like +the above to the configuration. + +You can use the same user and the same database for different forums +by specifying a different table_prefix for each installation in the +phpBB config. Note that all users can however access all databases then. + +Further examples when adding more forums: + +# same user, different database: +# let's hope they don't guess the name of the other databases +local phpbb3-2 phpbb3 md5 + +# different user, same database: +# only makes sense when you set table-specific privileges +local phpbb3 phpbb3-2 md5 + +# different user, different database: +# the way things should be +local phpbb3-2 phpbb3-2 md5 + +Again: do not simply add any of these to the bottom of the config +file, but at the location that was shown in the first example, +i.e. before the authentication for "all" is defined for the connection +method that you choose to employ (local=Unix-domain socket, +host=TCP/IP). + +For further details about client authentication to PostgreSQL, please +consult the excellent documentation at +http://www.postgresql.org/docs/7.4/static/client-authentication.html. -- cgit v1.2.3