Metacat

  <p class="header">Java</p>

  <p>You'll need a recent Java SDK, preferably j2sdk1.4.2 or later.  We haven't 

  tested with any of the 1.5.x versions yet, so probably best to stay with 1.4.x.

  Make sure that JAVA_HOME environment variable is properly set and that both

  java and javac are on your PATH.

  </p>

  <p class="header">Oracle 8i or Postgres</p>

  <p><i>Oracle:</i><br>

  <p><i>Postgres:</i><br>

  Postgres can be easily installed on most linux distributions and on

  Windows (using cygwin) and Mac OS X.  Using Fedora Core or RedHat Linux,

  you can install the rpms for postgres and then run 

  <code>/etc/init.d/postgresql start</code> in order to start the database.

  This initializes the data files.  You need to do a bit of configuration

  to create a database and set up a user account and allow internet access

  via jdbc.  See the postgres documentation for this, but here is a quick 

  start:

  <ul>

     <li>Switch to the "postgres" user account and edit "data/pg_hba.conf", adding the following line to the file:<br>

     <code>host   metacat  metacat      127.0.0.1         255.255.255.255   password</code></li>

     <li>Edit the "data/postgres.conf" file and uncomment and edit the line

     starting with "tcpip_socket" so that it reads 

     <code>tcpip_socket = true</code></li>

     <li>Run <code>createdb metacat</code> to create a new database</li>

     <li>Run <code>psql metacat</code> to log in using the postgres account and create a new "metacat" user account

     <ul>

        <li>In postgres, run <code>CREATE USER metacat WITH UNENCRYPTED PASSWORD 'apasswordyoulike';</code></li>

        <li>This creates a new account called metacat on the database named metacat</li>

        <li>Note: there are many ways to do this, so others such as using 

        ENCRYPTED passwords will work fine.</li>

     </ul>

     </li>

     <li>Exit the postgres account back to root and restart the postgres 

     database with <code>/etc/init.d/postgresql restart</code></li>

     <li>Test logging into the postgres db using the metacat account with 

     the following command: 

     <code>psql -U metacat -W -h localhost metacat</code></li>

  </ul>

  </p>

   should be available in the users path. We note that the current build is 

   not working with Ant 1.6.x, so you'll need to use an earler version.  We have 

   successfully used Ant 1.5.1, 1.5.2, and some earlier versions.

  <p><b>WARNING: Do NOT run this on an existing metacat installation as it

  will delete all of your data.  If you have an existing metacat installation,

  see the instructions for "Upgrading" below.</b></p>

  <p>To run the scripts using ant, type <code>ant installdb</code>.  This does 

  not work for postgres, so you'll need to run the xmltables-postgres.sql script 

  manually (see next paragraph).

   For postgres, use a command like: 

   <code>psql -U metacat -W -h localhost -f build/src/xmltables-postgres.sql metacat</code>

      <li>upgrade-db-to-1.4.sql</li>

   <pre><b>ant geteml install</b></pre>

   or, if you are upgrading an existing installation, type:

   <pre><b>ant geteml upgrade</b></pre>