search

linuxserver / docker-sonarr

GNU General Public License v3.0
815 stars 141 forks source link

Can't reset password[BUG] <title> #267

Closed lowrisk75 closed 1 year ago

lowrisk75 commented 1 year ago

Is there an existing issue for this?

Current Behavior

After removing and starting over with a new docker compose, sonarr is asking for a password which I don't have I tried UPDATE Users SET PasswordHash = 'newhash' WHERE Username = 'myuser'; or UPDATE User SET PasswordHash = 'newhash' WHERE Username = 'myuser'; none work

I tried to update Basic to None but when I do that the webinterface have an error. Tried to remove the config folder and start over and I have an error. tried to change to the developpement tag but same issue any idea how can I reset this password ???

Expected Behavior

No response

Steps To Reproduce

loging to the web interface

Environment

- OS:
- How docker service was installed:

CPU architecture

arm64

Docker creation

version: '3.8'
services:
  wireguard:
    image: ghcr.io/linuxserver/wireguard:arm64v8-latest
    container_name: mydownloadlab-wireguard
    restart: unless-stopped
    privileged: true
    ports:
      - 5055:5055/tcp
      - 6767:6767/tcp
      - 6881:6881/tcp
      - 6881:6881/udp
      - 7878:7878/tcp
      - 8080:8080/tcp
      - 8989:8989/tcp
      - 9696:9696/tcp
      - 8265:8265/tcp
      - 8787:8787/tcp
      - 3579:3579/tcp
      - 8191:8191/tcp
    volumes:
      - /lib/modules:/lib/modules
      - /Volumes/Drive/Docker/wireguard:/config
    environment:
      - TZ=Europe/Paris
      - PUID=1000
      - PGID=1000
      - PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
      - HOME=/root
      - LANGUAGE=en_US.UTF-8
      - LANG=en_US.UTF-8
      - TERM=xterm
      - S6_CMD_WAIT_FOR_SERVICES_MAXTIME=0
      - S6_VERBOSITY=1
      - S6_STAGE2_HOOK=/docker-mods
      - LSIO_FIRST_PARTY=true
      - DEBIAN_FRONTEND=noninteractive
    networks:
      - downloadlab_network

  qbittorrent:
    image: ghcr.io/linuxserver/qbittorrent:arm64v8-latest
    container_name: qbittorrent
    depends_on:
      - wireguard
    environment:
      - PUID=1000
      - PGID=1000
    volumes:
      - /Volumes/Drive/Media/Torrent:/data
      - /Volumes/Drive/Docker/qbittorrent:/config
    restart: unless-stopped
    network_mode: "service:wireguard"

  radarr:
    image: ghcr.io/linuxserver/radarr:arm64v8-latest
    container_name: radarr
    depends_on:
      - wireguard
    environment:
      - PUID=1000
      - PGID=1000
    volumes:
      - /Volumes/Drive/Media/Movies:/movies
      - /Volumes/Drive/Media/Kids\ Movies:/kidsmovies
      - /Volumes/Drive/Docker/radarr:/config
    restart: unless-stopped
    network_mode: "service:wireguard"

  sonarr:
    image: ghcr.io/linuxserver/sonarr:arm64v8-latest
    container_name: sonarr
    depends_on:
      - wireguard
    environment:
      - PUID=1000
      - PGID=1000
    volumes:
      - /Volumes/Drive/Media/TV:/tv
      - /Volumes/Drive/Docker/sonarr:/config
    restart: unless-stopped
    network_mode: "service:wireguard"

  prowlarr:
    image: ghcr.io/linuxserver/prowlarr:arm64v8-latest
    container_name: prowlarr
    depends_on:
      - wireguard
    environment:
      - PUID=1000
      - PGID=1000
    volumes:
      - /Volumes/Drive/Docker/prowlarr:/config
    restart: unless-stopped
    network_mode: "service:wireguard"

  readarr:
    image: lscr.io/linuxserver/readarr:develop
    container_name: readarr
    depends_on:
      - wireguard
    environment:
      - PUID=1000
      - PGID=1000
    volumes:
      - /Volumes/Drive/Media/Books:/books
      - /Volumes/Drive/Docker/readarr:/config
    restart: unless-stopped
    network_mode: "service:wireguard"

  tdarr:
    image: ghcr.io/haveagitgat/tdarr
    container_name: tdarr
    depends_on:
      - wireguard
    volumes:
      - /Volumes/Drive/Docker/tdarr:/config
      - /Volumes/Drive/Media:/media
    restart: unless-stopped
    network_mode: "service:wireguard"

  ombi:
    image: linuxserver/ombi:latest
    container_name: ombi
    depends_on:
      - wireguard
    environment:
      - PUID=1000
      - PGID=1000
    volumes:
      - /Volumes/Drive/Docker/ombi:/config
    restart: unless-stopped
    network_mode: "service:wireguard"

  flaresolverr:
    image: ghcr.io/flaresolverr/flaresolverr:latest
    container_name: flaresolverr
    depends_on:
      - wireguard
    volumes:
      - /Volumes/Drive/Docker/flaresolverr:/config
    restart: unless-stopped
    network_mode: "service:wireguard"

networks:
  downloadlab_network:
    external: true
    name: downloadlab_network

Container logs

at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0008e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <d636f104d58046fd9b195699bcb1a744>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <d636f104d58046fd9b195699bcb1a744>:0 
[Error] TaskExtensions: Task Error 
[v3.0.10.1567] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00174] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0008e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <d636f104d58046fd9b195699bcb1a744>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <d636f104d58046fd9b195699bcb1a744>:0 
[Error] TaskExtensions: Task Error 
[v3.0.10.1567] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00174] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0008e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <d636f104d58046fd9b195699bcb1a744>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <d636f104d58046fd9b195699bcb1a744>:0 
[Error] TaskExtensions: Task Error 
[v3.0.10.1567] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00174] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0008e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <d636f104d58046fd9b195699bcb1a744>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <d636f104d58046fd9b195699bcb1a744>:0 
[Error] TaskExtensions: Task Error 
[v3.0.10.1567] code = ReadOnly (8), message = System.Data.SQLite.SQLiteException (0x800017FF): attempt to write a readonly database
attempt to write a readonly database
  at System.Data.SQLite.SQLite3.Reset (System.Data.SQLite.SQLiteStatement stmt) [0x00088] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLite3.Step (System.Data.SQLite.SQLiteStatement stmt) [0x0006e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader.NextResult () [0x00174] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteDataReader..ctor (System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) [0x0008e] in <cf516e4846354910b3d60749c894b1bf>:0 
  at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand,System.Data.CommandBehavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x0000c] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar (System.Data.CommandBehavior behavior) [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at System.Data.SQLite.SQLiteCommand.ExecuteScalar () [0x00006] in <cf516e4846354910b3d60749c894b1bf>:0 
  at Marr.Data.QGen.InsertQueryBuilder`1[T].Execute () [0x00046] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\QGen\InsertQueryBuilder.cs:140 
  at Marr.Data.DataMapper.Insert[T] (T entity) [0x0005f] in C:\BuildAgent\work\63739567f01dbcc2\src\Marr.Data\DataMapper.cs:728 
  at NzbDrone.Core.Datastore.BasicRepository`1[TModel].Insert (TModel model) [0x00030] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Datastore\BasicRepository.cs:119 
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push[TCommand] (TCommand command, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x0015a] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:126 
  at System.Dynamic.UpdateDelegates.UpdateAndExecute4[T0,T1,T2,T3,TRet] (System.Runtime.CompilerServices.CallSite site, T0 arg0, T1 arg1, T2 arg2, T3 arg3) [0x00035] in <69ada62907b24213a012734531df1db1>:0 
  at (wrapper dynamic-method) System.Object.CallSite.Target(System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,NzbDrone.Core.Messaging.Commands.CommandQueueManager,object,NzbDrone.Core.Messaging.Commands.CommandPriority,NzbDrone.Core.Messaging.Commands.CommandTrigger)
  at NzbDrone.Core.Messaging.Commands.CommandQueueManager.Push (System.String commandName, System.Nullable`1[T] lastExecutionTime, NzbDrone.Core.Messaging.Commands.CommandPriority priority, NzbDrone.Core.Messaging.Commands.CommandTrigger trigger) [0x000b7] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Messaging\Commands\CommandQueueManager.cs:139 
  at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00043] in C:\BuildAgent\work\63739567f01dbcc2\src\NzbDrone.Core\Jobs\Scheduler.cs:42 
  at System.Threading.Tasks.Task.InnerInvoke () [0x0000f] in <d636f104d58046fd9b195699bcb1a744>:0 
  at System.Threading.Tasks.Task.Execute () [0x00000] in <d636f104d58046fd9b195699bcb1a744>:0
github-actions[bot] commented 1 year ago

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

Roxedus commented 1 year ago

https://wiki.servarr.com/sonarr/faq-v4#forced-authentication https://wiki.servarr.com/sonarr/faq#help-i-have-locked-myself-out

lowrisk75 commented 1 year ago

https://wiki.servarr.com/sonarr/faq-v4#forced-authentication https://wiki.servarr.com/sonarr/faq#help-i-have-locked-myself-out

I tried everything whatever I do, If I change anything I get SQL logic error no such column: t0.LanguageProfileId Version 3.0.10.1567

I have a holder container of sonarr sharing the same config folder, when it’s run no problem. I turn the new sonarr off and back to the old one, change the password and method, when I go back to the new sonarr, the method is changed too by password doesn’t work

Roxedus commented 1 year ago

I cant imagine this is a container problem, but rather a sonarr problem, so i suggest you reach out there. feel free to reply here if this turns out to not be the case.