" Internal Error" sqlite does not support inserting default values. Set the useNullAsDefault

[jhemelo]

I have just installed Nginx on my OpenMediavault server with the following stack:

version: "2"
services:
app:
image: jc21/nginx-proxy-manager:latest
restart: always
ports:
# Public HTTP Port:
- '80:80'
# Public HTTPS Port:
- '443:443'
# Admin Web Port:
- '81:81'
environment:
DB_SQLITE_FILE: "/data/database.sqlite"
volumes:
- ./data:/data
- ./letsencrypt:/etc/letsencrypt
- /srv/dev-disk-by-uuid-88ed3358-e48d-4163-ab7b-b726b9690f2c/CONFIG/Nginx:/config

The configuration seems has completed right, I'm able to load up the GUI and add few proxy hosts but the system is poping me as "internal error" when I try to set it SSL, in fact, the host is not even working with HTTP ,

I have created an A record to point my public IP and also confirmed the ports 80 and 443 are open on my firewall.

the logo shows the following error:

`❯ Enabling IPV6 in hosts: /data/nginx


sqlite does not support inserting default values. Set the `useNullAsDefault` flag to hide this warning. (see docs http://knexjs.org/#Builder-insert).


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      Current database version: none


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] auth Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] user Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] user_permission Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] proxy_host Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] redirection_host Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] dead_host Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] stream Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] access_list Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] certificate Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] access_list_auth Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [initial-schema] audit_log Table created


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [websockets] Migrating Up...


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [websockets] proxy_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [forward_host] Migrating Up...


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [forward_host] proxy_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [http2_support] Migrating Up...


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [http2_support] proxy_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [http2_support] redirection_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [http2_support] dead_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [forward_scheme] Migrating Up...


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [forward_scheme] proxy_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [disabled] Migrating Up...


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [disabled] proxy_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [disabled] redirection_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [disabled] dead_host Table altered


[1/23/2021] [8:09:56 AM] [Migrate  ] › ℹ  info      [disabled] stream Table altered


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [custom_locations] Migrating Up...


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [custom_locations] proxy_host Table altered


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [hsts] Migrating Up...


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [hsts] proxy_host Table altered


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [hsts] redirection_host Table altered


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [hsts] dead_host Table altered


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [settings] Migrating Up...


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [settings] setting Table created


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [access_list_client] Migrating Up...


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [access_list_client] access_list_client Table created


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [access_list_client] access_list Table altered


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [access_list_client_fix] Migrating Up...


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [access_list_client_fix] access_list Table altered


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [pass_auth] Migrating Up...


[1/23/2021] [8:09:57 AM] [Migrate  ] › ℹ  info      [pass_auth] access_list Table altered


[1/23/2021] [8:09:57 AM] [Setup    ] › ℹ  info      Creating a new JWT key pair...


[1/23/2021] [8:10:07 AM] [Setup    ] › ℹ  info      Wrote JWT key pair to config file: /app/config/production.json


[1/23/2021] [8:10:07 AM] [Setup    ] › ⚠  warning   Restarting interface to apply new configuration


sqlite does not support inserting default values. Set the `useNullAsDefault` flag to hide this warning. (see docs http://knexjs.org/#Builder-insert).


[1/23/2021] [8:10:12 AM] [Migrate  ] › ℹ  info      Current database version: none


[1/23/2021] [8:10:12 AM] [Setup    ] › ℹ  info      Creating a new user: [email protected] with password: changeme


[1/23/2021] [8:10:13 AM] [Setup    ] › ℹ  info      Initial admin setup completed


[1/23/2021] [8:10:13 AM] [Setup    ] › ℹ  info      Default settings added


[1/23/2021] [8:10:13 AM] [IP Ranges] › ℹ  info      Fetching IP Ranges from online services...


[1/23/2021] [8:10:13 AM] [IP Ranges] › ℹ  info      Fetching https://ip-ranges.amazonaws.com/ip-ranges.json


[1/23/2021] [8:10:14 AM] [IP Ranges] › ℹ  info      Fetching https://www.cloudflare.com/ips-v4


[1/23/2021] [8:10:14 AM] [IP Ranges] › ℹ  info      Fetching https://www.cloudflare.com/ips-v6


[1/23/2021] [8:10:14 AM] [SSL      ] › ℹ  info      Let's Encrypt Renewal Timer initialized


[1/23/2021] [8:10:14 AM] [SSL      ] › ℹ  info      Renewing SSL certs close to expiry...


[1/23/2021] [8:10:14 AM] [IP Ranges] › ℹ  info      IP Ranges Renewal Timer initialized


[1/23/2021] [8:10:14 AM] [Global   ] › ℹ  info      Backend PID 288 listening on port 3000 ...


[1/23/2021] [8:10:17 AM] [Nginx    ] › ℹ  info      Reloading Nginx


[1/23/2021] [8:10:17 AM] [SSL      ] › ℹ  info      Renew Complete


[1/23/2021] [8:10:35 AM] [Express  ] › ⚠  warning   invalid signature


[1/23/2021] [8:17:30 AM] [Express  ] › ⚠  warning   invalid signature


`QueryBuilder#allowEager` method is deprecated. You should use `allowGraph` instead. `allowEager` method will be removed in 3.0


`QueryBuilder#eager` method is deprecated. You should use the `withGraphFetched` method instead. `eager` method will be removed in 3.0


QueryBuilder#omit is deprecated. This method will be removed in version 3.0


Duplicate relation "access_list" in a relation expression. You should use "a.[b, c]" instead of "[a.b, a.c]". This will cause an error in objection 2.0


[1/23/2021] [8:19:00 AM] [Nginx    ] › ℹ  info      Reloading Nginx


[1/23/2021] [8:19:11 AM] [Nginx    ] › ℹ  info      Reloading Nginx


[1/23/2021] [8:19:11 AM] [SSL      ] › ℹ  info      Requesting Let'sEncrypt certificates for Cert #1: sonarr.jhmelo.com


[1/23/2021] [8:19:19 AM] [Nginx    ] › ℹ  info      Reloading Nginx


[1/23/2021] [8:19:19 AM] [Express  ] › ⚠  warning   Command failed: /usr/bin/certbot certonly --non-interactive --config "/etc/letsencrypt.ini" --cert-name "npm-1" --agree-tos --email "[email protected]" --preferred-challenges "dns,http" --domains "[email protected]" 


Saving debug log to /var/log/letsencrypt/letsencrypt.log


Plugins selected: Authenticator webroot, Installer None


Obtaining a new certificate


Performing the following challenges:


http-01 challenge for sonarr.jhmelo.com


Using the webroot path /data/letsencrypt-acme-challenge for all unmatched domains.


Waiting for verification...


Challenge failed for domain sonarr.jhmelo.com


http-01 challenge for sonarr.jhmelo.com


Cleaning up challenges


Some challenges have failed.

Any help tp fix this will be well appreciated

[chaptergy]

Please see #700