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
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
