starred/nginx-proxy-manager-NginxProxyManager

Fork 0

mirror of https://github.com/NginxProxyManager/nginx-proxy-manager.git synced 2026-04-26 01:45:54 +03:00

[GH-ISSUE #146] MariaDB Issues #128

New issue

Closed

opened 2026-02-26 06:30:28 +03:00 by kerem · 3 comments

kerem commented

2026-02-26 06:30:28 +03:00

Owner

Originally created by @HNGamingUK on GitHub (May 17, 2019).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/146

Hello, so I am using the latest linuxserver/mariadb container at the time of writing this but when I run the nginx-proxy-manager (with config) it starts but then gets the following error:

create table auth (idint unsigned not null auto_increment primary key,created_ondatetime not null,modified_ondatetime not null,user_idint unsigned not null,typevarchar(30) not null,secretvarchar(255) not null,metajson not null,is_deletedint unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null,is_deleted int unsigned not null default '0')' at line 1

Any Ideas on how to resolve this?

Originally created by @HNGamingUK on GitHub (May 17, 2019). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/146 Hello, so I am using the latest linuxserver/mariadb container at the time of writing this but when I run the nginx-proxy-manager (with config) it starts but then gets the following error: `create table `auth` (`id` int unsigned not null auto_increment primary key, `created_on` datetime not null, `modified_on` datetime not null, `user_id` int unsigned not null, `type` varchar(30) not null, `secret` varchar(255) not null, `meta` json not null, `is_deleted` int unsigned not null default '0') - ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, `is_deleted` int unsigned not null default '0')' at line 1` Any Ideas on how to resolve this?

kerem closed this issue

2026-02-26 06:30:29 +03:00

kerem commented

2026-02-26 06:30:30 +03:00

Author

Owner

@jc21 commented on GitHub (May 20, 2019):

I really doubt you're using the latest maria db at all. Json field support was added in 10.2.7.

@jc21 commented on GitHub (May 20, 2019): I really doubt you're using the latest maria db at all. Json field support was added in 10.2.7.

kerem commented

2026-02-26 06:30:30 +03:00

Author

Owner

@HNGamingUK commented on GitHub (May 20, 2019):

It seems that I need to get a new Pi as the current one is Arm32 bit and newer versions of MariaDB aren't available for it.

I have ordered a new Pi with 64Bit chip and will install Ubuntu on it. That should work, as such I will close this. Sorry to be an inconvenience.

@HNGamingUK commented on GitHub (May 20, 2019): It seems that I need to get a new Pi as the current one is Arm32 bit and newer versions of MariaDB aren't available for it. I have ordered a new Pi with 64Bit chip and will install Ubuntu on it. That should work, as such I will close this. Sorry to be an inconvenience.

kerem commented

2026-02-26 06:30:30 +03:00

Author

Owner

@talondnb commented on GitHub (Sep 22, 2019):

Just wanted to post this as I managed to get it running on a RPI 3B:

version: "3"
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
    volumes:
      # Make sure this config.json file exists as per instructions above:
      - ./config.json:/app/config/production.json
      - ./data:/data
      - ./letsencrypt:/etc/letsencrypt
    depends_on:
      - db
  db:
    image: yobasystems/alpine-mariadb:latest
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: "npm"
      MYSQL_DATABASE: "npm"
      MYSQL_USER: "npm"
      MYSQL_PASSWORD: "password"
    volumes:
      - ./data/mysql:/var/lib/mysql

@talondnb commented on GitHub (Sep 22, 2019): Just wanted to post this as I managed to get it running on a RPI 3B: ``` version: "3" 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 volumes: # Make sure this config.json file exists as per instructions above: - ./config.json:/app/config/production.json - ./data:/data - ./letsencrypt:/etc/letsencrypt depends_on: - db db: image: yobasystems/alpine-mariadb:latest restart: always environment: MYSQL_ROOT_PASSWORD: "npm" MYSQL_DATABASE: "npm" MYSQL_USER: "npm" MYSQL_PASSWORD: "password" volumes: - ./data/mysql:/var/lib/mysql ```

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#128

No description provided.

Rows
Columns