amuehlem / MISP-RPM

RPM packages for MISP
34 stars 15 forks source link

Warnings regarding pgsql.so and pdo_pgsql.so #49

Closed xdjibi closed 3 years ago

xdjibi commented 3 years ago

Hi,

Thank you for making these RPMs available.

I have installed it on RHEL7 using misp-2.4.122-1.el7.noarch.rpm and see some warnings when launching misp-workers :

 sudo systemctl status misp-workers
● misp-workers.service - MISP workers
   Loaded: loaded (/etc/systemd/system/misp-workers.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2021-05-07 15:58:20 CEST; 2 days ago
   CGroup: /system.slice/misp-workers.service
           ├─502 bash -c cd '/varsoft/www/MISP/app/Vendor/kamisama/php-resque-ex';     VERBOSE=true  QUEUE='default'  PIDFILE='/var/www/MISP/app/Plugin/CakeResque/tmp/16203958988583'  APP_INCLUDE='/var/www/MISP/app/Plugin/CakeResque/L...
           ├─503 php ./bin/resque
           ├─525 bash -c cd '/varsoft/www/MISP/app/Vendor/kamisama/php-resque-ex';     VERBOSE=true  QUEUE='prio'  PIDFILE='/var/www/MISP/app/Plugin/CakeResque/tmp/16203958992103'  APP_INCLUDE='/var/www/MISP/app/Plugin/CakeResque/Lib/...
           ├─526 php ./bin/resque
           ├─547 bash -c cd '/varsoft/www/MISP/app/Vendor/kamisama/php-resque-ex';     VERBOSE=true  QUEUE='cache'  PIDFILE='/var/www/MISP/app/Plugin/CakeResque/tmp/16203958995627'  APP_INCLUDE='/var/www/MISP/app/Plugin/CakeResque/Lib...
           ├─548 php ./bin/resque
           ├─570 bash -c cd '/varsoft/www/MISP/app/Vendor/kamisama/php-resque-ex';     VERBOSE=true  QUEUE='email'  PIDFILE='/var/www/MISP/app/Plugin/CakeResque/tmp/16203958999143'  APP_INCLUDE='/var/www/MISP/app/Plugin/CakeResque/Lib...
           ├─571 php ./bin/resque
           ├─592 bash -c cd '/varsoft/www/MISP/app/Vendor/kamisama/php-resque-ex';     VERBOSE=true  QUEUE='update'  PIDFILE='/var/www/MISP/app/Plugin/CakeResque/tmp/16203959002712'  APP_INCLUDE='/var/www/MISP/app/Plugin/CakeResque/Li...
           ├─593 php ./bin/resque
           ├─614 bash -c cd '/varsoft/www/MISP/app/Vendor/kamisama/php-resque-ex-scheduler';     VERBOSE=true  QUEUE='default'  PIDFILE='/var/www/MISP/app/Plugin/CakeResque/tmp/16203959006243'  APP_INCLUDE='/var/www/MISP/app/Plugin/Ca...
           └─615 php ./bin/resque-scheduler.php

May 07 15:58:20 su51060 start.sh[474]: Starting worker ... Done
May 07 15:58:20 su51060 start.sh[474]: PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_pgsql.so' (tried: /usr/lib64/php/20170718/pdo_pgsql.so (libpq.so.5: cannot open shared object file: No such file or directory), /usr...
May 07 15:58:20 su51060 start.sh[474]: PHP Warning:  PHP Startup: Unable to load dynamic library 'pgsql.so' (tried: /usr/lib64/php/20170718/pgsql.so (libpq.so.5: cannot open shared object file: No such file or directory), /usr/lib64/p...
May 07 15:58:20 su51060 start.sh[474]: Creating workers
May 07 15:58:20 su51060 start.sh[474]: Starting worker ... Done

PHP complains about pdo_pgsql.so and pgsql.so dynamic libraries. The warning is correct, these libraries don't exist on my system. But MISP uses MariaDB.

Having a look at PHP configuration files, I got rid of these warnings by disabling the corresponding extensions in /etc/php.d/pdo_pgsql.ini and /etc/php.d/pgsql.ini. Is there any reason to have these extensions enabled by default when installing MISP RPM ?

Regards, Xdjibi

amuehlem commented 3 years ago

These extensions would allow to use PostgreSQL as database for MISP. Some people prefer PostgreSQL over MySQL/MariaDB.