Re: [otrs] otrs speed consideration

2014-05-13 Thread Mimiko
On 13.05.2014 17:30, Bogdan Iosif wrote: You need to install a private MySQL instance for OTRS, on the same machine where the rest of OTRS components are installed (server 2: otrs, apache+modperl). I'm quite sure this will solve your performance problems. I did some test on this:

Re: [otrs] SSO

2014-05-13 Thread Gerald Young
As I mentioned, I haven't set up OTRS with RADIUS. I will only be able to tell you what I know about Network Policy Server. Any other RADIUS server implementations ... I don't know how to answer the question. The way I work NPS: In the Client section, I create an arbitrary friendly name. Remember

Re: [otrs] SSO

2014-05-13 Thread Darshak Modi(darshak.modi)
HI Gerald, Sorry I jumped to this topic. I would be interested to use RADIUS for such purpose. I tried earlier but not sure how / which field windows AD uses for password with radius. I guess we need to make logical mapping of password field.

Re: [otrs] SSO

2014-05-13 Thread Gerald Young
Hi, David, Since I'm constantly securing Cisco VPN's via RADIUS with Windows Network Policy Server, I have a recipe that works quite well for that purpose, making the VPN logins follow desktop passwords and using AD group membership to address allowed VPN users. I don't mind providing such inform

Re: [otrs] SSO

2014-05-13 Thread Gerald Young
Yes, I've made SSO with LDAP/AD work, and when it does, it's so cool. It's a REAL pain (to me) to get it to work properly. http://forums.otterhub.org/viewtopic.php?t=15422&p=59264#p77684 Note that you'll desire (likely) to use SSL in conjunction. >I notice the link you provided uses RADIUS for a

Re: [otrs] SSO

2014-05-13 Thread David Boyes
I notice the link you provided uses RADIUS for authentication instead of the others I pointed to that use Kerberos. Would you say that this is a simpler and more supported way of handling the SSO issue? I’m not Gerald, but I’ll speak up: No, unless you have another REALLY compelling reason to

Re: [otrs] SSO

2014-05-13 Thread Marty Hillman
Thanks Gerald. I know you do always come through with help. :) I notice the link you provided uses RADIUS for authentication instead of the others I pointed to that use Kerberos. Would you say that this is a simpler and more supported way of handling the SSO issue? I have LDAP integration wi

Re: [otrs] SSO

2014-05-13 Thread Gerald Young
> I find a simple "yes" to be such a helpful response. *sarcasm off* See, :) And look what happened. The post had been sitting for a week, I say "Yes" and then everyone pipes in... First, the question was answered because the question could only be answered with a Yes or No. Second, nobody here

Re: [otrs] otrs speed consideration

2014-05-13 Thread Bogdan Iosif
There's your problem right there. MySQL performs badly. I'm getting max 3s for these operations where you get ~7-8s and that's in a VM, on Windows. You need to install a private MySQL instance for OTRS, on the same machine where the rest of OTRS components are installed (server 2: otrs, apache+mod

Re: [otrs] SSO

2014-05-13 Thread Marty Hillman
I find a simple "yes" to be such a helpful response. *sarcasm off* I have been looking for the same solution for some time and have run across a few articles which provide some hints at how to get this done. http://osdir.com/ml/otrs.devel/2008-06/msg5.html - indicates that this is a combi

Re: [otrs] otrs speed consideration

2014-05-13 Thread Mimiko
SQL Benchmar results: Result: SQL KEY VALUE TIMECOMMENT Insert Time: 1 8 s :-( Should not take more than 5's on an average system. Update Time:17 s Ok Select Time: 1 7 s :-( Should not take more than 6's on an average system. Delete Time:14 s

Re: [otrs] otrs speed consideration

2014-05-13 Thread Bogdan Iosif
There's a package named Support that you should install from Package Manager. After it's installed you'll have a new link in the ADMIN page, named Support Assessment. Follow the link to a page presenting a report about the environment OTRS is running on. The report may load VERY slowly and return t

Re: [otrs] otrs speed consideration

2014-05-13 Thread Mimiko
On 13.05.2014 16:05, Bogdan Iosif wrote: I also noticed on my systems that opening SysConfig, and especially opening Package Manager, is an operation that is much slower than most others. Especially when submitting changes. The Support Package has a builtin benchmarking tool for the database

Re: [otrs] otrs speed consideration

2014-05-13 Thread Bogdan Iosif
I missed the point about you having this issue on a physical machine. I also noticed on my systems that opening SysConfig, and especially opening Package Manager, is an operation that is much slower than most others. The Support Package has a builtin benchmarking tool for the database. Did you ru

[otrs] Double follow up notifications because Agent is in CC of Auto follow up

2014-05-13 Thread Erik van Ast
Hi everyone, We have been using OTRS many years ago on an OpenSUSE system, but we have it installed on a Windows Server now. I created a new database, so everything is new without any imported history. Everything seems to work fine, but I have 1 annoying problem. When an agent replies to a noti

Re: [otrs] otrs speed consideration

2014-05-13 Thread Mimiko
I did say that I don't run otrs in VM. Its a dedicated physical server on Debian Wheezy x86-64 4 logical CPU 5GB RAM. Its Xeon 2.8GHz 5 years old. And only apache and otrs is on this server. I did read the chapter 6. There are no more than 100 tickets now and no more than 200 articles. Also, I

Re: [otrs] otrs speed consideration

2014-05-13 Thread Bogdan Iosif
There's probably a bottleneck in your config. Either at the hypervisor level or inside the VM. On my instance, I have 150 tickets/day, up to ~40 agents and up to ~140 customers simultaneously connected. I'm running Apache 32-bit/MySQL 32-bit/Strawberry Perl 32-bit/Windows 2008 R2 64-bit in a VM wi

[otrs] Create custom reports from the OTRS database for Support

2014-05-13 Thread Neeraj Kumar
This will entail a webpage allowing Support to do custom reports from the OTRS MySQL database. The first report they will need is one that give the following information. Sub ID Co ID Login User full name Owner of the ticket Ticket type Ticket subject Full body of email ticket and the correspon

Re: [otrs] otrs speed consideration

2014-05-13 Thread Mimiko
On 13.05.2014 11:56, Bogdan Iosif wrote: Hi Mimiko. Did you manage to solve the performance issue? Hello. Somehow. I did what mhillman sugested - ran shell> bin/otrs.RebuildConfig.pl shell> bin/otrs.DeleteCache.pl but in long terms, still it is visible slow for agents. Dashboard generation on

Re: [otrs] otrs speed consideration

2014-05-13 Thread Bogdan Iosif
Hi Mimiko. Did you manage to solve the performance issue? On Tue, Apr 1, 2014 at 9:19 AM, Mimiko wrote: > On 01.04.2014 09:07, Sander Goudswaard wrote: > >> Are you using mod_perl or perl via cgi? The latter tends to be slower. >> > > I am using mod_perl. I installed following guide on installat