Hi, I've been trying to get PhotoPrism going but I keep getting "fail to connect" when I click WebUI.

I created the database in MariaDB using adminer, I follow instructions from:

https://docs.photoprism.org/getting-started/advanced/databases/

CREATE DATABASE photoprism
CHARACTER SET = 'utf8mb4'
COLLATE = 'utf8mb4_unicode_ci';

and

CREATE USER 'photoprism'@'%' IDENTIFIED BY 'insecure';
GRANT ALL PRIVILEGES ON photoprism.* to 'photoprism'@'%';
FLUSH PRIVILEGES;

in the photoprism settings I selected Network Type: custom:photoprism, I also seleted the storage and data directories.

The Photoprims Database Type: I set it up as mysql

also the MySQL Database Connection: photoprism:insecure@tcp(MariaDB:3306)/photoprism?parseTime=true (where MariaDB is my ip address shown in adminer.

 

I'm not sure what I'm doing wrong.

 

any help?

 

On 10/15/2021 at 5:51 AM, Oscar Armendariz said:

Hi, I've been trying to get PhotoPrism going but I keep getting "fail to connect" when I click WebUI.

I created the database in MariaDB using adminer, I follow instructions from:

https://docs.photoprism.org/getting-started/advanced/databases/

CREATE DATABASE photoprism
CHARACTER SET = 'utf8mb4'
COLLATE = 'utf8mb4_unicode_ci';

and

CREATE USER 'photoprism'@'%' IDENTIFIED BY 'insecure';
GRANT ALL PRIVILEGES ON photoprism.* to 'photoprism'@'%';
FLUSH PRIVILEGES;

in the photoprism settings I selected Network Type: custom:photoprism, I also seleted the storage and data directories.

The Photoprims Database Type: I set it up as mysql

also the MySQL Database Connection: photoprism:insecure@tcp(MariaDB:3306)/photoprism?parseTime=true (where MariaDB is my ip address shown in adminer.

 

I'm not sure what I'm doing wrong.

 

any help?

 

im in the same step. i honestly think that we didnt specify what database in the connection. so we put in the db username and pw and the server address and port but nowhere did we put in the database name. we did change from sqlite to mysql. unsure if its in THIS step where we put in the database name?

 

edit: fixed it. it was a database name.  in the connection string, change /photoprism? to reflect the database name. so the instructions should read: 'DBUSER:DBPASSWORD@tcp(DBIP:DBPORT)/DBNAME?parseTime=true'

Edited March 24, 20224 yr by droopie

On 3/24/2022 at 3:14 PM, droopie said:

im in the same step. i honestly think that we didnt specify what database in the connection. so we put in the db username and pw and the server address and port but nowhere did we put in the database name. we did change from sqlite to mysql. unsure if its in THIS step where we put in the database name?

 

edit: fixed it. it was a database name.  in the connection string, change /photoprism? to reflect the database name. so the instructions should read: 'DBUSER:DBPASSWORD@tcp(DBIP:DBPORT)/DBNAME?parseTime=true'

Thanks your "edit" totally helped I was going nuts!