Comments (3)
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.
from clarkson.
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
from clarkson.
Nope same problem
from clarkson.
Related Issues (20)
- Change Base URL HOT 3
- Maintenance log HOT 3
- User not found HOT 6
- Persisted Login HOT 3
- Incorrect MPG Calculation HOT 6
- Clarkson needs a refresh HOT 2
- Curious what the timezone does? HOT 2
- Feature requests HOT 7
- User registration doesn't work HOT 18
- importing data HOT 1
- feature request: format currency with standard amount of decimals
- feature request: display total cost in fill-up log
- Add Electric Car HOT 1
- Feature requests HOT 2
- Feature Request
- Where would I get the setting on what units are set via API?
- Feature Request? HOT 2
- Deprecation warnings
- Login page not showing on browser
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from clarkson.