linuxserver
Not redirected to Dashboard
This is such a weird bug that I'm thinking it's something I've done wrong...
The Clarkson container starts up right after the db container finishes starting up. Clarkson populated the schema and seems to be working perfectly.
On the login screen I can register multiple users. When I enter the username and password correctly, nothing happens. When I enter a user that doesn't exist, it tells me "User not found". If I enter the password wrong it tells me "Incorrect password".
But when everything should be correct, it is as if the page authenticates and then stops.
I've looked at the network debug and when there is an invalid login the "/api/auth/authenticate" returns a 403 (forbidden) error. If the login is valid the response is 200 (ok).
Hi, are you able to provide a bit more information?
How are you deploying Clarkson? (Docker, natively etc). If natively which node version are you running? If via Docker, what was your command config?
Are you running MySQL or MariaDB as the backend? Clarkson hasn't been tested on MySQL 5.8+ as it uses Flyway as the migration tool and I'm unsure if it's compatible. It is compatible with MySQL 5.7 and (apparently) MariaDB 10.3.17.
I've just fired up an instance of Clarkson via Docker (latest tag) against both MySQL and MariaDB, and it's working OK.
Cheers.
Docker and linuxserver:latest Ruining with MariaDB 10.3.17 (Clarkson reports 10.3)
But looking at the logs now I see something weird: for some reason its trying to access the dataqbase 9666034a-aae7-40e3-a0e5-3a00a7c2c65d
There is no database like that in MariaDB.
-------------------------------------
GID/UID
-------------------------------------
usermod: no changes
User uid: 1003
User gid: 100
-------------------------------------
[cont-init.d] 10-adduser: exited 0.
[cont-init.d] 30-migrate: executing...
---------------------
Migrating database...
---------------------
Flyway 4.2.0 by Boxfuse
Database: jdbc:mysql://ClarksonDB:3306/ (MySQL 10.3)
Successfully validated 31 migrations (execution time 00:00.238s)
WARNING: Unable to restore connection to having no default schema: Access denied for user 'clarkson_usr'@'%' to database '9666034a-aae7-40e3-a0e5-3a00a7c2c65d'
Query is : CREATE SCHEMA `9666034a-aae7-40e3-a0e5-3a00a7c2c65d`
Current version of schema `clarkson`: 1.30
Schema `clarkson` is up to date. No migration necessary.
[cont-init.d] 30-migrate: exited 0.
[cont-init.d] 99-custom-files: executing...
[custom-init] no custom files found exiting...
[cont-init.d] 99-custom-files: exited 0.
[cont-init.d] done.
[services.d] starting services
------------------
Starting Clarkson.
------------------
[services.d] done.
(node:241) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
(node:241) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
The yaml I used looks like this:
clarkson:
image: linuxserver/clarkson
container_name: Clarkson
environment:
- PUID=1003
- PGID=100
- MYSQL_HOST=ClarksonDB
- MYSQL_USERNAME=clarkson_usr
- MYSQL_PASSWORD=clarkson_pwd
- ENABLE_REGISTRATIONS=true
- TZ=Africa/Johannesburg
networks:
- outside
- default
depends_on:
- mariadb
restart: unless-stopped
mariadb:
image: linuxserver/mariadb
container_name: ClarksonDB
environment:
- PUID=1003
- PGID=100
- MYSQL_ROOT_PASSWORD=[SUPERSECURE]
- TZ=Africa/Johannesburg
- MYSQL_DATABASE=clarkson #optional
- MYSQL_USER=clarkson_usr #optional
- MYSQL_PASSWORD=clarkson_pwd #optional
volumes:
- /share/ContainTheData/Clarkson/MariaDB:/config
expose:
- "3306"
restart: unless-stopped
The Maria DB privleges look like this
+-------------------------------------------------------------------------------------------------------------+
| Grants for clarkson_usr@% |
+-------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'clarkson_usr'@'%' IDENTIFIED BY PASSWORD '*50F9E8AFFA6210AE828B9A4704013993EB6EC0A0' |
| GRANT ALL PRIVILEGES ON `clarkson`.* TO 'clarkson_usr'@'%' |
+-------------------------------------------------------------------------------------------------------------+
I'll try with MySQL now