france
November 29, 2024, 6:10am
1
NS8
i’m recevied this error after upgrade packages on rockylinux . in the web server my app piwigo won’t start .
Warning: mysqli::__construct(): (HY000/2002): Connection refused in /app/9001/piwigo/include/dblayer/functions_mysqli.inc.php on line 52
Warning: my_error(): Couldn't fetch mysqli in /app/9001/piwigo/include/dblayer/functions_mysqli.inc.php on line 839
Warning: my_error(): Couldn't fetch mysqli in /app/9001/piwigo/include/dblayer/functions_mysqli.inc.php on line 839
Piwigo encountered a non recoverable error
[mysql error ]
Can't connect to server
#1 my_error /app/9001/piwigo/include/common.inc.php(122)
#2 include_once /app/9001/piwigo/index.php(11)
stephdl
November 29, 2024, 7:26am
2
does the mysql server container is running ?
france
November 29, 2024, 8:11am
3
hi sthepane , no do not have verified if mysql running . Today at afternoon I’m execute a snapshot of server and I retry the condition of error . Ok ?
stephdl
November 29, 2024, 8:45am
4
the problem is not webserver but a mysql issue, no reason why but you could have a clue figuring what is the state of the service
1 Like
france
November 29, 2024, 10:30am
5
ok I’m retry in this afternoon
france
November 29, 2024, 2:45pm
6
hi this is a error:[mysql error ] Connection refused #1 my_error /app/9001/piwigo/include/common.inc.php(122) #2 include_once /app/9001/piwigo/picture.php(10)
stephdl
November 29, 2024, 3:00pm
7
try to connect with phpmyadmin and check if the user of database is still there…webserver is not guilty
stephdl
November 29, 2024, 3:06pm
9
usage for piwigo, I think it is not authorized to connect to the database
france
November 29, 2024, 3:08pm
10
mhhh , I’have only reboot NS8 and that is situation .
stephdl
November 29, 2024, 3:13pm
14
can you login in phpmyadmin by using the piwigo user
does the tcp port of the mariadb container has not changed
?
france
November 29, 2024, 3:13pm
15
This is a list for upgrade rocky linux
NetworkManager-1:1.48.10-2.el9_5.x86_64 NetworkManager-libnm-1:1.48.10-2.el9_5.x86_64
NetworkManager-team-1:1.48.10-2.el9_5.x86_64 NetworkManager-tui-1:1.48.10-2.el9_5.x86_64
aardvark-dns-2:1.12.1-1.el9.x86_64 alternatives-1.24-1.el9_5.1.x86_64
audit-3.1.5-1.el9.x86_64 audit-libs-3.1.5-1.el9.x86_64
bind-libs-32:9.16.23-24.el9_5.x86_64 bind-license-32:9.16.23-24.el9_5.noarch
bind-utils-32:9.16.23-24.el9_5.x86_64 binutils-2.35.2-54.el9.x86_64
binutils-gold-2.35.2-54.el9.x86_64 chrony-4.5-3.el9.x86_64
conmon-3:2.1.12-1.el9.x86_64 container-selinux-3:2.232.1-1.el9.noarch
containers-common-2:1-93.el9_5.x86_64 coreutils-8.32-36.el9.x86_64
coreutils-common-8.32-36.el9.x86_64 crun-1.16.1-1.el9.x86_64
crypto-policies-20240828-2.git626aa59.el9_5.noarch crypto-policies-scripts-20240828-2.git626aa59.el9_5.noarch
cryptsetup-libs-2.7.2-3.el9_5.x86_64 curl-7.76.1-31.el9.x86_64
device-mapper-9:1.02.198-2.el9.x86_64 device-mapper-event-9:1.02.198-2.el9.x86_64
device-mapper-event-libs-9:1.02.198-2.el9.x86_64 device-mapper-libs-9:1.02.198-2.el9.x86_64
dnf-4.14.0-17.el9.noarch dnf-data-4.14.0-17.el9.noarch
dnf-plugins-core-4.3.0-16.el9.noarch dracut-057-70.git20240819.el9.x86_64
dracut-config-rescue-057-70.git20240819.el9.x86_64 dracut-network-057-70.git20240819.el9.x86_64
dracut-squash-057-70.git20240819.el9.x86_64 elfutils-debuginfod-client-0.191-4.el9.x86_64
elfutils-default-yama-scope-0.191-4.el9.noarch elfutils-libelf-0.191-4.el9.x86_64
elfutils-libs-0.191-4.el9.x86_64 expat-2.5.0-3.el9_5.1.x86_64
filesystem-3.16-5.el9.x86_64 findutils-1:4.8.0-7.el9.x86_64
firewalld-1.3.4-7.el9.noarch firewalld-filesystem-1.3.4-7.el9.noarch
fuse-common-3.10.2-9.el9.x86_64 fuse-libs-2.9.9-16.el9.x86_64
fuse-overlayfs-1.14-1.el9.x86_64 fuse3-3.10.2-9.el9.x86_64
fuse3-libs-3.10.2-9.el9.x86_64 gdbm-libs-1:1.23-1.el9.x86_64
glibc-2.34-125.el9_5.1.x86_64 glibc-common-2.34-125.el9_5.1.x86_64
glibc-gconv-extra-2.34-125.el9_5.1.x86_64 glibc-langpack-en-2.34-125.el9_5.1.x86_64
grub2-common-1:2.06-92.el9.noarch grub2-pc-1:2.06-92.el9.x86_64
grub2-pc-modules-1:2.06-92.el9.noarch grub2-tools-1:2.06-92.el9.x86_64
grub2-tools-efi-1:2.06-92.el9.x86_64 grub2-tools-extra-1:2.06-92.el9.x86_64
grub2-tools-minimal-1:2.06-92.el9.x86_64 hwdata-0.348-9.15.el9.noarch
ima-evm-utils-1.5-2.el9.0.1.x86_64 initscripts-rename-device-10.11.7-1.el9.x86_64
initscripts-service-10.11.7-1.el9.noarch irqbalance-2:1.9.4-1.el9.x86_64
iwl100-firmware-39.31.5.1-146.el9.noarch iwl1000-firmware-1:39.31.5.1-146.el9.noarch
iwl105-firmware-18.168.6.1-146.el9.noarch iwl135-firmware-18.168.6.1-146.el9.noarch
iwl2000-firmware-18.168.6.1-146.el9.noarch iwl2030-firmware-18.168.6.1-146.el9.noarch
iwl3160-firmware-1:25.30.13.0-146.el9.noarch iwl5000-firmware-8.83.5.1_1-146.el9.noarch
iwl5150-firmware-8.24.2.2-146.el9.noarch iwl6000g2a-firmware-18.168.6.1-146.el9.noarch
iwl6050-firmware-41.28.5.1-146.el9.noarch iwl7260-firmware-1:25.30.13.0-146.el9.noarch
jq-1.6-17.el9.x86_64 kbd-2.4.0-10.el9.x86_64
kbd-legacy-2.4.0-10.el9.noarch kbd-misc-2.4.0-10.el9.noarch
kernel-tools-5.14.0-503.14.1.el9_5.x86_64 kernel-tools-libs-5.14.0-503.14.1.el9_5.x86_64
kexec-tools-2.0.27-16.el9_5.1.x86_64 kmod-28-10.el9.x86_64
kmod-libs-28-10.el9.x86_64 kpartx-0.8.7-32.el9.x86_64
krb5-libs-1.21.1-4.el9_5.x86_64 less-590-5.el9.x86_64
libblkid-2.37.4-20.el9.x86_64 libbpf-2:1.4.0-1.el9.x86_64
libcurl-7.76.1-31.el9.x86_64 libdb-5.3.28-54.el9.x86_64
libdnf-0.69.0-12.el9.x86_64 libeconf-0.4.1-4.el9.x86_64
libfdisk-2.37.4-20.el9.x86_64 libgcc-11.5.0-2.el9.x86_64
libgcrypt-1.10.0-11.el9.x86_64 libgomp-11.5.0-2.el9.x86_64
libksba-1.5.1-7.el9.x86_64 libldb-2.9.1-2.el9.x86_64
libmaxminddb-1.5.2-4.el9.x86_64 libmount-2.37.4-20.el9.x86_64
libndp-1.9-1.el9.x86_64 libnet-1.2-7.el9.x86_64
libnghttp2-1.43.0-6.el9.x86_64 libslirp-4.4.0-8.el9.x86_64
libsmartcols-2.37.4-20.el9.x86_64 libsolv-0.7.24-3.el9.x86_64
libsss_certmap-2.9.5-4.el9_5.1.x86_64 libsss_idmap-2.9.5-4.el9_5.1.x86_64
libsss_nss_idmap-2.9.5-4.el9_5.1.x86_64 libsss_sudo-2.9.5-4.el9_5.1.x86_64
libstdc++-11.5.0-2.el9.x86_64 libtalloc-2.4.2-1.el9.x86_64
libtdb-1.4.10-1.el9.x86_64 libtevent-0.16.1-1.el9.x86_64
libtirpc-1.3.3-9.el9.x86_64 libuser-0.63-15.el9.x86_64
libuuid-2.37.4-20.el9.x86_64 linux-firmware-20240905-146.el9.noarch
linux-firmware-whence-20240905-146.el9.noarch lvm2-9:2.03.24-2.el9.x86_64
lvm2-libs-9:2.03.24-2.el9.x86_64 microcode_ctl-4:20240910-1.el9_5.noarch
nano-5.6.1-6.el9.x86_64 net-tools-2.0-0.64.20160912git.el9.x86_64
netavark-2:1.12.2-1.el9.x86_64 nftables-1:1.0.9-3.el9.x86_64
numactl-libs-2.0.18-2.el9.x86_64 oniguruma-6.9.6-1.el9.6.x86_64
openssh-8.7p1-43.el9.x86_64 openssh-clients-8.7p1-43.el9.x86_64
openssh-server-8.7p1-43.el9.x86_64 openssl-1:3.2.2-6.el9_5.x86_64
openssl-libs-1:3.2.2-6.el9_5.x86_64 pam-1.5.1-20.el9.x86_64
pcre-8.44-4.el9.x86_64 pcre2-10.40-6.el9.x86_64
pcre2-syntax-10.40-6.el9.noarch podman-4:5.2.2-9.el9_5.x86_64
python-unversioned-command-3.9.19-8.el9_5.1.noarch python3-3.9.19-8.el9_5.1.x86_64
python3-dnf-4.14.0-17.el9.noarch python3-dnf-plugins-core-4.3.0-16.el9.noarch
python3-firewall-1.3.4-7.el9.noarch python3-hawkey-0.69.0-12.el9.x86_64
python3-libdnf-0.69.0-12.el9.x86_64 python3-libs-3.9.19-8.el9_5.1.x86_64
python3-nftables-1:1.0.9-3.el9.x86_64 python3-pip-wheel-21.3.1-1.el9.noarch
python3-rpm-4.16.1.3-34.el9.0.1.x86_64 python3-setuptools-wheel-53.0.0-13.el9.noarch
python3-systemd-234-19.el9.x86_64 python3.11-3.11.9-7.el9_5.1.x86_64
python3.11-libs-3.11.9-7.el9_5.1.x86_64 python3.11-setuptools-wheel-65.5.1-3.el9.noarch
qemu-guest-agent-17:9.0.0-10.el9_5.x86_64 rocky-gpg-keys-9.5-1.2.el9.noarch
rocky-release-9.5-1.2.el9.noarch rocky-repos-9.5-1.2.el9.noarch
rpm-4.16.1.3-34.el9.0.1.x86_64 rpm-build-libs-4.16.1.3-34.el9.0.1.x86_64
rpm-libs-4.16.1.3-34.el9.0.1.x86_64 rpm-plugin-audit-4.16.1.3-34.el9.0.1.x86_64
rpm-plugin-selinux-4.16.1.3-34.el9.0.1.x86_64 rpm-plugin-systemd-inhibit-4.16.1.3-34.el9.0.1.x86_64
rpm-sign-libs-4.16.1.3-34.el9.0.1.x86_64 selinux-policy-38.1.45-3.el9_5.noarch
selinux-policy-targeted-38.1.45-3.el9_5.noarch shadow-utils-2:4.9-9.el9.x86_64
shadow-utils-subid-2:4.9-9.el9.x86_64 slirp4netns-1.3.1-1.el9.x86_64
snappy-1.1.8-8.el9.0.1.x86_64 sssd-client-2.9.5-4.el9_5.1.x86_64
sssd-common-2.9.5-4.el9_5.1.x86_64 sssd-kcm-2.9.5-4.el9_5.1.x86_64
systemd-252-46.el9_5.2.0.1.x86_64 systemd-libs-252-46.el9_5.2.0.1.x86_64
systemd-pam-252-46.el9_5.2.0.1.x86_64 systemd-resolved-252-46.el9_5.2.0.1.x86_64
systemd-rpm-macros-252-46.el9_5.2.0.1.noarch systemd-udev-252-46.el9_5.2.0.1.x86_64
tar-2:1.34-7.el9.x86_64 tpm2-tss-3.2.3-1.el9.x86_64
unzip-6.0-57.el9.x86_64 util-linux-2.37.4-20.el9.x86_64
util-linux-core-2.37.4-20.el9.x86_64 vim-minimal-2:8.2.2637-21.el9.x86_64
xfsprogs-6.4.0-4.el9.x86_64 yum-4.14.0-17.el9.noarch
yum-utils-4.3.0-16.el9.noarch
Installed:
attr-2.5.1-3.el9.x86_64 kernel-5.14.0-503.14.1.el9_5.x86_64 kernel-core-5.14.0-503.14.1.el9_5.x86_64
kernel-modules-5.14.0-503.14.1.el9_5.x86_64 kernel-modules-core-5.14.0-503.14.1.el9_5.x86_64 keyutils-1.6.3-1.el9.x86_64
passt-0^20240806.gee36266-2.el9.x86_64 passt-selinux-0^20240806.gee36266-2.el9.noarch
Removed:
kernel-5.14.0-427.37.1.el9_4.x86_64 kernel-core-5.14.0-427.37.1.el9_4.x86_64 kernel-modules-5.14.0-427.37.1.el9_4.x86_64
kernel-modules-core-5.14.0-427.37.1.el9_4.x86_64
stephdl
November 29, 2024, 3:17pm
17
inside a container, except eventually selinux and podman, it does not change something
stephdl
November 29, 2024, 3:18pm
18
piwigo can connect only from localhost, this is wrong it should be % from any host
france
November 29, 2024, 3:22pm
19
I don’t understand what has changed. What do I change? I have an active snap.
