You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2017-10-11 14:57:41

trololo4ik
Member
Registered: 2017-10-11
Posts: 3

Automatic action - queuednotification

Hello.
For earlier apologize for my English
After upgrading to version 9.2 found a problem with sending email notifications (queuednotification).
Some notifications are sent immediately but some are going in the "Notification queue". To send them to recipients, you must either manually send or execute the "queuednotification". Notification in the "Notification queue" can wait 10-20 minutes before sending, although the schedule is 1 time per minute.
What could be the problem?

Offline

#2 2017-10-11 15:06:43

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,288

Re: Automatic action - queuednotification

HI,
wich mode for queuednotification ? GLPI or CLI ?
CASE CLI mode : you have to set a cron tab/schduled task on your server that runs /glpi/front/cron.php periodically
CASE GLPI mode : action is triggered  by some actions  on glpi => if no actions ( overnight, week end, coffee time....) no mail is sent.


Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

Offline

#3 2017-10-11 15:39:59

trololo4ik
Member
Registered: 2017-10-11
Posts: 3

Re: Automatic action - queuednotification

Whether correctly I understand You?
In GLPI mode, required any user activity in the program if no one is active, messages are not sent?
In CLI mode, must configure the start /glpi/front/cron.php on Windows task scheduler, and then not important user activity in the program?

Offline

#4 2017-10-11 15:55:06

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,288

Re: Automatic action - queuednotification

you're right.
(any activity -> some specific activity would be exact)


Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

Offline

#5 2017-10-11 18:32:24

gmognon
Member
From: Brazil
Registered: 2017-09-29
Posts: 9

Re: Automatic action - queuednotification

Hello!
I have the same problem here after upgrading to version 9.2.
I'm using CLI mode and I have configured the Crontask correctly.

I had to rollback to version 9.1.6 where the notifications are fully functional.

Crontask command "php /var/www/virtual/glpi/front/cron.php --force queuedmail"

Last edited by gmognon (2017-10-11 18:33:51)

Offline

#6 2017-10-12 00:47:01

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 6,288

Re: Automatic action - queuednotification

in 9.2 "queuedmail" automatic action is renamed as "queuednotification".

I guess crontask command needs to be updated. (i did not test)


Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

Offline

#7 2017-10-12 09:52:13

trololo4ik
Member
Registered: 2017-10-11
Posts: 3

Re: Automatic action - queuednotification

LaDenrée wrote:

you're right.
(any activity -> some specific activity would be exact)

Thanks, I configured cron, notifications are sent.

Offline

#8 2017-10-12 11:34:33

grefabu
Member
Registered: 2017-09-22
Posts: 111

Re: Automatic action - queuednotification

Hi,

my notification go wired too.

On the 9.1.6 test system it works correct.
On the updateted 9.2 it work strange, I got no E-Mail.

I change the queuedmail from GLPI to cli and add an job every 60 sec. I see in the log for the job that it is executed, but without an action.
But I think there won't generated any mails from the ticket. How could I proof the creation?

In helpdesk I'm sure I on "emailfollowup yes".
in setup -> notification the specified notification is on active.

Offline

#9 2017-10-16 17:51:39

carlosbmc
Member
Registered: 2016-12-01
Posts: 161

Re: Automatic action - queuednotification

Me too..

after migration 9.1.1 to 9.2 GLPI  is not sending mails after ticket creation.   I have to run queuednotification manually

Any solution?

Last edited by carlosbmc (2017-10-16 17:52:23)


GLPI 9.5.2;; FusionInventory: 9.2+1.0;; GLPI Modifications 1.1.4;; Notifications 1.1.9;;  Dashboard 0.8.8;; PHP 7.3.33

Offline

#10 2017-10-16 18:12:20

machadomall
Member
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 208

Re: Automatic action - queuednotification

Hello good afternoon,
Check the following table;

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification

- I think maybe the update did not update the table.

It's just a check, whatever that is.


Márcio Machado
Brasília-DF / Brasil

Offline

#11 2017-10-16 22:00:54

carlosbmc
Member
Registered: 2016-12-01
Posts: 161

Re: Automatic action - queuednotification

Yes, its ok.  But doesn't work

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification

The automatic task never executes...     until manually.

Last edited by carlosbmc (2017-10-16 22:05:15)


GLPI 9.5.2;; FusionInventory: 9.2+1.0;; GLPI Modifications 1.1.4;; Notifications 1.1.9;;  Dashboard 0.8.8;; PHP 7.3.33

Offline

#12 2017-10-16 22:05:59

machadomall
Member
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 208

Re: Automatic action - queuednotification

Hello,
Can you view the logs? Dont show nothing?


Márcio Machado
Brasília-DF / Brasil

Offline

#13 2017-10-16 22:48:40

carlosbmc
Member
Registered: 2016-12-01
Posts: 161

Re: Automatic action - queuednotification

Working...

PHP version running cron PHP Script was 5.4.16  (not the needed version of php 5.6 for GLPI  9.2)

PHP Parse error: syntax error, unexpected '$item' (T_VARIABLE) in commondbtm.class.php on line 237

Thanks!!


GLPI 9.5.2;; FusionInventory: 9.2+1.0;; GLPI Modifications 1.1.4;; Notifications 1.1.9;;  Dashboard 0.8.8;; PHP 7.3.33

Offline

#14 2017-10-17 08:16:35

grefabu
Member
Registered: 2017-09-22
Posts: 111

Re: Automatic action - queuednotification

grefabu wrote:

Hi,

my notification go wired too.

On the 9.1.6 test system it works correct.
On the updateted 9.2 it work strange, I got no E-Mail.

For me it was a upgrade problem from 9.1.6 -> 9.2
I got an error for an not unique entry in the glpi_state table. After correction of the duplicate entrie I rerun the setup, but I think the routine didn't run correct then.

After a second try with update the 9.1.6 from a backup and coerrect the entry before upgrade the upgrade run well.
Now the automatik job has the right name and when using cli it work. I didn't test it with GLPI again.

Offline

#15 2017-10-17 17:25:36

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Automatic action - queuednotification

carlosbmc wrote:

PHP version running cron PHP Script was 5.4.16  (not the needed version of php 5.6 for GLPI  9.2)

PHP Parse error: syntax error, unexpected '$item' (T_VARIABLE) in commondbtm.class.php on line 237

In this place we use a PHP key introduce in 5.5. So you must update your PHP if you want to use GLPI 9.2


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#16 2017-10-17 21:35:45

carlosbmc
Member
Registered: 2016-12-01
Posts: 161

Re: Automatic action - queuednotification

Yes!  9.2 ok in production envoirment


GLPI 9.5.2;; FusionInventory: 9.2+1.0;; GLPI Modifications 1.1.4;; Notifications 1.1.9;;  Dashboard 0.8.8;; PHP 7.3.33

Offline

#17 2017-10-18 09:17:00

depra13
Member
Registered: 2017-10-18
Posts: 4

Re: Automatic action - queuednotification

machadomall wrote:

Hello good afternoon,
Check the following table;

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification

- I think maybe the update did not update the table.

It's just a check, whatever that is.

I have the same problem.
At the transition from version 9.1.6 to 9.2, notifications to the mail stopped coming.
someone is sent to one and the rest is not.
This entry itemtype = QueuedNotification, name = in the table: glpi_crontask I am not present. found Queuedmail and renamed it to QueuedNotification but did not help.

screenshot

the screenshot shows that in the glpi_queuednotifications table there are entries with sent_time and without.

Offline

#18 2017-10-18 10:51:27

depra13
Member
Registered: 2017-10-18
Posts: 4

Re: Automatic action - queuednotification

depra13 wrote:
machadomall wrote:

Hello good afternoon,
Check the following table;

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification

- I think maybe the update did not update the table.

It's just a check, whatever that is.

I have the same problem.
At the transition from version 9.1.6 to 9.2, notifications to the mail stopped coming.
someone is sent to one and the rest is not.
This entry itemtype = QueuedNotification, name = in the table: glpi_crontask I am not present. found Queuedmail and renamed it to QueuedNotification but did not help.

the screenshot shows that in the glpi_queuednotifications table there are entries with sent_time and without.


I remove the issue, everything worked.

Offline

#19 2017-10-18 16:14:33

gmognon
Member
From: Brazil
Registered: 2017-09-29
Posts: 9

Re: Automatic action - queuednotification

depra13 wrote:
depra13 wrote:
machadomall wrote:

Hello good afternoon,
Check the following table;

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification

- I think maybe the update did not update the table.

It's just a check, whatever that is.

I have the same problem.
At the transition from version 9.1.6 to 9.2, notifications to the mail stopped coming.
someone is sent to one and the rest is not.
This entry itemtype = QueuedNotification, name = in the table: glpi_crontask I am not present. found Queuedmail and renamed it to QueuedNotification but did not help.

the screenshot shows that in the glpi_queuednotifications table there are entries with sent_time and without.


I remove the issue, everything worked.

hello!
What have you done?
Did you renamed the table and it worked?

Last edited by gmognon (2017-10-18 17:07:11)

Offline

#20 2017-10-18 16:20:10

machadomall
Member
From: Brazil, Brasilia, DF
Registered: 2011-10-30
Posts: 208

Re: Automatic action - queuednotification

Hello,
Exactly, I just renamed the table fields.

That was before.

itemtype = Queuedmail, name = Queuedmail

For:

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification


Márcio Machado
Brasília-DF / Brasil

Offline

#21 2017-10-18 17:08:08

gmognon
Member
From: Brazil
Registered: 2017-09-29
Posts: 9

Re: Automatic action - queuednotification

machadomall wrote:

Hello,
Exactly, I just renamed the table fields.

That was before.

itemtype = Queuedmail, name = Queuedmail

For:

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification

Thank you!
I'll wait for version 9.2.1, hope this bug will be fixed.

Offline

#22 2017-10-24 08:46:25

trasher
GLPI dev
From: Montpellier
Registered: 2017-10-20
Posts: 37
Website

Re: Automatic action - queuednotification

Offline

#23 2017-10-25 00:29:55

gpqOficinayRed
Member
Registered: 2012-06-04
Posts: 13

Re: Automatic action - queuednotification

machadomall wrote:

Hello,
Exactly, I just renamed the table fields.

That was before.

itemtype = Queuedmail, name = Queuedmail

For:

Table: glpi_crontask
itemtype = QueuedNotification, name = queuednotification

I did this and there is a little bit of progress, but to make it work you have to edit your crontab so that it looks something like this:

*/5     *       *       *       *       /usr/bin/php /home/webs/glpi/front/cron.php --force mailgate &>/dev/null
*/1     *       *       *       *       /usr/bin/php /home/webs/glpi/front/cron.php --force queuednotification &>/dev/null

Change your directory paths to match your own configuration.

I hope this finally resolves my issues and also helps whoever stumbles upon this post now or in the future.

The first line collects your incoming tickets that were sent via email (assuming that you have set up a mail collector correctly through the web interface).

The second line makes sure that your ticket creation and follow-up emails are sent

If anybody ese cares to comment, I would appreciate it.

Last edited by gpqOficinayRed (2017-10-25 04:12:45)

Offline

#24 2018-12-20 09:38:25

iaanpermana
Member
Registered: 2018-12-20
Posts: 1

Re: Automatic action - queuednotification

trololo4ik wrote:
LaDenrée wrote:

you're right.
(any activity -> some specific activity would be exact)

Thanks, I configured cron, notifications are sent.

Hi, can you please share it to us, how you configure cron with windows ? i'm new, i can't understand how to set it up.

thank you

Offline

#25 2019-01-03 18:18:50

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Automatic action - queuednotification

For windows you must create a planned task


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

Board footer

Powered by FluxBB