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:/

[otrs] Fwd: problem installing packages

2008-11-09 Thread Johan Bogema
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 datab

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

[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

[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 c

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 <[EMAI

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(@u

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 aut

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 [ma

[otrs] More questions about CustomerID/Company

2008-11-09 Thread Paul Dale
It seems CustomerID and Company don't work the way I would think they would. I expected to be able to assign a customer_user a CustomerID and then the Company that I created with that CustomerID would show up when I receive an email from them. However when I get an email from the email address I

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

[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] Associating a group with a CustomerID?

2008-11-09 Thread Paul Dale
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-b

[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