mariadb #758

New issue

Closed

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

kerem commented

2026-02-26 06:34:17 +03:00

Owner

Originally created by @LogicalUnit on GitHub (Feb 17, 2021).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/896

Hello, I am trying to set up a reverse proxy on my Raspberry Pi 4. I am using Open Media Vault and Portainer. Nginx Reverse Proxy Manager works just fine with MariaDB when I run the database as a normal service installed with apt-get. However, when I try to use the MariaDB container provided by the linuxserver group, I get an error related to applying the initial database migrations. I can connect to the MariaDB container from the command line, and create new schemas and tables, etc.

Here is the error I get when trying to start the Nginx Reverse Proxy container:

[2/17/2021] [2:52:47 AM] [Migrate  ] › ℹ  info      Current database version: none
[2/17/2021] [2:52:47 AM] [Migrate  ] › ℹ  info      [initial-schema] Migrating Up...
migration file "20180618015850_initial.js" failed
migration failed with 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
[2/17/2021] [2:52:47 AM] [Global   ] › ✖  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

Here is a copy of my config file

{
  "database": {
    "engine": "mysql",
    "host": "192.168.1.110",
    "name": "reverseproxydb",
    "user": "root",
    "password": <removed>,
    "port": 3306
  },
  "jwt": {
    "key": "-----BEGIN RSA PRIVATE KEY-----
     <removed>
    "pub": "-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0JEuTnreXADUMaTmbb6L\nDhGsrHcyb2qu7VxCBg2BtFM5JsrO0lfh/ljFf3MA+lY+ABV6jU$
  }

Any help is appreciated. Thanks

Originally created by @LogicalUnit on GitHub (Feb 17, 2021). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/896 Hello, I am trying to set up a reverse proxy on my Raspberry Pi 4. I am using Open Media Vault and Portainer. Nginx Reverse Proxy Manager works just fine with MariaDB when I run the database as a normal service installed with apt-get. However, when I try to use the MariaDB container provided by the linuxserver group, I get an error related to applying the initial database migrations. I can connect to the MariaDB container from the command line, and create new schemas and tables, etc. Here is the error I get when trying to start the Nginx Reverse Proxy container: ``` [2/17/2021] [2:52:47 AM] [Migrate ] › ℹ info Current database version: none [2/17/2021] [2:52:47 AM] [Migrate ] › ℹ info [initial-schema] Migrating Up... migration file "20180618015850_initial.js" failed migration failed with 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 [2/17/2021] [2:52:47 AM] [Global ] › ✖ 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 ``` Here is a copy of my config file ```json { "database": { "engine": "mysql", "host": "192.168.1.110", "name": "reverseproxydb", "user": "root", "password": <removed>, "port": 3306 }, "jwt": { "key": "-----BEGIN RSA PRIVATE KEY----- <removed> "pub": "-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA0JEuTnreXADUMaTmbb6L\nDhGsrHcyb2qu7VxCBg2BtFM5JsrO0lfh/ljFf3MA+lY+ABV6jU$ } ``` Any help is appreciated. Thanks

kerem closed this issue

2026-02-26 06:34:17 +03:00

kerem commented

2026-02-26 06:34:18 +03:00

Author

Owner

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

It seems ghcr.io/linuxserver/mariadb does not support JSON data types. Have a look over at issue https://github.com/jc21/nginx-proxy-manager/issues/212, specifically the link in https://github.com/jc21/nginx-proxy-manager/issues/212#issuecomment-839744608. Use the db docker image suggested there, that seems to work for others.

@chaptergy commented on GitHub (May 25, 2021): It seems `ghcr.io/linuxserver/mariadb` does not support JSON data types. Have a look over at issue https://github.com/jc21/nginx-proxy-manager/issues/212, specifically the link in https://github.com/jc21/nginx-proxy-manager/issues/212#issuecomment-839744608. Use the db docker image suggested there, that seems to work for others.

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

No description provided.

Rows
Columns