- otrs - OTRS mailing lists

Another patch from CVS
by Atif Ghaffar 04 Jun '02

04 Jun '02

Hmm, I dont know if this was a mistake or it was intentional. In some places "QueueID" was written as "OueueID" O instead of Q best regards. -- Atif Ghaffar ---------------------------. +41 78 845 31 64 ¦ tel aghaffar(a)developer.ch ¦ email http://atifghaffar.com ¦ www 8206786 ¦ icq Index: System/Queue.pm =================================================================== RCS file: /home/cvs/otrs/Kernel/System/Queue.pm,v retrieving revision 1.4 diff -u -3 -p -u -r1.4 Queue.pm --- System/Queue.pm 2002/05/26 10:12:31 1.4 +++ System/Queue.pm 2002/06/04 04:56:25 @@ -25,7 +25,7 @@ sub new { my $Self = {}; # allocate new hash for object bless ($Self, $Type); - $Self->{OueueID} = $Param{QueueID} || ''; #die "Got no QueueID!"; + $Self->{QueueID} = $Param{QueueID} || ''; #die "Got no QueueID!"; $Self->{DBObject} = $Param{DBObject} || die "Got no DBObject!"; return $Self; } @@ -36,7 +36,7 @@ sub GetSystemAddress { my %Adresss; my $SQL = "SELECT sa.value0, sa.value1 FROM system_address as sa, queue as sq " . " WHERE " . - " sq.id = $Self->{OueueID} " . + " sq.id = $Self->{QueueID} " . " and " . " sa.id = sq.system_address_id"; $Self->{DBObject}->Prepare(SQL => $SQL); @@ -53,7 +53,7 @@ sub GetSalutation { my $String = ''; my $SQL = "SELECT text FROM salutation as sa, queue as sq " . " WHERE " . - " sq.id = $Self->{OueueID} " . + " sq.id = $Self->{QueueID} " . " and " . " sq.salutation_id = sa.id"; $Self->{DBObject}->Prepare(SQL => $SQL); @@ -69,7 +69,7 @@ sub GetSignature { my $String = ''; my $SQL = "SELECT text FROM signature as si, queue as sq " . " WHERE " . - " sq.id = $Self->{OueueID} " . + " sq.id = $Self->{QueueID} " . " and " . " sq.signature_id = si.id"; $Self->{DBObject}->Prepare(SQL => $SQL); Index: System/PostMaster/AutoResponse.pm =================================================================== RCS file: /home/cvs/otrs/Kernel/System/PostMaster/AutoResponse.pm,v retrieving revision 1.2 diff -u -3 -p -u -r1.2 AutoResponse.pm --- System/PostMaster/AutoResponse.pm 2001/12/30 00:42:58 1.2 +++ System/PostMaster/AutoResponse.pm 2002/06/04 04:56:25 @@ -33,7 +33,7 @@ sub new { sub GetResponseData { my $Self = shift; my %Param = @_; - my $QueueID = $Param{OueueID}; + my $QueueID = $Param{QueueID}; my $Type = $Param{Type}; my %Data; Index: System/PostMaster/FollowUp.pm =================================================================== RCS file: /home/cvs/otrs/Kernel/System/PostMaster/FollowUp.pm,v retrieving revision 1.10 diff -u -3 -p -u -r1.10 FollowUp.pm --- System/PostMaster/FollowUp.pm 2002/05/26 10:14:17 1.10 +++ System/PostMaster/FollowUp.pm 2002/06/04 04:56:26 @@ -164,7 +164,7 @@ sub Run { DBObject => $DBObject, ); my %Data = $AutoResponse->GetResponseData( - OueueID => $QueueID, + QueueID => $QueueID, Type => $AutoResponseType, ); if ($Data{Text} && $Data{Realname} && $Data{Address} && !$GetParam{'X-OTRS-Loop'}) { Index: System/PostMaster/NewTicket.pm =================================================================== RCS file: /home/cvs/otrs/Kernel/System/PostMaster/NewTicket.pm,v retrieving revision 1.9 diff -u -3 -p -u -r1.9 NewTicket.pm --- System/PostMaster/NewTicket.pm 2002/05/26 22:52:47 1.9 +++ System/PostMaster/NewTicket.pm 2002/06/04 04:56:26 @@ -175,7 +175,7 @@ sub Run { DBObject => $DBObject, ); my %Data = $AutoResponse->GetResponseData( - OueueID => $QueueID, + QueueID => $QueueID, Type => $AutoResponseType, ); if ($Data{Text} && $Data{Realname} && $Data{Address} && !$GetParam{'X-OTRS-Loop'}) {

3 2

multi domain setup
by Atif Ghaffar 04 Jun '02

04 Jun '02

hi. before I reading the code, I thought I might ask. Does OTRS support multi domains? I want to setup OTRS on a domain as offer it as a service to all ISP clients. Anyone can have support(a)domain.tld to be forwarded to OTRS. I have not yet fully thought on how auth etc will be handled. Just would like to inquire if this is already thought of. If not, I'll start thinking/coding. Best regards. -- Atif Ghaffar ---------------------------. +41 78 845 31 64 ¦ tel aghaffar(a)developer.ch ¦ email http://atifghaffar.com ¦ www 8206786 ¦ icq

2 9

OpenTRS PostgreSQL support!
by Martin Edenhofer 04 Jun '02

04 Jun '02

Hi, today I tested OpenTRS with PostgreSQL. And after a few changes (mostly in OpenTRS-schema.postgresql.sql and initial_insert.sql) it works fine. If you want to use it, install 0.5 Beta5 and update Kernel/Modules/AgentQueueView.pm Kernel/Modules/AgentZoom.pm install/database/OpenTRS-schema.postgresql.sql install/database/initial_insert.sql from the current CVS tree. Bye, Martin -- Martin Edenhofer - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider with kind regards Martin -- Martin Edenhofer - <martin(a)edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.

3 4

FP !!!!!!! First Patch! :)
by Atif Ghaffar 04 Jun '02

04 Jun '02

Or Shall I say Frist Patch?? best regards -- Atif Ghaffar ---------------------------. +41 78 845 31 64 ¦ tel aghaffar(a)developer.ch ¦ email http://atifghaffar.com ¦ www 8206786 ¦ icq Index: Config.pm =================================================================== RCS file: /home/cvs/otrs/Kernel/Config.pm,v retrieving revision 1.34 diff -u -3 -p -r1.34 Config.pm --- Config.pm 2002/05/30 15:34:17 1.34 +++ Config.pm 2002/06/03 23:50:44 @@ -148,7 +148,7 @@ sub Load { 'ID', 'Salutation', 'Login', - 'Fristname', + 'Firstname', 'Lastname', 'ValidID', 'Pw', Index: Output/HTML/Lite/AdminUserForm.dtl =================================================================== RCS file: /home/cvs/otrs/Kernel/Output/HTML/Lite/AdminUserForm.dtl,v retrieving revision 1.5 diff -u -3 -p -r1.5 AdminUserForm.dtl --- Output/HTML/Lite/AdminUserForm.dtl 2002/05/26 18:16:43 1.5 +++ Output/HTML/Lite/AdminUserForm.dtl 2002/06/03 23:50:45 @@ -64,7 +64,7 @@ </tr> <tr> <td>$Text{"Firstname"}: </td> - <td> <input type="text" name="Fristname" value="$Data{"UserFirstname"}" size="35" maxlength="50"></td> + <td> <input type="text" name="Firstname" value="$Data{"UserFirstname"}" size="35" maxlength="50"></td> </tr> <tr> <td>$Text{"Lastname"}: </td> Index: Output/HTML/Standard/AdminUserForm.dtl =================================================================== RCS file: /home/cvs/otrs/Kernel/Output/HTML/Standard/AdminUserForm.dtl,v retrieving revision 1.8 diff -u -3 -p -r1.8 AdminUserForm.dtl --- Output/HTML/Standard/AdminUserForm.dtl 2002/05/26 18:15:54 1.8 +++ Output/HTML/Standard/AdminUserForm.dtl 2002/06/03 23:50:45 @@ -64,7 +64,7 @@ </tr> <tr> <td>$Text{"Firstname"}: </td> - <td> <input type="text" name="Fristname" value="$Data{"UserFirstname"}" size="35" maxlength="50"></td> + <td> <input type="text" name="Firstname" value="$Data{"UserFirstname"}" size="35" maxlength="50"></td> </tr> <tr> <td>$Text{"Lastname"}: </td> Index: System/User.pm =================================================================== RCS file: /home/cvs/otrs/Kernel/System/User.pm,v retrieving revision 1.5 diff -u -3 -p -r1.5 User.pm --- System/User.pm 2002/05/12 22:05:10 1.5 +++ System/User.pm 2002/06/03 23:50:45 @@ -252,7 +252,7 @@ sub UserAdd { " valid_id, create_time, create_by, change_time, change_by)" . " VALUES " . " ('$Param{Salutation}', " . - " '$Param{Fristname}', " . + " '$Param{Firstname}', " . " '$Param{Lastname}', " . " '$Param{Login}', " . " '$Param{Pw}', " . @@ -315,7 +315,7 @@ sub UserUpdate { # -- my $SQL = "UPDATE $Self->{UserTable} SET " . " salutation = '$Param{Salutation}', " . - " first_name = '$Param{Fristname}'," . + " first_name = '$Param{Firstname}'," . " last_name = '$Param{Lastname}', " . " $Self->{UserTableUser} = '$Param{Login}', " . " valid_id = $Param{ValidID}, " .

2 1

[BUG] on table user_preference
by Bruno Arliguy 01 Jun '02

01 Jun '02

in the file "OpenTRS-schema.mysql.sql", the table "user_preferences" is describe like this : CREATE TABLE user_preferences ( user_id INTEGER NOT NULL, preferences_key VARCHAR (100) NOT NULL, preferences_value VARCHAR (250), PRIMARY KEY(user_id) ); it's better to describe like this : CREATE TABLE user_preferences ( user_id INTEGER NOT NULL, preferences_key VARCHAR (100) NOT NULL, preferences_value VARCHAR (250), PRIMARY KEY(user_id,preferences_key) ); else we can't save user preference because there is an "ERROR 1062: Duplicate entry '2' for key 1" in this table

2 1

Closed messages
by Markus Linden 30 May '02

30 May '02

Hello I was just wondering if there is a simple way of browsing the closed tickets?? Do they get moved to some special queue? It would be handy if there was a queue which just had closed ticked so you could easily find them. The only way I found was to search for them. By the way this is an excellent piece of software, keep up the good work. Markus Linden

2 1

Locked Messages
by Christoph Kaulich 29 May '02

29 May '02

Hallo, kann mir bitte jemand in kurzen Worten erklären, was das 'Locken' der Tickets bedeutet? Danke Christoph

4 5

installing with a postgresql backend
by Eddie Urenda 29 May '02

29 May '02

Is the only thing needed to use OpenTRS with a Postgresql backend a successful translation of OpenTRS-schema.mysql.sql ? In other words, are there any functions/schemas or other definitions that are MySQL dependent? If not, is anyone using the currrent otrs-0.5-BETA5.tar.gz (which is tar'ed but apparently not gzipped) with Postgresql? -Eddie

2 1

Problem with installing and using OpenTRS
by Erdal MUTLU 26 Apr '02

26 Apr '02

Hello, I am trying to install and configure OpenTRS on SuSE 7.3 from source. Now I am at a stage where I cannot login to the system using Login: root@localhost and password. I don't know where otrs looks for passords MySQL's users table or otrs' user. Ia have this message on the /var/log/messages file: OpenTRS[4427]: [Notice][Kernel::System::Auth] User: root@localhost with wrong Pw!!! If otrs is using otrs' user table, how can I change the passowrd? I have tryed UPDATE user SET pw=PASSWORD('otrs') where login='root@localhost'; and UPDATE user SET pw=';trs' where login='root@localhost'; but without success. Best regards. Erdal Mutlu

2 1

SecureMode in Config.pm
by Oliver Schwarz 18 Apr '02

18 Apr '02

Ahoi... bei der Installation via installer.pl erhalte ich folgende Fehler- meldung: Error: SecureMode activ! Kommentar: If you want to run the Installler, disable SecureMode in Config.pm! Handle: Modulefile: /opt/OpenTRS/bin/cgi-bin/installer.pl Module: main (v 1.1) Subfunction: Line: 74 Leider bin ich des perls nicht mächtig... und bin mir daher unschlüssig welche Variable(n) in der Config.pm geändert werden müssen. Habt Dank für Eure Antwort... mit schönen Grüßen Ciao, Oliver ----------------------------------------------------- SuSE Linux AG, SAP Competence Center, Oliver Schwarz Deutschherrnstraße 15-19 Fon: +49-911-74053288 90429 Nürnberg, Germany Mobil: 0179-2327682 E-Mail: os(a)suse.de http://www.suse.de ----------------------------------------------------- http://www.trussel.com/kir/naudel.htm 1296. love n. eauwà, eauwauwà Liebe f. 1297. love v. auwà, ebon lieben v.a.

2 1