Questions on Install Documentation

amu

Hi.

I am following the documentation in order to self-host liberaforms and I have some doubts.

The first one is, on the Clone LiberaForms section, there is a sentence reading "Make sure the user who runs LiberaForms is the owner of the directories and files" however it only shows the command chown liberaforms uploads.

Is that ok? Is that directory enough?

Thanks

chris

Hi! 🙂

amu The first one is, on the Clone LiberaForms section, there is a sentence reading "Make sure the user who runs LiberaForms is the owner of the directories and files" however it only shows the command chown liberaforms uploads.

Is that ok? Is that directory enough?

The user doens't necessarily need to own all the directories, but it's makes like easier if it does.

A part form uploads there is flask_session, and in the next version to release 4.5.0, there is another.

Hope that helps.

And thank you for posting here!

amu

Second question. Regarding the Database section, this is what I have:

(venv) root@forms:/opt/liberaforms# sudo su
root@forms:/opt/liberaforms# su postgres -c "liberaforms/commands/postgres.sh create-db"
su: user postgres does not exist or the user entry does not contain all the required fields
root@forms:/opt/liberaforms#

What should I do?

chris

amu su: user postgres does not exist

Mmm. The postgres user is created when you install PostgreSQL, at least on Debian.

Maybe you can find the name of the PostgreSQL administrator by looking at the content of /etc/passwd

Let me know.

amu

Thank you!

chris The user doens't necessarily need to own all the directories, but it's makes like easier if it does.

So, instead of chown liberaforms uploads, do you recommend doing chown -R liberaforms:liberaforms .?
That is the whole /opt/liberaforms directory and its contents.
And perhaps chmod g+s . too?

amu

chris A part form uploads there is flask_session

I can't see flask_session. Should I see it? Where?

amu

chris The postgres user is created when you install PostgreSQL

Ok, I understand PostgreSQL has to be manually installed (it's not in any of the previous steps).

Is package postgresql enough?
Do I need anything else?
Perhaps something like postgresql-contrib?

chris

amu Is package postgresql enough?
Do I need anything else?
Perhaps something like postgresql-contrib?

I don't think postgresql-contrib is necessary.

Try installing the minimum, just the server, first.

amu

Oops, sorry, I see now the requirements clearly states a PostgreSQL is needed.

amu

I can't see flask_session. Should I see it? Where?

Oops, sorry again, I see it now. I had to be into this venv thing.

amu

Should the liberaforms-logs.conf and liberaforms.conf files be created at /etc/supervisor/conf.d directory?

chris

amu Should the liberaforms-logs.conf and liberaforms.conf files be created at /etc/supervisor/conf.d directory?

Have a look at https://docs.liberaforms.org/sysadmin/install/#configure-supervisor

flask config hint supervisor

That command will tell you where to create the config files.

amu

Are these permissions ok?

(venv) root@forms:/opt/liberaforms# ls -hal
total 128K
drwxr-xr-x 16 root        root          31 sep 18 20:20 .
drwxr-xr-x  3 root        root           3 sep 13 07:59 ..
drwxr-xr-x  8 root        root          11 sep 13 07:59 assets
drwxr-xr-x  2 root        root           4 sep 13 07:59 babel
-rw-r--r--  1 root        root        2,0K sep 13 07:59 CONTRIBUTING.md
-rw-r--r--  1 root        root        2,4K sep 13 07:59 docker-compose.yml.example
-rw-r--r--  1 root        root         614 sep 13 07:59 Dockerfile
-rw-r--r--  1 root        root          79 sep 13 07:59 .dockerignore
drwxr-xr-x  2 root        root          17 sep 13 09:01 docs
-rw-r--r--  1 root        root        2,7K sep 13 07:59 dotenv.example
-rw-r--r--  1 root        root        2,8K sep 18 17:46 .env
-rw-r--r--  1 root        root        2,7K sep 13 09:08 env.ORIGINAL
drwxr-xr-x  2 liberaforms root           3 sep 18 20:26 flask_session
-rw-r--r--  1 root        root          45 sep 13 08:55 forms.mydomain.tld.CRYPTOKEY
drwxr-xr-x  8 root        root          13 sep 13 07:59 .git
-rw-r--r--  1 root        root         270 sep 13 07:59 .gitignore
-rw-r--r--  1 root        root         219 sep 13 09:17 gunicorn.py
drwxr-xr-x 15 root        root          16 sep 13 08:50 liberaforms
drwxr-xr-x  2 root        root           5 sep 13 07:59 LICENSES
-rw-r--r--  1 root        root        5,9K sep 13 07:59 log_listener.py
drwxr-xr-x  2 liberaforms liberaforms    4 sep 13 09:16 logs
drwxr-xr-x  4 root        root           8 sep 13 08:50 migrations
drwxr-xr-x  2 root        root           3 sep 13 08:50 __pycache__
-rw-r--r--  1 root        root        2,3K sep 13 07:59 README.md
-rw-r--r--  1 root        root        1,4K sep 13 07:59 requirements.txt
drwxr-xr-x  9 root        root          19 sep 13 07:59 tests
drwxr-xr-x  4 liberaforms root           5 sep 13 08:50 uploads
drwxr-xr-x  5 root        root           7 sep 13 08:00 venv
-rw-r--r--  1 root        root           6 sep 13 07:59 VERSION.txt
drwxr-xr-x  2 root        root           3 sep 13 07:59 .woodpecker
-rw-r--r--  1 root        root         356 sep 13 07:59 wsgi.py

amu

As shown above, I created the logs directory at /opt/liberaforms because in the .env file I just found:

# Directory where logs will be saved
LOG_DIR=logs

Is that ok?`

amu

I was following the Configure Supervisor step, but I get a problem with liberaforms-logs

(venv) root@forms:/opt/liberaforms# flask config hint supervisor
Supervisor configuration files

# ~~~~~ /etc/supervisor/conf.d/liberaforms.conf ~~~~~
[program:liberaforms]
directory = /opt/liberaforms
command = /opt/liberaforms/venv/bin/gunicorn -c /opt/liberaforms/gunicorn.py 'liberaforms:create_app()'
user = root
# ~~~~~


# ~~~~~ /etc/supervisor/conf.d/liberaforms-logs.conf ~~~~~
[program:liberaforms-logs]
directory = /opt/liberaforms
command = /opt/liberaforms/venv/bin/python log_listener.py
priority = 500
autostart = true
autorestart = true
user = root
# ~~~~~

(venv) root@forms:/opt/liberaforms#

With the info above, I created two files, see below:

(venv) root@forms:/opt/liberaforms# cat /etc/supervisor/conf.d/liberaforms.conf
# ~~~~~ /etc/supervisor/conf.d/liberaforms.conf ~~~~~
[program:liberaforms]
directory = /opt/liberaforms
command = /opt/liberaforms/venv/bin/gunicorn -c /opt/liberaforms/gunicorn.py 'liberaforms:create_app()'
user = liberaforms
# ~~~~~

(venv) root@forms:/opt/liberaforms# cat /etc/supervisor/conf.d/liberaforms-logs.conf 
# ~~~~~ /etc/supervisor/conf.d/liberaforms-logs.conf ~~~~~
[program:liberaforms-logs]
directory = /opt/liberaforms
command = /opt/liberaforms/venv/bin/python log_listener.py
priority = 500
autostart = true
autorestart = true
user = liberaforms
# ~~~~~

Are they ok?

(venv) root@forms:/opt/liberaforms# ls -hal /etc/supervisor/conf.d
total 10K
drwxr-xr-x 2 root root   4 sep 18 20:16 .
drwxr-xr-x 3 root root   4 sep 13 09:22 ..
-rw-r--r-- 1 root root 237 sep 18 17:17 liberaforms.conf
-rw-r--r-- 1 root root 253 sep 18 17:18 liberaforms-logs.conf

Are their permissions ok?

Look what I get:

venv) root@forms:/opt/liberaforms# systemctl restart supervisor.service 
(venv) root@forms:/opt/liberaforms# supervisorctl status liberaforms-logs
liberaforms-logs                 FATAL     Exited too quickly (process log may have details)
(venv) root@forms:/opt/liberaforms# supervisorctl status liberaforms
liberaforms                      STARTING

I also tried owning the two files at /etc/supervisor/conf.d/ by the liberaforms user, but then I get this:

(venv) root@forms:/opt/liberaforms# systemctl restart supervisor.service 
(venv) root@forms:/opt/liberaforms# supervisorctl status liberaforms-logs
liberaforms-logs                 BACKOFF   Exited too quickly (process log may have details)
(venv) root@forms:/opt/liberaforms# supervisorctl status liberaforms
liberaforms                      STARTING

Where did I go wrong?
How should I troubleshoot it?

chris

Hi,

amu How should I troubleshoot it?

Try these options to debug that problem

https://docs.liberaforms.org/sysadmin/install/#debugging

Please let me know, ok?

amu

I guess that means the answer to all my questions is that it is ok what I did.

But regarding the two files at /etc/supervisor/conf.d, are they ok being owned by root? Or should I change its ownership to user liberaforms?

chris

Hi,

Something is wrong for sure

BACKOFF Exited too quickly (process log may have details)

but I'm not sure what it is. If you try debugging and get back to me, that would help :)

amu But regarding the two files at /etc/supervisor/conf.d, are they ok being owned by root?

/etc/supervisor/* should definitely be owned by root.

amu

Sorry, I see I made a mistake, on the questions I did last day (September 18), when I asked about permissions, I meant ownership. I was asking about ownership.

chris

amu So, is everything working OK now?