[otrs] BETA7 -> BETA8

[Bryan Fullerton]

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 <[EMAIL PROTECTED]>
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

_______________________________________________
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