starred/nginx-proxy-manager-NginxProxyManager

Fork 0

mirror of https://github.com/NginxProxyManager/nginx-proxy-manager.git synced 2026-04-25 09:25:55 +03:00

[GH-ISSUE #72] ARMHF: Database won't initialize #69

New issue

Closed

opened 2026-02-26 05:34:05 +03:00 by kerem · 3 comments

kerem commented

2026-02-26 05:34:05 +03:00

Owner

Originally created by @xdasqurl on GitHub (Feb 18, 2019).
Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/72

Hi, I'm running the official jc21/nginx-proxy-manager:2-armhf image, upon starting the container I can see in the logs that the DB can't be initialized:

[2/18/2019] [3:20:07 PM] [Migrate ] › ℹ info Current database version: none [2/18/2019] [3:20:07 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up... migration file "20190104035154_disabled.js" failed migration failed with 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_deletedint unsigned not null default '0')' at line 1 [2/18/2019] [3:20:07 PM] [Global ] › ✖ error create tableauth (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

This is how my config.json looks like:

{ "database": { "engine": "mysql", "host": "192.168.1.xx", "name": "proxymanager", "user": "proxymanager", "password": "obfuscated", "port": 3306 } }

I'm running MariaDB, there seems to be nothing wrong with the DB as other apps are able to use it just fine. Any clue as to what might be wrong? Any suggestions or a nudge in the right direction will be much appreciated.

Thanks.

Originally created by @xdasqurl on GitHub (Feb 18, 2019). Original GitHub issue: https://github.com/NginxProxyManager/nginx-proxy-manager/issues/72 Hi, I'm running the official jc21/nginx-proxy-manager:2-armhf image, upon starting the container I can see in the logs that the DB can't be initialized: `[2/18/2019] [3:20:07 PM] [Migrate ] › ℹ info Current database version: none [2/18/2019] [3:20:07 PM] [Migrate ] › ℹ info [initial-schema] Migrating Up... migration file "20190104035154_disabled.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/18/2019] [3:20:07 PM] [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` This is how my config.json looks like: `{ "database": { "engine": "mysql", "host": "192.168.1.xx", "name": "proxymanager", "user": "proxymanager", "password": "obfuscated", "port": 3306 } } ` I'm running MariaDB, there seems to be nothing wrong with the DB as other apps are able to use it just fine. Any clue as to what might be wrong? Any suggestions or a nudge in the right direction will be much appreciated. Thanks.

kerem

2026-02-26 05:34:05 +03:00

closed this issue
added the
product-support
label

kerem commented

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

Author

Owner

@xdasqurl commented on GitHub (Feb 18, 2019):

Sorry for the weird formatting, not sure what happened

@xdasqurl commented on GitHub (Feb 18, 2019): Sorry for the weird formatting, not sure what happened

kerem commented

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

Author

Owner

@jc21 commented on GitHub (Feb 18, 2019):

So the version of Maria is probably old. The json field type was added in 10.2.7. Check the version and see if you can upgrade.

@jc21 commented on GitHub (Feb 18, 2019): So the version of Maria is probably old. The `json` field type was added in 10.2.7. Check the version and see if you can upgrade.

kerem commented

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

Author

Owner

@xdasqurl commented on GitHub (Feb 19, 2019):

Yup, that was it. Thanks, much appreciated,

@xdasqurl commented on GitHub (Feb 19, 2019): Yup, that was it. Thanks, much appreciated,

kerem referenced this issue

2026-02-26 07:38:36 +03:00

[PR #433] [MERGED] Add the ability to secure proxy hosts with OpenID Connect #3247

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

No description provided.

Rows
Columns