May 2005 - dev - OTRS mailing lists

How to set field Email: to take null value in the add user page.
by sumeet prasad 06 May '05

06 May '05

Hi OTRS Team, I don't want to give email address in the field Email: while creating user(agents). Right now when I don't give the email address while creating the user, I am not able to create user. I have searched in the database schema. I did not find the entry for this field. The schema where I am able to find this field is user_preferences. Its like this: # ----------------------------------------------------------------------- # user_preferences # ----------------------------------------------------------------------- drop table if exists user_preferences; CREATE TABLE user_preferences ( user_id INTEGER NOT NULL, preferences_key VARCHAR (150) NOT NULL, preferences_value VARCHAR (250), INDEX index_user_preferences_user_id (user_id) ); I am not able to get the UserEmail field in the database which actually contains the email address. Could u please tell me how to solve this problem. Thanks and Regards, Sumeet

1 0

Upgrade from 1.3.2 to 2.0.0b1
by Bryan Fullerton 06 May '05

06 May '05

I've updated my OTRS install from 1.3.2 to 2.0.0b1 (mmm, bleeding edge). I noted the following errors during the database update, using PostgreSQL. I've attached the full log of the SQL update output so you have context as well. [...] ERROR: column "o" does not exist ERROR: column "escalation_start_time" contains null values [...] ERROR: column "comments" of relation "ticket_state_type" does not exist [...] This database has been upgraded through numerous OTRS versions (starting with 0.5b :), so it's entirely possible there's some strangeness with the schema that needs tweaking. If so, please advise. If not, there are bugs in the script. Otherwise, everything looks OK so far... Thanks, Bryan

1 0

Cron.sh as root
by Rene Jochum 04 May '05

04 May '05

Hi, This is my first contribution (and first day in use :-)) to otrs. Thanks for it! I wasn't able to get otrs running with apache-2.0.53 and mod_perl-1.99.17, i have now apache-1.3.33 and mod_perl-1.27-r4 on Gentoo Linux with preloaded perl libs. I have written a little patch witch allows me to run ~otrs/bin/Cron.sh as root. cmd: ~otrs/bin/Cron.sh (start|stop|restart) <otrs_user> <otrs_home> With friendly regards, Jochum Rene P.s.: sry, for my poor english

1 1

2.0beta observations
by Peter Gervai 03 May '05

03 May '05

[btw last mail's hexcheck was for 2.0beta in this form, but could be "backported" by changing Ticket::Whatevers to TicketWhatevers in the code] I installed 2.0beta1, some observations. - postgres upgrade script _still_ contains mysql in the comment as example ;-)) Apart from that, upgrade worked almost seamless. Some Config.pm variables were changed (like my very first comment showed: TicketNumberGenerator became Ticket::NumberGenerator and like that), I figured this out pretty painfully for my own module mentioned up there. Linking and merging actually work, which is great, but not really what I'd expect, comments below: - I would expect closing a parent would close all its descendants (children and grandchildren etc), or at least have the possibility to do so. - Parents should be able to see all notes/entries of children together (probably using a "show all children" link), and navigate through them. I imagine every line would contain the source of the line, a clickable ticket number, if user want to attach new note to there. Or even a [note here] link? (I hope I was able to tell what I mean :)) - Merge should have similiar UI to linking: a chooser. I hate to memorise ticket numbers. - Merge-with-all-children feature? - For me it was unexpected that merge interface asks a ticket to merge INTO, and not merge FROM. UI could be a bit more detailed. - We often would like to open a new phone ticket based on an existing ticket or note, for example to call a user on a number in a note of a ticket. Would be nice to see the last ticket at the bottom of the "new phone ticket" UI and being able to see the contents of its notes. (Or vice versa, open a new phone ticket when browsing a ticket without losing the content of the screen, like opening a "new phone ticket" UI at the very bottom, or top.) Probably should be selectable (may annoy some people). - Being able to use a template to create a new email or phone ticket would be neat. (We often create tickets FOR customers with pretty standard texts, like "we're happy to inform you that your windows(r)(tm) machine is infected again and we happened to block your connection, have a nice day".) - FAQ might be used for the above as a hack, but "Done" button is maybe very badly named. I'd call it "Select" or even "Copy to form". So far that's it. I want to check whether utf-8 still screws up email output, but that's not for today. Bests, Peter -- Now using M2, Opera's e-mail client: http://www.opera.com/m2/

1 0

"hexcheck" number generator
by Peter Gervai 03 May '05

03 May '05

Attached -- Now using M2, Opera's e-mail client: http://www.opera.com/m2/

1 0

Mail Header problems (spam filter)
by Ritme Informatique 03 May '05

03 May '05

Hi there, we are using popfile as a spam proxy for otrs, it is performing very well (over 99.5 % of precision), but some spam mail do not get filtered by the postmaster filter. Popfile works by adding a header called "X-Text-Classification", so I filter on this in my postmaster. The problems is on some mails containing additionnal space in Subject, Otrs doesn't recognize the rest of the headers as Headers. Here is an example: Return-Path: <cvujhsuonyqse(a)wondstops.com> Received: from Dickson (194.98.113.80) by globald.com with SMTP (Eudora Internet Mail Server X 3.2.6); Tue, 5 Apr 2005 02:03:12 +0200 Return-Path: eiuliq(a)wondstops.com From: "Sherry" <cvujhsuonyqse(a)wondstops.com> Reply-To: "Sherry" <cvujhsuonyqse(a)wondstops.com> Date: Mon, 4 Apr 2005 17:04:38 -0700 To: MAILhidden(a)ritme.com Subject: Budget tight? Get up to 1500 USD by tomorrow Message-ID : <746847.5684276(a)wondstops.com> Content-Type: text/plain;charset="iso-8859-1 Message-ID: <1099463104-184944895(a)globald.com> X-Text-Classification: spam In fact the part starting with the Message ID is dumped in the email text in OTRS. Do you have any idea to avoid such behavior? Is it the right mailing list for this kind of problems? Best regards,

2 1

Change of contact
by Jason Dixon 02 May '05

02 May '05

Anyone that needs to reach me regarding any of our submissions to the OTRS project can now reach me at jason.dixon(a)amti.com. My email address at NASA (jason(a)nccs.nasa.gov) should no longer be used. Thanks, -- Jason Dixon Technical Lead, Open Source Tools AMTI, Inc.

1 0