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
ZIP missing message is not blocking : you can continue configuration.
If you're struck, possibly it's because you cannot create the postgres DB.
Try and created a db in postgres and use it.
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
Check for errors in :
- browser console
- projeqtor log file
- php error log file
- apache error log file
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(8)
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.
Apache mod-ssl not installed.
Isn't it required for porstgres ?
I think no...
But i have change this in file pg_hba.conf (ident by md5) :
Old value :
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 ident
host all all 192.168.47.141/32 ident
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 ident
host replication all ::1/128 ident
By new value :
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 192.168.47.141/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all peer
host replication all 127.0.0.1/32 ident
host replication all ::1/128 ident
And reload Postgres and now is work !!!
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 available : OK
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
Database 'projeqtor' created : OK
Parameters are saved.
On next page, log in as user "admin" with password "admin"
Thank you so mutch Babynus and merry christmas.
The post is closed !!