Project

General

Profile

Statistics
| Revision:

# Date Author Comment
13683 06/06/2014 05:27 AM Aaron Marcuse-Kubitza

web/.htaccess: auto-detect dotpath: need to explicitly set usernames_disabled=1, because for some reason the `%{QUERY_STRING} =""` check doesn't detect a query string

13682 06/06/2014 05:24 AM Aaron Marcuse-Kubitza

web/.htaccess: auto-detect dotpath: removed handling of no longer used @ prefix (used to be used by username-based prefix subpaths)

13681 06/06/2014 05:18 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: username-based prefix subpaths: usernames_disabled: also need to support it being set in the current round

13680 06/06/2014 05:16 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: username-based prefix subpaths: removed support for query strings because these are often used at the root level, and should then be treated as a regular dotpath rather than something with a username-based prefix

13679 06/06/2014 05:07 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: forced mod_autoindex listing: use $usernames_disabled to ensure that usernames stay disabled even when /all path is removed

13678 06/06/2014 05:06 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: username-based prefix subpaths: added back usernames_disabled env var, because it is needed if a RewriteRule in a previous round creates an empty path (mod_rewrite runs the RewriteRules repeatedly until no replacements are made)

13677 06/06/2014 05:01 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: username-based prefix subpaths: REDIRECT_REQUEST_URI: also allow it to be unset, as it is when using usernames

13676 06/06/2014 04:57 AM Aaron Marcuse-Kubitza

fix: web/index.php: directory index: don't append QUERY_STRING, as this is not used by /all

13675 06/06/2014 04:57 AM Aaron Marcuse-Kubitza

web/.htaccess: username-based prefix subpaths: removed usernames_disabled env var because the bug that appeared to require this has now been fixed

13674 06/06/2014 04:56 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: username-based prefix subpaths: also need to check original URL (REDIRECT_REQUEST_URI), in addition to current URL (REQUEST_URI) to see if usernames should be disabled

13673 06/06/2014 04:39 AM Aaron Marcuse-Kubitza

web/.htaccess: username-based prefix subpaths: allow explicitly disabling in a RewriteRule to handle special cases

13672 06/06/2014 04:28 AM Aaron Marcuse-Kubitza

web/.htaccess: auto-detect dotpath: removed handling of no longer used @ prefix (used to be used by username-based prefix subpaths)

13671 06/06/2014 04:20 AM Aaron Marcuse-Kubitza

bugfix: web/index.php: directory index: use QUERY_STRING, not HTTP_AUTHORIZATION (HTTP_AUTHORIZATION was probably left over from a previous attempt to provide username-based prefix subpaths)

13668 06/06/2014 02:38 AM Aaron Marcuse-Kubitza

web/.htaccess, username_prefix.php: username-based prefix subpaths: don't require the // at the end , to avoid clutter. IMPORTANT: in order to access the home page after visiting a URL with a username, you must now append "." to the host ("vegpath.org.") (other pages are not affected by this problem). since vegpath.org is a URL shortener, this is a worthwhile tradeoff to avoid needing the // suffixes everywhere.

13667 06/06/2014 02:19 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: subdomains: each path element must be non-empty, to avoid matching a trailing . incorrectly

13666 06/06/2014 01:18 AM Aaron Marcuse-Kubitza

web/.htaccess: username-based prefix subpaths: updated documentation to use leading // instead of trailing ? or ?@

13665 06/06/2014 01:14 AM Aaron Marcuse-Kubitza

web/username_prefix.php: $_SERVER["PHP_AUTH_USER"] test: factored $_SERVER["SCRIPT_URL"] out of both branches of if statement

13664 06/06/2014 12:36 AM Aaron Marcuse-Kubitza

web/username_prefix.php: don't remove @ from query string because that is no longer a special character

13662 06/05/2014 11:46 PM Aaron Marcuse-Kubitza

fix: web/.htaccess: username-based prefix subpaths: changed format to subpath@host//path because the trailing ? makes it look like the sentence the URL is in is a question

13661 06/05/2014 08:38 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: action redirect: only append ? if adding to the query string

13656 06/05/2014 11:33 AM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: view: default to displaying the columns rather than the definition

13653 06/05/2014 08:20 AM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: support viewing the columns of a view rather than the definition

13652 06/05/2014 08:16 AM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: RewriteRules: use overridable action var

13651 06/05/2014 08:14 AM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: support overriding action param in a later RewriteRule

13650 06/05/2014 08:04 AM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: removed skip= because this creates a confusing control flow, and prevents using chain

13629 06/04/2014 11:41 AM Aaron Marcuse-Kubitza

web/.htaccess: auto-detect dotpath in query string: also auto-prepend & for query strings appended to a username-based prefix, so that these don't need to have & manually prepended to make them appendable

13628 06/04/2014 11:14 AM Aaron Marcuse-Kubitza

web/.htaccess: auto-detect dotpath in query string: also auto-detect dotpath for query strings appended to a username-based prefix, so that these don't need to have . prepended to make them appendable

13627 06/04/2014 02:25 AM Aaron Marcuse-Kubitza

web/username_prefix.php: no prefix: use $_SERVER["SCRIPT_URL"] instead of rtrimming $_SERVER["REQUEST_URI"]

13626 06/04/2014 02:24 AM Aaron Marcuse-Kubitza

web/username_prefix.php: has prefix: use same expr whether or not it has a query string, because the with-query-string expr works for both cases

13625 06/04/2014 02:20 AM Aaron Marcuse-Kubitza

web/username_prefix.php: use if statements instead of `? :` for clarity

13624 06/04/2014 02:10 AM Aaron Marcuse-Kubitza

web/username_prefix.php: use $subpath instead of $_SERVER["PHP_AUTH_USER"] for clarity

13622 06/04/2014 01:59 AM Aaron Marcuse-Kubitza

web/.htaccess, username_prefix.php: username-based prefix subpaths: support dotpath in query string (which will be appended verbatim to the prefix). use "__?@__" instead of "__?__&" to signal username-based prefix, so that the query string does not end in a dangling & .

13620 06/04/2014 01:06 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: auto-detect dotpath in query string: don't exclude dotpaths that come before a normal query string (&k=v...)

13619 06/04/2014 01:05 AM Aaron Marcuse-Kubitza

web/.htaccess: auto-detect dotpath in query string: documented what each RewriteCond does

13618 06/04/2014 01:03 AM Aaron Marcuse-Kubitza

web/.htaccess: auto-detect dotpath in query string: use %{QUERY_STRING} instead of %0 for clarity

13617 06/04/2014 12:48 AM Aaron Marcuse-Kubitza

web/.htaccess, web/username_prefix.php: username-based prefix subpaths: support query strings in addition to paths

13616 06/04/2014 12:18 AM Aaron Marcuse-Kubitza

web/index.php: removed no longer needed redirection of username-based prefix subpaths, which is now handled by web/.htaccess

13615 06/04/2014 12:16 AM Aaron Marcuse-Kubitza

web/.htaccess: handle username-based prefix subpaths (of the form "subpath@url?") for all paths rather than just for the root (which were handled by index.php)

13614 06/04/2014 12:11 AM Aaron Marcuse-Kubitza

added web/username_prefix.php, for use with username-based prefix redirects

13613 06/03/2014 11:13 PM Aaron Marcuse-Kubitza

web/index.php: subpath@host? redirects: also support multiple @ and nested . in prefix: @host? -> host?b.c.a

13612 06/03/2014 11:01 PM Aaron Marcuse-Kubitza

web/index.php: support prefix redirect of the form subpath@host? , which is better than subpath.host because case is preserved and special chars allowed. (must require trailing ? for redirect, to avoid needing login to view the page itself.)

13611 06/03/2014 10:47 PM Aaron Marcuse-Kubitza

bugfix: web/index.php: full directory index: appending query string: need to use $_SERVER["QUERY_STRING"], not $_SERVER["HTTP_AUTHORIZATION"] for this

13460 05/16/2014 12:03 AM Aaron Marcuse-Kubitza

bugfix: web/.phpPgAdmin/.htaccess: only append subject if non-empty, to avoid confusing redirect.php

13459 05/15/2014 11:57 PM Aaron Marcuse-Kubitza

bugfix: web/.phpPgAdmin/.htaccess: custom pages: need to handle in query string because .php filename would be treated as path element

13458 05/15/2014 11:32 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: support custom .php pages

13407 05/06/2014 03:39 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: iPlant links: fixed broken links

13406 05/06/2014 03:34 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: starscream links: removed favicons so they wouldn't wake the Mac up on network access whenever someone opens the links page

13362 04/30/2014 07:06 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: fixed broken links

13334 04/29/2014 03:47 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: rsync: documented that this breaks use of ~ to reference the remote user's home dir

13307 04/23/2014 07:16 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: Apache: documented that MultiViews is actually only broken for redirects with the filename "index"

13306 04/23/2014 07:11 PM Aaron Marcuse-Kubitza

web/.htaccess: for dirs, redirect to index.*: document it is actually just the filename "index" that MultiViews is broken for, other filenames work fine

13305 04/23/2014 06:02 PM Aaron Marcuse-Kubitza

bugfix: web/index.php: full directory index: only display if invoked as "vegpath.org/", not "vegpath.org/index.php"

13304 04/23/2014 05:58 PM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: for dirs, redirect to index.*: added workaround for Ubuntu 14.04, which breaks MultiViews

13302 04/23/2014 05:53 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: Apache: documented that this breaks MultiViews, so you need to rewrite .htaccess files to avoid using MultiViews

13301 04/23/2014 05:24 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: added Postgres upgrading instructions

13299 04/23/2014 04:53 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade

13298 04/23/2014 04:47 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: added phpMyAdmin fixing instructions

13297 04/23/2014 04:45 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu 14.04 upgrade: added phpMyAdmin fixing instructions

13296 04/23/2014 04:31 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Ubuntu: Ubuntu 14.04 upgrade: added things broken by it. PostgreSQL: fixed links.

13293 04/23/2014 12:12 AM Aaron Marcuse-Kubitza

fix: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: wal_keep_segments method: clarified how to determine the value of wal_keep_segments. filesystem-level backups: documented the advantages of filesystem-level backups over traditional database-level backups with pg_dump.

13292 04/22/2014 11:32 PM Aaron Marcuse-Kubitza

fix: web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: wal_keep_segments: restored annotations

13291 04/22/2014 11:26 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: documented how to set up online and offline backups (with two possible approaches for online backups)

13290 04/22/2014 11:24 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: documented how to set up online and offline backups (with two possible approaches for online backups)

13289 04/22/2014 11:21 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: backups: documented how to set up online and offline backups (with two possible approaches for online backups)

13257 04/21/2014 05:55 PM Aaron Marcuse-Kubitza

lib/Firefox_bookmarks.reformat.csv: changed "page's own description" to "page's self-description" for clarity

13256 04/21/2014 05:50 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: removed dead links

13255 04/21/2014 05:43 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: updated favicons

13254 04/21/2014 05:28 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: modifying a running shell script: updated to document that `svn up` actually does use two-stage save automatically

13163 04/17/2014 05:28 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: added operator classes. added backups: filesystem-level backup, continuous archiving, WAL logging, etc. virtual collaboration: updated annotations.

13114 04/10/2014 02:05 PM Aaron Marcuse-Kubitza

bugfix: web/.phpPgAdmin/.htaccess: work around phpPgAdmin bug that causes page to be ignored when not logged in

13108 04/10/2014 12:35 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: extract path components 1st->last: documented that can't use subject param for this because that goes to the last selected tab, not the default (leftmost) tab

12968 03/29/2014 04:06 AM Aaron Marcuse-Kubitza

*{.sh,run}: runscript targets: use begin_target instead of echo_func so the target name is properly echoed. note that this requires using with_rm so that $rm is properly progagated to applicable invoked targets. (previously, $rm was progagated to all invoked targets. note that with_rm only works inside a runscript target that starts with begin_target.)

12930 03/27/2014 05:06 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Firefox: added instructions for enabling security.password_lifetime and making all tabs load when the browser is opened

12704 03/14/2014 06:33 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Google Drive: listed bugs that make it very difficult to use (the need to re-download all files when reconnecting a client to an account). added recommendation not to use it (unstable).

12637 03/11/2014 04:05 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: query planner: documented how to prevent incorrect query plans (`SET enable_seqscan = off;`, etc.)

12636 03/11/2014 03:38 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: query planner: documented that incorrect query plans are an ongoing bug in Postgres, because it does not support index hints and by default does not follow the join order. specifically, Postgres often does the following things in query plans which should normally never be done:...

12622 03/07/2014 02:26 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: added description of join_collapse_limit config param (which should be turned off, although it is on by default). added links for using TIDs ("the fastest possible access to a single row").

12616 03/06/2014 09:37 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: added links for troubleshooting autovacuuming (which can slow queries down significantly when it isn't happening for any tables)

12540 02/28/2014 05:27 PM Aaron Marcuse-Kubitza

lib/Firefox_bookmarks.reformat.csv: "page's description": changed to "page's own description" to clarify that this is a description provided by the page itself

12539 02/28/2014 05:25 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: added links for error reporting levels and how to hide stack traces in psql. SQL: added links for recursive queries, which can be used to traverse hierarchical (parent-pointer) tables.

12442 02/25/2014 11:49 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: difference between STABLE and IMMUTABLE: functions that depend on the search_path: clarified that the confusing effects of using IMMUTABLE for one of these functions are only noticeable if the function is called on only constant values in a PL/pgSQL function (in which case the wrong search_path (the one in effect at create time) will be used)

12440 02/25/2014 11:23 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: PostgreSQL: added explanation of the difference between STABLE and IMMUTABLE, and common pitfalls in using IMMUTABLE when you should use STABLE. svn: added troubleshooting steps for running `svn upgrade` after the last Mac system update, which upgrades svn.

12409 02/24/2014 11:39 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Roundtable: virtual collaboration: annotated the linked pages

12408 02/24/2014 11:24 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Roundtable: added materials for virtual collaboration roundtable. Mac: added steps for customizing screen saver security settings beyond the options supported in the UI.

12310 02/19/2014 11:59 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Unix: moved into OS folder. Windows: added steps to try for fixing Windows Update.

12239 02/16/2014 01:29 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: Redmine: added links to the REST API for exporting data. svn: added instructions for using svnsync to export a repository. PostgreSQL: removed duplicate pages that were linked for multiple versions of Postgres.

12180 02/13/2014 01:23 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: support linking to a function

12179 02/13/2014 01:08 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: support linking to the functions list

12178 02/13/2014 01:05 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: support linking to a view

12177 02/13/2014 12:58 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: allow linking directly to the views list of a schema

12175 02/13/2014 12:54 PM Aaron Marcuse-Kubitza

web/.phpPgAdmin/.htaccess: refactored to build the URL incrementally, extracting path components 1st->last, instead of handling each # of path components as a separate case (which was more rigid and created unnecessary duplication)

12173 02/13/2014 11:47 AM Aaron Marcuse-Kubitza

bugfix: web/.phpPgAdmin/.htaccess: path RewriteRules: need to go directly to the applicable tab, rather than going via redirect.php, because redirect.php will use the last selected tab, rather than the first tab for that section, leading to unexpected results when a non-default tab was previously selected

12111 02/07/2014 05:26 AM Aaron Marcuse-Kubitza

web/BIEN3: redirected to .wiki since the wiki homepage now contains the list of all BIEN3 components

12110 02/07/2014 05:26 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Quick links: use bien3.vegpath.org to link to the main BIEN3 page

12109 02/07/2014 05:05 AM Aaron Marcuse-Kubitza

added web/BIEN3 symlink, with .bien3 case-insensitive alias

12019 02/02/2014 01:51 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: wake for network access: added link to pmset man page, which contains commands for setting "wake for network access" for all power sources. note that "automatic restart on power loss" also needs to be set for all power sources, because the computer will always be in UPS mode at the time of a power failure.

12012 01/26/2014 10:23 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: NCEAS: added link to phone list, which contains the Balboa Building maintenance numbers

12008 01/24/2014 04:38 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: svn: added steps to add a file containing (append to the path)

12007 01/23/2014 03:07 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: `mysql`: added commands to get interactive formatting (including echoed queries) when inputting from a file, and to get raw formatting when inputting from the console. git: added equivalent to `svn update`.

11989 01/22/2014 12:17 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks: OS X 10.9 Mavericks upgrade: added links for whether to upgrade (conclusion: don't, it breaks existing programs)