Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Update Ticket Takes...
 
Notifications
Clear all

Update Ticket Takes over 10 seconds in 4.2.1

7 Posts
2 Users
0 Reactions
11.3 K Views
Mark Docken
(@mdocken)
Posts: 18
Active Member
Topic starter
 
[#1690]

Since I upgraded to 4.2.1 saving modified tickets sometimes takes up to 10 seconds. On 4.1.2 it never took more than 2 seconds. Saving Activities and Projects also slower on 4.2.1 (up to 5 seconds).


 
Posted : 14 Mar 2014 16H52
Mark Docken
(@mdocken)
Posts: 18
Active Member
Topic starter
 

It doesn't happen all the time and it possible it's only happening for tickets that were created or existed before the update. I will test this theory.


 
Posted : 14 Mar 2014 19H56
(@babynus)
Posts: 14952
Member Admin
 

I cannot reproduce.
Ticket saving is always fluent for me on V4.2.1.

Did you configure checklists ?
Does it happen when application sends email ?
Do you have any specific error in the log file ?

You can also try to trace queries to database : in parameters.php, add line :

$debugQuery=true;

 
Posted : 14 Mar 2014 21H22
Mark Docken
(@mdocken)
Posts: 18
Active Member
Topic starter
 

Creating a ticket for myself to troubleshoot SQL....will start as soon as the ticket finished saving ..... :silly: B)


 
Posted : 17 Mar 2014 14H17
(@babynus)
Posts: 14952
Member Admin
 

? :blink:


 
Posted : 17 Mar 2014 14H32
Mark Docken
(@mdocken)
Posts: 18
Active Member
Topic starter
 

'twas email. I was using port 465 and I guess something changed in 4.2.1 for SSL. I switched to port 25 since all mail chatter is local and I don't need SSL anyways.
So, that's a permanent workaround for me.

Projeqtor log:

2014-03-17 07:48:42 ----- DEBUG ----- 5.8E-5;select * from mailable where mailable.name='Mail'
2014-03-17 07:48:52 ** ERROR ** Error sending mail
2014-03-17 07:48:52 ** ERROR ** SMTP Server : localhost
2014-03-17 07:48:52 ** ERROR ** SMTP Port : 465
2014-03-17 07:48:52 ** ERROR ** Mail stored in Database : #663
2014-03-17 07:48:52 ** ERROR ** PHPMail error : SMTP connect() failed.
2014-03-17 07:48:52 ** ERROR ** PHPMail debug :

Postfix was throwing this error:

Mar 17 07:59:46 firewood postfix/smtpd[19564]: SSL_accept error from localhost.localdomain[127.0.0.1]: -1
Mar 17 07:59:46 firewood postfix/smtpd[19564]: warning: TLS library problem: 19564:error:140760FC:SSL routines:SSL23_GET_CLIENT_HELLO:unknown protocol:s23_srvr.c:584:

My certs are all good and I can connect with openssl s_client -connect localhost:465. Other clients can send (i.e. Thunderbird) on port 465 without a problem so not sure why projeqtor decided to leave the party.


 
Posted : 17 Mar 2014 15H23
(@babynus)
Posts: 14952
Member Admin
 

Hi,

There was some fix on V4.2.1 to force default mailer as PhhMailer (the most common mailing php liibrary).
I gues there is some issue using phpMailer in your case.

For information, you can retrieve previous behavior, just setting in parameters.php :

$paramMailerType='mail';

or for ssl

$paramMailerType='socket';

(this has an entrey in the user manual, just look for 'email')

I recorded ticket #1334 to have a look at possible phpMailer misconfiguration.


 
Posted : 17 Mar 2014 15H50
Share:

Scroll to Top