-*-outline-*-

  $Id: zope-info.txt,v 3.3 2004/03/29 20:27:22 biggers Exp $

* ================ Zope on "yourHost.yourDom.com"

** -------- Typical  Zope paths

  ZHOME=/usr/local/Zope	    ## (a typical) Zope 2.7.0 installation

  ZSRC=/usr/local/src/Zope  ## (a typical) dir for Zope tarfiles, Products


  PYDIR=/usr/local/python-2.3.3  

  ## Python 2.3.3, from a SuSE Linux 9 RPM custom-build ...
  ## 
  ## ADDED LATER - lib/python2.3/site-packages/mx "mxTools"
  ##               lib/python2.3/site-packages/psycopg.so ... 
  ##               "PsycoPG" for PgSQL


** -------- Zope installation

  SEE:  "zope-install.txt"


** -------- installed Zope Products

  ## Often, Products are installed by a simple "copy".   Then, restart Zope

  
  # == the ZetaDB product
  #    Get it (below).   USING IT, see: 
  #
  #  http://www.zope.org/Members/scamps/zope_zetadb_introduction
  #  http://zetadb.sourceforge.net/

  ## "Check-out" the latest ZDB code, from their SF.net acct:

  cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/zetadb login

  cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/zetadb co zetadb


  # ZSRC is your Zope tar-files home

  cd $ZSRC/Products

  cp -r zetadb  $ZHOME/lib/python/Products   ## copy it to your Zope install


  # == MaildropHost - Zope bulk-mailing, using spooling
  #    GET IT:
  #      http://www.dataflake.org/software/maildrophost/

  tar -zxvf -C $ZHOME/lib/python/Products  MaildropHost-1_3.tar.gz

  (SEE) MaildropHost/INSTALL.txt for further (easy) configuration


** -------- Zope instance(s) - creating

  ## a good convention - a "$ZHOME/www/someDir" is a Zope instance-dir
 

  ## SEE general Zope docs:  Zope-2.7.0/doc/INSTALL.txt  - etc.

  ## To make a new Zope instance:
  ##   this script will ask for a newInstanceDir path.
  ##   It creates a new ZODB here, too ...

  $ZHOME/bin/mkzopeinstance.py

  ## (answer with)
  ## $ZHOME/www/newInstanceDir
  ## AND the  zope-admin-user & user's passwd
  ##
  ## NOTE: You may want to modify $ZHOME/www/newInstanceDir/etc/zope.conf


** -------- starting, stopping Zope
 
  alias zopectl=$ZHOME/www/home1/bin/zopectl   ## www/home1 is a Z-instance

  zopectl [start|stop|status]                  ## manages Zope "daemon"

  ## "home page"  http://yourHost.yourDom.com:8080
  ##  ZMI @       http://yourHost.yourDom.com:8080/manage


  ##  edit CMapp content via GNU Emacs FTP ...
  ## 
  ##    C-X C-F  /zopeMan@yourHost.yourDom.com#8021:/
  ##
  ##  use Dired to "move about" the ZMI Folders


  !! (aside) a typical ZPsycoPG/PgSQL connection string !!

  host=localhost dbname=a_PG_DB user=aDBuser password=aDBuserpwd


* ================ PostgreSQL usage notes w/Zope, Python

** -------- DB scripting with Python and PgSQL - notes & examples

  Redhat DB 2.1 Programmer's docs for Python DB-api (decent):

    http://www.redhat.com/docs/manuals/database/RHDB-2.1-Manual/prog/x7260.html

  Triangle ZPUG article (example) -

    http://starship.python.net/pipermail/triangle-zpug/2003-May/000191.html

  DB-api PEP - http://www.python.org/peps/pep-0249.html


** -------- creating PgSQL users
 
  psql template1	## do (all this) as user 'postgres':

  alter user postgres password 'pgSQLUserPWD';   ## don't lose this!

  create user aDBuser password 'aDBuserpwd' createdb nocreateuser; 

 
** -------- typical 'a_PG_DB' set-up notes
 
  ## create a new PgSQL DB

  dropdb   -U aDBuser a_PG_DB   ## give "aDBuser's" db-passwd, above 

  createdb -U aDBuser a_PG_DB

  cd some_schemas_dir


  ## Create the tables in 'a_PG_DB'

  psql -U aDBuser  -f a_PG_DB_tables.sql  a_PG_DB


  ## a "DSN" string -- use in Python DB-api scripts or in Zope

  host=localhost dbname=a_PG_DB user=aDBuser password=xxxxxx 


** -------- Using ths 'pgaccess' PgSQL GUI

  apt-get -u install pgaccess  # on Debian (or SuSE, RH if config'd)

  pgaccess &  ## Database => Open
              ## Database: a_PG_DB
	      ## Username: aDBuser  Password: xxxxx
	      ## => Tables (to see this DB's tables)