trying to get OTRS 3 up with Postgres: bin/otrs.CheckDB.pl fails: permission denied for relation valid, SQL: 'SELECT * FROM valid'

30 Mar 2011

      otrs.CheckDB.pl fails, it says permission denied for table "valid" -
the table is there though.

# /opt/otrs/bin/otrs.CheckDB.pl
Trying to connect to database
DSN: DBI:Pg:dbname=otrs;host=localhost;
DatabaseUser: otrs

DBD::Pg::st execute failed: ERROR:  permission denied for relation
valid at /opt/otrs/Kernel/System/DB.pm line 553.
ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.8.8 OS: linux Time: Tue Mar 29
17:23:42 2011

 Message: ERROR:  permission denied for relation valid, SQL: 'SELECT *
FROM valid'

 Traceback (10727):
   Module: /opt/otrs/bin/otrs.CheckDB.pl (v1.4) Line: 71

DBD::Pg::st fetchrow_array failed: no statement executing at
/opt/otrs/Kernel/System/DB.pm line 616.
No initial inserts found!
# psql -U otrs otrs
psql (8.4.4)
Type "help" for help.
...
\d valid
                                       Table "public.valid"
   Column    |              Type              |                     Modifiers
-------------+--------------------------------+----------------------------------------------------
 id          | integer                        | not null default
nextval('valid_id_seq'::regclass)
 name        | character varying(200)         | not null
 create_time | timestamp(0) without time zone | not null
 create_by   | integer                        | not null
 change_time | timestamp(0) without time zone | not null
 change_by   | integer                        | not null
Indexes:
    "valid_pkey" PRIMARY KEY, btree (id)
    "valid_name" UNIQUE, btree (name)
Foreign-key constraints:
    "fk_valid_change_by_id" FOREIGN KEY (change_by) REFERENCES users(id)
    "fk_valid_create_by_id" FOREIGN KEY (create_by) REFERENCES users(id)
Referenced by:
    TABLE "article_sender_type" CONSTRAINT
"fk_article_sender_type_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "article_type" CONSTRAINT "fk_article_type_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "article" CONSTRAINT "fk_article_valid_id_id" FOREIGN KEY
(valid_id) REFERENCES valid(id)
    TABLE "auto_response_type" CONSTRAINT
"fk_auto_response_type_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "auto_response" CONSTRAINT "fk_auto_response_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "customer_user" CONSTRAINT "fk_customer_user_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "follow_up_possible" CONSTRAINT
"fk_follow_up_possible_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "groups" CONSTRAINT "fk_groups_valid_id_id" FOREIGN KEY
(valid_id) REFERENCES valid(id)
    TABLE "link_state" CONSTRAINT "fk_link_state_valid_id_id" FOREIGN
KEY (valid_id) REFERENCES valid(id)
    TABLE "link_type" CONSTRAINT "fk_link_type_valid_id_id" FOREIGN
KEY (valid_id) REFERENCES valid(id)
    TABLE "mail_account" CONSTRAINT "fk_mail_account_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "notification_event" CONSTRAINT
"fk_notification_event_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "queue" CONSTRAINT "fk_queue_valid_id_id" FOREIGN KEY
(valid_id) REFERENCES valid(id)
    TABLE "roles" CONSTRAINT "fk_roles_valid_id_id" FOREIGN KEY
(valid_id) REFERENCES valid(id)
    TABLE "salutation" CONSTRAINT "fk_salutation_valid_id_id" FOREIGN
KEY (valid_id) REFERENCES valid(id)
    TABLE "signature" CONSTRAINT "fk_signature_valid_id_id" FOREIGN
KEY (valid_id) REFERENCES valid(id)
    TABLE "standard_attachment" CONSTRAINT
"fk_standard_attachment_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "standard_response" CONSTRAINT
"fk_standard_response_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "system_address" CONSTRAINT "fk_system_address_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "ticket_history_type" CONSTRAINT
"fk_ticket_history_type_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "ticket_history" CONSTRAINT "fk_ticket_history_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "ticket_lock_type" CONSTRAINT
"fk_ticket_lock_type_valid_id_id" FOREIGN KEY (valid_id) REFERENCES
valid(id)
    TABLE "ticket_state" CONSTRAINT "fk_ticket_state_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "ticket_type" CONSTRAINT "fk_ticket_type_valid_id_id"
FOREIGN KEY (valid_id) REFERENCES valid(id)
    TABLE "ticket" CONSTRAINT "fk_ticket_valid_id_id" FOREIGN KEY
(valid_id) REFERENCES valid(id)
    TABLE "users" CONSTRAINT "fk_users_valid_id_id" FOREIGN KEY
(valid_id) REFERENCES valid(id)
...
Any suggestions?

Aleksey

Aleksey Tsalolikhin

Gerald Young

Aleksey Tsalolikhin

Michiel Beijen

tags

participants (3)