Changing user properties in db, (extending trail time)

[wouterdebruijn]

Hi,

I have a self hosted installation of plausible, but one of my accounts has stopped working. I it seems the trail period of that account has ended. I have discoverer I can create a new account with a 100 year trail with the following command:

Plausible.Auth.User.new(%Plausible.Auth.User{}, %{name: "Test name", email: "test@rl.hedium.nl"}) |> Plausible.Auth.User.set_password("123456") |> Plausible.Auth.User.changeset(%{trial_expiry_date: Timex.today() |> Timex.shift(years: 100)}) |> Plausible.Repo.insert

After more testing, command provided above doesn't work!

Now I need to adapt this command to update an existing user, but I don't know how to do that.
If anyone has the command, or knows how to find a user by email, that would be awesome!

This would be what I am looking for in pseudo ish code:

Plausible.Auth.User.byEmail("someEmail@mydomain.com") |> Plausible.Auth.User.changeset(%{trial_expiry_date: Timex.today() |> Timex.shift(years: 100)}) |> Plausible.Repo.update

The above is not working code! Its there to show that I want to do, User.byEmail doesn't exist!

[wouterdebruijn]

Followup!

I looked at the documentation for Ecto and Elixir and found a solution!

Here is a full guide for changing the trial expiry date

1. Login to your Plausible instance
   Open the remote console on your plausible instance, (docker ps to find your instance name, mine was hosting-master_plausible_1)

docker exec -it hosting-master_plausible_1 /app/bin/plausible remote

2. Create a User (Optional)

Plausible.Auth.User.new(%{name: "somename", email: "email@email", password: "123", password_confirmation: "123" }) |> Plausible.Repo.insert

2. Update the user

Plausible.Repo.get_by(Plausible.Auth.User, email: "test@rl.hedium.nl") |> Ecto.Changeset.change(%{trial_expiry_date: Timex.today() |> Timex.shift(years: 100)}) |> Plausible.Repo.update

Edit: Updated for newer plausible versions, also added the user creating command.