OpenACS / openacs-4 / packages / acs-core-docs / www

database-management.html

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 28 Dec
Commits this week: 0
Total Lines of Code (LoC): 5
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 20 Aug 2003
6:20 pm

joela

refactored from external entity to xinclude so that broken files don't kill overall make; added external authentication; brought i18n current; other smaller fixes

Options
    • -0
    • +0
    ./database-management.html
  2. … 158 more files in changeset.
Saturday 28 Jun 2003
7:07 am

joela

added quick guide; removed www/xml/files in favor of just www/files

Options
    • -1
    • +1
    ./database-management.html
  2. … 116 more files in changeset.
Tuesday 24 Jun 2003
5:58 am

joela

updated post-4-6-3

Options
    • -0
    • +59
    ./database-management.html
  2. … 92 more files in changeset.
Wednesday 07 May 2003
7:40 pm

donb

Modified xml/kernel/permissions-design.xml and regenerated the html

file (don't know why our makefile recreates each html file when you

only change one xml file)

Options
    • -10
    • +10
    ./database-management.html
  2. … 74 more files in changeset.
Sunday 04 May 2003
8:30 am

joela

Fixed:

> missing link to http://openacs.org/doc/openacs-4-6-2/files/analog-dev.cfg.txt

> http://openacs.org/doc/openacs-4-6-2/individual-programs.html

Removed the link altogether - removed all links to files actually in

the tarball

----------------------------------------------------------------------

> I'm running Mandrake 9.1 on my new workstation here, and when all the docbook

> stuff's installed there's a convenient "xsl-stylesheets" symbolic link to

Using symlink in openacs.xsl

----------------------------------------------------------------------

In qmail section, link to download page for ucspi and qmail

----------------------------------------------------------------------

>Which is the best keyword for "your service name?" in the docs. It should be

>easily recognized as a placeholder, easy to search-replace, and should

>be generic enough that most users can leave it unchanged. Currently we use

>"service0", which meets the last two of the three requirements.

>Earlier docs used "birdnotes," which met the first two requirements.

Decided I didn't care

----------------------------------------------------------------------

>Red Hat 9 issue:

>code change to compile daemontools and qmail

>http://www.riverside.org/archive/html/djbdns/2003-01/msg00307.html

>http://article.gmane.org/gmane.mail.qmail.general/13960

>put "#include <errno.h>" in /usr/local/src/postgresql-7.2.3/src/include/postgres.h

Added comment to instructions

----------------------------------------------------------------------

> Add text about which version of PostgreSQL works to top of that

section.

added.

----------------------------------------------------------------------

>First, in http://openacs.org/doc/openacs-4-6-2/postgres.html the make

>install didn't work for me when I used postgres so I had to use root and

>then do 'chown -R postgres.web /usr/local/pgsql'

Could not repro.

----------------------------------------------------------------------

> Second, in the [postgres.html] doc, in point 8 for Red Hat, why is

> there chmod 700 for the script? All the other scripts in

> /etc/rc.d/init.d are 755.

Changed to 755.

----------------------------------------------------------------------

>Optimizing Postgres:

>should optimize kernel settings for Postgres

>http://developer.postgresql.org/docs/postgres/kernel-resources.html

Added postgres tuning instructions

----------------------------------------------------------------------

>For compiling nsopenssl, this was necessary on Debian:

>apt-get install libssl-dev

>make OPENSSL=/usr/lib/ssl

>nsopenssl needs 0.9.6 or newer. Debian stable currently runs openssl

>0.9.6c

Added note.

----------------------------------------------------------------------

>If you are on Oracle, you have to su - oracle, then su to root to get

>your environment right. Otherwise, nsoracle won't compile.

Added note.

----------------------------------------------------------------------

>The web user wasn't added in the Oracle install step, so I added it

>now: groupadd web

Already mentioned in the doc.

----------------------------------------------------------------------

>For some reason, the include and sample-config.tcl files were owned by

>500.500 instead of root root. So:

>chown -R root.root include sample.config.tcl

owned by remadmin in reference platform. Seems harmless so didn't add anything to instructions.

----------------------------------------------------------------------

>bin and lib were group owned by staff. I changed that to root as well:

>chown -R root.root bin lib modules

could not repro

----------------------------------------------------------------------

> We should be recommending at least ANALYZE (by itself). If we are

> going to recommend VACUUM, we should recommend VACUUM ANALYZE once an

> hour (or so) and a VACUUM FULL ANALYZE once a night.

Changed default suggestion to --analyze (once per day) to be conservative due to forum thread about full analyze affecting performance due to locking

----------------------------------------------------------------------

> Red hat 9: Stock SSL doesn't work - kerberos problem and also not compiled with

> thread support. (there's an OpenACS thread to fix this)

>http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=84331

> edit nsopenssl Makefile to say

> CFLAGS += -I$(OPENSSL)/include <b>-I/usr/kerberos/include<b>

Added pointer to thread

Options
    • -0
    • +0
    ./database-management.html
  2. … 54 more files in changeset.
Tuesday 29 Apr 2003
7:58 am

joela

updated version number to 4.6.3, fixed a few typos, changed doc email address to docs@openacs.org alias

Options
    • -2
    • +2
    ./database-management.html
  2. … 78 more files in changeset.
Saturday 19 Apr 2003
10:39 pm

joela

assorted bug fixes and fixed missing files

Options
    • -7
    • +7
    ./database-management.html
  2. … 92 more files in changeset.
Tuesday 15 Apr 2003
7:03 pm

joela

added missing upgrade and qmail.rc.txt files

Options
    • -7
    • +7
    ./database-management.html
  2. … 74 more files in changeset.
Monday 07 Apr 2003
6:59 pm

joela

updated tutorial; added and updated supporting files; minor tweaks

Options
    • -0
    • +0
    ./database-management.html
  2. … 67 more files in changeset.
Sunday 30 Mar 2003
8:04 am

joela

updated backup/recovery

Options
    • -2
    • +2
    ./database-management.html
  2. … 64 more files in changeset.
Saturday 29 Mar 2003
9:44 pm

joela

4.6.2 update

Options
    • -0
    • +49
    ./database-management.html
  2. … 64 more files in changeset.
9:44 pm

joela

file database-management.html was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./database-management.html