Comments (16)
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
appdata\piwigo\log\nginx\error.log
2023/07/11 15:58:57 [error] 314#314: *5 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.46, server: _, request: "POST /install.php?language=de_DE HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.178.200:8280", referrer: "http://192.168.178.200:8280/install.php"
2023/07/11 15:59:15 [error] 314#314: *5 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.46, server: _, request: "POST /install.php?language=de_DE HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.178.200:8280", referrer: "http://192.168.178.200:8280/install.php"
2023/07/11 16:00:15 [error] 314#314: *5 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.46, server: _, request: "POST /install.php?language=de_DE HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.178.200:8280", referrer: "http://192.168.178.200:8280/install.php"
2023/07/11 16:02:14 [error] 313#313: *12 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.46, server: _, request: "POST /install.php?language=de_DE HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "192.168.178.200:8280", referrer: "http://192.168.178.200:8280/install.php"
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.
Related Issues (20)
- Error loading certificate "/config/keys/cert.crt" at docker run time HOT 3
- Change release download to https HOT 1
- Getting error - Deprecated: Invalid characters passed for attempted conversion, these have been ignored in /gallery/include/template.class.php on line 215 HOT 3
- No Database setup in Docker Compose HOT 3
- How to increase max file size correctly. HOT 5
- [BUG] After last migration, the /etc/s6-overlay/s6-rc.d/init-piwigo-config/run fails and piwigo is broken HOT 3
- [BUG] Does download arbitrary php files instead of giving a 404 HOT 10
- [BUG] < Operation not permitted> HOT 4
- [BUG] Upgrade php8.2 broke piwigo HOT 5
- [FEAT] Allow configuring the locations of `/config` and `/gallery` HOT 3
- [BUG] PHP message: PHP Fatal error: Uncaught Error: Call to undefined function get_magic_quotes_gpc() HOT 6
- [BUG] Uploading more than a few photos from Piwigo android app causes container to crash HOT 6
- [BUG] Loads of PHP warnings after install and upload of photos HOT 3
- [BUG] Missing Perl Module LWP::UserAgent HOT 3
- [BUG] Some plugins do not work due to the use of symlinks for plugin directory HOT 11
- [BUG] Piwigo jumps in and out of logged in user when using reverse proxy (SWAG) HOT 3
- [BUG] nginx misconfiguration HOT 3
- [BUG] Update to piwigo 14 doesn't work HOT 10
- After installation in unraid failed. HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from docker-piwigo.