Hello,

After a lot of research, I can't find anything that's really working about this topic.

I found this: https://glpi.userecho.com/communities/1/topics/824-ssl-connection-to-mysql-db and this https://github.com/glpi-project/glpi/pull/5892 among other links and there's this precision in installation instructions

"

SSL connection to database

New in version 9.5.0.

Once installation is done, you can update the config/config_db.php to define SSL connection parameters. Available parameters corresponds to parameters used by mysqli::ssl_set():

• $dbssl defines if connection should use SSL (false per default)
• $dbsslkey path name to the key file (null per default)
• $dbsslcert path name to the certificate file (null per default)
• $dbsslca path name to the certificate authority file (null per default)
• $dbsslcapath pathname to a directory that contains trusted SSL CA certificates in PEM format (null per default)
• $dbsslcacipher list of allowable ciphers to use for SSL encryption (null per default)

"

However, it doesnt work in my case and I can't for the life of me find out why. I have the following errors with the params supplied:

[Thu Apr 20 13:18:20.433141 2023] [php:warn] [pid 26913] [client XXXXX:50904] PHP Warning: mysqli::real_connect(): SSL operation failed with code 1. OpenSSL Error messages:\nerror:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed in /var/www/html/glpi/src/DBmysql.php on line 253, referer: http://XXXXX/glpi/front/central.php
[Thu Apr 20 13:18:20.433320 2023] [php:warn] [pid 26913] [client XXXXX:50904] PHP Warning: mysqli::real_connect(): Cannot connect to MySQL by using SSL in /var/www/html/glpi/src/DBmysql.php on line 253, referer: http://XXXXX/glpi/front/central.php
[Thu Apr 20 13:18:20.433409 2023] [php:warn] [pid 26913] [client XXXXX:50904] PHP Warning: mysqli::real_connect(): (HY000/2002): (trying to connect via (null)) in /var/www/html/glpi/src/DBmysql.php on line 253, referer: http://XXXXX/glpi/front/central.php

However, a simple php code works with SSL on this same machine so no networking problem or cert problem or username/passwd problem:

<?php
$conn = mysqli_init();
mysqli_ssl_set($conn,NULL,NULL, "/var/www/html/glpi/config/CertName.crt.pem", NULL, NULL);
mysqli_real_connect($conn, 'ServerName', 'Username', 'password', 'DBname', Port, MYSQLI_CLIENT_SSL);
if (mysqli_connect_errno()) {
die('Failed to connect to MySQL: '.mysqli_connect_error());
}

Can anyone tell me IF it really works, and if there's an example somewhere of someone that managed to make it work for real? I couldn't find any.

Thanks in advance.

Dear developer,

we're starting to explore the vast GLPI for possible deployment in our organisation. Since we are quite heavily oriented on group-based security model, the very first feature that we quite miss in GLPI is possibility to assign profile to a group. Currently it is only possible to assign profile to a user.

Right now when contract reach max linked items, there is no add buttons in item tabs.

however user still can add link item using mass actions button.

When doing so, glpi will throw unauthorize access error which gives user misunderstanding.

So I suggest adding a new error message for such event

Right now, we can't add Domains on Fields unicity

Closed tickets are the first source to identify a problem.

Unfortunately GLPI don't authorize to add closed tickets to problems. 

It's a pity, enable this feature would be useful to document problems with old closed tickets.

Hello !

Currently, when an anonymous user is talking (by mail) to a GLPI User (from the interface),

The anonymous user is having both notification from the GLPI User, and from himself. (Follow-up notification).

It would be good i think to have a way to avoid that, maybe by adding another option in the notification settings

Currently the follow-up notification have as event "New Follow-up", maybe a new event can be added, for example "New Follow-up (from GLPI user)"

In that way, we can avoid the anonymous user to receive both notification as said earlier, and we can even create some new custom notifications for them ! (E.G : Your answer has been received....)

Thanks !

Hi,

It seems attacheble customizable checklist with checkboxes will be usefull for ticket/change/problem/project

Hi,

There is a well-working mechanism to apply rules to tickets and it seems 10.1.0 will have the same for changes.

It will be great to have autoassigning, approval sending etc when a problem is being received from Zabbix

Hello everyone, I'm using GLPI 10.0.5, and I need to customize my default personal view. I want that the card "Your Planning" be always fixed in this position, because when people have many tickets, they can't see it clear. How can I do that?

Today, when selecting severall tickets in a random view, if you want to add a task to all selected tickets, it's neither possible to assign this task, nor to plan it.

Thanks for reading and aknowledging this issue