Search found 9 matches

by WarrenB
03 Nov 2013, 21:46
Forum: General
Topic: Automatic rejection if cc'd
Replies: 4
Views: 1284

Re: Automatic rejection if cc'd

I am using this as the regular expression to check the TO field:
(?!helpdeskaddress@mydomain)|(.*@.*@)

Any ideas on how to make this case-insensitive (I'm not sure what Perl accepts as flags)?
by WarrenB
03 Nov 2013, 21:36
Forum: General
Topic: Automatic rejection if cc'd
Replies: 4
Views: 1284

Re: Automatic rejection if cc'd

Thanks for the info - I will look into that during the week. In terms of the response I presume it will use "PostMaster::PreFilterModule::NewTicketReject::Body" etc for the message that goes back to the sender? I have also found that some customers are including other people in the TO field (which c...
by WarrenB
01 Nov 2013, 14:05
Forum: General
Topic: Automatic rejection if cc'd
Replies: 4
Views: 1284

Automatic rejection if cc'd

We have a number of customers that are cc'ing our helpdesk address in their emails. They often cc other people as well and we end up with tons of new tickets created if they reply to the original email. I would like a way to: 1. Reject any emails that are cc'd (or bcc'd) to our helpdesk address. 2. ...
by WarrenB
11 Feb 2013, 20:16
Forum: Howtos
Topic: OTRS on IIS 7.5 + SQL 2008 (solution to performance issues)
Replies: 10
Views: 23047

Re: OTRS on IIS 7.5 + SQL 2008 (solution to performance issu

I gave up on getting this to work and eventually spent a few hours migrating from MSSQL to MySQL (and all the headache involved with it). It was well worth the effort; Things that used to take around 10 sec are now a few ms. My current setup is IIS7.5 + PerlEx + MySQL... and performance is excellent!
by WarrenB
03 Feb 2013, 18:48
Forum: Howtos
Topic: OTRS on IIS 7.5 + SQL 2008 (solution to performance issues)
Replies: 10
Views: 23047

Re: OTRS on IIS 7.5 + SQL 2008 (solution to performance issu

I typed too soon - I cannot reply to tickets now - get database errors.
I have reverted to the ODBC DSN for now. :(
by WarrenB
03 Feb 2013, 17:50
Forum: Howtos
Topic: OTRS on IIS 7.5 + SQL 2008 (solution to performance issues)
Replies: 10
Views: 23047

Re: OTRS on IIS 7.5 + SQL 2008 (solution to performance issu

Thanks for the this info - But that example DSN would be to connect to an Access database. This is my connection DSN (SQL running on port 1433): $Self->{'DatabaseDSN'} = "DBI:ADO:Provider=sqloledb;driver={SQL Server Native Client 10.0};Server=$Self->{DatabaseHost},1433;database=$Self->{Database};"; ...
by WarrenB
02 Feb 2013, 23:58
Forum: Howtos
Topic: OTRS on IIS 7.5 + SQL 2008 (solution to performance issues)
Replies: 10
Views: 23047

Re: OTRS on IIS 7.5 + SQL 2008 (solution to performance issu

Looks like DBI:ADO has some issues with some characters.
We have some tickets that cannot load (customer names contain é).

If we change back to DBI:ODBC then the tickets load.

Does anyone have a suggestion of how to fix?
by WarrenB
02 Feb 2013, 23:53
Forum: Howtos
Topic: OTRS on IIS 7.5 + SQL 2008 (solution to performance issues)
Replies: 10
Views: 23047

Re: OTRS on IIS 7.5 + SQL 2008 (solution to performance issu

Ok - Looks like ADO does not work well with unicode strings. We have some tickets that include these that don't load anymore. :( One was sent by a customer with the chacter é in their name. If I change the DSN back to use DBI:ODBC then it works (but is slow again). Does anyone have any thoughts on h...
by WarrenB
02 Feb 2013, 21:57
Forum: Howtos
Topic: OTRS on IIS 7.5 + SQL 2008 (solution to performance issues)
Replies: 10
Views: 23047

OTRS on IIS 7.5 + SQL 2008 (solution to performance issues)

We rolled out OTRS at our office in November 2012; and as a MS based company we decided to go the IIS + MS-SQL route. Unfortunately performance was dismal... Clicking on anything took around 10 seconds to load. We are running multiple OTRS instances on the same IIS instance (to different MS-SQL data...