[GH-ISSUE #838] " Internal Error" sqlite does not support inserting default values. Set the useNullAsDefault #711

Closed
opened 2026-02-26 06:34:05 +03:00 by kerem · 1 comment
Owner

Originally created by @jhemelo on GitHub (Jan 23, 2021).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/838

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: admin@example.com 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 "jh@mysite.com" --preferred-challenges "dns,http" --domains "sonarr@mysite.com" 


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

Originally created by @jhemelo on GitHub (Jan 23, 2021). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/838 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: admin@example.com 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 "jh@mysite.com" --preferred-challenges "dns,http" --domains "sonarr@mysite.com" 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
kerem closed this issue 2026-02-26 06:34:05 +03:00
Author
Owner

@chaptergy commented on GitHub (May 12, 2021):

Please see #700

<!-- gh-comment-id:840140574 --> @chaptergy commented on GitHub (May 12, 2021): Please see #700
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/nginx-proxy-manager-NginxProxyManager#711
No description provided.