
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

Hi Bryan, On Tue, Oct 29, 2002 at 08:52:26AM -0500, Bryan Fullerton wrote:
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' [...]
Don't worry about the error messages, you can update all previous version with this script and in the most cases your database has already the most changes!
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 [...] The chown requests all completed successfully, just emitted warnings. I believe normally it's user:group on FreeBSD.
Is this (http://bogen.net/SetPermissions.sh) working?
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.
I changed it in the CVS. Thanks for this!
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. :(
Ja, this means there is a syntax error in Kernel/Config.pm near line 539.
Thanks,
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson

On Tuesday, October 29, 2002, at 05:59 PM, Martin Edenhofer wrote:
Don't worry about the error messages, you can update all previous version with this script and in the most cases your database has already the most changes!
Aaah, ok, thanks.
Is this (http://bogen.net/SetPermissions.sh) working?
Yes!
Ja, this means there is a syntax error in Kernel/Config.pm near line 539.
Ok, we got this figured out off-list - thanks! Now I have this... :) when sending a response to a ticket. ===== Software error: Undefined subroutine CGI::upload For help, please send mail to the webmaster (webmaster@samurai.com), giving this error message and the time and date of the error. ===== I'll try finding the CGI::upload module (not sure which CPAN module it's in) - might want to mention that it's now needed! Thanks, Bryan

On Tuesday, October 29, 2002, at 11:00 PM, Bryan Fullerton wrote:
I'll try finding the CGI::upload module (not sure which CPAN module it's in) - might want to mention that it's now needed!
Humm... this one is CGI::Upload (note case difference) - is this what it's supposed to be? http://www.cpan.org/modules/by-module/CGI/CGI-Upload-1.02.readme Bryan

Hi Bryan, On Tue, Oct 29, 2002 at 11:09:43PM -0500, Bryan Fullerton wrote:
I'll try finding the CGI::upload module (not sure which CPAN module it's in) - might want to mention that it's now needed!
Humm... this one is CGI::Upload (note case difference) - is this what it's supposed to be?
http://www.cpan.org/modules/by-module/CGI/CGI-Upload-1.02.readme
No. What version of CGI.pm do you use (find /usr/ -name CGI.pm | xargs grep 'CGI::VERSION=')? I use 2.752 (require 5.004) and this version comes with the upload() function. Maybe you use < 1.57 (http://stein.cshl.org/WWW/software/CGI/) then you have to update?
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Perfection is our goal, excellence will be tolerated. -- J. Yahl

On Wednesday, October 30, 2002, at 07:11 AM, Martin Edenhofer wrote:
What version of CGI.pm do you use (find /usr/ -name CGI.pm | xargs grep 'CGI::VERSION=')?
Aah... $CGI::VERSION='2.46';
I use 2.752 (require 5.004) and this version comes with the upload() function.
Maybe you use < 1.57 (http://stein.cshl.org/WWW/software/CGI/) then you have to update?
I installed version 2.89 and it's working again! Yay! Might want to mention that minimum version requirement in the INSTALL docs. :) Thanks, Bryan

Hi Bryan, On Wed, Oct 30, 2002 at 10:52:59AM -0500, Bryan Fullerton wrote:
Maybe you use < 1.57 (http://stein.cshl.org/WWW/software/CGI/) then you have to update?
I installed version 2.89 and it's working again! Yay!
Might want to mention that minimum version requirement in the INSTALL docs. :)
Done. :)
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider
participants (2)
-
Bryan Fullerton
-
Martin Edenhofer