!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!

This is currently my theme song.
https://youtu.be/U4n_8R5lKnw?si=jiexdE1R4wof82KR

Level Up

So come out.
You have been waiting long enough.
You're done with all the talk talk talk with nothing on the table.
It's time to come on out.
There will be no sign from above.
You'll only hear the knock knock knock of your own heart as signal.
If you are afraid, come out.
If you are awake, come out.
Come out and level up.
Begin again.
Dynamite the dam on the flow.
Your body feels the tock tock tock of time as it hammers.
Lord we are all cinders
From a fire burning long ago,
But here it is the knock knock knock of your own heart that matters.
If you are afraid, come forth.
If you are alone, come forth now.
Everybody here has loved and lost,
So level up and love again.
Call it any name you need.
Call it your 2.0, your rebirth, whatever –
So long as you can feel it all,
So long as all your doors are flung wide.
Call it your day #1 in the rest of forever.
If you are afraid, give more.
If you are alive, give more now.
Everybody here has seams and scars.
So what. level up.
Let your faith die.
Bring your wonder.
Yes, you are only one.
No, it is not enough
But if you lift your eyes, I am your brother.
And this is all we need.
And this is where we start.
This is the day we greet.
This is the day, no other.
~Vienna Teng

@Fly Boy
@Andy H3
@Michael Vogel
@Hypolite Petovan

I checked my bin permissions:
4 drwxrwxr-x 3 www-data www-data 4096 Feb 20 13:39

Is this where I run the command you noted?

YOU noted that I cannot run as root. Well, I always did. I will stop running as admin.

When I did execute the command, I get this result:

PHP Warning: include(/var/www/html/config/local.config.php): Failed to open stream: Permission denied in /var/www/html/src/Core/Config/Util/ConfigFileManager.php on line 362
PHP Warning: include(): Failed opening '/var/www/html/config/local.config.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/src/Core/Config/Util/ConfigFileManager.php on line 362
PHP Fatal error: Uncaught Friendica\Core\Config\Exception\ConfigFileException: Error loading config file /var/www/html/config/local.config.php in /var/www/html/src/Core/Config/Util/ConfigFileManager.php:365
Stack trace:
#0 /var/www/html/src/Core/Config/Util/ConfigFileManager.php(162): Friendica\Core\Config\Util\ConfigFileManager->loadConfigFile()
#1 /var/www/html/src/Core/Config/Util/ConfigFileManager.php(112): Friendica\Core\Config\Util\ConfigFileManager->loadCoreConfig()

The first few were PHP warning. Is this why you said to change it to run as PHP?

Thanks

@Michael Vogel
@Andy H3

I entered the command just as @Hypolite Petovan typed it in, and it does not like it. Here is the result:
root@social:/var/www/html# bin/console -v relay add https://relay.mycrowd.ca/actor
Executable: /var/www/html/bin/console.php
Arguments: array (
0 => 'add',
1 => 'https://relay.mycrowd.ca/actor',
)
Options: array (
'v' => 'relay',
)
Command: add
[Warning] Command add doesn't exist

Usage: bin/console [--version] [-h|--help|-?] <command> [<args>] [-v]

Commands:
addon Addon management
cache Manage node cache
config Edit site config
contact Contact management
createdoxygen Generate Doxygen headers
dbstructure Do database updates
docbloxerrorchecker Check the file tree for DocBlox errors
extract Generate translation string file for the Friendica project (deprecated)
globalcommunityblock Block remote profile from interacting with this node
globalcommunitysilence Silence a profile from the global community page
archivecontact Archive a contact when you know that it isn't existing anymore
help Show help about a command, e.g (bin/console help config)
autoinstall Starts automatic installation of friendica based on values from htconfig.php
lock Edit site locks
maintenance Set maintenance mode for this node
movetoavatarcache Move cached avatars to the file based avatar cache
mergecontacts Merge duplicated contact entries
user User management
php2po Generate a messages.po file from a strings.php file
po2php Generate a strings.php file from a messages.po file
typo Checks for parse errors in Friendica files
postupdate Execute pending post update scripts (can last days)
relocate Update node base URL
serverblock Manage blocked servers
storage Manage storage backend
relay Manage ActivityPub relay servers

Options:
-h|--help|-? Show help information
-v Show more debug information.
[Backtrace]:
#0 /var/www/html/src/Core/Console.php(157): Friendica\Core\Console->getSubConsole()
#1 /var/www/html/vendor/asika/simple-console/src/Console.php(108): Friendica\Core\Console->doExecute()
#2 /var/www/html/bin/console.php(45): Asika\SimpleConsole\Console->execute()
#3 {main}

Thanks for any ideas.

I entered the command just as @Hypolite Petovan typed it in, and it does not like it. Here is the result:
root@social:/var/www/html# bin/console -v relay add https://relay.mycrowd.ca/actor
Executable: /var/www/html/bin/console.php
Arguments: array (
0 => 'add',
1 => 'https://relay.mycrowd.ca/actor',
)
Options: array (
'v' => 'relay',
)
Command: add
[Warning] Command add doesn't exist

Usage: bin/console [--version] [-h|--help|-?] <command> [<args>] [-v]

Commands:
addon Addon management
cache Manage node cache
config Edit site config
contact Contact management
createdoxygen Generate Doxygen headers
dbstructure Do database updates
docbloxerrorchecker Check the file tree for DocBlox errors
extract Generate translation string file for the Friendica project (deprecated)
globalcommunityblock Block remote profile from interacting with this node
globalcommunitysilence Silence a profile from the global community page
archivecontact Archive a contact when you know that it isn't existing anymore
help Show help about a command, e.g (bin/console help config)
autoinstall Starts automatic installation of friendica based on values from htconfig.php
lock Edit site locks
maintenance Set maintenance mode for this node
movetoavatarcache Move cached avatars to the file based avatar cache
mergecontacts Merge duplicated contact entries
user User management
php2po Generate a messages.po file from a strings.php file
po2php Generate a strings.php file from a messages.po file
typo Checks for parse errors in Friendica files
postupdate Execute pending post update scripts (can last days)
relocate Update node base URL
serverblock Manage blocked servers
storage Manage storage backend
relay Manage ActivityPub relay servers

Options:
-h|--help|-? Show help information
-v Show more debug information.
[Backtrace]:
#0 /var/www/html/src/Core/Console.php(157): Friendica\Core\Console->getSubConsole()
#1 /var/www/html/vendor/asika/simple-console/src/Console.php(108): Friendica\Core\Console->doExecute()
#2 /var/www/html/bin/console.php(45): Asika\SimpleConsole\Console->execute()
#3 {main}

Thanks for any ideas.

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>

@Hypolite Petovan Hello. After lots more testing today, i now have 50% happy news!

1. I've still never succeeded in receiving a DM in Masto that was sent from Friendica [both libranet.de AND a new venera.social account i made today], if i use the 4-tab popup post-composer windowlet, with my Masto handle listed in the Permissions tab as a Private Message. Every single time, the DM appears to Send ok from Friendica, but it simply never arrives in Masto. Otoh...
2. Finally i have succeeded in sending DMs that DO arrive in Masto, using the Friendica "Envelope Icon" toolbar shortcut to https://libranet.de/message. The solution was exasperatingly simple, yet completely obscure to me for 36 hours coz i was relentlessly just blindly following posting "the Masto way", unaware that this is wrong in Friendica. Specifically in https://libranet.de/message, each previous time that i had tried unsuccessfully to send a DM, i had prefaced my Masto handle with "@", because in Masto that IS part of the handle. It was only today that finally i decided to see what would happen if i omitted that leading "@", at which point i was delighted but astonished to see that finally the autodetect kicked in, it successfully matched my correct handle, & consequently all my DMs now DO properly Send from both my Friendica accounts, AND get received in my Masto account. Phew & thank bloody goodness, coz this was driving me batty!

I'm still disappointed that #1 does not work for me, but very happy that at least #2 does.

As such, this certainly eliminates any possibility that my problem [#1 OR #2] might have been caused by a bug in the Dev version [libranet.de], given that i proved today that the problem equally occurred in the Stable version [venera.social] ... and now i know how to avoid/solve #2.

Thank you all for helping, & sorry that i was such a slow learner.

!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}