Hope of a running nextcloud! coz i fail all the time . . 😢

KarlF12 · August 30, 2022, 12:09pm

Ideally yes… one thread per issue.

You said sometimes DB connection is lost. What is it that makes you say that? Does it say on the screen somewhere?

On the collectives issue, you said it announced an error. What error does it announce? A screenshot would be helpful.

florom · August 30, 2022, 12:21pm

I get the feeling that punkyard installations are of the most complicated character and usually lack a specific question/problem. Then they are topped with an emontional title.
That is only a feeling.
Sorry for getting emotional myself.

punkyard · August 30, 2022, 12:26pm

@florom yes florom, I work every day since mid-july on this in order to deliver a collaborative tool to the team in september … hours and hours reinstalling, testing, i’m exhausted

punkyard · August 30, 2022, 12:38pm

yes, it displayed in a small box something like “error connection with database”
even this morning, trying to disable apps one by one, then create and open a new .md file made the whole webserver crash, i had to reboot.

domains log /var/apache2/domains/mydomain.com.error.log

[Tue Aug 30 13:02:18.015615 2022] [proxy_fcgi:error] [pid 38083:tid 140116475389504] [client 93.5.120.234:0] AH01079: failed to make connection to backend: >
[Tue Aug 30 13:02:25.197592 2022] [proxy:error] [pid 38083:tid 140115380790848] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix doma>
[Tue Aug 30 13:02:25.197677 2022] [proxy_fcgi:error] [pid 38083:tid 140115380790848] [client 93.5.120.234:0] AH01079: failed to make connection to backend: >
[Tue Aug 30 13:14:15.678850 2022] [proxy_fcgi:error] [pid 665:tid 140514544248384] (70007)The timeout specified has expired: [client 93.5.120.234:0] AH01075>

i have disabled cache systems in my attempts to isolate the source of the disfunction of Text App.

apache2/error/log

[Tue Aug 30 01:25:02.502743 2022] [mpm_event:notice] [pid 656:tid 140189962233728] AH00492: caught SIGWINCH, shutting down gracefully
[Tue Aug 30 01:25:03.104286 2022] [ssl:warn] [pid 38066:tid 140116732094336] AH01909: 194.163.141.9:443:0 server certificate does NOT include an ID which matches the server name
[Tue Aug 30 01:25:03.106986 2022] [suexec:notice] [pid 38066:tid 140116732094336] AH01232: suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Tue Aug 30 01:25:03.140089 2022] [ssl:warn] [pid 38068:tid 140116732094336] AH01909: 194.163.141.9:443:0 server certificate does NOT include an ID which matches the server name
[Tue Aug 30 01:25:03.152645 2022] [mpm_event:notice] [pid 38068:tid 140116732094336] AH00489: Apache/2.4.54 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/3.0.2 configured -- resuming normal operations
[Tue Aug 30 01:25:03.152679 2022] [core:notice] [pid 38068:tid 140116732094336] AH00094: Command line: '/usr/sbin/apache2'
[Tue Aug 30 13:02:28.493394 2022] [mpm_event:notice] [pid 38068:tid 140116732094336] AH00492: caught SIGWINCH, shutting down gracefully
[Tue Aug 30 13:03:07.575343 2022] [ssl:warn] [pid 608:tid 140514994407296] AH01909: 194.163.141.9:443:0 server certificate does NOT include an ID which matches the server name
[Tue Aug 30 13:03:07.593177 2022] [suexec:notice] [pid 608:tid 140514994407296] AH01232: suEXEC mechanism enabled (wrapper: /usr/lib/apache2/suexec)
[Tue Aug 30 13:03:07.720947 2022] [ssl:warn] [pid 657:tid 140514994407296] AH01909: 194.163.141.9:443:0 server certificate does NOT include an ID which matches the server name
[Tue Aug 30 13:03:07.754123 2022] [mpm_event:notice] [pid 657:tid 140514994407296] AH00489: Apache/2.4.54 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/3.0.2 configured -- resuming normal operations
[Tue Aug 30 13:03:07.754276 2022] [core:notice] [pid 657:tid 140514994407296] AH00094: Command line: '/usr/sbin/apache2'

If it was a bad server config? like php specs or mysql, how could I see it?

punkyard · August 30, 2022, 12:53pm

I have ClamAV installed on my server, could ‘Antivirus for files’ app in nextcloud be in conflict?

punkyard · August 30, 2022, 12:56pm

an error in logs, i published it earlier (in post 1)
a small box with red line says:

KarlF12 · August 31, 2022, 1:30am

I think you need to post your Apache and Nextcloud configs.

punkyard · August 31, 2022, 6:24pm

apache2.conf

# It is split into several files forming the configuration hierarchy outlined
# below, all located in the /etc/apache2/ directory:
#
#	/etc/apache2/
#	|-- apache2.conf
#	|	`--  ports.conf
#	|-- mods-enabled
#	|	|-- *.load
#	|	`-- *.conf
#	|-- conf.d
#	|	`-- *

# Global configuration
PidFile ${APACHE_PID_FILE}
Timeout 300
KeepAlive Off
MaxKeepAliveRequests 1000
KeepAliveTimeout 1

<IfModule mpm_prefork_module>
    StartServers          8
    MinSpareServers       5
    MaxSpareServers      20
    ServerLimit         256
    MaxClients          200
    MaxRequestsPerChild 4000
</IfModule>

<IfModule mpm_worker_module>
    StartServers          2
    MinSpareThreads      25
    MaxSpareThreads      75 
    ThreadLimit          64
    ThreadsPerChild      25
    MaxClients          200
    MaxRequestsPerChild 4000
</IfModule>

<IfModule mpm_event_module>
    StartServers          2
    MinSpareThreads      25
    MaxSpareThreads      75 
    ThreadLimit          64
    ThreadsPerChild      25
    MaxClients          200
    MaxRequestsPerChild 4000
</IfModule>

# These need to be set in /etc/apache2/envvars
User ${APACHE_RUN_USER}
Group ${APACHE_RUN_GROUP}
#User www-data
#Group www-data

AccessFileName .htaccess

<Files ~ "^\.ht">
    Order allow,deny
    Deny from all
    Satisfy all
</Files>

DefaultType None
HostnameLookups Off

ErrorLog ${APACHE_LOG_DIR}/error.log
LogLevel warn

# Include module configuration:
Include mods-enabled/*.load
Include mods-enabled/*.conf

# Include list of ports to listen on and which to use for name based vhosts
Include ports.conf

LogFormat "%v:%p %h %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" vhost_combined
LogFormat "%a %l %u %t \"%r\" %>s %O \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%a %l %u %t \"%r\" %>s %O" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
LogFormat "%b" bytes

IncludeOptional conf.d/*.conf
IncludeOptional conf.d/domains/*.conf

# Include the virtual host configurations:
#Include sites-enabled/

ErrorDocument 403 /error/403.html
ErrorDocument 404 /error/404.html
ErrorDocument 500 /error/50x.html
ErrorDocument 501 /error/50x.html
ErrorDocument 502 /error/50x.html
ErrorDocument 503 /error/50x.html
ErrorDocument 506 /error/50x.html

punkyard · August 31, 2022, 6:28pm

punkyard:

<?php
$CONFIG = array (
  'instanceid' => '-',
  'passwordsalt' => 'I1/-+',
  'secret' => '-',
  'trusted_domains' => 
  array (
    0 => 'domain.net',
  ),
  'default_language' => 'fr',
  'default_locale' => 'fr_FR',
  'default_phone_region' => 'FR',
  'datadirectory' => '/home/public_html/data',
  'skeletondirectory' => '/home/public_html/data/skeleton',
  'templatedirectory' => '',
  'dbtype' => 'mysql',
  'version' => '24.0.4.1',
  'overwrite.cli.url' => 'https://domain.net',
  'dbname' => '-',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => '-',
  'dbpassword' => '-',
  'installed' => true,
  'mail_from_address' => '-',
  'mail_smtpmode' => 'smtp',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => 'domain;net',
  'mail_smtpsecure' => 'ssl',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'mail.domain.net',
  'mail_smtpport' => '465',
  'mail_smtpname' => 'mail@domain.net',
  'mail_smtppassword' => '-',
  'allow_user_to_change_display_name' => true,
  'loglevel' => 2,
  'memcache.local' => '\OC\Memcache\APCu',
  'memcache.distributed' => '\OC\Memcache\Redis',
  'filelocking.enabled' => 'true',
  'memcache.locking' => '\OC\Memcache\Redis',
  'redis' => [
    'host'     => '/var/run/redis/redis.sock',
    'port'     => 0,
    'dbindex'  => 0,
    'password' => '',
    'timeout'  => 1.5,
    ],
  'htaccess.RewriteBase' => '/',
#  'app_install_overwrite' => 
# array (
#  0 => 'documentserver_community',
# ),
  'maintenance' => false,
);

it hasn’t changed much since
i’ve just uncommented the cache settings

punkyard · August 31, 2022, 6:31pm

after testing on several nextcloud settings
it seems there is a conflict with ClamAV when it’s installed on the server and enabled in Nextcloud

ARI · August 31, 2022, 6:53pm

Try this script from Carsten Rieger. I have used these with each new release of NC. It really works in 10 minutes. (and then I donate to him)

punkyard · August 31, 2022, 7:16pm

Thanks @ARI i’ll keep that one for later, i don’t think i’ll run a 20th install