/** * 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; }