- otrs - OTRS mailing lists

BETA7 -> BETA8
by Bryan Fullerton 30 Oct '02

30 Oct '02

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 <martin(a)otrs.org> 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

2 6

Ticket follow-up question
by Marco Cintolesi 30 Oct '02

30 Oct '02

Hi all, We are starting to use OTRS in our business, And (of course) i have some questions........ How OTRS track a follow-up to a ticket ??? For example, if the agent reply (via e-mail) to a message WITHOUT leaving the ticket ID in the subject, the subsequent reply from the customer comes as a new ticket.......Here (in some cases) we dont like to answer with the ticket ID in the subject.... theres a "trick" to use a X-header for ticket tracking ??? example: OTRS can insert a x-header like: X-OTRS-TT: TICKET 1234567890 and then track the ticket using this X-header, without using the "subject" field..... Is this possible ??? Many many thanks Marco Cintolesi

3 2

OTRS Update Beta7 -> Beta8
by Volker Voßkämper 30 Oct '02

30 Oct '02

Server: SuSE 8.0 Client: W2K de SP3, MS IExplorer 5.0 First a short description what I did: - rcotrs stop-force - Backup otrs Database - Install RPM with -U Option - Edit new version of following files: - /etc/sysconfig/otrs - /opt/OpenTRS/.fetchmail - /opt/OpenTRS/Kernel/Config.pm - /opt/OpenTRS/var/cron/fetchmail - copy and delete of rpm backup files - running permissions-script (you forgot the s in your anounce mail /opt/OpenTRS/bin/SetPermission.sh) - running updateDB script (this returns the following errors: vk-main:/opt/OpenTRS/Kernel # cat /opt/OpenTRS/scripts/DBUpdate.mysql.sql | mysql -f -u root otrs ERROR 1050 at line 52: Table 'ticket_index' already exists ERROR 1050 at line 64: Table 'time_accounting' already exists ERROR 1062 at line 79: Duplicate entry 'TimeAccounting' for key 2 ERROR 1062 at line 85: Duplicate entry 'email-notification-ext' for key 2 ERROR 1062 at line 89: Duplicate entry 'email-notification-int' for key 2 ERROR 1062 at line 95: Duplicate entry 'Forward' for key 2 ERROR 1062 at line 99: Duplicate entry 'Bounce' for key 2 ERROR 1060 at line 106: Duplicate column name 'a_content_type' ERROR 1061 at line 112: Duplicate key name 'index_user_preferences_user_id' ERROR 1060 at line 118: Duplicate column name 'ticket_answered' ERROR 1062 at line 121: Duplicate entry 'SendAgentNotification' for key 2 ERROR 1062 at line 127: Duplicate entry 'French' for key 2 ERROR 1062 at line 133: Duplicate entry 'email-external' for key 2 ERROR 1062 at line 137: Duplicate entry 'email-internal' for key 2 ERROR 1050 at line 143: Table 'user_preferences' already exists ERROR 1050 at line 152: Table 'session' already exists vk-main:/opt/OpenTRS/Kernel # ) - rcotrs start-force Did some tests. OK. everything looks good... ... but don't know about the dbscript errors ?!? OK. Now some attachment tests. - making new telephone call (windows client) - make answer with attachment of: E:\Daten\Test.zip - the recipient got the mail but the name of the attachement is: EDatenTest.zip (but the file is ok) - in the ticket the file ist shown by E:\Daten\Test.zip - I try to download this file from the ticket - file dialog shows: Filename: index Type: -document after saving this a message apperars in explorer: action aborted the URL is: http://myhost/otrs/index.pl?Action=AgentAttachment&ArticleID=190&File=E:\Dat en\Test.zip the filename in server filesystem is: EDATE~2L.ZIP but the file was allready downloaded as index after renaming the file on my client to index.zip I can open it - the file is OK. - now I try a second answer with attachement a message appears:page cannot be shown http 500 internal error the URL is: http://myhost/otrs/index.pl no message is send I can't write any more answer with attachment on this ticket !!! normal answer is OK answer with attachment on other ticket is same as described before. OK, that's all for now. (I have some truble with euro sign. But later...) regards Volker

4 6

Bug in PhoneView?
by Andreas Haase 30 Oct '02

30 Oct '02

Hello, I just tried to open a new ticket via Phone View. That did as I wanted but if in the ticket the From: and To: are the same adresses, although if I selected different ones. The queue the ticket is pushed into, is the right one, so its just a blemish. An yesterday I customized a frontend theme. In Header.dtl I wanted to display an image, but OTRS expanded the path with the session id. For other links that seems good, but not for images. Bye, Andreas -- --------------- professional INTERNET services -------------- EastLink GmbH - Augustusburger Strasse 1 - D-09111 Chemnitz voice: +49-180-5432060 fax: +49-371-4320626 www.eastlink.de

2 1

PostgreSQL note
by Bryan Fullerton 29 Oct '02

29 Oct '02

Oh yeah, one thing I was reminded of by upgrading to BETA8, I had to make this change to Kernel/Config.pm because my PostgreSQL server isn't localhost. 117c117 < # $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; --- > $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};"; (I'm pretty sure this isn't why things aren't working, as I did the same thing with BETA7) Thanks, Bryan

2 2

beta 8 administration panel
by Detlef Kocks 29 Oct '02

29 Oct '02

Hi, if i don't need e.g. the "misc"-queue and want to delete it, is it right that i have to delete the mysql-record? I did not found any possibility to delete several standards (e. g. queue, auto-answer etc.). Is there any other way, beside to edit the values, for deletion? Or a hidden button "delete" i not found? Thanks in advance and best regards Detlef Kocks

2 1

Apache 2.0.x?
by Stefan Wintermeyer 29 Oct '02

29 Oct '02

Hi, does anybody use OTRS with Apache 2.0.x? Did you have any problems (e.g. with Perl or mod_perl)? take care Stefan -- Stefan Wintermeyer I wish we hadn't had to do this. (McCoy) "Star Trek"

1 0

OpenTicketView idea
by Bastian Hoyer 28 Oct '02

28 Oct '02

Hi all, The OpenTicketView is really a cool thing, but it would be even better if Tickets with new messages (customer responses) would be marked with an red exclamation mark or highlighted in an other way in the list. Bastian

2 2

text wrap.
by Diane Shieh 28 Oct '02

28 Oct '02

Hello, Is there any way that I can set the text of an outgoing email to be 72 characters across instead of text-wrapping? The emails end up looking "unattractive" on PINE and other email clients =( I would really appreciate any solutions or assistance =) =Diane

2 3

some suggestions
by Volker Voßkämper 28 Oct '02

28 Oct '02

First my congratulations to the progammers of this tool. I'm happy that I can use it now! OTRS is nice for managing incomming e-mails but support is often done via telephone. For telephone support the most important thing (at least for me) is managing contacts. So I miss the following features: - Forms for managing customers and their contact persons (two tables) - field for foraign system customerID for referencing with billingsystem - In PhoneView: - search for contact name and automatic fill for the fields e-mail and customer ID - optional new ticket with only a name (if contact has no e-mail - yes, this ist real) - Quick insert of new customer and contact if name is not found - Filter for open (and closed) )tickets by customerID, Name or contact name (for fast editing an existing call when contact person did not know his ticket#) - on incomming mail automatical fill contact name and customerID if e-mail address match with contact in contact table - change of the From field on existing ticket if ticket is generated via PhoneView (to correct errors) - flag for billing in each step of a ticket (you can't make an invoice for all things you do) - separat statistics for work and possible billing grouped by customer and contact with list of ticket# - view cusomer name in queue view Generally I miss: - send answers with attachment I hope I'm not alone with this wishes and may find some of this in feature releases. regards Volker

3 3