[otrs] OTRS installation on IIS?

2008-11-09 Thread Jie(Jack) Zhu
Hi Guys,

 

We have IIS server and running some other stuffs, it's impossible to us to
have another server which just running Apache.

I tried manually installing the OTRS on IIS server. I can install it with
install.pl and everything seemed ok no error reported. 

But I just can't run it. Always get errors tell me module loading problem.

 

Does any one have the experience to implement OTRS on IIS? How to get it
work? 

 

Thanks a lot!

 

Jack

___
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

Re: [otrs] Associating a group with a CustomerID?

2008-11-09 Thread Paul Dale
I was able to put it in an external perl program which I can call in a
preprocessor before the mail goes into Otrs.


if ( my %Uid = $CommonObject{CustomerUserObject}-CustomerSearch(
PostMasterSearch  = $Param{CustomerUserEmail} ) ) {

my @uids = keys %Uid;
my $user_login = pop(@uids);
my @CustomerIDs = $CommonObject{CustomerUserObject}-CustomerIDs(
 User = $user_login
);
my $CustomerID = pop( @CustomerIDs )
   # Add mail header X-OTRS-CustomerNo: $CustomerID
}


2008/11/9 Jie(Jack) Zhu [EMAIL PROTECTED]:
 I don't think there is such function.

 But it is a nice idea though.

 -Original Message-
 From: Paul Dale [mailto:[EMAIL PROTECTED]
 Sent: 2008年11月9日 13:03 PM
 To: otrs@otrs.org
 Subject: [otrs] Associating a group with a CustomerID?

 Is it possible to have anyone with a given CustomerID automatically
 added to a group or queue?

 Thanks,

 Paul


 ___
 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
___
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

Re: [otrs] Associating a group with a CustomerID?

2008-11-09 Thread Paul Dale
Just to finish this thread in case it's useful for anyone else.

I used formail -t -xFrom: to extract the from header, then looked that
up using the command below,
then used formail -A  X-OTRS-CustomerNo: %s to set the header before
passing it to PostMaster.pl

...paul

2008/11/9 Paul Dale [EMAIL PROTECTED]:
 I was able to put it in an external perl program which I can call in a
 preprocessor before the mail goes into Otrs.


 if ( my %Uid = $CommonObject{CustomerUserObject}-CustomerSearch(
 PostMasterSearch  = $Param{CustomerUserEmail} ) ) {

my @uids = keys %Uid;
my $user_login = pop(@uids);
my @CustomerIDs = $CommonObject{CustomerUserObject}-CustomerIDs(
 User = $user_login
);
my $CustomerID = pop( @CustomerIDs )
   # Add mail header X-OTRS-CustomerNo: $CustomerID
 }


 2008/11/9 Jie(Jack) Zhu [EMAIL PROTECTED]:
 I don't think there is such function.

 But it is a nice idea though.

 -Original Message-
 From: Paul Dale [mailto:[EMAIL PROTECTED]
 Sent: 2008年11月9日 13:03 PM
 To: otrs@otrs.org
 Subject: [otrs] Associating a group with a CustomerID?

 Is it possible to have anyone with a given CustomerID automatically
 added to a group or queue?

 Thanks,

 Paul


 ___
 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

___
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

Re: [otrs] How to access the MySQL!

2008-11-09 Thread Jie(Jack) Zhu
Thanks Paul,

I've tried. It only works locally. And the root password is empty. It seems
I have to make some setup on MySQL so I can access it remotely.

I installed SQL Manager Lite on the localhost, and then setup a root account
with % (Global) access. Now I can access it remotely.

Jack

-Original Message-
From: Paul Dale [mailto:[EMAIL PROTECTED] 
Sent: 2008年11月9日 14:05 PM
To: [EMAIL PROTECTED]
Subject: Re: [otrs] How to access the MySQL!

It's possible that you have to access it locally. It depends on how
the user is set up (I'm not sure how otrs sets it up by default),
mysql does have the ability to allow local and not remote.

root with empty password is probably also only @ localhost, but I'm
not sure about that either.

paul

2008/11/9 Jie(Jack) Zhu [EMAIL PROTECTED]:
 Thanks for your prompt answer Paul,

 I have phpmyadmin installed on another server. I tried to access OTRS's
 MySQL through it. I used empty password for root, and also tried user
otrs.
 Both of them don't work. Do I have to access the database locally?

 -Original Message-
 From: Paul Dale [mailto:[EMAIL PROTECTED]
 Sent: 2008年11月9日 13:37 PM
 To: [EMAIL PROTECTED]; User questions and discussions about OTRS.
 Subject: Re: [otrs] How to access the MySQL!

 I believe the default mysql root password is empty.

 To access the database login to mysql and type use otrs; to switch to
 the otrs DB.

 2008/11/9 Jie(Jack) Zhu [EMAIL PROTECTED]:
 Hi there,



 I installed the OTRS win32 package. It created everything automatically
 including the MySQL.



 The server is working fine. However, I am just wondering how can I access
 MySQL database?



 What is the default password for root?



 Thanks for your help!



 Jack

 ___
 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




___
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

Re: [otrs] Fwd: problem installing packages

2008-11-09 Thread Michiel Beijen
Johan,

The FAQ you are refering to is for MySQL, not for MS-SQL. Other than
that, it lists TWO possible issues.
Can you specify what the exact issue is you are experiencing? Error
message, maybe a screen shot?

Regards,
-- 
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl

2008/11/10 Johan Bogema [EMAIL PROTECTED]:
 Does anybody have any idea?

 From: Johan Bogema [EMAIL PROTECTED]
 Date: 7 november 2008 10:58:39 GMT+01:00
 To: otrs@otrs.org
 Subject: problem installing packages
 Hi all,

 We've just set up an installation of OTRS using an MSSQL server. This due to
 the fact that we want to have just one database engine in our company.
 However, when I try to install an extra package (fe. the FAQ package) it
 gives the same error as explained in the FAQ item here:
 http://faq.otrs.org/otrs/public.pl?Action=PublicFAQCategoryID=4ItemID=50

 The problem I have, is that I can't use that hint to configure my MSSQL
 server. Does anyone know how to overcome this problem using MSSQL server?

 Regards,

 Johan Bogema


 ___
 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

___
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


Re: [otrs] How to access the MySQL!

2008-11-09 Thread Jie(Jack) Zhu
Thanks for your prompt answer Paul,

I have phpmyadmin installed on another server. I tried to access OTRS's
MySQL through it. I used empty password for root, and also tried user otrs.
Both of them don't work. Do I have to access the database locally?

-Original Message-
From: Paul Dale [mailto:[EMAIL PROTECTED] 
Sent: 2008年11月9日 13:37 PM
To: [EMAIL PROTECTED]; User questions and discussions about OTRS.
Subject: Re: [otrs] How to access the MySQL!

I believe the default mysql root password is empty.

To access the database login to mysql and type use otrs; to switch to
the otrs DB.

2008/11/9 Jie(Jack) Zhu [EMAIL PROTECTED]:
 Hi there,



 I installed the OTRS win32 package. It created everything automatically
 including the MySQL.



 The server is working fine. However, I am just wondering how can I access
 MySQL database?



 What is the default password for root?



 Thanks for your help!



 Jack

 ___
 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


___
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

Re: [otrs] How to access the MySQL!

2008-11-09 Thread Paul Dale
I believe the default mysql root password is empty.

To access the database login to mysql and type use otrs; to switch to
the otrs DB.

2008/11/9 Jie(Jack) Zhu [EMAIL PROTECTED]:
 Hi there,



 I installed the OTRS win32 package. It created everything automatically
 including the MySQL.



 The server is working fine. However, I am just wondering how can I access
 MySQL database?



 What is the default password for root?



 Thanks for your help!



 Jack

 ___
 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

___
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


[otrs] Related tickets?

2008-11-09 Thread Paul Dale
I could swear that there was a way to have linked tickets in OTRS, but
I'm not finding it at the moment.

Is there one, or am I just mixing it up with something else ...?

Also, when one is using the customer front end. Is there a way to make
it so that a customer sees all tickets that have their customer id on
them, whichever queue they are in?

The problem I am having is that if a ticket comes into the customer
queue and I reassign it to another group then the customer can't see
it any more.

thanks :)

paul
___
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


[otrs] [OTRS] To: field in responses is empty

2008-11-09 Thread Gordon
Hi,

We are having a problem with our OTRS installation. When responding to a
ticket the To: field appears empty. Although in the original ticket its
fine.

Whats interesting is that if you split the ticket the To: field populates
fine. Ive done a lot of searching through the archives and cant find
anything like this. We are running 2.3.3 and Exchange. Ive also had a look
in the DB and the article seems to have the correct a_from and a_to
addresses. Its almost like the reply just isn't picking these up. Same also
happens for CC fields (not as important).

Any tips or suggestions would be more than welcome. Thanks in advance...

Gordon
___
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

Re: [otrs] Associating a group with a CustomerID?

2008-11-09 Thread Jie(Jack) Zhu
I don't think there is such function. 

But it is a nice idea though. 

-Original Message-
From: Paul Dale [mailto:[EMAIL PROTECTED] 
Sent: 2008年11月9日 13:03 PM
To: otrs@otrs.org
Subject: [otrs] Associating a group with a CustomerID?

Is it possible to have anyone with a given CustomerID automatically
added to a group or queue?

Thanks,

Paul


___
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

[otrs] How to access the MySQL!

2008-11-09 Thread Jie(Jack) Zhu
Hi there,

 

I installed the OTRS win32 package. It created everything automatically
including the MySQL.

 

The server is working fine. However, I am just wondering how can I access
MySQL database?

 

What is the default password for root? 

 

Thanks for your help!

 

Jack

___
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