Project

General

Profile

Statistics
| Revision:

# Date Author Comment
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)

11975 01/20/2014 02:23 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. git: added instructions to migrate from svn.

11974 01/20/2014 02:20 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. git: added instructions to migrate from svn.

11973 01/20/2014 12:01 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added instructions for running `svn switch` after moving everything into /trunk/ (for us, use `svn switch --force https://code.nceas.ucsb.edu/code/projects/bien/trunk # runtime: <1 min`).

11972 01/20/2014 11:59 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added instructions for running `svn switch` after moving everything into /trunk/ (for us, use `svn switch --force https://code.nceas.ucsb.edu/code/projects/bien/trunk # runtime: <1 min`).

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).

11968 01/18/2014 11:43 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added links to the sPlot ERD. Dropbox: added information about a missing upgrade notification when you use the Dropbox client to look up a file on the Dropbox website.

11954 01/15/2014 08:36 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Quick links: removed page descriptions, which clutter up the quick links list.

11953 01/15/2014 08:34 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Quick links: added VegBIEN FAQ.

11948 01/14/2014 09:30 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Quick links: removed page descriptions, which clutter up the quick links list

11947 01/14/2014 09:28 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Quick links: added link to meetings

11946 01/14/2014 09:14 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Quick links: reordered in the order they should apper to visitors to the BIEN links page, rather than to me in the bookmarks toolbar.

11945 01/14/2014 09:04 PM Aaron Marcuse-Kubitza

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

11944 01/14/2014 08:56 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added links for sPlot and iPlant open-sourcing.

11935 12/20/2013 05:41 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. open-sourcing BIEN: added links for VegBank's license (GPLv2), and how these terms apply to us (a diff of our changes is not GPL-ed under GPLv2, although it is claimed to be GPL-ed under GPLv3)

11919 12/17/2013 07:28 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added links for fixing the "App Store is temporarily unavailable" error (turn on Spotlight) and modifying a running shell script (unlink it first).

11798 12/03/2013 04:59 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. PostgreSQL: added links for troubleshooting out-of-memory errors, which show up (cryptically) as "The database system is in recovery mode" errors in processes running at the time the out-of-memory condition occurred.

11737 11/25/2013 02:58 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added API writing links, including the best quotes from a Google developer's PowerPoint on the topic.

11722 11/21/2013 01:59 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. BIEN: added DataONE compatibility links.

11703 11/20/2013 11:38 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. BIEN: open-sourcing: added UArizona and iPlant IP policies, which are relevant to Brad's numerous documentation and schema-modeling contributions in our repository (most done while he was an iPlant employee).

11699 11/19/2013 09:21 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. BIEN: open-sourcing: added potential licenses we could use (public domain/CC0, BSD, GNU Verbatim Copying License, not CC-BY because incompatible w/ GPL).

11698 11/19/2013 08:31 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. BIEN: added links related to open-sourcing it, including the "Request to Open Source Software" form, the funding sources that need to be included in it, and part of the delegation of authority chain (from the UC Regents) that authorizes the open-sourcing.

11694 11/18/2013 12:10 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. upgrading to PostgreSQL 9.3: added Linux pg_upgrade steps and install instructions. added Mac PostGIS, psycopg2 install steps. added note that after installing, you need to restore config values that the upgrade reset: in pgAdmin > Preferences > Query tool > Query editor, set Max characters per column back to -1 (to avoid cells being truncated). (this is not a bug in PostgreSQL, only in pgAdmin, and does not signal a need to downgrade.)

11665 11/14/2013 07:19 AM Aaron Marcuse-Kubitza

bugfix: lib/Firefox_bookmarks.reformat.csv: remove empty <DD> tags (which Firefox now adds for all bookmarks) so they don't create a blank space on the page

11664 11/14/2013 07:16 AM Aaron Marcuse-Kubitza

bugfix: lib/Firefox_bookmarks.reformat.csv: don't prepend "page's description:" to empty <DD> tags, which Firefox now adds for all bookmarks, even if they don't have a description

11663 11/14/2013 07:06 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added instructions for upgrading PostgreSQL to 9.3, and some GBIF links.

11649 11/13/2013 04:50 PM Aaron Marcuse-Kubitza

web/.htaccess: mod_autoindex: show .* files which are normally hidden, because these are important parts of our codebase. (the leading . is not used for access controls.) .svn folders will remain hidden to avoid clutter.

11646 11/13/2013 01:07 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added links related to PostgreSQL plain-text pkeys and the GBIF data use agreement (which is apparently much less restrictive than the LoA we signed, and would even allow the data to be public). vegetation data: placed links into subfolders by datasource.

11403 10/22/2013 08:34 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added links for EER models, data management plans. put PostgreSQL before MySQL because we have found PostgreSQL to be a much more capable database system, even though it lacks some of MySQL's user-friendly features.

11372 10/19/2013 04:33 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. PostgreSQL: ALTER TABLE: added documentation about disabling of foreign key triggers, which is only possible by the superuser. note that marking a foreign key constraint as NOT VALID does not disable the trigger, so NOT VALID cannot be used for this purpose. this would be used to add fkeys from core VegBIEN tables to validation results tables such as the geoscrubbing results, without needing to import the validation results directly into core VegBIEN (which is time-consuming and currently must be done before input data is loaded, requiring a datasource reload to add geoscrubbing results).

11246 10/10/2013 03:07 PM Aaron Marcuse-Kubitza

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

11245 10/10/2013 02:57 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. sudo: added instructions to turn off incorrect password e-mails.

11186 10/09/2013 10:43 AM Aaron Marcuse-Kubitza

bugfix: web/people/Brad_Boyle/.htaccess: only forward requests for a term defined by Brad to the attribution/ subdir, so that Brad.vegpath.org shows a directory listing instead of forwarding right to the attribution doc

11185 10/09/2013 10:33 AM Aaron Marcuse-Kubitza

bugfix: web/people/Brad_Boyle/.htaccess: set %{ENV:innermost_dir} to Brad_Boyle

11184 10/09/2013 10:28 AM Aaron Marcuse-Kubitza

added web/people/Brad_Boyle/data_provenance/ (BIEN database entities related to data provenance and ownership.docx)

11183 10/09/2013 09:56 AM Aaron Marcuse-Kubitza

bugfix: web/people/Brad_Boyle/attribution/.htaccess: \-escape the %s so that they aren't treated as backreferences. set the [redirect] flag so that the downloaded file has the correct filename (BIEN 3 data use and attribution.docx instead of attribution).

11182 10/09/2013 09:49 AM Aaron Marcuse-Kubitza

bugfix: web/people/Brad_Boyle/attribution/.htaccess: use %20 instead of + because the Apache server apparently doesn't translate + to space correctly

11181 10/09/2013 09:47 AM Aaron Marcuse-Kubitza

bugfix: web/people/Brad_Boyle/attribution/.htaccess: link to the VegBIEN subdir in /exchange_schemas instead of the main /VegBIEN because there are actually two VegBIEN subdirs, and the main one instead points to /datasources/VegBIEN

11180 10/09/2013 09:45 AM Aaron Marcuse-Kubitza

added web/people/Brad_Boyle/ with attribution/ subdir for BIEN 3 data use and attribution.docx

11092 09/27/2013 06:31 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added Java client- and server-side links. web: split into client- and server-side folders.

11073 09/24/2013 12:54 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added PostgreSQL links.

11039 09/21/2013 10:17 PM Aaron Marcuse-Kubitza

web/.htaccess: mod_autoindex: IndexHeadInsert: use IndexStyleSheet for stylesheet link instead

11034 09/21/2013 09:42 PM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: mod_autoindex: IndexOptions: use +HTMLTable to ensure that the contents are always displayed in an HTML table, even when a header file is provided with HeaderName (which turns off the default HTML table for some reason)

10894 09/09/2013 02:04 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. MySQL: added steps to add a user if you are not root but have sudo access.

10837 08/30/2013 06:28 PM Aaron Marcuse-Kubitza

fix: web/links/index.htm: PostgreSQL: vacuuming: moved info about autovacuum process being aborted to correct bookmark

10836 08/30/2013 06:25 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. PostgreSQL: added info on vacuuming and analyzing.

10705 08/22/2013 01:04 PM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Gmvault: added steps to do full backup and to backup only new e-mails

10703 08/22/2013 11:12 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. Gmvault: added run instructions for Mac.

10702 08/22/2013 10:50 AM Aaron Marcuse-Kubitza

web/links/index.htm: updated to Firefox bookmarks. added link to Gmvault (Gmail backup), which wouldn't install for me on Mac (but that may be because I'm using 10.8, and Gmvault is for 10.7/10.6)

10670 08/18/2013 07:58 PM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: auto-detect dotpath in query string: need to include the path ($0) in the replacement, to avoid reverting to the root dir. (mod_rewrite replacements are not like relative URLs, which would interpret ?... as being relative to the current path, not the root.)

10669 08/18/2013 07:56 PM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: auto-detect dotpath in query string: added missing $ at end of regexp

10612 08/07/2013 08:12 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: parse dotpath in query string: make dotpath replacement start with ./ instead of / (which would incorrectly create an absolute URL path). this bug only appears when there is a trailing /, because this causes the matched text to be empty instead of a filesystem path with leading /.

10611 08/07/2013 08:04 AM Aaron Marcuse-Kubitza

bugfix: web/.htaccess: parse dotpath in query string: redirect so REQUEST_URI is populated from REQUEST_FILENAME: need to use - instead of $0 as the redirect destination so that REQUEST_FILENAME is used instead of the empty REQUEST_URI (i.e. the redirect vars are left untouched)