Search found 8 matches

by jalvarado
06 Apr 2013, 05:24
Forum: General
Topic: Error configuración SMPT
Replies: 1
Views: 2034

Re: Error configuración SMPT

¿La modificación fue realizada directamente al archivo ZZZAuto.pm o a través del menú Admin->SysConfig?

Sugiero que lo haga por allí y pruebe de nuevo .
by jalvarado
03 Apr 2013, 02:13
Forum: General
Topic: track time by ticket state
Replies: 25
Views: 51785

Re: track time by ticket state

I need to make calculations for old tickets, so the use of trigger is not an option in my case. I created an stored procedure that uses new tables. These tables must have the data for calendars, any changes in OTRS calendars configurations must be replicated to these tables (this is a tedious duty)....
by jalvarado
08 Mar 2013, 20:32
Forum: General
Topic: Work time
Replies: 1
Views: 981

Re: Work time

Hello:

Please see viewtopic.php?f=53&t=14242
by jalvarado
08 Mar 2013, 02:37
Forum: General
Topic: track time by ticket state
Replies: 25
Views: 51785

Re: track time by ticket state

Hello: I have been doing some queries with the following logic: 1. Create tables to store calendars and working hour per calendar 2. Populate data into these tables with the same configuration of calendar and working hours in OTRS files 3. Calculate starting and ending dates for each state for each ...
by jalvarado
20 Feb 2013, 21:16
Forum: General
Topic: track time by ticket state
Replies: 25
Views: 51785

Re: track time by ticket state

Hello, How can I use your query in order to calculate the duration of each ticket state but in working hours? Any idea to integrate your query with files with calendars´configuration? May be using static stats in OTRS (http://doc.otrs.org/3.1/en/html/stats-managing-the-stats-module-by-the-sysadmin.h...
by jalvarado
03 Oct 2012, 20:31
Forum: General
Topic: Email and SSL problems [SOLVED]
Replies: 2
Views: 1706

Re: Email and SSL problems

Thanks for the links,

I found two workarounds:
Downgrade perl package IO::Socket::SSL to version 1.68.
Use IMAPS instead of POP3S and SMTPS
by jalvarado
02 Oct 2012, 09:51
Forum: General
Topic: Email and SSL problems [SOLVED]
Replies: 2
Views: 1706

Email and SSL problems [SOLVED]

Hello, I installed OTRS 3.1.10 using differents servers for application and database. When I go to Admin-"PostMaster Mail Accounts" and select "Fetch mail" I got "Internal Server Error" from Apache and the log of Apache contains: [[Tue Oct 02 02:37:18 2012] [error] [cli...