Forum GLPI-Project

marcin

Member

Registered: 2022-05-06

Posts: 24

Problem with mailgate

Hello,
i have a problem with get email

In log:
[2024-05-14 09:15:20] glpiphplog.WARNING:   *** PHP Warning (2): error_log(/var/log/glpi/cron.log): Failed to open stream: Permission denied in /var/www/html/src/Toolbox.php at line 622
  Backtrace :
  src/Toolbox.php:622                                error_log()
  src/CronTask.php:1074                              Toolbox::logInFile()
  front/cron.php:67                                  CronTask::launch()

And:
[2024-05-14 08:59:07] glpisqllog.ERROR: DBmysql::doQuery() in /var/www/html/src/DBmysql.php line 403
  *** MySQL query error:
  SQL: SELECT `glpi_groups`.*, `glpi_groups_users`.`id` AS `IDD`, `glpi_groups_users`.`id` AS `linkid`, `glpi_groups_users`.`is_dynamic` AS `is_dynamic`, `glpi_groups_users`.`is_manager` AS `is_manager`, `glpi_groups_users`.`is_userdelegate` AS `is_userdelegate` FROM `glpi_groups_users` LEFT JOIN `glpi_groups` ON (`glpi_groups`.`id` = `glpi_groups_users`.`groups_id`) WHERE `glpi_groups_users`.`users_id` = '0' ORDER BY `glpi_groups`.`name`
  Error: MySQL server has gone away
  Backtrace :
  src/DBmysqlIterator.php:112                        DBmysql->doQuery()
  src/DBmysql.php:1109                               DBmysqlIterator->execute()
  src/Group_User.php:85                              DBmysql->request()
  src/RuleTicketCollection.php:150                   Group_User::getUserGroups()
  src/RuleCollection.php:1832                        RuleTicketCollection->prepareInputDataForProcess()
  src/RuleCollection.php:1673                        RuleCollection->prepareInputDataForProcessWithPlugins()
  src/Ticket.php:1960                                RuleCollection->processAllRules()
  src/CommonDBTM.php:1297                            Ticket->prepareInputForAdd()
  src/MailCollector.php:897                          CommonDBTM->add()
  front/mailcollector.form.php:106                   MailCollector->collect()
  {"user":"7@helpdesk","mem_usage":"0.000\", 23.48Mio)"}

[2024-05-14 08:59:07] glpisqllog.ERROR: DBmysql::doQuery() in /var/www/html/src/DBmysql.php line 403
  *** MySQL query error:
  SQL: SELECT * FROM `glpi_mailcollectors` WHERE `glpi_mailcollectors`.`id` = '3' LIMIT 1
  Error: MySQL server has gone away
  Backtrace :
  src/DBmysqlIterator.php:112                        DBmysql->doQuery()
  src/DBmysql.php:1109                               DBmysqlIterator->execute()
  src/CommonDBTM.php:303                             DBmysql->request()
  src/CommonDBTM.php:1586                            CommonDBTM->getFromDB()
  src/MailCollector.php:983                          CommonDBTM->update()
  front/mailcollector.form.php:106                   MailCollector->collect()
  {"user":"7@helpdesk","mem_usage":"0.000\", 23.97Mio)"}

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,809

Website

Re: Problem with mailgate

You should check the file permissions on your GLPI log files.
If the ownership was replaced with root or some user/group other than the one your web server runs as, you probably set up a cron job or something else to run as root instead of www-data or whatever your web server uses. If that is the case, that also needs to be fixed to prevent the file permissions from being messed up again.

For the "MySQL server has gone away" errors, sound like an issue with the database server and not GLPI. I cannot really help with that.

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.