ARMHF: Database won't initialize #72
Description
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.