How to Change Environment Variables when self-hosted NocoDB running as a service

Self-Host
1

I installed nocodb in an LXC container on a proxmox device using this Proxmox Helper script: Proxmox VE Helper-Scripts.

NocoDB is running as a service: systemctl | grep noco > “nocodb.service loaded active running nocodb”

When I try the Test Webhook button for a local webhook I get the following error “… is not allowed. Because, It is a private IP address.”

So, I’d like to set the NC_ALLOW_LOCAL_HOOKS environment variable to true, however I’ve not been able to do that.

If I try printenv, no NocoDB environment variables including NC_DB (a NocoDB mandatory environment variable) are defined.

However, I did try in vain adding NC_ALLOW_LOCAL_HOOKS=true to the /etc/environment file, which then shows up in printenv after rebooting.

I found this post How do I set environment variables on [Aug 09] which implies the variables can be set through a web Gui, but the screenshot doesn’t look anything like what my web app looks like.

If I try find / -iname noco*, the only directories found are:
/usr/share/doc/mawk/examples/nocomment.awk
/etc/systemd/system/multi-user.target.wants/nocodb.service
/etc/systemd/system/nocodb.service
/opt/nocodb
/opt/nocodb/noco.db
/opt/nocodb/nc/uploads/noco
/opt/nocodb/nc/thumbnails/noco
/opt/nocodb/nocodb
/sys/fs/cgroup/system.slice/nocodb.service

I looked in /opt/nocodb, but didn’t find anything resembling a config file.

/opt/nocodb
├── nc
│ ├── thumbnails
│ │ └── noco
│ │ └── p1czez8szoqdxrl
│ │ └── m9300kkx4srl6ck
│ │ └── c2qcflp6guc1bv0
│ │ └── large_edc78837-0f01-444d-9d5d-8da981cf0797_fMO4I.jpeg
│ │ ├── card_cover.jpg
│ │ ├── small.jpg
│ │ └── tiny.jpg
│ └── uploads
│ └── noco
│ └── p1czez8szoqdxrl
│ └── m9300kkx4srl6ck
│ └── c2qcflp6guc1bv0
│ └── large_edc78837-0f01-444d-9d5d-8da981cf0797_fMO4I.jpeg
├── noco.db
└── nocodb

I looked in /etc/systemd/system/multi-user.target.wants/nocodb.service and /etc/systemd/system/nocodb.service, but no envirnment variables are defined.

I looked in the directory /sys/fs/cgroup/system.slice/nocodb.service, but didn’t see any config files.

I’m out of ideas, so how do I set NC_ALLOW_LOCAL_HOOKS == true?

2

It will be a good idea to query in proxmox forums. Have no idea about it unfortunately.