Pi-Hole and Passbolt on one machine

seminology · March 16, 2022, 9:50am

Checklist
I have read intro post: About the Installation Issues category
I have read the tutorials, help and searched for similar issues
I provide relevant information about my server (component names and versions, etc.)
I provide a copy of my logs and healthcheck
I describe the steps I have taken to trouble shoot the problem
I describe the steps on how to reproduce the issue

Server operating system name and version

HW-Info: Raspberry Pi 3 Model B Rev 1.2
OS Version: Raspbian GNU/Linux 11 (bullseye)
Debian Version: 11.2
Kernel Version: Linux StaticPi 5.10.92-v7+

Database server name and version:

Ver 15.1 Distrib 10.5.12-MariaDB

Php version:

PHP 7.4.28 (cli)

Passbolt version:

latest (new Installation)

Healthcheck:

pi@StaticPi:~/Downloads $ sudo -H -u www-data bash -c "/usr/share/php/passbolt/bin/cake passbolt healthcheck"

     ____                  __          ____  
    / __ \____  _____ ____/ /_  ____  / / /_ 
   / /_/ / __ `/ ___/ ___/ __ \/ __ \/ / __/ 
  / ____/ /_/ (__  |__  ) /_/ / /_/ / / /    
 /_/    \__,_/____/____/_.___/\____/_/\__/   

 Open source password manager for teams
-------------------------------------------------------------------------------
 Healthcheck shell.....Notice Error: Undefined index: message
In [/usr/share/php/passbolt/src/Utility/Healthchecks/DatabaseHealthchecks.php, line 72]

2022-03-16 09:36:31 Notice: Notice (8): Undefined index: message in [/usr/share/php/passbolt/src/Utility/Healthchecks/DatabaseHealthchecks.php, line 72]
Exception: Connection to Mysql could not be established: SQLSTATE[HY000] [1698] Access denied for user ''@'localhost'
In [/usr/share/php/passbolt/vendor/cakephp/cakephp/src/Database/Driver.php, line 140]

pi@StaticPi:~/Downloads $ sudo systemctl start nginx
Job for nginx.service failed because the control process exited with error code.
See "systemctl status nginx.service" and "journalctl -xe" for details.

pi@StaticPi:~/Downloads $ systemctl status nginx.service
● nginx.service - A high performance web server and a reverse proxy server
     Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Wed 2022-03-16 10:36:20 CET; 3min 50s ago
       Docs: man:nginx(8)
    Process: 4471 ExecStartPre=/usr/sbin/nginx -t -q -g daemon on; master_process on; (code=exited, status=0/SUCCESS)
    Process: 4472 ExecStart=/usr/sbin/nginx -g daemon on; master_process on; (code=exited, status=1/FAILURE)
        CPU: 262ms

Mär 16 10:36:18 StaticPi nginx[4472]: nginx: [emerg] bind() to 0.0.0.0:80 failed (98: Address already in use)
Mär 16 10:36:18 StaticPi nginx[4472]: nginx: [emerg] bind() to [::]:80 failed (98: Address already in use)
Mär 16 10:36:19 StaticPi nginx[4472]: nginx: [emerg] bind() to 0.0.0.0:80 failed (98: Address already in use)
Mär 16 10:36:19 StaticPi nginx[4472]: nginx: [emerg] bind() to [::]:80 failed (98: Address already in use)
Mär 16 10:36:19 StaticPi nginx[4472]: nginx: [emerg] bind() to 0.0.0.0:80 failed (98: Address already in use)
Mär 16 10:36:19 StaticPi nginx[4472]: nginx: [emerg] bind() to [::]:80 failed (98: Address already in use)
Mär 16 10:36:20 StaticPi nginx[4472]: nginx: [emerg] still could not bind()
Mär 16 10:36:20 StaticPi systemd[1]: nginx.service: Control process exited, code=exited, status=1/FAILURE
Mär 16 10:36:20 StaticPi systemd[1]: nginx.service: Failed with result 'exit-code'.
Mär 16 10:36:20 StaticPi systemd[1]: Failed to start A high performance web server and a reverse proxy server.

pi@StaticPi:~/Downloads $ journalctl -xe
Mär 16 10:40:10 StaticPi sudo[7070]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:10 StaticPi sudo[7070]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:10 StaticPi sudo[7070]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:12 StaticPi sudo[7082]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:12 StaticPi sudo[7082]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:12 StaticPi sudo[7082]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:13 StaticPi sudo[7094]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:13 StaticPi sudo[7094]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:13 StaticPi sudo[7094]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:14 StaticPi sudo[7106]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:14 StaticPi sudo[7106]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:14 StaticPi sudo[7106]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:15 StaticPi sudo[7118]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:15 StaticPi sudo[7118]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:15 StaticPi sudo[7118]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:16 StaticPi sudo[7130]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:16 StaticPi sudo[7130]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:16 StaticPi sudo[7130]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:17 StaticPi sudo[7142]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:17 StaticPi sudo[7142]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:17 StaticPi sudo[7142]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:19 StaticPi sudo[7154]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:19 StaticPi sudo[7154]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:19 StaticPi sudo[7154]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:20 StaticPi sudo[7166]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:20 StaticPi sudo[7166]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:20 StaticPi sudo[7166]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:21 StaticPi sudo[7178]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:21 StaticPi sudo[7178]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:21 StaticPi sudo[7178]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:22 StaticPi sudo[7190]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:22 StaticPi sudo[7190]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:22 StaticPi sudo[7190]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:23 StaticPi sudo[7203]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:23 StaticPi sudo[7203]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:23 StaticPi sudo[7203]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:24 StaticPi sudo[7215]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:24 StaticPi sudo[7215]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:24 StaticPi sudo[7215]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:25 StaticPi sudo[7227]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:25 StaticPi sudo[7227]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:25 StaticPi sudo[7227]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:27 StaticPi sudo[7239]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:27 StaticPi sudo[7239]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:27 StaticPi sudo[7239]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:28 StaticPi sudo[7251]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:28 StaticPi sudo[7251]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:28 StaticPi sudo[7251]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:29 StaticPi sudo[7263]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:29 StaticPi sudo[7263]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:29 StaticPi sudo[7263]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:30 StaticPi sudo[7275]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:30 StaticPi sudo[7275]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:30 StaticPi sudo[7275]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:31 StaticPi sudo[7287]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:31 StaticPi sudo[7287]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:31 StaticPi sudo[7287]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:32 StaticPi sudo[7299]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:32 StaticPi sudo[7299]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:33 StaticPi sudo[7299]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:34 StaticPi sudo[7311]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:34 StaticPi sudo[7311]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:34 StaticPi sudo[7311]: pam_unix(sudo:session): session closed for user root
Mär 16 10:40:35 StaticPi sudo[7323]: www-data : PWD=/var/www/html/admin ; USER=root ; COMMAND=/usr/local/bin/pihole status web
Mär 16 10:40:35 StaticPi sudo[7323]: pam_unix(sudo:session): session opened for user root(uid=0) by (uid=33)
Mär 16 10:40:35 StaticPi sudo[7323]: pam_unix(sudo:session): session closed for user root
lines 981-1046/1046 (END)

– What steps did you take?
I did an new installation of Passbolt on my Raspberry Pi on which is already Pi-Hole runnning. Therefore I can’t access the Passbolt configuration Site. Chapter 2 in the installation guide.

– What happened?
I end up on the Pi-Hole configuration site.

– What did you expect instead?
Passbolt configuration site.

So my Question:
Is it possible to use my already existing and running Raspberry Pi with Pi-Hole and Passbolt?

garrett · March 16, 2022, 12:03pm

Hi @seminology Yes, but we are not recommending it. In order to set it up one would need to be comfortable modifying NGINX configuration, in addition to whatever else is needed.

The Raspberry Pi instructions include:

The steps do not take into consideration other installations such as Pi-Hole. I use Pi-Hole, so based on my experience I think it’s possible, to answer your question.

seminology · March 16, 2022, 3:30pm

Hi,

thank you for you response. Change the Interface from Pi-Hole and now i’m a step further
For any other Interested: ext. Link