Comments (18)
Did you also try MYSQL_HOST=clarkson_db
?
I had some weird issues there, also the connection for creating the database is technically different than the one that the Clarkson backend uses. Those are 2 different scripts, that's why it's possible that it does create it, while being unable to use it while the application is running.
from clarkson.
from clarkson.
I have the same problem. Any advice?
from clarkson.
Hey all have the same Problem also the MYSQL Password is not used when turning the docker on so i had to create a user without password. Then i have added a User in the Database but still cannot login(obviously not in the right way).
from clarkson.
Registration does not work for me either. Any solutions yet?
from clarkson.
Hi I had this problem at first as well, try using the official mysql docker with tag 5.7
Also, it has to run on the default sql port (3306), so either forward that post from host to docker, or create a custom docker network and use the internal docker ip or hostname of the mysql docker as MYSQL_HOST in the Clarkson docker
from clarkson.
I face same issue. Always getting polyfills.15dcd8d4a7e5a6c1e6d6.bundle.js:1 POST http://192.168.1.10:3000/api/user 500 (Internal Server Error)
when trying to register user.
I've tried official mysql docker with tag 5.7 and equal mariadb 110.4 (which supports mysql 5.7) and numerous combinations of the suggestion mysql_upgrade -uroot -p --force
@wranglatang and deleting the database.
This is my configuration https://github.com/slimcdk/home-server/blob/b8aaab53278c035ea15019475baab0677f2f1f8f/docker-compose.yaml#L46-L86
I'm not sure if the logs indicate that the connetion is fine but both the database and tables are created.
This appers in the clarkson log.
clarkson | [services.d] done.
clarkson | [cont-finish.d] executing container finish scripts...
clarkson | [cont-finish.d] done.
clarkson | [s6-finish] waiting for services.
clarkson | [s6-finish] sending all processes the TERM signal.
clarkson | [s6-finish] sending all processes the KILL signal and exiting.
clarkson | [s6-init] making user provided files available at /var/run/s6/etc...exited 0.
clarkson | [s6-init] ensuring user provided files have correct perms...exited 0.
clarkson | [fix-attrs.d] applying ownership & permissions fixes...
clarkson | [fix-attrs.d] done.
clarkson | [cont-init.d] executing container initialization scripts...
clarkson | [cont-init.d] 01-envfile: executing...
clarkson | [cont-init.d] 01-envfile: exited 0.
clarkson | [cont-init.d] 10-adduser: executing...
clarkson | usermod: no changes
clarkson |
clarkson | -------------------------------------
clarkson | _ ()
clarkson | | | ___ _ __
clarkson | | | / __| | | / \
clarkson | | | \__ \ | | | () |
clarkson | |_| |___/ |_| \__/
clarkson |
clarkson |
clarkson | Brought to you by linuxserver.io
clarkson | -------------------------------------
clarkson |
clarkson | To support LSIO projects visit:
clarkson | https://www.linuxserver.io/donate/
clarkson | -------------------------------------
clarkson | GID/UID
clarkson | -------------------------------------
clarkson |
clarkson | User uid: 1000
clarkson | User gid: 1000
clarkson | -------------------------------------
clarkson |
clarkson | [cont-init.d] 10-adduser: exited 0.
clarkson | [cont-init.d] 30-migrate: executing...
clarkson | ---------------------
clarkson | Migrating database...
clarkson | ---------------------
clarkson | Flyway 4.2.0 by Boxfuse
clarkson |
clarkson | Database: jdbc:mysql://clarkson_db:3306/ (MySQL 5.7)
clarkson | Successfully validated 31 migrations (execution time 00:00.063s)
clarkson | WARNING: Unable to restore connection to having no default schema: Access denied for user 'clarkson_user'@'%' to database '0c891d7a-9731-47c1-9614-a9452d905c51'
clarkson | Query is : CREATE SCHEMA `0c891d7a-9731-47c1-9614-a9452d905c51`
clarkson | Current version of schema `clarkson`: 1.30
clarkson | Schema `clarkson` is up to date. No migration necessary.
clarkson | [cont-init.d] 30-migrate: exited 0.
clarkson | [cont-init.d] 99-custom-files: executing...
clarkson | [custom-init] no custom files found exiting...
clarkson | [cont-init.d] 99-custom-files: exited 0.
clarkson | [cont-init.d] done.
clarkson | [services.d] starting services
clarkson | ------------------
clarkson | Starting Clarkson.
clarkson | ------------------
clarkson | [services.d] done.
clarkson | (node:272) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
clarkson | (node:272) [DEP0126] DeprecationWarning: timers.active() is deprecated. Please use timeout.refresh() instead.
clarkson | ::ffff:192.168.1.20 - - [01/Sep/2020:11:23:27 +0000] "POST /api/user HTTP/1.1" 500 136 "http://192.168.1.10:3000/register" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.83 Safari/537.36"
clarkson | (node:272) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
from clarkson.
@rob1998 Omg thanks! That literally solved it!
from clarkson.
@slimcdk happy to be able to help π
from clarkson.
i have installed this container on UnRaid and setup a new fresh mysql:5.7
Created the shema as intended in the docs
start clarkson
ad can't register an account.
i don't see anything in the logs
The database is created
Thats all I see
MYSQL_HOST=ip:port
Thats strange to me
from clarkson.
This is my working config. https://github.com/slimcdk/home-server/blob/b8023a73266293b7886625c900b010c8170dbbf6/docker-compose.yaml#L48-L85
from clarkson.
@slimcdk
I changed all to your compose and nothing, made all new and done the chematic and nothing
just don't working for me, don't know what im making wrong
from clarkson.
Hmm, try to do this.
- Delete containers and (data in) volumes.
- Spin up the database.
- Run the mysql_upgrade command in the container
- Start clarkson
from clarkson.
i have installed this container on UnRaid and setup a new fresh mysql:5.7
Created the shema as intended in the docs
start clarkson
ad can't register an account.i don't see anything in the logs
The database is created
Thats all I see
MYSQL_HOST=ip:portThats strange to me
@wuast94 the problem that I saw in this comment was the exact same slimcdk had. The mysql port has to be 3306 and you must not specify it in MYSQL_HOST. When specified it simply does not work in clarkson itself (so for registering users, etc.). The creation of the database is a separate process, which can handle port specification. That's why the database exists, at least is should.
I'll leave it to @slimcdk to help you for now
from clarkson.
OK I understand the problem...but u can't use this port becouse it's already in use by another database.
How can we fix this port issue? Is it a problem of linuxserver and should be fixed here or is it a issue from Clarkson it self and should be fixed there?
from clarkson.
OK I understand the problem...but u can't use this port becouse it's already in use by another database.
How can we fix this port issue? Is it a problem of linuxserver and should be fixed here or is it a issue from Clarkson it self and should be fixed there?
@wuast94
It's a Clarkson issue as far as I know, but it has to do with updating some dependencies probably. Which is probably gonna break stuff.
What I did was put both of them in a user defined docker network (which I already used for my reverse proxies), that way you can use the name of the docker as hostname (and thus IP address in this case). That way you connect directly to the docker, which runs the database on 3306, instead of connecting through the forwarded post on your host.
Another way is to use the docker link option, but that one is deprecated so I would advise against it.
And finally the other alternative: switch the ports, so the one that's using 3306 now has to be reconfigured (and all services that use it). This would probably be the most annoying option
from clarkson.
Hi guys,
Firstly, my sincere apologies for not seeing this sooner. I've been quite busy recently (young child, plus burnout from working from home). I'll see if I can replicate this issue and will make an attempt to update any deprecated packages which may be causing this problem.
Thanks.
from clarkson.
Hi guys,
Firstly, my sincere apologies for not seeing this sooner. I've been quite busy recently (young child, plus burnout from working from home). I'll see if I can replicate this issue and will make an attempt to update any deprecated packages which may be causing this problem.
Thanks.
No worry..Family is more important than this. But I'm happy to see that it get,hopefully, fixed in near future :)
from clarkson.
Related Issues (20)
- Change Base URL HOT 3
- Maintenance log HOT 3
- User not found HOT 6
- Persisted Login HOT 3
- Not redirected to Dashboard HOT 3
- Incorrect MPG Calculation HOT 6
- Clarkson needs a refresh HOT 2
- Curious what the timezone does? HOT 2
- Feature requests HOT 7
- 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.