!Friendica Support
I had my first-ever server crash of https://my-place.social. This is in syslog:

2024-11-18T21:34:49.022603-05:00 my-place php: PHP Fatal error: Uncaught mysqli_sql_exception: Too many connections in /var/www/html/src/Database/Database.php:201
2024-11-18T21:34:49.022822-05:00 my-place php: Stack trace:
2024-11-18T21:34:49.022855-05:00 my-place php: #0 /var/www/html/src/Database/Database.php(201): mysqli->__construct()
2024-11-18T21:34:49.022885-05:00 my-place php: #1 /var/www/html/src/Database/Database.php(106): Friendica\Database\Database->connect()
2024-11-18T21:34:49.022911-05:00 my-place php: #2 [internal function]: Friendica\Database\Database->__construct()
2024-11-18T21:34:49.022933-05:00 my-place php: #3 /var/www/html/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs()
2024-11-18T21:34:49.022958-05:00 my-place php: #4 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.022985-05:00 my-place php: #5 /var/www/html/vendor/level-2/dice/Dice.php(247): Dice\Dice->create()
2024-11-18T21:34:49.023014-05:00 my-place php: #6 /var/www/html/vendor/level-2/dice/Dice.php(132): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023049-05:00 my-place php: #7 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023074-05:00 my-place php: #8 /var/www/html/vendor/level-2/dice/Dice.php(247): Dice\Dice->create()
2024-11-18T21:34:49.023100-05:00 my-place php: #9 /var/www/html/vendor/level-2/dice/Dice.php(132): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023125-05:00 my-place php: #10 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
2024-11-18T21:34:49.023147-05:00 my-place php: #11 /var/www/html/index.php(34): Dice\Dice->create()
2024-11-18T21:34:49.023172-05:00 my-place php: #12 {main}
2024-11-18T21:34:49.023208-05:00 my-place php: thrown in /var/www/html/src/Database/Database.php on line 201

show variables like 'max_connections'; shows 151 max_connections.

I did: SET GLOBAL max_connections = 200;

I also edited /etc/mysql/mariadb.conf.d/50-server.cnf and set max_connections = 200

Is this too high? Too low? Did I do this the correct way?

Thank you!

Thanks!

Uppsi.
The Server works so far, but going to /admon/site throws an error:
---
Service Unavailable

unable to create directory /var/www/friendica/view/smarty3/compiled/58/70/d1

Exception thrown in /var/www/friendica/src/Core/Renderer.php:90
Stack trace:
#0 /var/www/friendica/src/Module/Admin/Site.php(592): Friendica\Core\Renderer::replaceMacros('file:/var/www/f...', Array)
#1 /var/www/friendica/src/BaseModule.php(250): Friendica\Module\Admin\Site->content(Array)
#2 /var/www/friendica/src/App.php(711): Friendica\BaseModule->run(Object(Friendica\Module\Special\HTTPException), Array)
#3 /var/www/friendica/index.php(55): Friendica\App->runFrontend(Object(Friendica\App\Router), Object(Friendica\Core\PConfig\Type\JitPConfig), Object(Friendica\Security\Authentication), Object(Friendica\App\Page), Object(Friendica\Content\Nav), Object(Friendica\Module\Special\HTTPException), Object(Friendica\Util\HTTPInputData), 1702744026.4542, Array)
#4 {main}

Request: 657dcfda7165b
---
BTW. Sorry for not using some formatting (e.g., for code), but currently, I'm running from a live Slax on an ancient laptop with an exotic German keyboard.

New error message (of FRIO) about a folder created by the user root.

I haven't found the extensive conversation about this problem with @Hypolite Petovan yet but I'm quite sure that I changed all folders to ownership of user www-data before 28th of November of the smarty folder. Actually there was another conversation about ownership of folders and I changed all folders to be owned by root except storage and view that day on 02:45hs, the new folder owned by root at /view/smarty3/compiled/ like stated below was created on 3:50hs.

As for what I remember of all the conversations this shouldn't have happened.

<?php
/* Smarty version 4.3.1, created on 2023-11-28 03:50:02
  from '7cd2693513597460a71347ba02d3179c5e5ab822' */
/* @var Smarty_Internal_Template $_smarty_tpl */
if ($_smarty_tpl->_decodeProperties($_smarty_tpl, array (
  'version' => '4.3.1',
  'unifunc' => 'content_6565636a645732_50647552',
  'has_nocache_code' => false,
  'file_dependency' => 
  array (
  ),
  'includes' => 
  array (
  ),
),false)) {
function content_6565636a645732_50647552 (Smarty_Internal_Template $_smarty_tpl) {
?>[url=https://tupambae.org/profile/utopiarte]utopiArte[/url] replied to you on [url=https://tupambae.org/display/0ac89072-1065-6562-6405-8bb240314547]"bugreport - can't answer, like or reshare posts"[/url]<?p>

utopiArte

2023-11-28 03:45:40

> bugreport - can't answer, like or reshare posts

Somehow this is still happening, the profile tutorial can't reply on standard posts of admin or utopiarte.

admin profile trouble
#bugResearch

I didn't have a look at gitHub

--

information for dev and server team:
The only error that is printed in the error log file every once in a while is:

@Friendica Support

#bugResearch

hi there, I have this message in my php.error.log

what should I do?

I didn't have a look at gitHub

@utzer [Friendica]
smallest VPS:
VPS #1
1GB RAM
1 CPU
25GB DISK
1TB TRANSFER(tx+rx)

your recomandation:
VPS #4
8GB RAM
4 CPU
160GB DISK
5TB TRANSFER(tx+rx)

btw, this is what they state about the debian options:

OpenVPN
For freedom fighters
The only VPN to be trusted is the one you have full control over.
The server and client certificates are automatically generated and the client file sent via email to the customer after. Runs on port 443, which is almost always accessible. All logging is sent to /dev/null and DNS queries are made on the same server.

Wireguard
Also for freedom fighters
40-50% faster than OpenVPN.
Route all your traffic through an encrypted tunnel, perfect for bypassing internet controlled by a fascist government.

LEMP
Ready to use webserver
LEMP stands for Linux, nginx (pronounced Engine x), MySQL, and PHP. It comes preconfigured with an optimized PHP setup which can run, depending on the size of the server, load heavy sites. It is also good as a content delivery server for example advertisement banners, videos, or even a fileserver for files to download.

Nextcloud Server
Ready to use Nextcloud
Run your own cloud service.
Nextcloud, the next generation open source Enterprise File Sync and Share software, the server is optimized for high usage with Let's Encrypt https certificate.

@bitPickup mʕ•ﻌ•ʔm @Hank G ☑️ @Raroun @TupambAdmin

!Friendica Support
https://wiki.friendi.ca/docs/install
So I am stuck at the create a database point. I can't tell if they just told me, create a database without telling me how or if this helped create a database. I went with B and here were the resutls. Are there peices missing or are these warnings ok for the system we are using?

$ bin/console autoinstall -v
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
Executable: /home/anubis2814/mywebsite/bin/console.php
Arguments: array (
0 => 'autoinstall',
)
Options: array (
'v' => 1,
)
Command: autoinstall
Initializing setup...
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
Complete!

Checking environment...
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
PHP Warning: Module "curl" is already loaded in Unknown on line 0
PHP Warning: Module "gd" is already loaded in Unknown on line 0
PHP Warning: Module "mbstring" is already loaded in Unknown on line 0
NOTICE: Not checking .htaccess/URL-Rewrite during CLI installation.

[Error] --------
GNU Multiple Precision PHP module: Error: GNU Multiple Precision PHP module required but not installed.

[Backtrace]:
#0 /home/anubis2814/mywebsite/vendor/asika/simple-console/src/Console.php(108): Friendica\Console\AutomaticInstallation->doExecute()
#1 /home/anubis2814/mywebsite/src/Core/Console.php(163): Asika\SimpleConsole\Console->execute()
#2 /home/anubis2814/mywebsite/vendor/asika/simple-console/src/Console.php(108): Friendica\Core\Console->doExecute()
#3 /home/anubis2814/mywebsite/bin/console.php(41): Asika\SimpleConsole\Console->execute()
#4 {main}

• Die ersten fünf Notices sind das Umschalten auf PHP 7.4.
  
• Dann kommt die erste Warnung beim Aufruf der Friendica-Login-Seite, gefolgt von acht weiteren Warnungen.
  
• Der Zyklus von insgesamt neun Warnungen wiederholt sich fünf mal identisch, es sind also insgesamt sechs Zyklen mit je neun Warnungen.
  
• Nun wird im Browser der 500er-Error von vorhin angezeigt.

[10-Feb-2022 21:34:31] NOTICE: configuration file /opt/uberspace/etc/snila/php-fpm.conf test is successful
[10-Feb-2022 21:34:31] NOTICE: using inherited socket fd=3, "/run/php-fpm-snila.sock"
[10-Feb-2022 21:34:31] NOTICE: fpm is running, pid 24296
[10-Feb-2022 21:34:31] NOTICE: ready to handle connections
[10-Feb-2022 21:34:31] NOTICE: systemd monitor interval set to 10000ms
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "[10-Feb-2022 21:34:34 Europe/Berlin] PHP Notice: Undefined index: Psr\Log\NullLogger in /var/www/virtual/snila/html/vendor/level-2/dice/Dice.php on line 134"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "[10-Feb-2022 21:34:34 Europe/Berlin] PHP Fatal error: Uncaught TypeError: Argument 3 passed to Friendica\Database\Database::__construct() must implement interface PsrExt\Log\LoggerInterface, instance of Friendica\Core\Logger\Factory\Logger given in /var/www/virtual/snila/html/src/Database/Database.php:76"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "Stack trace:"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "#0 [internal function]: Friendica\Database\Database->__construct(Object(Friendica\Core\Config\ValueObject\Cache), Object(Friendica\Util\Profiler), Object(Friendica\Core\Logger\Factory\Logger))"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "#1 /var/www/virtual/snila/html/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs(Object(Friendica\Database\Database), Array)"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "#2 /var/www/virtual/snila/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}(Array, Array)"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "#3 /var/www/virtual/snila/html/vendor/level-2/dice/Dice.php(247): Dice\Dice->create('Friendica\\Datab...', Array, Array)"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "#4 /var/www/virtual/snila/html/vendor/level-2/dice/Dice.php(149): Dice\Dice->Dice\{closure}(Array, Array)"
[10-Feb-2022 21:34:34] WARNING: [pool www] child 24331 said into stderr: "#5 /var/www/virtual/snila/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}(Arra in /var/www/virtual/snila/html/src/Database/Database.php on line 76"