IncidentsTable::getReportDetails() - Code Metrics - phpmyadmin/error-reporting-server - Measure and Improve Code Quality continuously with Scrutinizer

IncidentsTable::getReportDetails() A
last analyzed 2024-09-02 13:01 UTC

↳ Parent: IncidentsTable

Complexity

Conditions	3
Paths	2

Size

Total Lines	37
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	24
CRAP Score	3

Importance

Changes

Metric	Value
cc	3
eloc	25
nc	2
nop	2
dl	0
loc	37
ccs	24
cts	24
cp	1
crap	3
rs	9.52
c	0
b	0
f	0

<?php

/**
 * An incident a representing a single incident of a submited bug.
 *
 * phpMyAdmin Error reporting server
 * Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
 *
 * Licensed under The MIT License
 * For full copyright and license information, please see the LICENSE.txt
 * Redistributions of files must retain the above copyright notice.
 *
 * @copyright Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
 * @license   https://opensource.org/licenses/mit-license.php MIT License
 *
 * @see      https://www.phpmyadmin.net/
 */

namespace App\Model\Table;

use Cake\Log\Log;
use Cake\Model\Model;
use Cake\ORM\Entity;
use Cake\ORM\Table;
use Cake\ORM\TableRegistry;

use function array_merge;
use function array_push;
use function array_slice;
use function count;
use function date;
use function hash_final;
use function hash_init;
use function hash_update;
use function in_array;
use function json_encode;
use function mb_strimwidth;
use function mb_strlen;
use function preg_match;
use function strtotime;
use function time;

/**
 * An incident a representing a single incident of a submited bug.
 */
class IncidentsTable extends Table
{
    /**
     * @var array
     *
     * @see http://book.cakephp.org/2.0/en/models/behaviors.html#using-behaviors
     * @see Model::$actsAs
     */
    public $actsAs = ['Summarizable'];

    /**
     * @var array
     *
     * @see http://book.cakephp.org/2.0/en/models/model-attributes.html#validate
     * @see http://book.cakephp.org/2.0/en/models/data-validation.html
     * @see Model::$validate
     */
    public $validate = [
        'pma_version' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'php_version' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'full_report' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'stacktrace' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'browser' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'stackhash' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'user_os' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'locale' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'script_name' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'server_software' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
        'configuration_storage' => [
            'rule' => 'notEmpty',
            'required' => true,
        ],
    ];

    /**
     * @var array
     *
     * @see http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#belongsto
     * @see Model::$belongsTo
     */

    /**
     * The fields which are summarized in the report page with charts and are also
     * used in the overall stats and charts for the website.
     *
     * @var array
     */
    public $summarizableFields = [
        'browser',
        'pma_version',
        'php_version',
        'locale',
        'server_software',
        'user_os',
        'script_name',
        'configuration_storage',
    ];

    /** @var array[] */
    public $filterTimes = [];

    public function __construct(array $data)
    {
        parent::__construct($data);

        $this->filterTimes = [
            'all_time' => [
                'label' => 'All Time',
                'limit' => null,
                'group' => "DATE_FORMAT(Incidents.created, '%m %Y')",
            ],
            'day' => [
                'label' => 'Last Day',
                'limit' => date('Y-m-d', strtotime('-1 day')),
                'group' => "DATE_FORMAT(Incidents.created, '%a %b %d %Y %H')",
            ],
            'week' => [
                'label' => 'Last Week',
                'limit' => date('Y-m-d', strtotime('-1 week')),
                'group' => "DATE_FORMAT(Incidents.created, '%a %b %d %Y')",
            ],
            'month' => [
                'label' => 'Last Month',
                'limit' => date('Y-m-d', strtotime('-1 month')),
                'group' => "DATE_FORMAT(Incidents.created, '%a %b %d %Y')",
            ],
            'year' => [
                'label' => 'Last Year',
                'limit' => date('Y-m-d', strtotime('-1 year')),
                'group' => "DATE_FORMAT(Incidents.created, '%b %u %Y')",
            ],
        ];
    }

    /**
     * creates an incident/report record given a raw bug report object.
     *
     * This gets a decoded bug report from the submitted json body. This has not
     * yet been santized. It either adds it as an incident to another report or
     * creates a new report if nothing matches.
     *
     * @param array|null $bugReport the bug report being submitted
     *
     * @return array of:
     *          1. array of inserted incident ids. If the report/incident was not
     *               correctly saved, false is put in it place.
     *          2. array of newly created report ids. If no new report was created,
     *               an empty array is returned
     */
    public function createIncidentFromBugReport(?array $bugReport): array
    {
        if ($bugReport === null) {
            return [
                'incidents' => [false],
                'reports' => [],
            ];
        }

        $incident_ids = [];    // array to hold ids of all the inserted incidents
        $new_report_ids = []; // array to hold ids of all newly created reports

        // Avoid storing too many errors from single report
        if (isset($bugReport['errors']) && count($bugReport['errors']) > 40) {
            $bugReport['errors'] = array_slice($bugReport['errors'], 0, 40);
        }

        if (isset($bugReport['exception']['stack']) && count($bugReport['exception']['stack']) > 40) {
            $bugReport['exception']['stack'] = array_slice($bugReport['exception']['stack'], 0, 40);
        }

        // Also sanitizes the bug report
        $schematizedIncidents = $this->getSchematizedIncidents($bugReport);
        $incidentsTable = TableRegistry::getTableLocator()->get('Incidents');
        $reportsTable = TableRegistry::getTableLocator()->get('Reports');
        foreach ($schematizedIncidents as $index => $si) {
            // find closest report. If not found, create a new report.
            $closestReport = $this->getClosestReport($bugReport, $index);
            if ($closestReport) {
                $si['report_id'] = $closestReport['id'];
                $si['error_message'] = mb_strimwidth($si['error_message'], 0, 200, '...');
                $si = $incidentsTable->newEntity($si);
                $si->created = date('Y-m-d H:i:s', time());
                $si->modified = date('Y-m-d H:i:s', time());

                $this->logLongIncidentSubmissions($si, $incident_ids);
                if (in_array(false, $incident_ids)) {
                    break;
                }
            } else {
                // no close report. Create a new report.
                $report = $this->getReportDetails($bugReport, $index);

                $this->logLongIncidentSubmissions($si, $incident_ids);
                if (in_array(false, $incident_ids)) {
                    break;
                }

                $report = $reportsTable->newEntity($report);
                $report->created = date('Y-m-d H:i:s', time());
                $report->modified = date('Y-m-d H:i:s', time());
                $reportsTable->save($report);

                $si['report_id'] = $report->id;
                $si['error_message'] = mb_strimwidth($si['error_message'], 0, 200, '...');
                $new_report_ids[] = $report->id;
                $si = $incidentsTable->newEntity($si);
                $si->created = date('Y-m-d H:i:s', time());
                $si->modified = date('Y-m-d H:i:s', time());
            }

            $isSaved = $incidentsTable->save($si);
            if ($isSaved) {
                array_push($incident_ids, $si->id);
                if (! $closestReport) {
                    // add notifications entry
                    $tmpIncident = $incidentsTable->findById($si->id)->all()->first();
                    if (! TableRegistry::getTableLocator()->get('Notifications')->addNotifications((int) $tmpIncident['report_id'])) {
                        Log::write(
                            'error',
                            'ERRORED: Notification::addNotifications() failed on Report#'
                                . $tmpIncident['report_id'],
                            'alert'
                        );
                    }
                }
            } else {
                array_push($incident_ids, false);
            }
        }

        return [
            'incidents' => $incident_ids,
            'reports' => $new_report_ids,
        ];
    }

    /**
     * retrieves the closest report to a given bug report.
     *
     * it checks for another report with the same line number, filename and
     * pma_version
     *
     * @param array $bugReport the bug report being checked
     *                         Integer $index: for php exception type
     * @param int   $index     The report index
     *
     * @return Entity|null the first similar report or null
     */
    protected function getClosestReport(array $bugReport, int $index = 0): ?Entity
    {
        if (
            isset($bugReport['exception_type'])
            && $bugReport['exception_type'] === 'php'
        ) {
            $location = $bugReport['errors'][$index]['file'];
            $linenumber = $bugReport['errors'][$index]['lineNum'];
        } else {
            [$location, $linenumber] =
                    $this->getIdentifyingLocation($bugReport['exception']['stack'] ?? []);
        }

        return TableRegistry::getTableLocator()->get('Reports')->findByLocationAndLinenumberAndPmaVersion(
            $location,
            $linenumber,
            self::getStrippedPmaVersion($bugReport['pma_version'])
        )->all()->first();
    }

    /**
     * creates the report data from an incident that has no related report.
     *
     * @param array $bugReport the bug report the report record is being created for
     *                         Integer $index: for php exception type
     * @param int   $index     The report index
     *
     * @return array an array with the report fields can be used with Report->save
     */
    protected function getReportDetails(array $bugReport, int $index = 0): array
    {
        if (
            isset($bugReport['exception_type'])
            && $bugReport['exception_type'] === 'php'
        ) {
            $location = $bugReport['errors'][$index]['file'];
            $linenumber = $bugReport['errors'][$index]['lineNum'];
            $reportDetails = [
                'error_message' => $bugReport['errors'][$index]['msg'],
                'error_name' => $bugReport['errors'][$index]['type'],
            ];
            $exception_type = 1;
        } else {
            $exception = $bugReport['exception'] ?? [];
            [$location, $linenumber] =
                $this->getIdentifyingLocation($exception['stack'] ?? []);

            $reportDetails = [
                'error_message' => $exception['message'] ?? '',
                'error_name' => $exception['name'] ?? '',
            ];
            $exception_type = 0;
        }

        $reportDetails = array_merge(
            $reportDetails,
            [
                'status' => 'new',
                'location' => $location,
                'linenumber' => $linenumber ?? 0,
                'pma_version' => self::getStrippedPmaVersion($bugReport['pma_version']),
                'exception_type' => $exception_type,
            ]
        );

        return $reportDetails;
    }

    /**
     * creates the incident data from the submitted bug report.
     *
     * @param array $bugReport the bug report the report record is being created for
     *
     * @return array an array of schematized incident.
     *               Can be used with Incident->save
     */
    protected function getSchematizedIncidents(array $bugReport): array
    {
        //$bugReport = Sanitize::clean($bugReport, array('escape' => false));
        $schematizedReports = [];
        $schematizedCommonReport = [
            'pma_version' => self::getStrippedPmaVersion($bugReport['pma_version']),
            'php_version' => $this->getSimpleVersion($bugReport['php_version'] ?? '', 2),
            'browser' => ($bugReport['browser_name'] ?? '') . ' '
                    . $this->getSimpleVersion($bugReport['browser_version'] ?? '', 1),
            'user_os' => $bugReport['user_os'] ?? '',
            'locale' => $bugReport['locale'] ?? '',
            'configuration_storage' => $bugReport['configuration_storage'] ?? '',
            'server_software' => $this->getServer($bugReport['server_software'] ?? ''),
            'full_report' => json_encode($bugReport),
        ];

        if (
            isset($bugReport['exception_type'])
            && $bugReport['exception_type'] === 'php'
        ) {
            // for each "errors"
            foreach ($bugReport['errors'] as $error) {
                $tmpReport = array_merge(
                    $schematizedCommonReport,
                    [
                        'error_name' => $error['type'],
                        'error_message' => $error['msg'],
                        'script_name' => $error['file'],
                        'stacktrace' => json_encode($error['stackTrace'] ?? []),
                        'stackhash' => $error['stackhash'],
                        'exception_type' => 1,         // 'php'
                    ]
                );
                array_push($schematizedReports, $tmpReport);
            }
        } else {
            $exception = $bugReport['exception'] ?? [
                'name' => '',
                'message' => '',
                'stack' => [],
            ];
            $tmpReport = array_merge(
                $schematizedCommonReport,
                [
                    'error_name' => $exception['name'] ?? '',
                    'error_message' => $exception['message'] ?? '',
                    'script_name' => $bugReport['script_name'] ?? '',
                    'stacktrace' => json_encode($exception['stack'] ?? []),
                    'stackhash' => self::getStackHash($exception['stack'] ?? []),
                    'exception_type' => 0,     //'js'
                ]
            );

            if (isset($bugReport['steps'])) {
                $tmpReport['steps'] = $bugReport['steps'];
            }

            array_push($schematizedReports, $tmpReport);
        }

        return $schematizedReports;
    }

    /**
     * Gets the identifiying location info from a stacktrace.
     *
     * This is used to skip stacktrace levels that are within the error reporting js
     * files that sometimes appear in the stacktrace but are not related to the bug
     * report
     *
     * returns two things in an array:
     * - the first element is the filename/scriptname of the error
     * - the second element is the linenumber of the error
     *
     * @param array $stacktrace the stacktrace being examined
     *
     * @return array an array with the filename/scriptname and linenumber of the
     *               error
     */
    protected function getIdentifyingLocation(array $stacktrace): array
    {
        $fallback = [
            'UNKNOWN',
            0,
        ];
        foreach ($stacktrace as $level) {
            if (isset($level['filename'])) {
                // ignore unrelated files that sometimes appear in the error report
                if ($level['filename'] === 'tracekit/tracekit.js') {
                    continue;
                }

                if ($level['filename'] === 'error_report.js') {
                    // in case the error really is in the error_report.js file save it for
                    // later
                    if ($fallback[0] === 'UNKNOWN') {
                        $fallback = [
                            $level['filename'],
                            $level['line'],
                        ];
                    }

                    continue;
                }

                return [
                    $level['filename'],
                    $level['line'],
                ];
            }

            if (isset($level['scriptname'])) {
                return [
                    $level['scriptname'],
                    $level['line'],
                ];
            }

            continue;
        }

        return $fallback;
    }

    /**
     * Gets a part of a version string according to the specified version Length.
     *
     * @param string $versionString the version string
     * @param string $versionLength the number of version components to return. eg
     *                              1 for major version only and 2 for major and
     *                              minor version
     *
     * @return string the major and minor version part
     */
    protected function getSimpleVersion(string $versionString, string $versionLength): string
    {
        $versionLength = (int) $versionLength;
        if ($versionLength < 1) {
            $versionLength = 1;
        }

        /* modify the re to accept a variable number of version components. I
         * atleast take one component and optionally get more components if need be.
         * previous code makes sure that the $versionLength variable is a positive
         * int
         */
        $result = preg_match(
            '/^(\d+\.){' . ($versionLength - 1) . '}\d+/',
            $versionString,
            $matches
        );
        if ($result) {
            return $matches[0];
        }

        return $versionString;
    }

    /**
     * Returns the version string stripped of
     * 'deb', 'ubuntu' and other suffixes
     *
     * @param string $versionString phpMyAdmin version
     *
     * @return string stripped phpMyAdmin version
     */
    public static function getStrippedPmaVersion(string $versionString): string
    {
        // This regex contains a negative lookahead to avoid fedora version suffix
        // Use: https://regex101.com/
        // See tests: IncidentsTableTest::versionsStripping
        $allowedRegexp = '/^((\d+)(\.\d+){0,3}(\-[a-z0-9]+){0,1})(?!\.[a-z]{1,}[0-9]{1,})/';
        $matches = [];

        // Check if $versionString matches the regexp
        // and store the matched strings
        if (preg_match($allowedRegexp, $versionString, $matches)) {
            return $matches[0];
        }

        // If $versionString does not match the regexp at all,
        // leave it as it is
        return $versionString;
    }

    /**
     * Gets the server name and version from the server signature.
     *
     * @param string $signature the server signature
     *
     * @return string the server name and version or UNKNOWN
     */
    protected function getServer(string $signature): string
    {
        if (
            preg_match(
                '/(apache\/\d+\.\d+)|(nginx\/\d+\.\d+)|(iis\/\d+\.\d+)'
                . '|(lighttpd\/\d+\.\d+)/i',
                $signature,
                $matches
            )
        ) {
            return $matches[0];
        }

        return 'UNKNOWN';
    }

    /**
     * returns the hash pertaining to a stacktrace.
     *
     * @param array $stacktrace the stacktrace in question
     *
     * @return string the hash string of the stacktrace
     */
    public function getStackHash(array $stacktrace): string
    {
        $handle = hash_init('md5');
        foreach ($stacktrace as $level) {
            $elements = [
                'filename',
                'scriptname',
                'line',
                'func',
                'column',
            ];
            foreach ($elements as $element) {
                if (! isset($level[$element])) {
                    continue;
                }

                hash_update($handle, $level[$element]);
            }
        }

        return hash_final($handle);
    }

    /**
     * Checks the length of stacktrace and full_report
     * and logs if it is greater than what it can hold
     *
     * @param object $si           submitted incident
     * @param array  $incident_ids incident IDs
     * @return void Nothing
     */
    private function logLongIncidentSubmissions($si, array &$incident_ids): void// phpcs:ignore SlevomatCodingStandard.TypeHints.TypeHintDeclaration.MissingParameterTypeHint
    {
        $stacktraceLength = mb_strlen($si['stacktrace']);
        $fullReportLength = mb_strlen($si['full_report']);

        if (
            $stacktraceLength <= 65535
            && $fullReportLength <= 65535
        ) {
            return;
        }

        // If length of report is longer than
        // what can fit in the table field,
        // we log it and don't save it in the database
        Log::error(
            'Too long data submitted in the incident. The length of stacktrace: '
            . $stacktraceLength . ', the length of bug report: '
            . $fullReportLength . '. The full incident reported was as follows: '
            . json_encode($si)
        );

        // add a 'false' to the return array
        array_push($incident_ids, false);
    }
}


1		<?php
2
3		/**
4		* An incident a representing a single incident of a submited bug.
5		*
6		* phpMyAdmin Error reporting server
7		* Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
8		*
9		* Licensed under The MIT License
10		* For full copyright and license information, please see the LICENSE.txt
11		* Redistributions of files must retain the above copyright notice.
12		*
13		* @copyright Copyright (c) phpMyAdmin project (https://www.phpmyadmin.net/)
14		* @license https://opensource.org/licenses/mit-license.php MIT License
15		*
16		* @see https://www.phpmyadmin.net/
17		*/
18
19		namespace App\Model\Table;
20
21		use Cake\Log\Log;
22		use Cake\Model\Model;
23		use Cake\ORM\Entity;
24		use Cake\ORM\Table;
25		use Cake\ORM\TableRegistry;
26
27		use function array_merge;
28		use function array_push;
29		use function array_slice;
30		use function count;
31		use function date;
32		use function hash_final;
33		use function hash_init;
34		use function hash_update;
35		use function in_array;
36		use function json_encode;
37		use function mb_strimwidth;
38		use function mb_strlen;
39		use function preg_match;
40		use function strtotime;
41		use function time;
42
43		/**
44		* An incident a representing a single incident of a submited bug.
45		*/
46		class IncidentsTable extends Table
47		{
48		/**
49		* @var array
50		*
51		* @see http://book.cakephp.org/2.0/en/models/behaviors.html#using-behaviors
52		* @see Model::$actsAs
53		*/
54		public $actsAs = ['Summarizable'];
55
56		/**
57		* @var array
58		*
59		* @see http://book.cakephp.org/2.0/en/models/model-attributes.html#validate
60		* @see http://book.cakephp.org/2.0/en/models/data-validation.html
61		* @see Model::$validate
62		*/
63		public $validate = [
64		'pma_version' => [
65		'rule' => 'notEmpty',
66		'required' => true,
67		],
68		'php_version' => [
69		'rule' => 'notEmpty',
70		'required' => true,
71		],
72		'full_report' => [
73		'rule' => 'notEmpty',
74		'required' => true,
75		],
76		'stacktrace' => [
77		'rule' => 'notEmpty',
78		'required' => true,
79		],
80		'browser' => [
81		'rule' => 'notEmpty',
82		'required' => true,
83		],
84		'stackhash' => [
85		'rule' => 'notEmpty',
86		'required' => true,
87		],
88		'user_os' => [
89		'rule' => 'notEmpty',
90		'required' => true,
91		],
92		'locale' => [
93		'rule' => 'notEmpty',
94		'required' => true,
95		],
96		'script_name' => [
97		'rule' => 'notEmpty',
98		'required' => true,
99		],
100		'server_software' => [
101		'rule' => 'notEmpty',
102		'required' => true,
103		],
104		'configuration_storage' => [
105		'rule' => 'notEmpty',
106		'required' => true,
107		],
108		];
109
110		/**
111		* @var array
112		*
113		* @see http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html#belongsto
114		* @see Model::$belongsTo
115		*/
116
117		/**
118		* The fields which are summarized in the report page with charts and are also
119		* used in the overall stats and charts for the website.
120		*
121		* @var array
122		*/
123		public $summarizableFields = [
124		'browser',
125		'pma_version',
126		'php_version',
127		'locale',
128		'server_software',
129		'user_os',
130		'script_name',
131		'configuration_storage',
132		];
133
134		/** @var array[] */
135		public $filterTimes = [];
136
137	315	public function __construct(array $data)
138		{
139	315	parent::__construct($data);
140
141	315	$this->filterTimes = [
142	45	'all_time' => [
143	270	'label' => 'All Time',
144		'limit' => null,
145		'group' => "DATE_FORMAT(Incidents.created, '%m %Y')",
146		],
147		'day' => [
148	315	'label' => 'Last Day',
149	315	'limit' => date('Y-m-d', strtotime('-1 day')),
150	315	'group' => "DATE_FORMAT(Incidents.created, '%a %b %d %Y %H')",
151		],
152		'week' => [
153	315	'label' => 'Last Week',
154	315	'limit' => date('Y-m-d', strtotime('-1 week')),
155	315	'group' => "DATE_FORMAT(Incidents.created, '%a %b %d %Y')",
156		],
157		'month' => [
158	315	'label' => 'Last Month',
159	315	'limit' => date('Y-m-d', strtotime('-1 month')),
160	315	'group' => "DATE_FORMAT(Incidents.created, '%a %b %d %Y')",
161		],
162		'year' => [
163	315	'label' => 'Last Year',
164	315	'limit' => date('Y-m-d', strtotime('-1 year')),
165	315	'group' => "DATE_FORMAT(Incidents.created, '%b %u %Y')",
166		],
167		];
168	315	}
169
170		/**
171		* creates an incident/report record given a raw bug report object.
172		*
173		* This gets a decoded bug report from the submitted json body. This has not
174		* yet been santized. It either adds it as an incident to another report or
175		* creates a new report if nothing matches.
176		*
177		* @param array\|null $bugReport the bug report being submitted
178		*
179		* @return array of:
180		* 1. array of inserted incident ids. If the report/incident was not
181		* correctly saved, false is put in it place.
182		* 2. array of newly created report ids. If no new report was created,
183		* an empty array is returned
184		*/
185	14	public function createIncidentFromBugReport(?array $bugReport): array
186		{
187	14	if ($bugReport === null) {
188		return [
189	7	'incidents' => [false],
190		'reports' => [],
191		];
192		}
193
194	14	$incident_ids = []; // array to hold ids of all the inserted incidents
195	14	$new_report_ids = []; // array to hold ids of all newly created reports
196
197		// Avoid storing too many errors from single report
198	14	if (isset($bugReport['errors']) && count($bugReport['errors']) > 40) {
199	7	$bugReport['errors'] = array_slice($bugReport['errors'], 0, 40);
200		}
201
202	14	if (isset($bugReport['exception']['stack']) && count($bugReport['exception']['stack']) > 40) {
203	7	$bugReport['exception']['stack'] = array_slice($bugReport['exception']['stack'], 0, 40);
204		}
205
206		// Also sanitizes the bug report
207	14	$schematizedIncidents = $this->getSchematizedIncidents($bugReport);
208	14	$incidentsTable = TableRegistry::getTableLocator()->get('Incidents');
209	14	$reportsTable = TableRegistry::getTableLocator()->get('Reports');
210	14	foreach ($schematizedIncidents as $index => $si) {
211		// find closest report. If not found, create a new report.
212	14	$closestReport = $this->getClosestReport($bugReport, $index);
213	14	if ($closestReport) {
214	14	$si['report_id'] = $closestReport['id'];
215	14	$si['error_message'] = mb_strimwidth($si['error_message'], 0, 200, '...');
216	14	$si = $incidentsTable->newEntity($si);
217	14	$si->created = date('Y-m-d H:i:s', time());
218	14	$si->modified = date('Y-m-d H:i:s', time());
219
220	14	$this->logLongIncidentSubmissions($si, $incident_ids);
221	14	if (in_array(false, $incident_ids)) {
222	14	break;
223		}
224		} else {
225		// no close report. Create a new report.
226	14	$report = $this->getReportDetails($bugReport, $index);
227
228	14	$this->logLongIncidentSubmissions($si, $incident_ids);
229	14	if (in_array(false, $incident_ids)) {
230		break;
231		}
232
233	14	$report = $reportsTable->newEntity($report);
234	14	$report->created = date('Y-m-d H:i:s', time());
235	14	$report->modified = date('Y-m-d H:i:s', time());
236	14	$reportsTable->save($report);
237
238	14	$si['report_id'] = $report->id;
239	14	$si['error_message'] = mb_strimwidth($si['error_message'], 0, 200, '...');
240	14	$new_report_ids[] = $report->id;
241	14	$si = $incidentsTable->newEntity($si);
242	14	$si->created = date('Y-m-d H:i:s', time());
243	14	$si->modified = date('Y-m-d H:i:s', time());
244		}
245
246	14	$isSaved = $incidentsTable->save($si);
247	14	if ($isSaved) {
248	14	array_push($incident_ids, $si->id);
249	14	if (! $closestReport) {
250		// add notifications entry
251	14	$tmpIncident = $incidentsTable->findById($si->id)->all()->first();
252	14	if (! TableRegistry::getTableLocator()->get('Notifications')->addNotifications((int) $tmpIncident['report_id'])) {
253		Log::write(
254		'error',
255		'ERRORED: Notification::addNotifications() failed on Report#'
256		. $tmpIncident['report_id'],
257	14	'alert'
258		);
259		}
260		}
261		} else {
262		array_push($incident_ids, false);
263		}
264		}
265
266		return [
267	14	'incidents' => $incident_ids,
268	14	'reports' => $new_report_ids,
269		];
270		}
271
272		/**
273		* retrieves the closest report to a given bug report.
274		*
275		* it checks for another report with the same line number, filename and
276		* pma_version
277		*
278		* @param array $bugReport the bug report being checked
279		* Integer $index: for php exception type
280		* @param int $index The report index
281		*
282		* @return Entity\|null the first similar report or null
283		*/
284	21	protected function getClosestReport(array $bugReport, int $index = 0): ?Entity
285		{
286		if (
287	21	isset($bugReport['exception_type'])
288	21	&& $bugReport['exception_type'] === 'php'
289		) {
290	14	$location = $bugReport['errors'][$index]['file'];
291	14	$linenumber = $bugReport['errors'][$index]['lineNum'];
292		} else {
293	6	[$location, $linenumber] =
294	21	$this->getIdentifyingLocation($bugReport['exception']['stack'] ?? []);
295		}
296
297	21	return TableRegistry::getTableLocator()->get('Reports')->findByLocationAndLinenumberAndPmaVersion(
298	21	$location,
299	3	$linenumber,
300	21	self::getStrippedPmaVersion($bugReport['pma_version'])
301	21	)->all()->first();
302		}
303
304		/**
305		* creates the report data from an incident that has no related report.
306		*
307		* @param array $bugReport the bug report the report record is being created for
308		* Integer $index: for php exception type
309		* @param int $index The report index
310		*
311		* @return array an array with the report fields can be used with Report->save
312		*/
313	21	protected function getReportDetails(array $bugReport, int $index = 0): array
314		{
315		if (
316	21	isset($bugReport['exception_type'])
317	21	&& $bugReport['exception_type'] === 'php'
318		) {
319	21	$location = $bugReport['errors'][$index]['file'];
320	21	$linenumber = $bugReport['errors'][$index]['lineNum'];
321	6	$reportDetails = [
322	21	'error_message' => $bugReport['errors'][$index]['msg'],
323	21	'error_name' => $bugReport['errors'][$index]['type'],
324		];
325	21	$exception_type = 1;
326		} else {
327	21	$exception = $bugReport['exception'] ?? [];
328	6	[$location, $linenumber] =
329	21	$this->getIdentifyingLocation($exception['stack'] ?? []);
330
331	6	$reportDetails = [
332	21	'error_message' => $exception['message'] ?? '',
333	21	'error_name' => $exception['name'] ?? '',
334		];
335	21	$exception_type = 0;
336		}
337
338	21	$reportDetails = array_merge(
339	21	$reportDetails,
340		[
341	21	'status' => 'new',
342	21	'location' => $location,
343	21	'linenumber' => $linenumber ?? 0,
344	21	'pma_version' => self::getStrippedPmaVersion($bugReport['pma_version']),
345	21	'exception_type' => $exception_type,
346		]
347		);
348
349	21	return $reportDetails;
350		}
351
352		/**
353		* creates the incident data from the submitted bug report.
354		*
355		* @param array $bugReport the bug report the report record is being created for
356		*
357		* @return array an array of schematized incident.
358		* Can be used with Incident->save
359		*/
360	21	protected function getSchematizedIncidents(array $bugReport): array
361		{
362		//$bugReport = Sanitize::clean($bugReport, array('escape' => false));
363	21	$schematizedReports = [];
364	6	$schematizedCommonReport = [
365	21	'pma_version' => self::getStrippedPmaVersion($bugReport['pma_version']),
366	21	'php_version' => $this->getSimpleVersion($bugReport['php_version'] ?? '', 2),
367	21	'browser' => ($bugReport['browser_name'] ?? '') . ' '
368	21	. $this->getSimpleVersion($bugReport['browser_version'] ?? '', 1),
369	21	'user_os' => $bugReport['user_os'] ?? '',
370	21	'locale' => $bugReport['locale'] ?? '',
371	21	'configuration_storage' => $bugReport['configuration_storage'] ?? '',
372	21	'server_software' => $this->getServer($bugReport['server_software'] ?? ''),
373	21	'full_report' => json_encode($bugReport),
374		];
375
376		if (
377	21	isset($bugReport['exception_type'])
378	21	&& $bugReport['exception_type'] === 'php'
379		) {
380		// for each "errors"
381	21	foreach ($bugReport['errors'] as $error) {
382	21	$tmpReport = array_merge(
383	21	$schematizedCommonReport,
384		[
385	21	'error_name' => $error['type'],
386	21	'error_message' => $error['msg'],
387	21	'script_name' => $error['file'],
388	21	'stacktrace' => json_encode($error['stackTrace'] ?? []),
389	21	'stackhash' => $error['stackhash'],
390	21	'exception_type' => 1, // 'php'
391		]
392		);
393	21	array_push($schematizedReports, $tmpReport);
394		}
395		} else {
396	21	$exception = $bugReport['exception'] ?? [
397	15	'name' => '',
398		'message' => '',
399		'stack' => [],
400		];
401	21	$tmpReport = array_merge(
402	21	$schematizedCommonReport,
403		[
404	21	'error_name' => $exception['name'] ?? '',
405	21	'error_message' => $exception['message'] ?? '',
406	21	'script_name' => $bugReport['script_name'] ?? '',
407	21	'stacktrace' => json_encode($exception['stack'] ?? []),
408	21	'stackhash' => self::getStackHash($exception['stack'] ?? []),
409	21	'exception_type' => 0, //'js'
410		]
411		);
412
413	21	if (isset($bugReport['steps'])) {
414	21	$tmpReport['steps'] = $bugReport['steps'];
415		}
416
417	21	array_push($schematizedReports, $tmpReport);
418		}
419
420	21	return $schematizedReports;
421		}
422
423		/**
424		* Gets the identifiying location info from a stacktrace.
425		*
426		* This is used to skip stacktrace levels that are within the error reporting js
427		* files that sometimes appear in the stacktrace but are not related to the bug
428		* report
429		*
430		* returns two things in an array:
431		* - the first element is the filename/scriptname of the error
432		* - the second element is the linenumber of the error
433		*
434		* @param array $stacktrace the stacktrace being examined
435		*
436		* @return array an array with the filename/scriptname and linenumber of the
437		* error
438		*/
439	35	protected function getIdentifyingLocation(array $stacktrace): array
440		{
441	10	$fallback = [
442	25	'UNKNOWN',
443		0,
444		];
445	35	foreach ($stacktrace as $level) {
446	35	if (isset($level['filename'])) {
447		// ignore unrelated files that sometimes appear in the error report
448	35	if ($level['filename'] === 'tracekit/tracekit.js') {
449	7	continue;
450		}
451
452	35	if ($level['filename'] === 'error_report.js') {
453		// in case the error really is in the error_report.js file save it for
454		// later
455	7	if ($fallback[0] === 'UNKNOWN') {
456	2	$fallback = [
457	7	$level['filename'],
458	7	$level['line'],
459		];
460		}
461
462	7	continue;
463		}
464
465		return [
466	35	$level['filename'],
467	35	$level['line'],
468		];
469		}
470
471	7	if (isset($level['scriptname'])) {
472		return [
473	7	$level['scriptname'],
474	7	$level['line'],
475		];
476		}
477
478	7	continue;
479		}
480
481	7	return $fallback;
482		}
483
484		/**
485		* Gets a part of a version string according to the specified version Length.
486		*
487		* @param string $versionString the version string
488		* @param string $versionLength the number of version components to return. eg
489		* 1 for major version only and 2 for major and
490		* minor version
491		*
492		* @return string the major and minor version part
493		*/
494	28	protected function getSimpleVersion(string $versionString, string $versionLength): string
495		{
496	28	$versionLength = (int) $versionLength;
497	28	if ($versionLength < 1) {
498	7	$versionLength = 1;
499		}
500
501		/* modify the re to accept a variable number of version components. I
502		* atleast take one component and optionally get more components if need be.
503		* previous code makes sure that the $versionLength variable is a positive
504		* int
505		*/
506	28	$result = preg_match(
507	28	'/^(\d+\.){' . ($versionLength - 1) . '}\d+/',
508	28	$versionString,
509	28	$matches
510		);
511	28	if ($result) {
512	28	return $matches[0];
513		}
514
515		return $versionString;
516		}
517
518		/**
519		* Returns the version string stripped of
520		* 'deb', 'ubuntu' and other suffixes
521		*
522		* @param string $versionString phpMyAdmin version
523		*
524		* @return string stripped phpMyAdmin version
525		*/
526	196	public static function getStrippedPmaVersion(string $versionString): string
527		{
528		// This regex contains a negative lookahead to avoid fedora version suffix
529		// Use: https://regex101.com/
530		// See tests: IncidentsTableTest::versionsStripping
531	196	$allowedRegexp = '/^((\d+)(\.\d+){0,3}(\-[a-z0-9]+){0,1})(?!\.[a-z]{1,}[0-9]{1,})/';
532	196	$matches = [];
533
534		// Check if $versionString matches the regexp
535		// and store the matched strings
536	196	if (preg_match($allowedRegexp, $versionString, $matches)) {
537	182	return $matches[0];
538		}
539
540		// If $versionString does not match the regexp at all,
541		// leave it as it is
542	14	return $versionString;
543		}
544
545		/**
546		* Gets the server name and version from the server signature.
547		*
548		* @param string $signature the server signature
549		*
550		* @return string the server name and version or UNKNOWN
551		*/
552	28	protected function getServer(string $signature): string
553		{
554		if (
555	28	preg_match(
556		'/(apache\/\d+\.\d+)\|(nginx\/\d+\.\d+)\|(iis\/\d+\.\d+)'
557	28	. '\|(lighttpd\/\d+\.\d+)/i',
558	28	$signature,
559	28	$matches
560		)
561		) {
562	28	return $matches[0];
563		}
564
565	7	return 'UNKNOWN';
566		}
567
568		/**
569		* returns the hash pertaining to a stacktrace.
570		*
571		* @param array $stacktrace the stacktrace in question
572		*
573		* @return string the hash string of the stacktrace
574		*/
575	28	public function getStackHash(array $stacktrace): string
576		{
577	28	$handle = hash_init('md5');
578	28	foreach ($stacktrace as $level) {
579	8	$elements = [
580	20	'filename',
581		'scriptname',
582		'line',
583		'func',
584		'column',
585		];
586	28	foreach ($elements as $element) {
587	28	if (! isset($level[$element])) {
588	28	continue;
589		}
590
591	28	hash_update($handle, $level[$element]);
592		}
593		}
594
595	28	return hash_final($handle);
596		}
597
598		/**
599		* Checks the length of stacktrace and full_report
600		* and logs if it is greater than what it can hold
601		*
602		* @param object $si submitted incident
603		* @param array $incident_ids incident IDs
604		* @return void Nothing
605		*/
606	14	private function logLongIncidentSubmissions($si, array &$incident_ids): void// phpcs:ignore SlevomatCodingStandard.TypeHints.TypeHintDeclaration.MissingParameterTypeHint
607		{
608	14	$stacktraceLength = mb_strlen($si['stacktrace']);
609	14	$fullReportLength = mb_strlen($si['full_report']);
610
611		if (
612	14	$stacktraceLength <= 65535
613	14	&& $fullReportLength <= 65535
614		) {
615	14	return;
616		}
617
618		// If length of report is longer than
619		// what can fit in the table field,
620		// we log it and don't save it in the database
621		Log::error(
622		'Too long data submitted in the incident. The length of stacktrace: '
623		. $stacktraceLength . ', the length of bug report: '
624		. $fullReportLength . '. The full incident reported was as follows: '
625		. json_encode($si)
626		);
627
628		// add a 'false' to the return array
629		array_push($incident_ids, false);
630		}
631		}
632

phpmyadmin / error-reporting-server

IncidentsTable::getReportDetails() A last analyzed 2024-09-02 13:01 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

IncidentsTable::getReportDetails() A
last analyzed 2024-09-02 13:01 UTC