Issues Installing

andrs333

Hi everyone,
I’m trying to install Dédalo on Ubuntu (Apache + PHP-FPM + PostgreSQL), and I’ve run into a few problems during the installation process.

1) Installer doesn’t create required folders
The installer fails to create directories like media, session, backup, etc.
I have to create them manually and set permissions so that the PHP user (www-data or dedalo_user) can write to them.

2) Database import fails with .gz file
The installer cannot import the database if it’s compressed (.gz).
If I manually decompress the file and import it myself, it works fine, but the installer’s automatic import always fails.

3) .pgpass file issue
The installer throws this error:
Error. Database import failed! Verify your .pgpass file and look for errors in php error file. - PHP get_current_user: dedalo - PHP whoami: www-data - PHP home: /var/www - .pgpass file permissions: 0600

4) Unclear which user PHP-FPM should use
I read that the .pgpass file must be located in the home directory of the PHP-FPM user, but it’s not clear whether that should be www-data or a dedicated user (for example, dedalo_user).
In my case, PHP-FPM is configured to run under a dedicated user dedalo_user, with its home set to /prehistoria.

Has anyone managed to get the Dédalo installer to:
1) automatically create the necessary directories, and
2) import the compressed .gz database file correctly?

Also, could someone confirm which user PHP-FPM should run as and where exactly the .pgpass file should be placed?

Thanks in advance!

Alex

Hi andrs333 and Welcome!

andrs333 1) Installer doesn’t create required folders

It could happens when the GNU/Linux user and PHP-FPM user don't match. (it depends of how you want to create the vhosts, that is not a Dédalo thing, is a PHP thing... )
Typical way is to use the same for GNU/Linux user and PHP-FPM.
When you create the GNU/Linux user, it will create its home directory. In this configuration, the Apache vhosts needs to point the ./httpdocs directory inside the Dédalo user home directory and the PHP-FPM can uses the GNU/Linux Dédalo user, defined into the PHP-FMP pool definition:

/etc/php/8.4/fpm/pool.d/my_pool.org.conf

You can see a typical configuration here

andrs333 2) Database import fails with .gz file

Seems that your PHP installation has not the zip lib installed.

I recommend you to follow the installation commands defined in the install documentation manual, if you don't follow the oficial instructions... some errors can appear....

I copy for you the PHP command here:

sudo apt install php8.4 php8.4-cli php8.4-common php8.4-mysql php8.4-pgsql php8.4-gd php8.4-mbstring php8.4-xml php8.4-pspell php8.4-tidy php8.4-bcmath php8.4-imap php8.4-soap php8.4-opcache php8.4-fpm php8.4-zip php8.4-curl

andrs333 3) .pgpass file issue

The .pgpass file, as postgreSQL define, needs to be set for PHP-FMP user, because PHP needs to access to the PostgreSQL. And the file needs to be in the $HOME of this user with 0600 file permissions. For security reasons, don't allow to Apache to read this file, so the user or group can't be www-data you needs to use your Dédalo GNU/Linux / PHP user and root for the group.

chown dedalo:root .pgpass

andrs333 4) Unclear which user PHP-FPM should use

Why? you can create the Apache, PHP vhosts and pool as you want... but, it needs to make sense, if you put www-data to PHP user and Apache can read your .pgpass the file is readable for every one... but, is your installation...

andrs333 In my case, PHP-FPM is configured to run under a dedicated user dedalo_user, with its home set to /prehistoria.

Not, is not:

andrs333 PHP whoami: www-data

Again, review your PHP-FPM pool user, it needs to be the GNU/Linux user for Dédalo.

andrs333 1) automatically create the necessary directories

If the PHP-FPM user has a rigth permissions, the installer will create all directories automatically. If your PHP is not allowed to create directories.... the install process will fails, because it has not permissions... of course.

andrs333 Has anyone managed to get the Dédalo installer to:

Yes, I did lot of times.

andrs333 2) import the compressed .gz database file correctly?

If your PHP installation has the correct libraries installed, the .gz database will import automatically. If your PHP installation has not all libraries... the install process will fail...

andrs333 Also, could someone confirm which user PHP-FPM should run as and where exactly the .pgpass file should be placed?

You can do it in different ways, but, as I said, the most typical configuration is set the GNU/Linux user for Dédalo to PHP-FPM user.

I hope it helps.

Best