Notes on the BETA8 upgrade... number 4 below is most important. :)
1. PostgreSQL update (couple of errors, no biggies):
% cat scripts/DBUpdate.postgresql.sql | psql -U otrs -h db otrs
Password:
CREATE
NOTICE: CREATE TABLE will create implicit sequence
'customer_user_id_seq' for SERIAL column 'customer_user.id'
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'customer_user_pkey' for table 'customer_user'
NOTICE: CREATE TABLE / UNIQUE will create implicit index
'customer_user_login_key' for table 'customer_user'
CREATE
CREATE
ERROR: index named "index_user_id" already exists
CREATE
ERROR: Relation 'ticket_index' already exists
NOTICE: CREATE TABLE will create implicit sequence
'time_accounting_id_seq' for SERIAL column 'time_accounting.id'
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'time_accounting_pkey' for table 'time_accounting'
ERROR: Relation 'time_accounting_id_seq' already exists
ERROR: index named "time_accounting_ticket_id" already exists
ERROR: Cannot insert a duplicate key into unique index
ticket_history_type_name_key
ERROR: Cannot insert a duplicate key into unique index
article_type_name_key
ERROR: Cannot insert a duplicate key into unique index
article_type_name_key
ERROR: Cannot insert a duplicate key into unique index
ticket_history_type_name_key
ERROR: Cannot insert a duplicate key into unique index
ticket_history_type_name_key
ERROR: ALTER TABLE: column name "a_content_type" already exists in
table "article"
2. SetPermissions.sh (warnings)
% bin/SetPermissions.sh /usr/local/otrs otrs www nogroup www
SetPermissions.sh <$Revision: 1.13 $> - set OTRS file permissions
Copyright (c) 2002 Martin Edenhofer
Setting file permissions...
chown -R 0.0 /usr/local/otrs
chown: separation of user and group with a period is deprecated
chown otrs.nogroup /usr/local/otrs
chown: separation of user and group with a period is deprecated
chown otrs.nogroup /usr/local/otrs/.fetchmailrc
chown: separation of user and group with a period is deprecated
chmod 0710 /usr/local/otrs/.fetchmailrc
chown otrs.nogroup /usr/local/otrs/.procmailrc
chown: separation of user and group with a period is deprecated
chmod 0644 /usr/local/otrs/.procmailrc
chown -R otrs.www /usr/local/otrs/var/
chown: separation of user and group with a period is deprecated
chown -R www.www /usr/local/otrs/var/sessions/
chown: separation of user and group with a period is deprecated
otrs.www /usr/local/otrs/var/log/TicketCounter.log
chown: separation of user and group with a period is deprecated
chmod -R 755 /usr/local/otrs/bin/
(chown && chmod 700) otrs.0 /usr/local/otrs/bin/DeleteSessionIDs.pl
chown: separation of user and group with a period is deprecated
(chown && chmod 700) otrs.0 /usr/local/otrs/bin/UnlockTickets.pl
chown: separation of user and group with a period is deprecated
(chown && chmod 700) otrs.0 /usr/local/otrs/bin/otrs.getConfig
chown: separation of user and group with a period is deprecated
The chown requests all completed successfully, just emitted warnings. I
believe normally it's user:group on FreeBSD.
3. /bin/bash (hardcoded location)
Lots of places, shells are hardcoded to /bin/bash - FreeBSD ports
installs bash as /usr/local/bin/bash. IMHO, the only shell you should
assume is on a system is /bin/sh.
4. index.pl no longer works! (eep!)
% perl -cw bin/cgi-bin/index.pl
syntax error at /usr/local/otrs/bin/cgi-bin/../../Kernel/Config.pm line
539, near "$_;"
BEGIN failed--compilation aborted at ../otrs/bin/cgi-bin/index.pl line
48.
Help! I tried checking index.pl from CVS, it does the same thing. :(
Thanks,
Bryan
