Hi, I'm new to openmediavault and the NAS world. I'm trying to setup my first system and the use of PhotoPrism is crucial and one of the main reasons I choose omv.
I really tried everything and I'm lost. Nothing works when it comes to PhotoPrism so I need your help.
I downloaded the plugin and created the required folders, I think the permissions are right (users group has access). No matter what I try I can't get to the webUI of PP.
Podman plugin shows the container is running but I keep receiving errors in the logs and I don't know what to modify.
Here the logs for the app:
started 240711 as root (amd64-prod)
init: account with the user id 994 already exists
init: updating filesystem permissions
PHOTOPRISM_DISABLE_CHOWN="true" disables permission updates
init: https
Creation of a default HTTPS/TLS certificate is skipped because PHOTOPRISM_DEFAULT_TLS is "false".
Problems? Our Troubleshooting Checklists help you quickly diagnose and solve them:
https://docs.photoprism.app/getting-started/troubleshooting/
file umask....: "0002" (u=rwx,g=rwx,o=rx)
home directory: /photoprism
assets path...: /opt/photoprism/assets
storage path..: /photoprism/storage
config path...: default
cache path....: default
backup path...: /photoprism/storage/backups
import path...: /photoprism/import
originals path: /photoprism/originals
switching to uid 994:100
/opt/photoprism/bin/photoprism start
time="2024-08-08T16:00:17Z" level=info msg="config: waiting for the database to become available"
time="2024-08-08T16:01:22Z" level=error msg="Error 1130: Host '127.0.0.1' is not allowed to connect to this MariaDB server"
/opt/photoprism/bin/photoprism start
time="2024-08-08T16:01:25Z" level=info msg="config: waiting for the database to become available"
time="2024-08-08T16:02:25Z" level=error msg="Error 1130: Host '127.0.0.1' is not allowed to connect to this MariaDB server"
Display More
And for the database:
2024-08-08 16:00:13+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.4.2+maria~ubu2404 started.
2024-08-08 16:00:21+00:00 [Warn] [Entrypoint]: /sys/fs/cgroup///memory.pressure not writable, functionality unavailable to MariaDB
2024-08-08 16:00:21+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-08-08 16:00:21+00:00 [Note] [Entrypoint]: Entrypoint script for MariaDB Server 1:11.4.2+maria~ubu2404 started.
2024-08-08 16:00:23+00:00 [Note] [Entrypoint]: MariaDB upgrade information missing, assuming required
2024-08-08 16:00:23+00:00 [Note] [Entrypoint]: MariaDB upgrade (mariadb-upgrade or creating healthcheck users) required, but skipped due to $MARIADB_AUTO_UPGRADE setting
2024-08-08 16:00:23 0 [Note] Starting MariaDB 11.4.2-MariaDB-ubu2404 source revision 3fca5ed772fb75e3e57c507edef2985f8eba5b12 as process 1
2024-08-08 16:00:26 0 [Note] mariadbd: Aria engine: starting recovery
recovered pages: 0% 99% 100% (1.7 seconds); transactions to roll back: 1 0 (6.6 seconds); tables to flush: 1 0 (2.1 seconds);
2024-08-08 16:00:37 0 [Note] mariadbd: Aria engine: recovery done
2024-08-08 16:00:38 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-08-08 16:00:38 0 [Note] InnoDB: Number of transaction pools: 1
2024-08-08 16:00:38 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-08-08 16:00:38 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
2024-08-08 16:00:38 0 [Warning] mariadbd: io_uring_queue_init() failed with errno 95
2024-08-08 16:00:38 0 [Warning] InnoDB: liburing disabled: falling back to innodb_use_native_aio=OFF
2024-08-08 16:00:38 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2024-08-08 16:00:38 0 [Note] InnoDB: Completed initialization of buffer pool
2024-08-08 16:00:38 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-08-08 16:00:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=18022
2024-08-08 16:00:42 0 [Note] InnoDB: End of log at LSN=37792
2024-08-08 16:00:42 0 [Note] InnoDB: To recover: 146 pages
2024-08-08 16:00:43 0 [Note] InnoDB: Opened 3 undo tablespaces
2024-08-08 16:00:43 0 [Note] InnoDB: 128 rollback segments in 3 undo tablespaces are active.
2024-08-08 16:00:43 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
2024-08-08 16:00:43 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
2024-08-08 16:00:43 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
2024-08-08 16:00:43 0 [Note] InnoDB: log sequence number 37792; transaction id 4
2024-08-08 16:00:43 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2024-08-08 16:00:43 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory
2024-08-08 16:00:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-08-08 16:00:43 0 [Note] Plugin 'wsrep-provider' is disabled.
2024-08-08 16:00:43 0 [Note] Recovering after a crash using tc.log
2024-08-08 16:00:46 0 [Note] Starting table crash recovery...
2024-08-08 16:00:46 0 [Note] Crash table recovery finished.
2024-08-08 16:00:52 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-08-08 16:00:52 0 [Note] Server socket created on IP: '::'.
2024-08-08 16:00:54 0 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2024-08-08 16:00:54 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2024-08-08 16:00:56 0 [ERROR] Cannot open mysql.event
2024-08-08 16:00:56 0 [ERROR] mariadbd: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2024-08-08 16:00:56 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
2024-08-08 16:00:57 0 [Note] mariadbd: ready for connections.
Version: '11.4.2-MariaDB-ubu2404' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-08-08 16:00:57 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-08-08 16:01:02 4 [Warning] Aborted connection 4 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-08-08 16:01:07 5 [Warning] Aborted connection 5 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-08-08 16:01:12 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-08-08 16:01:17 7 [Warning] Aborted connection 7 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-08-08 16:01:25 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
2024-08-08 16:01:25 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
Display More
I reinstalled everything multiple times but keep getting errors regarding the app being unable to access the database. Should I modify the yml file or something (I don't know where it is), I'm quite confused. If I go to the PhotoPrism ip on my browser I get connection refused.
Thank you in advance