User not found

[Sblop]

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?

[JoshStark]

If all your tables are present and contain data, I can only guess that somehow it is connected to a different database (it may have potentially created another copy of the table structure). Can you double-check your sql connection to make sure it's definitely connected to the database?

[compil3]

I'm having the same issue, I even created the user manually in mysql and still can't login.

Deployment was done via unRaid container, followed the instructions on the docker hub page by creating the mysql schema prior to running Clarkson, then launching Clarkson. Clicking on Register to create the admin account (1st registration according to docker hub instructions), doesn't seem to create the user in mysql. Creating the user manually in mysql also didn't work.

This is using MySQL 5.7 https://i.imgur.com/QTiEojs.png - mysql user table https://i.imgur.com/bGl058T.png - clarkson config in unraid. https://i.imgur.com/LaTPumD.png - clarkson docker log

[JoshStark]

Adding a user manually probably won’t work because the passwords are hashed using bcrypt. You’d need to enter the password pre-hashed if you add it directly to the database (which I don’t recommend).

It’s odd that people are seeing this particular error as it’s one I have been unable to replicate. I’ll have another look tonight but nothing has changed in the codebase in ages.

The logs look good though.

[monty124]

I can also confirm i am seeing this behaviour. have reproduced this twice here are the steps: docker container from https://registry.hub.docker.com/r/linuxserver/clarkson using a docker container of mariadb (mysqld 10.4.7-MariaDB-1:10.4.7+maria~bionic) port 3307 user has full privlidges for empty schema called "clarkson" start clarkson container: docker run -d --name=clarkson --restart unless-stopped -p 3001:3001/tcp -e "PS1=$(whoami)@$(hostname):$(pwd)\$ " -e "S6_BEHAVIOUR_IF_STAGE2_FAILS=2" -e "PUID=1024" -e "PGID=100" -e "MYSQL_HOST=192.168.1.1:3307" -e "MYSQL_USERNAME=clarkson" -e "MYSQL_PASSWORD=clarkson" -e "ENABLE_REGISTRATIONS=true" -e "APP_PORT=3001" -e "TZ=Australia/Sydney" linuxserver/clarkson navigate to the UI and "register" an admin user, screen refreshes but user not created: SELECT * FROM clarkson.Users LIMIT 0, 1000 0 row(s) returned 0.000 sec / 0.000 sec container logs look the same as screenshot from compil3 above. would love to test this but any ideas on whats going on? any other logs we can look at?

[wranglatang]

I am having the exact same problem using UNRAID. Go to register for the first time, type in a username, email & password, hit register and nothing.

In the log I'm seeing:

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:259) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
(node:259) [DEP0126] DeprecationWarning: timers.active() is deprecated. Please use timeout.refresh() instead.
::ffff:10.168.40.57 - - [29/Feb/2020:20:48:47 +0000] "POST /api/user HTTP/1.1" 500 136 "http://10.168.40.1:5000/register" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.5 Safari/605.1.15"

(node:259) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
::ffff:10.168.40.57 - - [29/Feb/2020:20:52:40 +0000] "POST /api/user HTTP/1.1" 500 136 "http://10.168.40.1:5000/register" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.122 Safari/537.36"
::ffff:10.168.40.89 - - 

I also find that when opening the developer console and clicking register I get:

POST http://10.168.40.1:5000/api/user 500 (Internal Server Error)

Would really appreciate help getting this up and running

[monty124]

commenting to say I just had another chance to look at this and can confirm after linking to an instance of mysql:5.7 docker this container is working fine it does now say 5.7 is a requirement (it may have said that before and i missed it!!) https://docs.linuxserver.io/images/docker-clarkson#application-setup