[otrs] OTRS installation on IIS?
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?
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?
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!
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
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!
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!
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?
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
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?
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!
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