Re: [otrs] Can't go after Login

2015-02-25 Thread aledr 
Just to point that It seemed to be a rare condition caused by the daylight
saving change.
Last sunday clock went backward one hour and after that SLA.pm was never
finishing to process the tickets.

Here is what we have done to solve this:
1 - Change all "open" tickets to "new":

UPDATE ticket SET ticket_state_id = 1 WHERE ticket_state_id = 4

2 - Reset times on them:

UPDATE ticket SET escalation_time = 0, escalation_update_time = 0,
escalation_solution_time = 0, escalation_response_time = 0, timeout = 0
WHERE ticket_state_id = 1

3 - Unlock.

UPDATE ticket SET ticket_lock_id = 1 WHERE ticket_state_id = 1 AND
ticket_lock_id = 2

Problem solved and OTRS updated to 4.0.6.

(If some developer wants do debug it I can send a backup with this
behaviour.)

Thanks.

On Tue, Feb 24, 2015 at 5:11 PM, aledr  wrote:

> Hi!
>
> We just found that the problem is at Kernel/System/SLA.pm line 275.
> It stuck at this query on the database:
>
> "SELECT service_id FROM service_sla WHERE sla_id = $1 ORDER BY service_id
> ASC'
>
> I expected to see a value in place of "$1".
> Any hint from here?
>
> Thanks.
>
> On Tue, Feb 24, 2015 at 1:52 AM, aledr 
> wrote:
>
>> Seems that otrs.GenericAgent.pl have a problem too.
>> It keeps running after showing:
>>
>> Job: 'send escalation notifications'
>>   - Use module
>> (Kernel::System::GenericAgent::NotifyAgentGroupOfCustomQueue) for Ticket
>> (...)
>>
>> Thanks.
>>
>> On Mon, Feb 23, 2015 at 10:09 PM, aledr 
>> wrote:
>>
>>> Hi Carlos!
>>>
>>> It is 4.0.3 and I can reach https://cloud.otrs.com from it.
>>> I can open "index.pl?Action=Admin " but
>>> not "index.pl?Action=AgentDashboard
>>> " or "
>>> index.pl?Action=AgentTicketResponsibleView
>>> " as example.
>>>
>>> Thanks.
>>>
>>> On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez <
>>> carlos.rodrig...@otrs.com> wrote:
>>>
 Hi Aledr,

 If you are using OTRS 4, please make sure you can reach
 https://cloud.otrs.com from your OTRS box.

 ((enjoy))

 Carlos Rodríguez




 On Feb 23, 2015, at 1:28 PM, aledr  wrote:

 Hi there!

 Suddenly I'm not able to go after login on index.pl, but customer.pl
 still works normally.
 No message on logs, no error, nothing... It just keeps "loading".

 How can I debug this?

 Thanks.
 --
 [ ]'s
 Aledr - Alexandre


-- 
[ ]'s
Aledr - Alexandre
-
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] Can't go after Login

2015-02-24 Thread aledr 
Hi!

We just found that the problem is at Kernel/System/SLA.pm line 275.
It stuck at this query on the database:

"SELECT service_id FROM service_sla WHERE sla_id = $1 ORDER BY service_id
ASC'

I expected to see a value in place of "$1".
Any hint from here?

Thanks.

On Tue, Feb 24, 2015 at 1:52 AM, aledr  wrote:

> Seems that otrs.GenericAgent.pl have a problem too.
> It keeps running after showing:
>
> Job: 'send escalation notifications'
>   - Use module
> (Kernel::System::GenericAgent::NotifyAgentGroupOfCustomQueue) for Ticket
> (...)
>
> Thanks.
>
> On Mon, Feb 23, 2015 at 10:09 PM, aledr 
> wrote:
>
>> Hi Carlos!
>>
>> It is 4.0.3 and I can reach https://cloud.otrs.com from it.
>> I can open "index.pl?Action=Admin " but
>> not "index.pl?Action=AgentDashboard
>> " or "
>> index.pl?Action=AgentTicketResponsibleView
>> " as example.
>>
>> Thanks.
>>
>> On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez <
>> carlos.rodrig...@otrs.com> wrote:
>>
>>> Hi Aledr,
>>>
>>> If you are using OTRS 4, please make sure you can reach
>>> https://cloud.otrs.com from your OTRS box.
>>>
>>> ((enjoy))
>>>
>>> Carlos Rodríguez
>>>
>>>
>>>
>>>
>>> On Feb 23, 2015, at 1:28 PM, aledr  wrote:
>>>
>>> Hi there!
>>>
>>> Suddenly I'm not able to go after login on index.pl, but customer.pl
>>> still works normally.
>>> No message on logs, no error, nothing... It just keeps "loading".
>>>
>>> How can I debug this?
>>>
>>> Thanks.
>>> --
>>> [ ]'s
>>> Aledr - Alexandre
>>>
>>>  -
>>> 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
>>>
>>
>>
>>
>> --
>> [ ]'s
>> Aledr - Alexandre
>>
>>
>
>
> --
> [ ]'s
> Aledr - Alexandre
>
-
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] Can't go after Login

2015-02-23 Thread aledr 
Seems that otrs.GenericAgent.pl have a problem too.
It keeps running after showing:

Job: 'send escalation notifications'
  - Use module
(Kernel::System::GenericAgent::NotifyAgentGroupOfCustomQueue) for Ticket
(...)

Thanks.

On Mon, Feb 23, 2015 at 10:09 PM, aledr  wrote:

> Hi Carlos!
>
> It is 4.0.3 and I can reach https://cloud.otrs.com from it.
> I can open "index.pl?Action=Admin " but
> not "index.pl?Action=AgentDashboard
> " or "
> index.pl?Action=AgentTicketResponsibleView
> " as example.
>
> Thanks.
>
> On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez <
> carlos.rodrig...@otrs.com> wrote:
>
>> Hi Aledr,
>>
>> If you are using OTRS 4, please make sure you can reach
>> https://cloud.otrs.com from your OTRS box.
>>
>> ((enjoy))
>>
>> Carlos Rodríguez
>>
>>
>>
>>
>> On Feb 23, 2015, at 1:28 PM, aledr  wrote:
>>
>> Hi there!
>>
>> Suddenly I'm not able to go after login on index.pl, but customer.pl
>> still works normally.
>> No message on logs, no error, nothing... It just keeps "loading".
>>
>> How can I debug this?
>>
>> Thanks.
>> --
>> [ ]'s
>> Aledr - Alexandre
>>
>>  -
>> 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
>>
>
>
>
> --
> [ ]'s
> Aledr - Alexandre
>
>


-- 
[ ]'s
Aledr - Alexandre
Gerente de T.I. - Equipe Exata T.I.
44 3029-6416
44 9116-3154 (TIM)
www.exatati.com.br
-
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] Can't go after Login

2015-02-23 Thread aledr 
Hi Carlos!

It is 4.0.3 and I can reach https://cloud.otrs.com from it.
I can open "index.pl?Action=Admin " but not "
index.pl?Action=AgentDashboard " or
"index.pl?Action=AgentTicketResponsibleView
" as example.

Thanks.

On Mon, Feb 23, 2015 at 9:55 PM, Carlos Rodríguez  wrote:

> Hi Aledr,
>
> If you are using OTRS 4, please make sure you can reach
> https://cloud.otrs.com from your OTRS box.
>
> ((enjoy))
>
> Carlos Rodríguez
>
>
>
>
> On Feb 23, 2015, at 1:28 PM, aledr  wrote:
>
> Hi there!
>
> Suddenly I'm not able to go after login on index.pl, but customer.pl
> still works normally.
> No message on logs, no error, nothing... It just keeps "loading".
>
> How can I debug this?
>
> Thanks.
> --
> [ ]'s
> Aledr - Alexandre
>
>  -
> 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
>



-- 
[ ]'s
Aledr - Alexandre
-
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] Can't go after Login

2015-02-23 Thread Carlos Rodríguez 
Hi Aledr,

If you are using OTRS 4, please make sure you can reach https://cloud.otrs.com 
 from your OTRS box.

((enjoy))

Carlos Rodríguez




> On Feb 23, 2015, at 1:28 PM, aledr  wrote:
> 
> Hi there!
> 
> Suddenly I'm not able to go after login on index.pl , but 
> customer.pl  still works normally.
> No message on logs, no error, nothing... It just keeps "loading".
> 
> How can I debug this?
> 
> Thanks.
> --
> [ ]'s
> Aledr - Alexandre
> 
> -
> 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



signature.asc
Description: Message signed with OpenPGP using GPGMail
-
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] Can't go after Login

2015-02-23 Thread Leonardo Certuche 
Hello,

With any browser?
Try with Firefox installing firebug and seeing its error console



On 23 February 2015 at 14:28, aledr  wrote:

> Hi there!
>
> Suddenly I'm not able to go after login on index.pl, but customer.pl
> still works normally.
> No message on logs, no error, nothing... It just keeps "loading".
>
> How can I debug this?
>
> Thanks.
> --
> [ ]'s
> Aledr - Alexandre
>
>
> -
> 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