Drupa security

Found 2 security vulnerability advisories affecting 2 packages:

my_custom_module1.routing.yml

Solution 1 (low level security: at least one of roles required):

Code:

Convert "Western European" encoding to UTF-8 (from ISO-8859-1 / Windows-1252):

$my_detect_encoding = mb_detect_encoding($content, mb_detect_order(), false);
    
if( $my_detect_encoding != 'UTF-8'){
	$content= iconv('ISO-8859-1', 'UTF-8//TRANSLIT//IGNORE', $content);
}

Problem:

Timezone of Server/PHP/Drupal : Europe/Germany

Datetime value converted automatically to UTC + 120 Minutes (Europe/Germany). 

Solution:

Convert Datetime to UTC before saving node. 

PHP Code (modules/custom/my_module/src/Controller/MyController1.php):

CSS:

word-break: break-word;
overflow-wrap: break-word;
hyphenate-limit-chars: 15 5 5;

Problem:

Drupal\Core\Http\Exception\CacheableAccessDeniedHttpException: in Drupal\Core\Routing\AccessAwareRouter->checkAccess() (line 115

Solution

Give DB User File permission:

mysqldump --user=MyDBUser --password --tab=/tmp/my_export_dir MyDBName

Install sysbench:

apt-get install sysbench

CPU benchmarking (single-threaded / all cores):
 

sysbench cpu run

sysbench --threads="$(nproc)" cpu run

Problem:

Fatal error: Composer detected issues in your platform: 
Your Composer dependencies require a PHP version ">= 8.2.0".