linuxserver / clarkson Goto Github PK

Web-based fuel logging dashboard

License: MIT License

JavaScript 21.79% Shell 1.04% Batchfile 0.76% TypeScript 46.28% HTML 28.94% CSS 1.19%

clarkson's Introduction

This project is no longer under development. The codebase is extrememly out of date and requires a ground-up rewrite. No further features will be added, and no PRs will be merged in. I truly appreciate the response this application got, but I chose poorly when it came to the language/framework. Using Angular2 when it was just starting out and thus quite volatile and open to change wans't a smart move. As such, most of the code is now either deprecated or requires updates. I unfortunately don't have the time to do this.

A spiritual successor to Clarkson is now in development, called Hammond. I highly recommend people check it out: https://github.com/akhilrex/hammond

Clarkson

Clarkson is a web-based dashboard application that gives you a neat and clean interface for logging your fuel fill-ups for all of your vehicles. The application has full multi-user support, as well as multiple vehicles per user. Whenever you fill-up your car or motorcycle, keep the receipt and record the data in Clarkson.

Screenshot

Features

Dashboard giving you high-level statistics on your vehicle fill-ups, including:
- Total spent on fill-ups on all your vehicles
- Total distance traveled
- Graphs showing fuel consumption trends
Add/edit/remove an unlimited number of vehicles
- Include basic information such as Make, Model, Registration, VIN, Fuel Type
Add/edit/remove fuel fill-ups
- Total cost or unit cost will be automatically calculated as you enter the data
- Include any notes
- Inform the app whether or not the fill-up was to the top (full tank), or if you missed any previous fill-ups
Choose your units - available settings:
- Fuel Units: Litres, Gallons, or US Gallons
- Consumption Units: MPG, L/100KM
- Distance Units: Miles, Kilometres
- Currency Units: GBP, USD, EUR, AUD, CAD

Running the application

Clarkson has an Angular front-end, with ExpressJS backend, connecting to a MySQL database (Supported version v5.7.*). It uses Flyway as a means of managing incremental migrations of the database schema.

Get the dependencies

To get the application running, you'll need node and npm installed. Firstly, install the angular-cli (plus ts dependencies):

npm install -g @angular/cli ts-node typescript

Then grab all of the dependencies for the app itself:

npm install

Set up the frontend config

Depending on how you run the application, you'll need to update the src/environments/environment.prod.ts file so the frontend points to the right server URL:

export const environment = {
    production: true,
    apiBaseUrl: 'https://your-domain-here/api' // or use 'http://<local_network_ip>:3000' if not behind a reverse proxy
};

Build

Once you're happy with the endpoint in config, build the frontend:

ng build --prod

This will create a dist/ directory, which is where the frontend gets served.

Migrate the database

Before you run the application, you'll need to run a database migration using flyway. This will create the schema and initial tables/procedures that are used by Clarkson. To do this, run:

./flyway/flyway -user=<mysql_user> -password=<mysql_user> -schemas=clarkson -url=jdbc:mysql://<mysql_host_ip> migrate

Note: The -user, -password and -url values must match those that you use when running the application (see below).

JRE: Flyway is a Java tool, so requires the JRE to be available in $PATH. It is not packaged as part of this application due to variations in OS requirements.

Start the app

Finally, start the application by running:

MYSQL_HOST=<mysql_host_ip> MYSQL_USERNAME=<mysql_user> MYSQL_PASSWORD=<mysql_user> ENABLE_REGISTRATIONS=true APP_PORT=3000 node clarkson.js

Environment variables at startup:

Env	Required?	Used for
MYSQL_HOST	Yes	Points the backend to the MySQL database
MYSQL_USERNAME	Yes	The user with access to the clarkson schema
MYSQL_PASSWORD	Yes	The password for the user
ENABLE_REGISTRATIONS	No	Defaults to false. If set to true, allows new users to register
APP_PORT	No	Defaults to 3000. Changes the running port of the application

Credits

Web Framework: Angular
Server: ExpressJS
Security: Helmet
Charts: ChartJS
Charts: ng2-charts
Theme: Bootstrap
Theme: Bootswatch
Flash Notifications: angular2-flash-messages

clarkson's People

Contributors

Stargazers

Watchers

Forkers

mahlerchen ko351555 max-z80 christofp whi-tw clarionhoover homeincorporated rob1998 iskandarsaleh fedepujol meetlily oasis256 compil3 isabella232

clarkson's Issues

Feature Request

Would it be possible to add maintenance reminders for vehicles, mainly based off mileage. Things like oil changes every 5,000 miles, or serpentine belt every 60,000 miles. Things like that, and maybe customizable so that you can add/remove types of routine maintenance based on your vehicle.

fuel consumption graphs keep on expanding in height.

After I entered some random values, the fuel consumption graph keeps on expanding in height, apparently one pixel at a time. Maybe related, the cpu resource consumption is very high when the dashboard is displayed.
Bug occurs on firefox 52.7.3. Is it because my browser is too old ?

MySQL -e environment passed, but log states password: no

Hi, I created the app with the following command in docker,

docker run -d --net clarkson_nw --name=clarkson_app -e MYSQL_HOST=clarkson_db -e MYSQL_USERNAME=clarkson -e MYSQL_PASSWORD=secret -e ENABLE_REGISTRATIONS=false -p 3000:3000 linuxserver/clarkson

and on app startup, I get this error, complete error is on hastebin link below.

Unable to obtain Jdbc connection from DataSource (jdbc:mysql://clarkson_db:3306) for user 'clarkson': Could not connect: Access denied for user 'clarkson'@'172.27.0.3' (using password: NO)

https://hastebin.com/putogovaqa.cs

Incorrect MPG Calculation

While I would love to get this kind of mileage from this car, it's just not right... All of the mpg calculations are incorrect.

Example:

240 miles divided by 10.65 gallons = 22.54 mpg, not the 27.06 displayed.

Add Electric Car

I have on petrol and one electric car.
It would be nice if I could track both.

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).

Where would I get the setting on what units are set via API?

I'm looking to be able to tell if the default units is Gal or Liters via api

feature request: format currency with standard amount of decimals

If gas is $1.80 a gallon, the fill-up list displays this as $1.8. This could be fixed by adding something similar to line 30 of the same component: https://github.com/linuxserver/Clarkson/blob/master/src/app/components/fuel-list/fuel-list.component.html#L30

I however am not sure if this is applicable to all currencies.

Clarkson needs a refresh

I wrote this project as a hobby back when I was interested in understanding the economy on my vehicles as I commuted to work. I'm really happy it picked up interest and it's great that people are using it.

Unfortunately I decided to write it in Angular 2 right at the point where the Angular project was propelling itself at an astronomical rate. The side-effect of this is that the codebase for Clarkson is woefully out of date now. Case in point is I needed to make a two-line bugfix but in doing so would need to completely rebuild the project and update its dependencies.

This issue is to serve more as a notice that I understand and am aware that the project could use a bit of TLC but my time is a bit stretched at the moment as my wife and I are expecting our first child in the next few months. I'm happy to keep maintaining this project but any maintenance or improvements will be a bit few and far between.

If anyone wishes to help support this project with extra development work, it's more than welcome.

Thanks again for using this app!

Unable to install new instance

MySQL Server version: 5.5.58-0ubuntu0.14.04.1 - (Ubuntu) (also in a docker-container)

As directions have indicated I created the clarkson user on the mysql server first... but when first 'migrating' the db it threw the following error. Can a DATETIME not really have a default value of CURRENT_TIMESTAMP? should the field be a TIMESTAMP instead of DATETIME?

clarkson-clarkson-1 | 2018-09-08T17:52:16.227421828Z [s6-init] ensuring user provided files have correct perms...exited 0.
clarkson-clarkson-1 | 2018-09-08T17:52:16.233890017Z [fix-attrs.d] applying ownership & permissions fixes...
clarkson-clarkson-1 | 2018-09-08T17:52:16.240732549Z [fix-attrs.d] done.
clarkson-clarkson-1 | 2018-09-08T17:52:16.244915938Z [cont-init.d] executing container initialization scripts...
clarkson-clarkson-1 | 2018-09-08T17:52:16.251734920Z [cont-init.d] 10-adduser: executing...
clarkson-clarkson-1 | 2018-09-08T17:52:16.299978837Z
clarkson-clarkson-1 | 2018-09-08T17:52:16.300022228Z -------------------------------------
clarkson-clarkson-1 | 2018-09-08T17:52:16.300034348Z           _         ()
clarkson-clarkson-1 | 2018-09-08T17:52:16.300045463Z          | |  ___   _    __
clarkson-clarkson-1 | 2018-09-08T17:52:16.300067923Z          | | / __| | |  /  \
clarkson-clarkson-1 | 2018-09-08T17:52:16.300079389Z          | | \__ \ | | | () |
clarkson-clarkson-1 | 2018-09-08T17:52:16.300093123Z          |_| |___/ |_|  \__/
clarkson-clarkson-1 | 2018-09-08T17:52:16.300104969Z
clarkson-clarkson-1 | 2018-09-08T17:52:16.300117005Z
clarkson-clarkson-1 | 2018-09-08T17:52:16.300127583Z Brought to you by linuxserver.io
clarkson-clarkson-1 | 2018-09-08T17:52:16.300139040Z We gratefully accept donations at:
clarkson-clarkson-1 | 2018-09-08T17:52:16.300149737Z https://www.linuxserver.io/donate/
clarkson-clarkson-1 | 2018-09-08T17:52:16.300161560Z -------------------------------------
clarkson-clarkson-1 | 2018-09-08T17:52:16.300172393Z GID/UID
clarkson-clarkson-1 | 2018-09-08T17:52:16.300183067Z -------------------------------------
clarkson-clarkson-1 | 2018-09-08T17:52:16.313654571Z                                                                                                                             
clarkson-clarkson-1 | 2018-09-08T17:52:16.313696495Z User uid:    1000
clarkson-clarkson-1 | 2018-09-08T17:52:16.313714303Z User gid:    1000
clarkson-clarkson-1 | 2018-09-08T17:52:16.313725115Z -------------------------------------
clarkson-clarkson-1 | 2018-09-08T17:52:16.313735783Z
clarkson-clarkson-1 | 2018-09-08T17:52:16.330959565Z [cont-init.d] 10-adduser: exited 0.
clarkson-clarkson-1 | 2018-09-08T17:52:16.335975303Z [cont-init.d] 30-migrate: executing...
clarkson-clarkson-1 | 2018-09-08T17:52:16.348901009Z ---------------------
clarkson-clarkson-1 | 2018-09-08T17:52:16.349032715Z Migrating database...
clarkson-clarkson-1 | 2018-09-08T17:52:16.349051812Z ---------------------
clarkson-clarkson-1 | 2018-09-08T17:52:16.640726984Z Flyway 4.2.0 by Boxfuse
clarkson-clarkson-1 | 2018-09-08T17:52:16.640817999Z
clarkson-clarkson-1 | 2018-09-08T17:52:16.906545452Z Database: jdbc:mysql://db:3306/ (MySQL 5.5)
clarkson-clarkson-1 | 2018-09-08T17:52:17.087193102Z Successfully validated 31 migrations (execution time 00:00.074s)
clarkson-clarkson-1 | 2018-09-08T17:52:17.126228496Z WARNING: Unable to restore connection to having no default schema: Access denied for user 'clarkson'@'%' to database 'b1d154
ba-ef3c-4d26-bfd6-b8411493c6ff'
clarkson-clarkson-1 | 2018-09-08T17:52:17.126273000Z Query is : CREATE SCHEMA `b1d154ba-ef3c-4d26-bfd6-b8411493c6ff`
clarkson-clarkson-1 | 2018-09-08T17:52:17.151940934Z Creating Metadata table: `clarkson`.`schema_version`
clarkson-clarkson-1 | 2018-09-08T17:52:19.955200766Z Current version of schema `clarkson`: << Empty Schema >>
clarkson-clarkson-1 | 2018-09-08T17:52:20.423081320Z Migrating schema `clarkson` to version 1.0 - Create Tables
clarkson-clarkson-1 | 2018-09-08T17:52:28.993612011Z ERROR: Migration of schema `clarkson` to version 1.0 - Create Tables failed! Please restore backups and roll back database a
nd code!
clarkson-clarkson-1 | 2018-09-08T17:52:29.294052489Z ERROR:
clarkson-clarkson-1 | 2018-09-08T17:52:29.294402773Z Migration V1.0__Create_Tables.sql failed
clarkson-clarkson-1 | 2018-09-08T17:52:29.294423410Z ----------------------------------------
clarkson-clarkson-1 | 2018-09-08T17:52:29.294439181Z SQL State  : 42000
clarkson-clarkson-1 | 2018-09-08T17:52:29.294451387Z Error Code : 1067
clarkson-clarkson-1 | 2018-09-08T17:52:29.294468928Z Message    : Invalid default value for 'date'
clarkson-clarkson-1 | 2018-09-08T17:52:29.294479755Z Query is : CREATE  TABLE `Fuel` (
clarkson-clarkson-1 | 2018-09-08T17:52:29.294502488Z     `id`                    VARCHAR(36)     NOT NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294513936Z     `vehicle`               VARCHAR(36)     NOT NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294524718Z     `date`                  DATETIME        NOT NULL DEFAULT CURRENT_TIMESTAMP,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294535727Z     `fuelAmount`            DECIMAL(5,2)    NOT NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294552338Z     `totalCost`             DECIMAL(5,2)    NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294563150Z     `fuelUnitCost`          DECIMAL(5,3)    NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294573872Z     `locationLatitude`      DECIMAL(10,8)   NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294584794Z     `locationLongitude`     DECIMAL(11,8)   NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294608986Z     `odometerReading`       INT(11)         NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294619723Z     `notes`                 TEXT            NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294630828Z     `fullTank`              TINYINT(1)      NULL DEFAULT 1,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294641574Z     `missedFillUp`          TINYINT(1)      NULL DEFAULT 0,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294652620Z     PRIMARY KEY (`id`),
clarkson-clarkson-1 | 2018-09-08T17:52:29.294664053Z     UNIQUE INDEX `id_UNIQUE` (`id` ASC),
clarkson-clarkson-1 | 2018-09-08T17:52:29.294680327Z     INDEX `FK_fuel_vehicleId_idx` (`vehicle` ASC),
clarkson-clarkson-1 | 2018-09-08T17:52:29.294691313Z     CONSTRAINT `FK_fuel_vehicleId` FOREIGN KEY (`vehicle`) REFERENCES `Vehicles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACT
ION
clarkson-clarkson-1 | 2018-09-08T17:52:29.294712640Z )
clarkson-clarkson-1 | 2018-09-08T17:52:29.294723142Z Location   : /app/clarkson/flyway/sql/V1.0__Create_Tables.sql (/app/clarkson/flyway/sql/V1.0__Create_Tables.sql)
clarkson-clarkson-1 | 2018-09-08T17:52:29.294740299Z Line       : 85
clarkson-clarkson-1 | 2018-09-08T17:52:29.294750805Z Statement  : CREATE  TABLE `Fuel` (
clarkson-clarkson-1 | 2018-09-08T17:52:29.294763149Z     `id`                    VARCHAR(36)     NOT NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294781932Z     `vehicle`               VARCHAR(36)     NOT NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294827654Z     `date`                  DATETIME        NOT NULL DEFAULT CURRENT_TIMESTAMP,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294864418Z     `fuelAmount`            DECIMAL(5,2)    NOT NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.294875152Z     `totalCost`             DECIMAL(5,2)    NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.295188690Z     `fuelUnitCost`          DECIMAL(5,3)    NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.295250038Z     `locationLatitude`      DECIMAL(10,8)   NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.295263190Z     `locationLongitude`     DECIMAL(11,8)   NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.295275067Z     `odometerReading`       INT(11)         NULL,                                                                           
clarkson-clarkson-1 | 2018-09-08T17:52:29.295286098Z     `notes`                 TEXT            NULL,
clarkson-clarkson-1 | 2018-09-08T17:52:29.295301967Z     `fullTank`              TINYINT(1)      NULL DEFAULT 1,
clarkson-clarkson-1 | 2018-09-08T17:52:29.295314333Z     `missedFillUp`          TINYINT(1)      NULL DEFAULT 0,
clarkson-clarkson-1 | 2018-09-08T17:52:29.295327206Z     PRIMARY KEY (`id`),
clarkson-clarkson-1 | 2018-09-08T17:52:29.295340291Z     UNIQUE INDEX `id_UNIQUE` (`id` ASC),
clarkson-clarkson-1 | 2018-09-08T17:52:29.295377329Z     INDEX `FK_fuel_vehicleId_idx` (`vehicle` ASC),
clarkson-clarkson-1 | 2018-09-08T17:52:29.295393768Z     CONSTRAINT `FK_fuel_vehicleId` FOREIGN KEY (`vehicle`) REFERENCES `Vehicles` (`id`) ON DELETE NO ACTION ON UPDATE NO ACT
ION
clarkson-clarkson-1 | 2018-09-08T17:52:29.295405162Z )
clarkson-clarkson-1 | 2018-09-08T17:52:29.295421995Z
clarkson-clarkson-1 | 2018-09-08T17:52:29.350079849Z [cont-init.d] 30-migrate: exited 1.
clarkson-clarkson-1 | 2018-09-08T17:52:29.418470623Z [cont-finish.d] executing container finish scripts...
clarkson-clarkson-1 | 2018-09-08T17:52:29.431934795Z [cont-finish.d] done.
clarkson-clarkson-1 | 2018-09-08T17:52:29.434439331Z [s6-finish] syncing disks.
clarkson-clarkson-1 | 2018-09-08T17:52:29.645037068Z [s6-finish] sending all processes the TERM signal.
clarkson-clarkson-1 | 2018-09-08T17:52:32.684926536Z [s6-finish] sending all processes the KILL signal and exiting.

EDIT: using docker-compose to set it up... here is my config:

services:
  clarkson:
    image: linuxserver/clarkson
    environment:
      ENABLE_REGISTRATIONS: 'true'
      MYSQL_HOST: db
      MYSQL_PASSWORD: <password>
      MYSQL_USERNAME: clarkson
      PGID: '1000'
      PUID: '1000'
    external_links:
    - mysql/mysql:db
    logging:
      driver: json-file
      options:
        max-file: '50'
        max-size: 500k

        
# CREATE SCHEMA `clarkson`;
# CREATE USER 'clarkson' IDENTIFIED BY '<password>';
# GRANT ALL ON `clarkson`.* TO 'clarkson';

testing again

test

Login page not showing on browser

Hello,

I have a strange problem.
I use Clarkson now for a while in a docker container on a VPS.
I have created a shortcut on my iphone to acess it and it works really fine.
I can connect, add fill ups etc etc

But...

When I try to acces it using a regular browser and the standart url (my.website.url/clarkson) (I have a nginx rule) I only have a blank page... no logging page... with this source code

<!doctype html><html lang="en"><head><meta charset="utf-8"><title>Clarkson</title><base href="/"><meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=1,user-scalable=no"/><link rel="apple-touch-icon" sizes="180x180" href="apple-touch-icon.png"><link rel="icon" type="image/x-icon" href="favicon.ico"><link rel="icon" type="image/png" sizes="32x32" href="favicon-32x32.png"><link rel="icon" type="image/png" sizes="16x16" href="favicon-16x16.png"><link rel="manifest" href="site.webmanifest"><link rel="mask-icon" href="safari-pinned-tab.svg" color="#5bbad5"><meta name="msapplication-TileColor" content="#da532c"><meta name="theme-color" content="#ffffff"><link href="assets/vendor/css/bootstrap.min.css" rel="stylesheet"><script defer="defer" src="assets/vendor/js/fontawesome-all.min.js"></script><link href="styles.3c28d03cf5418d95d4df.bundle.css" rel="stylesheet"/></head><body><app-root></app-root><script src="assets/vendor/js/jquery-3.2.1.min.js"></script><script src="assets/vendor/js/bootstrap.bundle.min.js"></script><script src="assets/vendor/js/Chart.bundle.min.js"></script><script type="text/javascript" src="inline.318b50c57b4eba3d437b.bundle.js"></script><script type="text/javascript" src="polyfills.eed1d3601d005a257b2d.bundle.js"></script><script type="text/javascript" src="main.9d4a4ef9ec72efb86364.bundle.js"></script></body></html>

Also

Trying to acces it using my.website.url:3000 gives me an error

on Chrome : ERR_SSL_PROTOCOL_ERROR
on Firefox : SSL_ERROR_RX_RECORD_TOO_LONG

Change Base URL

I am trying to put Clarkson behind a reverse proxy at https://site.domain.tld/clarkson. It is failing because Clarkson is setting <base href="/">. This means it tries to load the resources from https://site.domain/tld/ instead. How/Where can I change the base href?

Feature Request?

A few things I was wondering if they could be added?

I notice there is a Vehicle Picture field in the DB Schema, How difficult would it be to have that implemented into the Add/Edit Vehicle page?

On the Fill-Ups, could a manual date entry be added? Sometimes we (as a family) go on weekend trips and data may not be entered in until a few days after we return, Could we have a filed that if no date is entered, use the current time, but if a date is selected or entered use that date?

blah again

some text here

Deprecation warnings

I noticed these deprecation warnings being emitted during my initial setup of Clarkson in a testing environment:

clarkson_1  | (node:275) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
clarkson_1  | (node:275) [DEP0126] DeprecationWarning: timers.active() is deprecated. Please use timeout.refresh() instead.
clarkson_1  | (node:275) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.

Persisted Login

Currently the login expires after 1 hour, even if you are continually using the app. Is it possible to implement a more sophisticated authentication system that would be able to persist logins, for example by using refresh tokens for example? It's not ideal that you have to login every time in order to add a record.

I am currently looking into building a mobile app that would allow you to do fuel-ups from your phone more easily, however not having this kind of persistent login would make having the app mostly irrelevant (without me saving the username and password directly, which is obviously not what I want to do ideally).

Is there any chance you would want to look into getting something like this implemented?

PS: Some API docs for the backend would be neat 😉

Maintenance log

Would it be possible to add a maintenance log? Just a simple field that keeps the date and a short comment of what was done that is bound to a vehicle?

last ever test

Feature requests

I have several feature request that I think will make Clarkson much more usable and user friendly.

There should be an option for creating a custom currency.
The total amount of money for one refuel for now is limited to 999. It should allow more - if there is a custom currency.
When clicking on the date when the refuel was made - there should be a calendar popping up, so it will make the input of date so much easier.
The field for how much liters have been poured in the tank, should be calculated (auto completed), if you input the total money you spent and the price per liter.

I would like to hear some feedback on there requests - if they sound reasonable or not.

Feature requests

Hello
just installed and some ideas ;

fuel type subcategories : E98, E95...
transalation : i will be happy to help translate into french
set a default vehicule

Unable to register on initial application start "Registrations are Closed"

Hi,

Got the application installed, and tried to register initial user and get an error message that "Registrations Are Closed" I'm assuming because the ENABLE_REGISTRATIONS is set to false by default. How do I register an initial admin account?

blah test

ignore just testing new webhook isn't building everything

Cannot install Clarkson

Hello,
I've tried installing Clarkson but failed.
I tried the instructions step by step. OS: Ubuntu Server 22.04.3 LTS
Installing NodeJS with the command from the following website:
https://deb.nodesource.com
Installing NPM via apt (sudo apt install npm)
Then running the commands from "Get the dependencies" https://github.com/linuxserver/Clarkson
It always throws errors. I don't know where I have to clone the Git repository to etc.
Is there a full guide available?
I am pretty much a noob at Linux, know some basic stuff.

Greetings from Germany
Max

feature request: display total cost in fill-up log

When I get home, I add my fillup to Firefly, and the only way I can see it is by editing. It would be nice to see the total cost in the fill-up log.

User not found

Hi all,

Clarkson is on the same network as my MYSQL. It has been working, but I only log-in once a week or so. - I noticed that Clarkson was upgraded. yay...
Now, however when I try to login, clarkson writes: "User not found".
Terminal log: All migrations complete.
In the db my username is correct. Password is hashed. How to reset the password, or do anybody else have this problem?

importing data

is there a way data can be imported directly into the fuel table for example? would it be possible to do via a sql query?
the id column looks to be a guid so not auto incr id? other than that i cant see it being an issue?
how are you generating the id guid? could this be done in a sql insert?
or maybe if dev on this is picked up again, an import using a csv?
before i found this i had a spreadsheet of all my data so i would like to try and not do one by one :)
thanks!

Curious what the timezone does?

The readme here and for the docker container both say to specify the timezone, but I'm curious what that controls? I'm wondering because I set it to "America/Los_Angeles" and when I add a fill, the time gets recorded as the current UTC time. I thought this might be a bug or something I messed up in setting things up.... Or is this expected behavior that everything is recorded in UTC?

Thanks for the help in advance!