User registration doesn't work

[rvoosterhout]

When I try to register my first user, nothing happens. I fill in the required fields, hit register, but I only see a spinning wheel for around 2 secconds and after that nothing. The installation went without problems, SQL database is in use.

System: UnRaid, using the template from the Community Applications SQL: MariaDB From the Community Applications Unraid version: 6.8.2

[rvoosterhout]

[j0yze]

I have the same problem. Any advice?

[geekblog-dev]

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

[jon4hz]

Registration does not work for me either. Any solutions yet?

[rob1998]

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

[slimcdk]

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.

[rob1998]

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.

[slimcdk]

@rob1998 Omg thanks! That literally solved it!

[rob1998]

@slimcdk happy to be able to help 😊

[wuast94]

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

[slimcdk]

@wuast94

This is my working config. https://github.com/slimcdk/home-server/blob/b8023a73266293b7886625c900b010c8170dbbf6/docker-compose.yaml#L48-L85

[wuast94]

@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

[slimcdk]

Hmm, try to do this.

1. Delete containers and (data in) volumes.
2. Spin up the database.
3. Run the mysql_upgrade command in the container
4. Start clarkson

[rob1998]

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

@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 ☺️

[wuast94]

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?

[rob1998]

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

[JoshStark]

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.

[wuast94]

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