/**
* Return Nginx service Data
* @param array $params
* @return array
*/
public function getServiceDataDatabaseConnections(array $params)
{
$dataPostgresql = new \Cityware\Monitoring\Models\Services\DataPostgreSql($params);
$connectionsDatabases = $dataPostgresql->getDataPgSqlDatabasesConnections();
$return = array();
$geoipV1 = new \Cityware\Utility\GeoIpV1();
$geoipV1->geoip_open(DATA_PATH . 'GeoIp/GeoIPASNum.dat', GEOIP_STANDARD);
foreach ($connectionsDatabases as $key => $value) {
$desAsnIsp = !empty($value['client_addr']) ? \Cityware\Format\Text::convertString($geoipV1->geoip_name_by_addr($value['client_addr'])) : '';
$return[$key]['des_ip'] = $value['client_addr'];
$return[$key]['des_asn_isp'] = strtoupper(\Cityware\Format\Text::removeAccents($desAsnIsp));
$return[$key]['des_hash'] = hash('crc32b', $value['datname']);
$return[$key]['nam_database'] = $value['datname'];
$return[$key]['num_total_connections'] = $value['total_connections'];
}
return $return;
}
