Hi Eddie, On Fri, May 31, 2002 at 05:07:29PM -0700, Eddie Urenda wrote:
I attempted to follow the instuctions in README.database with the replacement files OpenTRS-schema.postgresql.sql and initial_insert.sql along with the *.pm files from the CVS tree.
Then I proceeded to create a user 'otrs' with home directory /opt/OpenTRS then created otrs database with 'createdb otrs' (as root).
I am using PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
When I attempt to insert the database (ran 'createuser root' and 'otrs' as well) using 'psql otrs < OpenTRS-schema.postgresql.sql', I get the following errors (sorry for this being so long), and most of the tables do not get created (it does not seem to like to check for tables that don't exist and does not like the NOT NULL statements either) :
-------------------------------------------------------------- ERROR: sequence "valid_id_seq" does not exist ERROR: table "valid" does not exist ERROR: parser: parse error at or near "NOT" [...]
I'm using PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.95.3. The error message locks like that the OpenTRS-schema.postgresql.sql isn't up to date. Do you have http://otrs.org/cgi-bin/cvsweb.cgi/~checkout~/otrs/install/database/OpenTRS-... from Thu May 30 13:20:59 2002 UTC? This works fine for me.
The tables that get created are:
session | table | root session_id_seq | sequence | root user_preferences | table | root
Am I missing a step or doing something incorrectly?
The way is right. Please check the OpenTRS-schema.postgresql.sql file. There should be 30 tables. %-)
Thanks,
-Eddie
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- socrate: 9:03am up 147 days, 19:50, 2 users, load average: 0.08, 0.05, 0.01