Project

General

Profile

# Date Author Comment
11970 01/20/2014 11:33 AM Aaron Marcuse-Kubitza

moved everything into /trunk/ to create the standard svn layout, for use with tools that require this (eg. git-svn). IMPORTANT: do NOT do an `svn up`. instead, re-use your working copy's existing files with `svn switch` (http://svnbook.red-bean.com/en/1.6/svn.ref.svn.c.switch.html).

11451 10/29/2013 01:22 AM Aaron Marcuse-Kubitza

bugfix: schemas/pg_hba.conf: don't allow ident authentication for Unix socket connections, because this apparently prevents having normal, password-based connections ("md5"). note that just switching the order of the ident and md5 entries is not useful, because whichever authentication type comes second will be ignored completely. this problem was previously worked around by just not using Unix socket connections at all, and always specifying "localhost" as the host to force a hostname-based connection. this does not affect the postgres superuser, because they have their own ident line in pg_hba.conf.

8832 05/06/2013 03:14 AM Aaron Marcuse-Kubitza

schemas/pg_hba*.conf: removed trailing whitespace

8831 05/06/2013 03:10 AM Aaron Marcuse-Kubitza

schemas/pg_hba*.conf: allow the bien group to access all databases, including test (on the Mac). note that this does not grant access to the vegbank DB on vegbiendev, because that is owned by postgres.

6822 12/12/2012 10:36 PM Aaron Marcuse-Kubitza

Makefile mk_db, schemas/pg_hba*.conf: Added passwordless public_ user with access to just the database schema. Note that in PostgreSQL, only users with explicit GRANT permissions on a table can read data in that table, but all DB users with a login can view all table schemas.

6332 11/20/2012 07:15 PM Aaron Marcuse-Kubitza

schemas/: Synced pg_hba.conf and pg_hba.Mac.conf's bien entries, which adds phpPgAdmin support (template1 access) on the Mac and bien_read access on Linux

6297 11/19/2012 04:58 PM Aaron Marcuse-Kubitza

schemas/pg_hba.conf: Also grant the bien user access to template1, which is accessed by phpPgAdmin

6276 11/19/2012 02:37 PM Aaron Marcuse-Kubitza

schemas/pg_hba.conf: Fixed bug where also need an IPv6 bien entry with md5 authentication, because the IPv4 md5 authentication does not apply to "localhost", which is translated to the IPv6 address ::1

6275 11/19/2012 02:27 PM Aaron Marcuse-Kubitza

schemas/pg_hba.conf: Fixed bug where also need a local bien entry with md5 authentication, because the host-based md5 authentication applies only to literal IP addresses, not "localhost"

6273 11/19/2012 02:01 PM Aaron Marcuse-Kubitza

schemas/pg_hba.conf: Restrict all accesses to the server except the bien user accessing vegbien using ident or a password, and the postgres superuser logging in using ident

6267 11/19/2012 12:22 PM Aaron Marcuse-Kubitza

schemas/pg_hba.conf: Changed trust authentication back to ident/md5. Not sure how it got set to trust since I used md5 when enabling remote access to the DB for the bien user.

6266 11/19/2012 12:08 PM Aaron Marcuse-Kubitza

Added schemas/pg_hba.conf