DBUpdate-to-3.1.pl

[dubarca]

Hi there,

I'm running into a problem when executing the above mentioned script.

I run it as root/otrs -> I get an error when trying to make changes to the DB.
I run it as postgres -> I get an error when making changes to the files.

I added otrs to the postgres group, didn't do the job either.

I'm updating from 3.0.1 to 3.1.3 on a Debian 6 + postgres.

I'm sure it's something with perms. but I don't see it. Check out the error, this one comes up when running it as root or otrs user:

Code: Select all

Step 2 of 24: Check framework version... done.

DBD::Pg::db do failed: ERROR:  permission denied for relation dynamic_field at /var/www/vhosts/otrs/Kernel/System/DB.pm line 478.
ERROR: OTRS-DBUpdate-to-3.1-10 Perl: 5.10.1 OS: linux Time: Thu Apr 19 17:20:30 2012

 Message: ERROR:  permission denied for relation dynamic_field, SQL: 'SELECT count(id) FROM dynamic_field'

 Traceback (18662):
   Module: main::_CheckDynamicFieldTables (v1.85) Line: 385
   Module: scripts/DBUpdate-to-3.1.pl (v1.85) Line: 86

Check if dynamic_field table exists, failed! at scripts/DBUpdate-to-3.1.pl line 390.

Thanks for any hint.

Br

d

[dubarca]

Ok, I fixed it. The problem where missing permissions on the DB. Now before going into the whole pg_hba.conf shabang, a simple

Code: Select all

ALTER USER otrs CREATEDB;

as user postgres did the job.