[BUG] Site isn't working - error 500 about docker-piwigo HOT 16 CLOSED

Same result as described, however in my case redirected to install.php and error 500

I suspect you are providing the wrong hostname for the db on the install screen. Assuming you are using docker compose and have the mysql container running alongside the piwigo container, make sure the host name you provide is the name of the database service in the docker compose file.

e.g.:

services:
  piwigo:
    image: lscr.io/linuxserver/piwigo:latest
    ...
  db: <--- this is the name of the database service
    image: mysql
    ...

from docker-piwigo.

Same result as described, however in my case redirected to install.php and error 500

from docker-piwigo.

Writing this here in case someone else faces the same issue:

Entering the (correct) docker container name as the database server (in my case mariadb, with both Piwigo and MariaDB containers having those respective names and being in the same custom bridge network), wouldn't work for me either. It would lead to a 500 HTTP error page. I also tried with mariadb.<the custom bridge network's name>, and mariadb.<my LAN's domain name>, but it would result to the same error.

What solved it for me was that I instead entered the database server's IP address, the one it has in the custom docker network (the 172.x.x.x one). This way it completed the installation without any issues, and I could run it fine.

But to make sure it continues running after starting/stopping containers or rebooting the host (since those IPs aren't static) I went into Piwigo's config folder and opened the file /config/www/local/config/database.inc.php . I changed the line $conf['db_host'] = '172.x.x.x'; , replacing the IP I had entered during install with the database server's name (in my case mariadb). Restarting Piwigo worked just fine with server name, I'm not sure why it wouldn't accept it during installation, but 🤷 .

from docker-piwigo.

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

from docker-piwigo.

Ever get this sorted out? Exact same thing for me. I fill out all the setup stuff and submit, and then just get redirected to upgrade.php in the location bar, but it's Error 500.

The database does get populated with the initial stuff, and the bind mounts get populated with the files; I just get stuck at this point.

from docker-piwigo.

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

from docker-piwigo.

I have the same problem, on Linux Debian 11, with mariadb and mysql.

With mariadb I got an access denied log error so I did this in the mariadb container:
GRANT ALL ON piwigo.* to 'piwigo'@'%' IDENTIFIED BY 'xxxxx' WITH GRANT OPTION;
It is strange I had to do this but then the install worked, even if the first start was very very long.

Alas the problem isn't totally fixed, now I get an 504 Gateway Time-out when I try to open the admin page.
( Other pages looks ok but I haven't uploaded any photo yet )

Here is the error in nginx/error.log:
upstream timed out (110: Operation timed out) while reading response header from upstream, client: 192.168.15.206, server: _, request: "GET /admin.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "piwigo.ill.fr:8080", referrer: "http://piwigo.ill.fr:8080/profile.php"

I checked the database: piwigo tables are here, so my db credentials are the good ones.

from docker-piwigo.

I found the solution for the timeout in the admin page.

On our site we must use a proxy to access outside web sites.
I added it in it php-fpm conf (maybe there is a way to add it directly in the kiwigo conf but without a way to access admin page it's complicated)

In config/php/www2.conf add something like:
env[HTTP_PROXY] =http://xxxx:8888
env[HTTPS_PROXY]=http://xxxx:8888
env[NO_PROXY] ="localhost,127.0.0.1"

I hope this can help

from docker-piwigo.

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

from docker-piwigo.

same for me when trying to install on unraid.
no matter what I put in the details, I only get chrome error message "this site does not work".
No error message from Piwigo.

got these logs from

Am I missing somethin?

from docker-piwigo.

Hi, same here, try to install in ubuntu jammy

docker-compose.yml

---
version: "2.1"
services:
  piwigo:
    image: lscr.io/linuxserver/piwigo:latest
    container_name: piwigo
    network_mode: bridge
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Etc/UTC
    volumes:
      - /opt/docker/piwigo/config:/config
      - /opt/docker/piwigo/gallery:/gallery
    ports:
      - 8082:80
    links:
      - db
    restart: unless-stopped
    depends_on:
      - db

  db:
    image: mysql
    network_mode: bridge
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_USER: piwigo
      MYSQL_PASSWORD: piwigo
      MYSQL_DATABASE: piwigo
      MYSQL_RANDOM_ROOT_PASSWORD: true

the nginx error log show this:

2023/07/20 17:21:39 [error] 284#284: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function set_charset() on null in /app/www/public/include/dblayer/functions_mysqli.inc.php:88
Stack trace:
#0 /app/www/public/install.php(261): pwg_db_check_charset()
#1 {main}
  thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 88" while reading response header from upstream, client: xx.xx.xx.xx, server: _, request: "POST /install.php?language=en_GB HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "yy.yy.yy.yy:8082", referrer: "http://yy.yy.yy.yy:8082/install.php"

same error use de default 80 port.

Regards.

from docker-piwigo.

I commented out pwg_db_check_charset() and install completed sucessfully

from docker-piwigo.

Hi, i try to install piwigo, this is my docker-compose.yml

version: "2.1"
services:
  piwigo:
    image: lscr.io/linuxserver/piwigo:latest
    container_name: piwigo
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Etc/UTC
    volumes:
      - ./config:/config
      - ./gallery:/gallery
    ports:
      - 80:80
    restart: unless-stopped
  mariadb:
    image: lscr.io/linuxserver/mariadb:latest
    container_name: mariadb
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Etc/UTC
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=piwigo
      - MYSQL_USER=piwigo
      - MYSQL_PASSWORD=piwigo
    volumes:
      - ./db:/config
    ports:
      - 3306:3306
    restart: unless-stopped

i can access the basic configuration, after that i get http error 500

Linuxserver.io version:- 13.8.0-ls223 Build-date:- 2023-08-12T15:23:42+00:00

Nothing at logs. Any advice?

EDIT
Found same error like above

2023/08/21 20:41:58 [error] 259#259: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Error: Call to a member function set_charset() on null in /app/www/public/include/dblayer/functions_mysqli.inc.php:88
Stack trace:
#0 /app/www/public/install.php(261): pwg_db_check_charset()
#1 {main}
  thrown in /app/www/public/include/dblayer/functions_mysqli.inc.php on line 88" while reading response header from upstream, client: 192.168.178.43, server: _, request: "POST /install.php?language=de_DE HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.178.73", referrer: "http://192.168.178.73/install.php" 

from docker-piwigo.

Works now ... On install page the db host has to be the name of the mariadb container or the IP + Port. Wasnt self explaning for me.

from docker-piwigo.

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

from docker-piwigo.

This issue is locked due to inactivity

from docker-piwigo.