[SOLVED] Issue about PHP-ZIP only choice Datebase type PostgreSQL

Hello teams,

I install from scratch ProjeQtOr v9.3.5 on Centos v8.5.211 / Apache v2.4.37-43 / Php v8.0.14-1 and all extension PHP need ProjeQtOr.
- In the first configuration, choice :
   - database MySQL the buton Save Configuration all items is OK.
   - database PostgreSQL the buton doesn't work (no effect, nothing)
I try to remove PHP-ZIP and reload HTTPD : the buton work for the choice database PostegreSQL but i have this message : Class ZipArchive is not available - You won't be able to manage plugins - check your php configuration (php.ini).
Impossible to terminate the first configuration !

PHP version is 8.0.14 : OK
Module PDO is available : OK
Module PDO for 'PGSQL' is available : OK
Module MBSTRING is available : OK
Class ZipArchive is not available - You won't be able to manage plugins - check your php configuration (php.ini)
Module DOMDocument is available : OK
GD Library is available and correctly installed : OK
Module IMAP is available : OK
Module OPENSSL is available : OK
Module XML is available : OK
max_input_vars=4000 : OK
max_execution_time=30 : OK
memory_limit=512M : OK
file_uploads=1 : OK
session.auto_start is disabled : OK
register_globals is disabled : OK

Thanks for your support.
Stéphane
 

Hi Babynus,

My database is install : PostgreSQL v10.17-2
The buton "Save Configuration" doesn't work (no effect, nothing).
I try on Edge and Firefox same issu.

I install projeqtor many times in past. But i have no idea.
I work at SOGETI/CAPGEMINI and now SCNF RESEAU

No log projeqtor !

Status Apache :
[root@Tichat ~]# systemctl status httpd
● httpd.service - The Apache HTTP Server
Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
Drop-In: /usr/lib/systemd/system/httpd.service.d
└─php-fpm.conf
Active: active (running) since Thu 2021-12-23 16:53:02 CET; 47min ago
Docs: man:httpd.service(
Process: 3505 ExecReload=/usr/sbin/httpd $OPTIONS -k graceful (code=exited, status=0/SUCCESS)
Main PID: 1547 (httpd)
Status: "Total requests: 218; Idle/Busy workers 100/0;Requests/sec: 0.0762; Bytes served/sec: 3.8KB/sec"
Tasks: 278 (limit: 23385)
Memory: 59.9M
CGroup: /system.slice/httpd.service
├─1547 /usr/sbin/httpd -DFOREGROUND
├─3506 /usr/sbin/httpd -DFOREGROUND
├─3507 /usr/sbin/httpd -DFOREGROUND
├─3508 /usr/sbin/httpd -DFOREGROUND
├─3509 /usr/sbin/httpd -DFOREGROUND
└─3761 /usr/sbin/httpd -DFOREGROUND

déc. 23 16:53:03 Tichat httpd[1547]: Server configured, listening on: port 80
déc. 23 16:59:33 Tichat systemd[1]: Reloading The Apache HTTP Server.
déc. 23 16:59:33 Tichat httpd[1547]: Server configured, listening on: port 80
déc. 23 16:59:34 Tichat systemd[1]: Reloaded The Apache HTTP Server.
déc. 23 17:00:24 Tichat systemd[1]: Reloading The Apache HTTP Server.
déc. 23 17:00:24 Tichat systemd[1]: Reloaded The Apache HTTP Server.
déc. 23 17:00:24 Tichat httpd[1547]: Server configured, listening on: port 80
déc. 23 17:02:44 Tichat systemd[1]: Reloading The Apache HTTP Server.
déc. 23 17:02:44 Tichat httpd[1547]: Server configured, listening on: port 80
déc. 23 17:02:44 Tichat systemd[1]: Reloaded The Apache HTTP Server.

Log Apache :
[root@Tichat httpd]# cat error_log
[Thu Dec 23 17:50:04.294177 2021] [lbmethod_heartbeat:notice] [pid 1547:tid 140296136980800] AH02282: No slotmem from mod_heartmonitor
[Thu Dec 23 17:50:04.296348 2021] [http2:warn] [pid 1547:tid 140296136980800] AH02951: mod_ssl does not seem to be enabled
[Thu Dec 23 17:50:04.297830 2021] [mpm_event:notice] [pid 1547:tid 140296136980800] AH00489: Apache/2.4.37 (centos) configured -- resuming normal operations
[Thu Dec 23 17:50:04.297907 2021] [core:notice] [pid 1547:tid 140296136980800] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'

Log PHP :
[root@Tichat php-fpm]# cat error.log
[23-Dec-2021 16:39:18] NOTICE: fpm is running, pid 4741
[23-Dec-2021 16:39:18] NOTICE: ready to handle connections
[23-Dec-2021 16:39:18] NOTICE: systemd monitor interval set to 10000ms
[23-Dec-2021 16:52:31] NOTICE: Terminating ...
[23-Dec-2021 16:52:31] NOTICE: exiting, bye-bye!
[23-Dec-2021 16:53:00] NOTICE: fpm is running, pid 1306
[23-Dec-2021 16:53:00] NOTICE: ready to handle connections
[23-Dec-2021 16:53:00] NOTICE: systemd monitor interval set to 10000ms

Status PostgreSQL :
[root@Tichat ~]# systemctl status postgresql.service
● postgresql.service - PostgreSQL database server
Loaded: loaded (/usr/lib/systemd/system/postgresql.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2021-12-23 16:53:00 CET; 48min ago
Process: 1310 ExecStartPre=/usr/libexec/postgresql-check-db-dir postgresql (code=exited, status=0/SUCCESS)
Main PID: 1326 (postmaster)
Tasks: 8 (limit: 23385)
Memory: 23.7M
CGroup: /system.slice/postgresql.service
├─1326 /usr/bin/postmaster -D /sgbd/postgres/pgsql/data
├─1340 postgres: logger process
├─1342 postgres: checkpointer process
├─1343 postgres: writer process
├─1344 postgres: wal writer process
├─1345 postgres: autovacuum launcher process
├─1346 postgres: stats collector process
└─1347 postgres: bgworker: logical replication launcher

déc. 23 16:53:00 Tichat systemd[1]: Starting PostgreSQL database server...
déc. 23 16:53:00 Tichat postmaster[1326]: 2021-12-23 16:53:00.478 CET [1326] LOG: en écoute sur IPv4, adresse « 0.0.0.0 », port 5432
déc. 23 16:53:00 Tichat postmaster[1326]: 2021-12-23 16:53:00.478 CET [1326] LOG: en écoute sur IPv6, adresse « :: », port 5432
déc. 23 16:53:00 Tichat postmaster[1326]: 2021-12-23 16:53:00.481 CET [1326] LOG: écoute sur la socket Unix « /var/run/postgresql/.s.PGSQL.5432 »
déc. 23 16:53:00 Tichat postmaster[1326]: 2021-12-23 16:53:00.484 CET [1326] LOG: écoute sur la socket Unix « /tmp/.s.PGSQL.5432 »
déc. 23 16:53:00 Tichat postmaster[1326]: 2021-12-23 16:53:00.520 CET [1326] LOG: redirection des traces vers le processus de récupération des traces
déc. 23 16:53:00 Tichat postmaster[1326]: 2021-12-23 16:53:00.520 CET [1326] ASTUCE : Les prochaines traces apparaîtront dans le répertoire « log ».
déc. 23 16:53:00 Tichat systemd[1]: Started PostgreSQL database server.