Re: [otrs] OpenTRS PostgreSQL support!

Martin, 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" ERROR: sequence "ticket_priority_id_seq" does not exist ERROR: table "ticket_priority" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "ticket_lock_type_id_seq" does not exist ERROR: table "ticket_lock_type" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "system_user_id_seq" does not exist ERROR: table "system_user" does not exist ERROR: parser: parse error at or near "NOT" ERROR: table "user_preferences" does not exist NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'user_preferences_pkey' for table 'user_preferences' CREATE ERROR: sequence "groups_id_seq" does not exist ERROR: table "groups" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "group_user_id_seq" does not exist ERROR: table "group_user" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "personal_queues_id_seq" does not exist ERROR: table "personal_queues" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "language_id_seq" does not exist ERROR: table "language" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "theme_id_seq" does not exist ERROR: table "theme" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "charset_id_seq" does not exist ERROR: table "charset" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "ticket_state_id_seq" does not exist ERROR: table "ticket_state" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "salutation_id_seq" does not exist ERROR: table "salutation" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "signature_id_seq" does not exist ERROR: table "signature" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "system_address_id_seq" does not exist ERROR: table "system_address" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "follow_up_possible_id_seq" does not exist ERROR: table "follow_up_possible" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "queue_id_seq" does not exist ERROR: table "queue" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "ticket_id_seq" does not exist ERROR: table "ticket" does not exist ERROR: parser: parse error at or near "NOT" ERROR: parser: parse error at or near "(" ERROR: parser: parse error at or near "(" ERROR: parser: parse error at or near "(" ERROR: sequence "ticket_history_id_seq" does not exist ERROR: table "ticket_history" does not exist ERROR: parser: parse error at or near "NOT" ERROR: parser: parse error at or near "(" ERROR: sequence "ticket_history_type_id_seq" does not exist ERROR: table "ticket_history_type" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "article_type_id_seq" does not exist ERROR: table "article_type" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "article_sender_type_id_seq" does not exist ERROR: table "article_sender_type" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "article_id_seq" does not exist ERROR: table "article" does not exist ERROR: parser: parse error at or near "NOT" ERROR: parser: parse error at or near "(" ERROR: sequence "standard_response_id_seq" does not exist ERROR: table "standard_response" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "queue_standard_response_id_seq" does not exist ERROR: table "queue_standard_response" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "auto_response_type_id_seq" does not exist ERROR: table "auto_response_type" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "auto_response_id_seq" does not exist ERROR: table "auto_response" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "queue_auto_response_id_seq" does not exist ERROR: table "queue_auto_response" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "faq_id_seq" does not exist ERROR: table "faq" does not exist ERROR: parser: parse error at or near "NOT" ERROR: sequence "session_id_seq" does not exist ERROR: table "session" does not exist NOTICE: CREATE TABLE will create implicit sequence 'session_id_seq' for SERIAL column 'session.id' NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'session_pkey' for table 'session' NOTICE: CREATE TABLE / UNIQUE will create implicit index 'session_session_id_key' for table 'session' CREATE ERROR: parser: parse error at or near "(" ------------------------------------------------------------------ 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? Thanks, -Eddie On Thu, 30 May 2002, Martin Edenhofer wrote:

Hi,

today I tested OpenTRS with PostgreSQL. And after a few changes (mostly in OpenTRS-schema.postgresql.sql and initial_insert.sql) it works fine.

If you want to use it, install 0.5 Beta5 and update

Kernel/Modules/AgentQueueView.pm Kernel/Modules/AgentZoom.pm install/database/OpenTRS-schema.postgresql.sql install/database/initial_insert.sql

from the current CVS tree.

Bye,

Martin

-- Martin Edenhofer - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider

with kind regards

Martin

-- Martin Edenhofer - - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.

_______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs