[6.6] postgresql .lock: Permission denied

[CiotBSD]

Hi,

Today I install postgresql server on OpenBSD 6.6 server.

Into file postgresql.conf, I set socket_unix_directories, as:

unix_socket_directories = '/var/www/tmp/postgresql, /tmp'

But, the server deny to start!

2020-03-04 14:02:04.169 CET [50162] LOG: listening on IPv4 address "127.0.0.1", port 5432
2020-03-04 14:02:04.169 CET [50162] LOG: listening on IPv6 address "::1", port 5432
2020-03-04 14:02:04.170 CET [50162] FATAL: could not open lock file "/var/www/tmp/postgresql/.s.PGSQL.5432.lock": Permission denied
2020-03-04 14:02:04.170 CET [50162] LOG: database system is shut down

The rights on FS are:

# ls -al /var/www/ | grep tmp                                                                                                                                                         
drwx-----T   3 www   www     512 Mar  4 01:00 tmp/

# ls -al /var/www/tmp         
total 12
drwx-----T   3 www          www     512 Mar  4 01:00 ./
drwxr-xr-x  13 root         daemon  512 Mar  4 00:35 ../
drwxr-xr-x   2 _postgresql  www     512 Mar  4 01:00 postgresql/

One idea/suggestion?!

[LeFrettchen]

Could be a user's permissions issue.
Have you tried to start the server as root ? if not, it's worth to try...

[CiotBSD]

After inform me about sticky bit, I chmod /var/www/tmp to 1705; and the service postgresql starts correctly!

But, why by defaut, folders cache and tmp are rights to minimalist 1700???

[jggimi]

Originally Posted by CiotBSD

...by defaut, folders cache and tmp are rights to minimalist 1700???

The /var/www/tmp directory does not exist by default and is not created by the postgresql-server package -- it is not in the port's PLIST.

You might have created this directory with mkdir(1)?

[CiotBSD]

no. I think when I installed pkg php-7.3, no?!

[jggimi]

Good catch! That PLIST contains:

@sample ${CHROOT_DIR}/tmp/

Perhaps you could discuss adding an @exec-add to the PLISTs with Stuart Henderson, the PHP maintainer. Testing and then attaching a unified diff(1) applied to /usr/ports/lang/php/{7.2,7.3}/pkg/PLIST-main in your Email would permit him to review your recommendation, and if approved, easily commit your patch.

Stuart's Email can be obtained with $ pkg_info php--, note the two dash characters.