installation issue: Warning: File .pgpass not found

marcobat

Hello everyone,
I am installing dedalo and i'm running into a few issues, possibly due to the fact that i'm installing it into a FreeBSD server.
I'm getting this error:
Warning: File .pgpass not found at: //.pgpass Check your .pgpass file into php user home dir
I have crated this file when i created the database but i cannot move it into the 'php user home dir' that would be www home dir which is /nonexistent
(www:*:80:80:World Wide Web Owner:/nonexistent:/usr/sbin/nologin)
I don't see in the config file any option to set this location to a custom one.
Did anyone encounter this issue before?
Thanks.

Alex

Hi marcobat Wellcome!

I thinks that FreeBSD is ok for Dédalo, and is super cool install it in other Unix than Ubuntu... 🙂

Ok. the main thing is that .pgpass file need to be place inside the home of PHP user, not in the Apache user.

Explanation: To run PHP with FPM you will need to create a unix user which will be the 'Dédalo' user and PHP user (Yes, is the same user), the PHP-FPM pool use this user to create directories, files, and other tasks, so this user need to be different than the Apache user. See more info here and here. (I found a tutorial about PHP and FreeBSD here)

Usually the PHP user's home will be:

/home/www/my_dedalo_user

And the Apache httpdocs will point into a directory inside it:

/home/www/my_dedalo_user/httpdocs

Note: remember set the owner of httpdocs as root.

So, the .pgpass file will be in user directory as:

/home/www/my_dedalo_user/.pgpass

Note: remember set the correct permissions (600)

Why? Because PHP will execute postgreSQL commands for backup and maintenance using his user and postgreSQL will try to find the .pgpass into the home of the caller user, see the documentation here.

I hope is clear.

Best