@flamber Thanks for your quick reply. I am aware that I should switch to postgres at some point in time. For me the question is if this switch will solve my restting password problem. If I understand your response correctly, this should not be the case and it can be solved using H2, too.
So, some more informations what I did:
I am using the newest official metabase/metabase docker image and haven't changed the database yet. I copied the h2 db file and viewed it locally, so I can see that the CORE_USER table contains only one user - the user I want to reset the password for. As far as I can see, the user is not deactivated (IS_ACTIVE and IS_SUPERUSER columns are both set to true).
I copied the EMAIL value directly from the db, so it took the value as is without changing the case (it is completely in lower case btw), but I still got the 'No user found...' error when trying to run this command inside the docker container's / directory:
java -XX:+IgnoreUnrecognizedVMOptions -Dfile.encoding=UTF-8 -Dlogfile.path=target/log -XX:+CrashOnOutOfMemoryError -server -jar /app/metabase.jar reset-password my.double.checked@mail.address
output:
bash-5.1# java -XX:+IgnoreUnrecognizedVMOptions -Dfile.encoding=UTF-8 -Dlogfile.path=target/log -XX:+CrashOnOutOfMemoryError -server -jar /app/metabase.jar reset-password my.double.checked@mail.address
Warning: environ value jdk-11.0.14+9 for key :java-version has been overwritten with 11.0.14
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2022-03-04 03:17:51,380 INFO metabase.util :: Maximum memory available to JVM: 1.9 GB
2022-03-04 03:18:04,388 INFO util.encryption :: Saved credentials encryption is DISABLED for this Metabase instance. ๐
For more information, see https://metabase.com/docs/latest/operations-guide/encrypting-database-details-at-rest.html
2022-03-04 03:18:08,179 INFO driver.impl :: Registered abstract driver :sql ๐
โฎฆ Load driver :sql took 676.5 ms
2022-03-04 03:18:08,202 INFO driver.impl :: Registered abstract driver :sql-jdbc (parents: [:sql]) ๐
Load driver :sql-jdbc took 704.9 ms
2022-03-04 03:18:08,208 INFO driver.impl :: Registered driver :h2 (parents: [:sql-jdbc]) ๐
2022-03-04 03:18:08,234 INFO driver.impl :: Registered driver :mysql (parents: [:sql-jdbc]) ๐
2022-03-04 03:18:08,257 INFO driver.impl :: Registered driver :postgres (parents: [:sql-jdbc]) ๐
2022-03-04 03:18:11,339 INFO metabase.core ::
Metabase v0.42.0 (de1264e release-x.42.x)
Copyright ยฉ 2022 Metabase, Inc.
Metabase Enterprise Edition extensions are NOT PRESENT.
2022-03-04 03:18:11,364 WARN db.env :: WARNING: Using Metabase with an H2 application database is not recommended for production deployments. For production deployments, we highly recommend using Postgres, MySQL, or MariaDB instead. If you decide to continue to use H2, please be sure to back up the database file regularly. For more information, see https://metabase.com/docs/latest/operations-guide/migrating-from-h2.html
2022-03-04 03:18:11,368 INFO db.setup :: Verifying h2 Database Connection ...
2022-03-04 03:18:11,743 INFO db.setup :: Successfully verified H2 1.4.197 (2018-03-18) application database connection. โ
2022-03-04 03:18:11,744 INFO db.setup :: Running Database Migrations...
2022-03-04 03:18:11,751 INFO db.setup :: Setting up Liquibase...
2022-03-04 03:18:11,821 INFO db.setup :: Liquibase is ready.
2022-03-04 03:18:11,822 INFO db.liquibase :: Checking if Database has unrun migrations...
2022-03-04 03:18:15,141 INFO db.setup :: Database Migrations Current ... โ
2022-03-04 03:18:15,164 INFO db.data-migrations :: Running all necessary data migrations, this may take a minute.
2022-03-04 03:18:15,176 INFO db.data-migrations :: Finished running data migrations.
Database setup took 3.8 s
Resetting password for my.double.checked@mail.address...
FAIL [[[No user found with email address 'my.double.checked@mail.address'. Please check the spelling and try again.]]]
Any ideas what I did wrong?