Portainer stack setup does not work if you change PHOTOPRISM_DATABASE_PASSWORD from "insecure" to anything else.

[gershte]

I use standard setup from photoprism repository.

If I change all passwords in the file stack.env from "insecure" to anything else, stack is starting but I can not login to web login page. I am getting this errors from containers

Log of containers photoprism

time="2024-04-21T22:45:31Z" level=info msg="config: waiting for the database to become available"
time="2024-04-21T22:46:31Z" level=error msg="Error 1045 (28000): Access denied for user 'photoprism'@'172.20.0.3' (using password: YES)"
/opt/photoprism/bin/photoprism start
time="2024-04-21T22:46:41Z" level=info msg="config: waiting for the database to become available"

Log of mariadb

2024-04-21 23:04:25 0 [Note] Server socket created on IP: '0.0.0.0'.
2024-04-21 23:04:25 0 [Note] Server socket created on IP: '::'.
2024-04-21 23:04:25 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
2024-04-21 23:04:25 0 [Note] mariadbd: ready for connections.
Version: '11.3.2-MariaDB-1:11.3.2+maria~ubu2204' socket: '/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution
2024-04-21 23:04:58 3 [Warning] Access denied for user 'photoprism'@'172.21.0.3' (using password: YES)
2024-04-21 23:04:58 4 [Warning] Access denied for user 'photoprism'@'172.21.0.3' (using password: YES)
2024-04-21 23:05:03 5 [Warning] Access denied for user 'photoprism'@'172.21.0.3' (using password: YES)
2024-04-21 23:05:08 6 [Warning] Access denied for user 'photoprism'@'172.21.0.3' (using password: YES)

I was able to login to mariadb container using phpmyadmin and changing the password of the photoprism user back to insecure. After that the Web Interface starts working and I can log in to the App.

What should I do? I do not think it is safe to leave access to photoprism database without proper password.

Thank you for you help!

[ai30328348]

I think this is due to the database user not allowing remote connections or an incorrect password.
Run select host,user from mysql.user; to check whether the user allows remote connections