Cannot install SL any longer

[sse450]

Dear Tekki,

Something must have been changed (probably in OS). I am not able to install and run SL any more. I get some weird responses.
First, my server is Almalinux 9.5 fresh install and all updated. Apache and SL are 2.4.62 and 3.2.12.050 (latest tekki version), respectively. No any existing database. Just fresh install of SL.

1. Apache comes with a mpm module in /etc/httpd/conf.modules.d/00-mpm.conf. Within this module conf file LoadModule mpm_event_module modules/mod_mpm_event.so is uncommented as default (this was working before). If this option is left as it is, SL doesn't come up. Instead, it gives "Service Unavailable. The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later." If I comment that line and comment out LoadModule mpm_prefork_module modules/mod_mpm_prefork.so then SL comes up. However, if I leave it with LoadModule mpm_prefork_module modules/mod_mpm_prefork.so uncommented , the apache log complaints with a warning:" The mpm module (prefork.c) is not supported by mod_http2. The mpm determines how things are processed in your server. HTTP/2 has more demands in this regard and the currently selected mpm will just not do. This is an advisory warning. Your server will continue to work, but the HTTP/2 protocol will be inactive."
2. As you know, admin.pl asks to set a master admin password at the beginning. I enter a password and get "Error! users/members : Permission denied" response. Of course users/ directory is apache writable. Even my old server (was working with the same setup doesn't work anymore with Permission denied error.

I would appreciate any help.
Thanks,
Müfit

[Tekki]

Hello Müfit
Can't tell you directly what the problem could be. Concerning point 2, the last changes in the code to save the members file are from 2017. So at first sight it seems that the cause is somewhere in Almalinux. I'll look into it as soon as I have time (this means not in the next days).
Tekki

[sse450]

Please take your time. I wish you a Merry Christmas and happy New Year.

Thank you.

[Tekki]

I'm preparing version 51, that's the why I don't have much time.
Just tried the most recent Almalinux Docker image ("AlmaLinux 9.5 (Teal Serval)"). The only problem is that I'm not able to install Spreadsheet::ParseXLSX, which is not a big thing. But then everything works fine, without any configuration change. What I don't know is if there is a difference in the Apache installation of the version on Docker Hub and the one you get from somewhere else.
If you have such permission errors, the question is: Do you install SQL-Ledger in /var/www/html/sql-ledger as in my sample Docker file or somewhere else?

[sse450]

Dear Tekki,

I appreciate your post and effort. It took me by surprise.

I always install SL by unzipping your package (v3.2.12.051 this time) in /var/www/html/progs/. No Docker.

I created a new VPS and installed all prerequisite software (apache, postgresql, DBI, DBD etc) in their default version and SL on it. You are right. SL worked straight away.

From that moment on I am struggling with my main server and trying to understand what is wrong with that. Unfortunately, it was fruitless no matter what I did. The main server has additional software: php, higher version of postgresql, nextcloud, some websites (mostly wordpress). I also fiddled with php-fpm www.conf file.

Web page says: "503 Service Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later."

SL Virtual host log says: [Sat Dec 28 09:33:22.257142 2024] [cgid:error] [pid 645192:tid 645334] (13)Permission denied: [client x.x.x.x 36489] AH01257: stderr from /var/www/html/progs/finans/login.pl: unable to connect to cgi daemon after multiple tries

The problem is apparently login.pl cannot connect to cgi daemon. Isn't php.fpm is the cgi daemon? It's status is active running. srwxrwxrwx+ 1 root root 0 Dec 28 10:51 www.sock is available in /run/php-fpm.

All perl files in SL are +x executable.

Where else should I check? Thank you.

Edit: I was wrong. php-fpm has nothing to do with SL. I removed php and php-fpm from the working instance. SL still works. So, what is the cgi mechanism of SL?

Virtual Host file:
<VirtualHost *:443>
ServerName finans.xxx.com
DocumentRoot /var/www/html/progs/finans
SSLEngine On
SSLCertificateFile /etc/letsencrypt/live/xxx.com/cert.pem
SSLCertificateKeyFile /etc/letsencrypt/live/xxx.com/privkey.pem
ErrorLog /var/log/httpd/finans_error.log
CustomLog /var/log/httpd/finans_access.log combined

<Directory /var/www/html/progs/finans>
AllowOverride All
AddHandler cgi-script .pl
Options ExecCGI Includes FollowSymlinks
Order Deny,Allow
Deny from all
Allow from All

<Directory /var/www/html/progs/finans/users>
Require all granted
Order Deny,Allow
Deny from All

<VirtualHost *:80>
ServerName finans.xxx.com
Redirect permanent / https://finans.xxx.com