[GH-ISSUE #2976] ER_BAD_FIELD_ERROR: Unknown column 'openidc_allowed_users' #2027

Closed
opened 2026-02-26 07:33:44 +03:00 by kerem · 0 comments
Owner

Originally created by @ThierryIT on GitHub (Jun 3, 2023).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/2976

I have found a bug

Checklist

  • Have you pulled and found the error with jc21/nginx-proxy-manager:latest docker image?
    • No
  • Are you sure you're not using someone else's docker image?
    • Yes I am using another docker image 'from baudneo/nginx-proxy-manager:latest'
  • Have you searched for similar issues (both open and closed)?
    • Yes

Describe the bug

Not able to add any 'proxy host'

Nginx Proxy Manager Version

V0.0.0

To Reproduce
Steps to reproduce the behavior:

  1. Go to 'proxy host'
  2. Click on 'add proxy host'
  3. Scroll down to 'add domain, ip number etc.'
  4. See error: 'logs from the docker'

Expected behavior

to be able to add my proxy host

Screenshots

Operating System

Using docker on Unraid server with Portainer-ce:

version: "3"
services:
npm:
#image: 'jc21/nginx-proxy-manager:latest'
image: 'baudneo/nginx-proxy-manager:latest'
restart: always
container_name: npm-crowdsec
ports:
# Public HTTP Port:
- '1080:80'
# Public HTTPS Port:
- '10443:443'
# Admin Web Port:
- '1081:81'
environment:
TZ: "Europe/Helsinki"
ADMIN_PANEL_LOG: "1"
CROWDSEC_BOUNCER: "1"
OPENRESTY_DEBUG: "0"

  CROWDSEC_LAPI: "0.0.0.0:8080"
  CROWDSEC_KEY: "222c3e052a2bef1884b78832bd9aa475"

  # These are the settings to access your db
  DB_MYSQL_HOST: "172.20.0.2"
  DB_MYSQL_PORT: 3306
  DB_MYSQL_USER: "npm_user"
  DB_MYSQL_PASSWORD: "BvSfSd48W492u"
  DB_MYSQL_NAME: "npm_db"
  # If you would rather use Sqlite uncomment this
  # and remove all DB_MYSQL_* lines above
  # DB_SQLITE_FILE: "/data/database.sqlite"
  # Uncomment this if IPv6 is not enabled on your host
  DISABLE_IPV6: 'true'
volumes:
  - ./data:/data
  - ./letsencrypt:/etc/letsencrypt
depends_on:
  - db

db:
image: 'jc21/mariadb-aria:latest'
restart: always
container_name: npm_db
environment:
MYSQL_ROOT_PASSWORD: '7QsjYU9wB3k63'
MYSQL_DATABASE: 'npm_db'
MYSQL_USER: 'npm_user'
MYSQL_PASSWORD: 'BvSfSd48W492u'
volumes:
- ./data/mysql:/var/lib/mysql

Unraid server version: 6.11.5

  • Portainer-ce

Additional context

[6/3/2023] [10:08:01 AM] [Express ] › ⚠ warning insert into proxy_host (access_list_id, advanced_config, allow_websocket_upgrade, block_exploits, caching_enabled, certificate_id, created_on, domain_names, enable_proxy_protocol, forward_host, forward_port, forward_scheme, hsts_enabled, hsts_subdomains, http2_support, locations, meta, modified_on, openidc_allowed_users, openidc_auth_method, openidc_client_id, openidc_client_secret, openidc_discovery, openidc_redirect_uri, owner_user_id, ssl_forced) values (0, '', false, false, false, 0, NOW(), '["www.doma.org"]', false, '192.168.xxxxx', 80, 'http', false, false, false, '[]', '{"letsencrypt_agree":false,"dns_challenge":false}', NOW(), '[]', 'client_secret_post', '', '', '', '', 1, false) - ER_BAD_FIELD_ERROR: Unknown column 'openidc_allowed_users' in 'field list'

Thx for your support ...

Originally created by @ThierryIT on GitHub (Jun 3, 2023). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/2976 <!-- Are you in the right place? - If you are looking for support on how to get your upstream server forwarding, please consider asking the community on Reddit. - If you are writing code changes to contribute and need to ask about the internals of the software, Gitter is the best place to ask. - If you think you found a bug with NPM (not Nginx, or your upstream server or MySql) then you are in the *right place.* --> I have found a bug **Checklist** - Have you pulled and found the error with `jc21/nginx-proxy-manager:latest` docker image? - No - Are you sure you're not using someone else's docker image? - Yes I am using another docker image 'from baudneo/nginx-proxy-manager:latest' - Have you searched for similar issues (both open and closed)? - Yes **Describe the bug** <!-- A clear and concise description of what the bug is. --> Not able to add any 'proxy host' **Nginx Proxy Manager Version** <!-- What version of Nginx Proxy Manager is reported on the login page? --> V0.0.0 **To Reproduce** Steps to reproduce the behavior: 1. Go to 'proxy host' 2. Click on 'add proxy host' 3. Scroll down to 'add domain, ip number etc.' 4. See error: 'logs from the docker' **Expected behavior** <!-- A clear and concise description of what you expected to happen. --> to be able to add my proxy host **Screenshots** <!-- If applicable, add screenshots to help explain your problem. --> **Operating System** <!-- Please specify if using a Rpi, Mac, orchestration tool or any other setups that might affect the reproduction of this error. --> Using docker on Unraid server with Portainer-ce: version: "3" services: npm: #image: 'jc21/nginx-proxy-manager:latest' image: 'baudneo/nginx-proxy-manager:latest' restart: always container_name: npm-crowdsec ports: # Public HTTP Port: - '1080:80' # Public HTTPS Port: - '10443:443' # Admin Web Port: - '1081:81' environment: TZ: "Europe/Helsinki" ADMIN_PANEL_LOG: "1" CROWDSEC_BOUNCER: "1" OPENRESTY_DEBUG: "0" CROWDSEC_LAPI: "0.0.0.0:8080" CROWDSEC_KEY: "222c3e052a2bef1884b78832bd9aa475" # These are the settings to access your db DB_MYSQL_HOST: "172.20.0.2" DB_MYSQL_PORT: 3306 DB_MYSQL_USER: "npm_user" DB_MYSQL_PASSWORD: "BvSfSd48W492u" DB_MYSQL_NAME: "npm_db" # If you would rather use Sqlite uncomment this # and remove all DB_MYSQL_* lines above # DB_SQLITE_FILE: "/data/database.sqlite" # Uncomment this if IPv6 is not enabled on your host DISABLE_IPV6: 'true' volumes: - ./data:/data - ./letsencrypt:/etc/letsencrypt depends_on: - db db: image: 'jc21/mariadb-aria:latest' restart: always container_name: npm_db environment: MYSQL_ROOT_PASSWORD: '7QsjYU9wB3k63' MYSQL_DATABASE: 'npm_db' MYSQL_USER: 'npm_user' MYSQL_PASSWORD: 'BvSfSd48W492u' volumes: - ./data/mysql:/var/lib/mysql Unraid server version: 6.11.5 + Portainer-ce **Additional context** <!-- Add any other context about the problem here, docker version, browser version, logs if applicable to the problem. Too much info is better than too little. --> [6/3/2023] [10:08:01 AM] [Express ] › ⚠ warning insert into `proxy_host` (`access_list_id`, `advanced_config`, `allow_websocket_upgrade`, `block_exploits`, `caching_enabled`, `certificate_id`, `created_on`, `domain_names`, `enable_proxy_protocol`, `forward_host`, `forward_port`, `forward_scheme`, `hsts_enabled`, `hsts_subdomains`, `http2_support`, `locations`, `meta`, `modified_on`, `openidc_allowed_users`, `openidc_auth_method`, `openidc_client_id`, `openidc_client_secret`, `openidc_discovery`, `openidc_redirect_uri`, `owner_user_id`, `ssl_forced`) values (0, '', false, false, false, 0, NOW(), '[\"www.doma.org\"]', false, '192.168.xxxxx', 80, 'http', false, false, false, '[]', '{\"letsencrypt_agree\":false,\"dns_challenge\":false}', NOW(), '[]', 'client_secret_post', '', '', '', '', 1, false) - ER_BAD_FIELD_ERROR: Unknown column 'openidc_allowed_users' in 'field list' Thx for your support ...
kerem 2026-02-26 07:33:44 +03:00
  • closed this issue
  • added the
    bug
    label
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#2027
No description provided.