Skip to main content

PHP error log thrown in /src/Database/Database.php on line 191

@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

php.error.log Database.php on line 191thrown in /var/www/html/src/Database/Database.php on line 191
[14-Nov-2023 14:15:30 UTC] PHP Fatal error: Uncaught mysqli_sql_exception: Connection refused in /var/www/html/src/Database/Database.php:191
Stack trace:
#0 /var/www/html/src/Database/Database.php(191): mysqli->__construct()
#1 /var/www/html/src/Database/Database.php(97): Friendica\Database\Database->connect()
#2 [internal function]: Friendica\Database\Database->__construct()
#3 /var/www/html/vendor/level-2/dice/Dice.php(132): ReflectionMethod->invokeArgs()
#4 /var/www/html/vendor/level-2/dice/Dice.php(96): Dice\Dice->Dice\{closure}()
#5 /var/www/html/src/DI.php(98): Dice\Dice->create()
#6 /var/www/html/src/DI.php(66): Friendica\DI::dba()
#7 /var/www/html/src/DI.php(54): Friendica\DI::setCompositeRootDependencyByHand()
#8 /var/www/html/index.php(35): Friendica\DI::init()
#9 {main}
thrown in /var/www/html/src/Database/Database.php on line 191

Platform Info: 2023.05 - stableFriendica Version: 2023.05 - stable
Friendica Source: gitHub
PHP version: 8.1.2-1ubuntu2.14
SQL version: MySQL / MariaDB
memory_limit 256M
4 Core CPU, 8 GB Ram with 300GB NVME Disk
#1 #2 #7 #9 #3 #5 #6 #4 #8 #bugResearch @Friendica Support
in reply to utopiArte

silverwizard
silverwizard
•
@utopiArte that starts with a "connection refused"
is the mysql server connecting at all? Is the password right?
@utopiArte

Friendica Support reshared this.

in reply to utopiArte

Hypolite Petovan
Hypolite Petovan
• •
@utopiArte Connection refused means that your database configuration is wrong in your local.config.php file.
@utopiArte
This entry was edited (1 year ago)

Friendica Support reshared this.

in reply to Hypolite Petovan

utopiArte
utopiArte
• •

this error message appears like every once in a while.
there is this doubt I have that I posted before:
tupambae.org/display/0ac89072-…

@silverwizard
> is the mysql server connecting at all?

Could I be able to domost things but not with all profiles?
I mean I posted these helpreuqestsuploadpictures, answer posts, get notifications.
There a profiles that can't comment on public posts of others even tho they should be able to.

TupambAdmin [stable]

2023-11-17 18:10:38


@Friendica Support

Is there a way to do some kind of general recheck of the settings inside the DB or something like that?

This server was hosted at a BETA testing.
In the local.config.php there was apparently a wrong setting:
'hostname' => 'subdomain.oldhosting.com:3306',<-- WRONG SETTING AT OLD PROVIDER!!!
'hostname' => 'localhost',<-- Correct setting!

Different things on that installation didn't work, like posting to the helpers forum, a 500 error showed up.

There are several bugs I encounter that don't look to me like "normal" in the sense that they should have been noticed and fixed by the community in any case already.

So now I wonder if there is some routine I can execute that checks settings that could have been set wrongly, be it by the error described above or other problems.


@silverwizard

Friendica Support reshared this.

in reply to utopiArte

Hypolite Petovan
Hypolite Petovan
• •
@utopiArte If it’s sporadic and your node mostly works, then your database server might be acting up. In this case, there’s little that can be done at the Friendica level. Has your database server enough resources to run?
@utopiArte

Friendica Support reshared this.

in reply to Hypolite Petovan

utopiArte
utopiArte
• •

Have a look at the spoiler above:
Platform Info: 2023.05 - stable
memory_limit 256M
4 Core CPU, 8 GB Ram with 300GB NVME Disk

That should be more than suffice and the server has basically no users, only some forum pages with few followers as of now.

Again, going back to my initial question of the other help request.
tupambae.org/display/0ac89072-…

Is it possible that in the moment of initial installation on the BETA testing site the setting:
'hostname' => 'subdomain.oldhosting.com:3306'
was registered somewhere in the DB and is messing now with some functionality while the node actually migrated to a standard Ubuntu VPS that doesn't use some kind of SNAP installation?

TupambAdmin [stable]

2023-11-17 18:10:38


@Friendica Support

Is there a way to do some kind of general recheck of the settings inside the DB or something like that?

This server was hosted at a BETA testing.
In the local.config.php there was apparently a wrong setting:
'hostname' => 'subdomain.oldhosting.com:3306',<-- WRONG SETTING AT OLD PROVIDER!!!
'hostname' => 'localhost',<-- Correct setting!

Different things on that installation didn't work, like posting to the helpers forum, a 500 error showed up.

There are several bugs I encounter that don't look to me like "normal" in the sense that they should have been noticed and fixed by the community in any case already.

So now I wonder if there is some routine I can execute that checks settings that could have been set wrongly, be it by the error described above or other problems.


Friendica Support reshared this.

in reply to utopiArte

silverwizard
silverwizard
•
@utopiArte @Hypolite Petovan yeah - if the user is allowed access from only subdomain.oldhosting.com in mysql (check the users table) then you wont have access and your connection will be refused
@Hypolite Petovan @utopiArte

Friendica Support reshared this.

⇧