Forum GLPI-Project

alientm

Member

Registered: 2014-07-07

Posts: 50

Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

3 days ago I updated the system from ubuntu 14.04 to 16.04. GLPI works but it looks like "Recurrent tickets" has stopped working.
In Ubuntu 14.04, it worked correctly for three years.

Now in "Historical":

375489    2017-11-27 07:04    cron_ticketrecurrent        Zgłoszenie 781 pomyślnie stworzone
375462    2017-11-20 07:04    cron_ticketrecurrent        Zgłoszenie 780 pomyślnie stworzone
375230    2017-11-13 07:02    cron_ticketrecurrent        Zgłoszenie 776 pomyślnie stworzone
375169    2017-11-06 07:02    cron_ticketrecurrent        Zgłoszenie 772 pomyślnie stworzone

In "Information":
Next creation on 2017-12-04 06:30

but now is 2017-12-04 08:05 - time in system Ubuntu is set correctly.

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

In "Automatic action" last run of all action is: 2017-12-01 09:41 - date before system update

i use now PHP 7.2.0-1

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

Roshan

Member

Registered: 2017-07-26

Posts: 69

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

Hi ,
check your cron , i think should be something like this ,
*/1 * * * * /usr/bin/php  /<path of your glpi directory>/front/cron.php
this example is based on centos , should work for ubuntu too , but please check man for cron on ubuntu.

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

I admit that I do not have any knowledge about cron, I do not really know and understand how to check it out.

It's tasks in my cron

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

eulogy

Member

Registered: 2013-10-11

Posts: 118

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

Check your crontask (last line) runs periodically.

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

it's the details of the task /usr/bin/php /usr/share/glpi/front/cron.php

Is everything correct here?

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

the result of the command grep cron/var/log/syslog
Dec  6 07:52:01 glpi CRON[16944]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 07:53:01 glpi CRON[16962]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 07:54:01 glpi CRON[16966]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 07:55:01 glpi CRON[16970]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 07:56:01 glpi CRON[17001]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 07:57:01 glpi CRON[17006]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 07:58:01 glpi CRON[17026]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 07:59:01 glpi CRON[17030]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:00:01 glpi CRON[17036]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:00:01 glpi CRON[17037]: (smmsp) CMD (test -x /etc/init.d/sendmail && test -x /usr/share/sendmail/sendmail && test -x /usr/lib/sm.bin/sendmail && /usr/share/sendmail/sendmail cron-msp)
Dec  6 08:00:01 glpi CRON[17039]: (root) CMD (   test -x /usr/sbin/tigercron && { [ -r "$DEFAULT" ] && . "$DEFAULT" ; nice -n$NICETIGER /usr/sbin/tigercron -q ; })
Dec  6 08:01:01 glpi CRON[17205]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:01:12 glpi crontab[17209]: (root) LIST (root)
Dec  6 08:01:19 glpi crontab[17211]: (root) LIST (www-data)
Dec  6 08:01:53 glpi crontab[17213]: (root) LIST (www-data)
Dec  6 08:02:01 glpi CRON[17215]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:03:01 glpi CRON[17225]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:04:01 glpi CRON[17261]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:05:01 glpi CRON[17265]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:06:01 glpi CRON[17298]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:06:03 glpi crontab[17301]: (root) BEGIN EDIT (root)
Dec  6 08:06:07 glpi crontab[17301]: (root) END EDIT (root)
Dec  6 08:06:36 glpi crontab[17314]: (root) BEGIN EDIT (root)
Dec  6 08:06:48 glpi crontab[17314]: (root) END EDIT (root)
Dec  6 08:07:01 glpi CRON[17327]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:08:01 glpi CRON[17331]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)
Dec  6 08:09:01 glpi CRON[17359]: (www-data) CMD (/usr/bin/php /usr/share/glpi/front/cron.php)

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

KKAdmin

Member

From: Germany

Registered: 2010-03-05

Posts: 959

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

Linux cron looks fine. Can you manually run cron job in linux:
/usr/bin/php /usr/share/glpi/front/cron.php / Exit without error i suppose

1. Enable debug mode in your preferences (you should be super-admin).
2. Go into the Automatic action - ticketrecurrent reset it if currently running, and run it. If it is currently running and is in stuck nothing could work so cancel it.

3. If you see error messages (red background), you should retrieve the trace in your logs files (files/_logs/ directory).

Last edited by KKAdmin (2017-12-06 15:26:43)

---

You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3

KKAdmin

Member

From: Germany

Registered: 2010-03-05

Posts: 959

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

deleted

Last edited by KKAdmin (2017-12-06 15:31:15)

---

You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

root@glpi:~# /usr/bin/php /usr/share/glpi/front/cron.php
PHP Fatal error:  Uncaught Error: Class 'mysqli' not found in /usr/share/glpi/in               c/dbmysql.class.php:107
Stack trace:
#0 /usr/share/glpi/inc/dbmysql.class.php(81): DBmysql->connect(NULL)
#1 /usr/share/glpi/inc/dbconnection.class.php(196): DBmysql->__construct()
#2 /usr/share/glpi/inc/dbconnection.class.php(276): DBConnection::switchToMaster               ()
#3 /usr/share/glpi/inc/config.php(78): DBConnection::establishDBConnection(0, 0)
#4 /usr/share/glpi/inc/includes.php(57): include_once('/usr/share/glpi...')
#5 /usr/share/glpi/front/cron.php(42): include('/usr/share/glpi...')
#6 {main}
  thrown in /usr/share/glpi/inc/dbmysql.class.php on line 107
root@glpi:~#

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

In debug mode, when i start a recurrent ticket manualy - nothing appears on a red background, no messages with errors

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

KKAdmin

Member

From: Germany

Registered: 2010-03-05

Posts: 959

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

Go to:
Home
Setup
General
system

there should be a line like "mysqli extension is installed"

---

You can mark this threat as [resolved] in subject of your threat. (This is only available edit of the first post.) It is good for users who help others to quickly see which post is still open.
##############################################
GLPI 9.3.3

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

I temporarily switched back to php5.6

Apache -
$ sudo a2dismod php7.1
$ sudo a2enmod php5.6
$ sudo service apache2 restart
CLI: -
$ sudo update-alternatives --set php /usr/bin/php5.6

now all automatic action work, but I would like to work on a newer php

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

> I temporarily switched back to php5.6

Clearly not a GLPI issue, GLPI works perfectly with PHP 7.x

> PHP Fatal error:  Uncaught Error: Class 'mysqli' not found in /usr/share/glpi/in               c/dbmysql.class.php:107

Installation issue.

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

alientm

Member

Registered: 2014-07-07

Posts: 50

Re: Recurrent tickets (GLPI 9.2.1) after Ubuntu update 14.04 -> 16.04

I do not know if I have chosen the right tactics, but I have uninstalled everything that started with php, php5, php7, ubuntu restart, php7 installation (by default, version 7.1), GLPI re-installation.

From 3 days everything works on php 7.1, thank you for suggestions and help.

---

GLPI 9.4.4 + FusionInventory 9.4+1.1 on Ubuntu 18.04