Rockylinux basic update, app on webserver does not start

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)

does the mysql server container is running ?

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 ?

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

ok I’m retry in this afternoon

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)

try to connect with phpmyadmin and check if the user of database is still there…webserver is not guilty

I’m found this

usage for piwigo, I think it is not authorized to connect to the database

mhhh , I’have only reboot NS8 and that is situation .

I plaid not guilty

better :stuck_out_tongue:

can you login in phpmyadmin by using the piwigo user

does the tcp port of the mariadb container has not changed

?

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 

inside a container, except eventually selinux and podman, it does not change something

piwigo can connect only from localhost, this is wrong it should be % from any host

I don’t understand what has changed. What do I change? I have an active snap.