@@ -32,8 +32,8 @@ discard block |
||
32 | 32 | protected $trapClass; //< Trap class for bin/trap_class.php |
33 | 33 | |
34 | 34 | /** Get instance of TrapModuleConfig class |
35 | - * @return TrapModuleConfig |
|
36 | - */ |
|
35 | + * @return TrapModuleConfig |
|
36 | + */ |
|
37 | 37 | public function getModuleConfig() |
38 | 38 | { |
39 | 39 | if ($this->moduleConfig == Null) |
@@ -58,12 +58,12 @@ discard block |
||
58 | 58 | |
59 | 59 | public function getTrapHostListTable() |
60 | 60 | { |
61 | - if ($this->trapTableHostList == Null) |
|
61 | + if ($this->trapTableHostList == Null) |
|
62 | 62 | { |
63 | - $this->trapTableHostList = new TrapTableHostList(); |
|
64 | - $this->trapTableHostList->setConfig($this->getModuleConfig()); |
|
65 | - } |
|
66 | - return $this->trapTableHostList; |
|
63 | + $this->trapTableHostList = new TrapTableHostList(); |
|
64 | + $this->trapTableHostList->setConfig($this->getModuleConfig()); |
|
65 | + } |
|
66 | + return $this->trapTableHostList; |
|
67 | 67 | } |
68 | 68 | |
69 | 69 | public function getHandlerListTable() |
@@ -77,11 +77,11 @@ discard block |
||
77 | 77 | } |
78 | 78 | |
79 | 79 | /** Get Database connexion |
80 | - * @param $DBname string DB name in resource.ini_ge |
|
81 | - * @param $test bool if set to true, returns error code and not database |
|
82 | - * @param $test_version bool if set to flase, does not test database version of trapDB |
|
83 | - * @return array<integer,mixed>|mixed : if test=false, returns DB connexion, else array(error_num,message) or null on error. |
|
84 | - */ |
|
80 | + * @param $DBname string DB name in resource.ini_ge |
|
81 | + * @param $test bool if set to true, returns error code and not database |
|
82 | + * @param $test_version bool if set to flase, does not test database version of trapDB |
|
83 | + * @return array<integer,mixed>|mixed : if test=false, returns DB connexion, else array(error_num,message) or null on error. |
|
84 | + */ |
|
85 | 85 | public function getDbByName($DBname,$test=false,$test_version=true) |
86 | 86 | { |
87 | 87 | try |
@@ -166,20 +166,20 @@ discard block |
||
166 | 166 | |
167 | 167 | if ( ! $dbresource ) |
168 | 168 | { |
169 | - if ($test) return array(1,'No database in config.ini'); |
|
170 | - $this->redirectNow('trapdirector/settings?idodberror=1'); |
|
171 | - return null; |
|
169 | + if ($test) return array(1,'No database in config.ini'); |
|
170 | + $this->redirectNow('trapdirector/settings?idodberror=1'); |
|
171 | + return null; |
|
172 | 172 | } |
173 | 173 | |
174 | 174 | try |
175 | 175 | { |
176 | - $dbconn = IcingaDbConnection::fromResourceName($dbresource); |
|
176 | + $dbconn = IcingaDbConnection::fromResourceName($dbresource); |
|
177 | 177 | } |
178 | 178 | catch (Exception $e) |
179 | 179 | { |
180 | - if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2"); |
|
181 | - $this->redirectNow('trapdirector/settings?idodberror=2'); |
|
182 | - return null; |
|
180 | + if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2"); |
|
181 | + $this->redirectNow('trapdirector/settings?idodberror=2'); |
|
182 | + return null; |
|
183 | 183 | } |
184 | 184 | |
185 | 185 | if ($test == false) |
@@ -190,13 +190,13 @@ discard block |
||
190 | 190 | |
191 | 191 | try |
192 | 192 | { |
193 | - $query = $dbconn->select() |
|
194 | - ->from('icinga_dbversion',array('version')); |
|
195 | - $version=$dbconn->fetchRow($query); |
|
196 | - if ( ($version == null) || ! property_exists($version,'version') ) |
|
197 | - { |
|
198 | - return array(4,"$dbresource does not look like an IDO database"); |
|
199 | - } |
|
193 | + $query = $dbconn->select() |
|
194 | + ->from('icinga_dbversion',array('version')); |
|
195 | + $version=$dbconn->fetchRow($query); |
|
196 | + if ( ($version == null) || ! property_exists($version,'version') ) |
|
197 | + { |
|
198 | + return array(4,"$dbresource does not look like an IDO database"); |
|
199 | + } |
|
200 | 200 | } |
201 | 201 | catch (Exception $e) |
202 | 202 | { |
@@ -206,15 +206,15 @@ discard block |
||
206 | 206 | return array(0,''); |
207 | 207 | } |
208 | 208 | |
209 | - protected function applyPaginationLimits(Paginatable $paginatable, $limit = 25, $offset = null) |
|
210 | - { |
|
211 | - $limit = $this->params->get('limit', $limit); |
|
212 | - $page = $this->params->get('page', $offset); |
|
209 | + protected function applyPaginationLimits(Paginatable $paginatable, $limit = 25, $offset = null) |
|
210 | + { |
|
211 | + $limit = $this->params->get('limit', $limit); |
|
212 | + $page = $this->params->get('page', $offset); |
|
213 | 213 | |
214 | - $paginatable->limit($limit, $page > 0 ? ($page - 1) * $limit : 0); |
|
214 | + $paginatable->limit($limit, $page > 0 ? ($page - 1) * $limit : 0); |
|
215 | 215 | |
216 | - return $paginatable; |
|
217 | - } |
|
216 | + return $paginatable; |
|
217 | + } |
|
218 | 218 | |
219 | 219 | public function displayExitError($source,$message) |
220 | 220 | { // TODO : check better ways to transmit data (with POST ?) |
@@ -223,33 +223,33 @@ discard block |
||
223 | 223 | |
224 | 224 | protected function checkReadPermission() |
225 | 225 | { |
226 | - if (! $this->Auth()->hasPermission('trapdirector/view')) { |
|
227 | - $this->displayExitError('Permissions','No permission fo view content'); |
|
228 | - } |
|
226 | + if (! $this->Auth()->hasPermission('trapdirector/view')) { |
|
227 | + $this->displayExitError('Permissions','No permission fo view content'); |
|
228 | + } |
|
229 | 229 | } |
230 | 230 | |
231 | 231 | protected function checkConfigPermission() |
232 | 232 | { |
233 | - if (! $this->Auth()->hasPermission('trapdirector/config')) { |
|
234 | - $this->displayExitError('Permissions','No permission fo configure'); |
|
235 | - } |
|
233 | + if (! $this->Auth()->hasPermission('trapdirector/config')) { |
|
234 | + $this->displayExitError('Permissions','No permission fo configure'); |
|
235 | + } |
|
236 | 236 | } |
237 | 237 | |
238 | - /** |
|
239 | - * Check if user has write permission |
|
240 | - * @param number $check optional : if set to 1, return true (user has permission) or false instead of displaying error page |
|
241 | - * @return boolean : user has permission |
|
242 | - */ |
|
238 | + /** |
|
239 | + * Check if user has write permission |
|
240 | + * @param number $check optional : if set to 1, return true (user has permission) or false instead of displaying error page |
|
241 | + * @return boolean : user has permission |
|
242 | + */ |
|
243 | 243 | protected function checkModuleConfigPermission($check=0) |
244 | 244 | { |
245 | - if (! $this->Auth()->hasPermission('trapdirector/module_config')) { |
|
246 | - if ($check == 0) |
|
247 | - { |
|
248 | - $this->displayExitError('Permissions','No permission fo configure module'); |
|
249 | - } |
|
250 | - return false; |
|
251 | - } |
|
252 | - return true; |
|
245 | + if (! $this->Auth()->hasPermission('trapdirector/module_config')) { |
|
246 | + if ($check == 0) |
|
247 | + { |
|
248 | + $this->displayExitError('Permissions','No permission fo configure module'); |
|
249 | + } |
|
250 | + return false; |
|
251 | + } |
|
252 | + return true; |
|
253 | 253 | } |
254 | 254 | |
255 | 255 | /************************* Trap class get **********************/ |
@@ -269,8 +269,8 @@ discard block |
||
269 | 269 | /************************** MIB related **************************/ |
270 | 270 | |
271 | 271 | /** Get MIBLoader class |
272 | - * @return MIBLoader class |
|
273 | - */ |
|
272 | + * @return MIBLoader class |
|
273 | + */ |
|
274 | 274 | protected function getMIB() |
275 | 275 | { |
276 | 276 | if ($this->MIBData == null) |
@@ -288,9 +288,9 @@ discard block |
||
288 | 288 | /************************** Database queries *******************/ |
289 | 289 | |
290 | 290 | /** Get host(s) by IP (v4 or v6) or by name in IDO database |
291 | - * does not catch exceptions |
|
292 | - * @return array of objects ( name, id (object_id), display_name) |
|
293 | - */ |
|
291 | + * does not catch exceptions |
|
292 | + * @return array of objects ( name, id (object_id), display_name) |
|
293 | + */ |
|
294 | 294 | protected function getHostByIP($ip) |
295 | 295 | { |
296 | 296 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
@@ -309,9 +309,9 @@ discard block |
||
309 | 309 | } |
310 | 310 | |
311 | 311 | /** Get host(s) by name in IDO database |
312 | - * does not catch exceptions |
|
313 | - * @return array of objects ( name, id (object_id), display_name) |
|
314 | - */ |
|
312 | + * does not catch exceptions |
|
313 | + * @return array of objects ( name, id (object_id), display_name) |
|
314 | + */ |
|
315 | 315 | protected function getHostByName($name) |
316 | 316 | { |
317 | 317 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
@@ -330,9 +330,9 @@ discard block |
||
330 | 330 | } |
331 | 331 | |
332 | 332 | /** Get host groups by name in IDO database |
333 | - * does not catch exceptions |
|
334 | - * @return array of objects ( name, id (object_id), display_name) |
|
335 | - */ |
|
333 | + * does not catch exceptions |
|
334 | + * @return array of objects ( name, id (object_id), display_name) |
|
335 | + */ |
|
336 | 336 | protected function getHostGroupByName($ip) |
337 | 337 | { |
338 | 338 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
@@ -352,9 +352,9 @@ discard block |
||
352 | 352 | |
353 | 353 | |
354 | 354 | /** Get host IP (v4 and v6) by name in IDO database |
355 | - * does not catch exceptions |
|
356 | - * @return array ( name, display_name, ip4, ip6) |
|
357 | - */ |
|
355 | + * does not catch exceptions |
|
356 | + * @return array ( name, display_name, ip4, ip6) |
|
357 | + */ |
|
358 | 358 | protected function getHostInfoByID($id) |
359 | 359 | { |
360 | 360 | if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
@@ -373,9 +373,9 @@ discard block |
||
373 | 373 | |
374 | 374 | |
375 | 375 | /** Get host by objectid in IDO database |
376 | - * does not catch exceptions |
|
377 | - * @return array of objects ( id, name, display_name, ip, ip6, ) |
|
378 | - */ |
|
376 | + * does not catch exceptions |
|
377 | + * @return array of objects ( id, name, display_name, ip, ip6, ) |
|
378 | + */ |
|
379 | 379 | protected function getHostByObjectID($id) // TODO : duplicate of getHostInfoByID above |
380 | 380 | { |
381 | 381 | if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
@@ -393,10 +393,10 @@ discard block |
||
393 | 393 | } |
394 | 394 | |
395 | 395 | /** Get services from object ( host_object_id) in IDO database |
396 | - * does not catch exceptions |
|
397 | - * @param $id int object_id |
|
398 | - * @return array display_name (of service), service_object_id |
|
399 | - */ |
|
396 | + * does not catch exceptions |
|
397 | + * @param $id int object_id |
|
398 | + * @return array display_name (of service), service_object_id |
|
399 | + */ |
|
400 | 400 | protected function getServicesByHostid($id) |
401 | 401 | { |
402 | 402 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
@@ -416,11 +416,11 @@ discard block |
||
416 | 416 | } |
417 | 417 | |
418 | 418 | /** Get services from hostgroup object id ( hostgroup_object_id) in IDO database |
419 | - * gets all hosts in hostgroup and return common services |
|
420 | - * does not catch exceptions |
|
421 | - * @param $id int object_id |
|
422 | - * @return array display_name (of service), service_object_id |
|
423 | - */ |
|
419 | + * gets all hosts in hostgroup and return common services |
|
420 | + * does not catch exceptions |
|
421 | + * @param $id int object_id |
|
422 | + * @return array display_name (of service), service_object_id |
|
423 | + */ |
|
424 | 424 | protected function getServicesByHostGroupid($id) |
425 | 425 | { |
426 | 426 | if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
@@ -459,7 +459,7 @@ discard block |
||
459 | 459 | //print_r($common_services); |
460 | 460 | foreach (array_keys($common_services) as $key) |
461 | 461 | { |
462 | - if ($common_services[$key]['num'] == $num_hosts) |
|
462 | + if ($common_services[$key]['num'] == $num_hosts) |
|
463 | 463 | { |
464 | 464 | array_push($result,array($key,$common_services[$key]['name'])); |
465 | 465 | } |
@@ -469,11 +469,11 @@ discard block |
||
469 | 469 | } |
470 | 470 | |
471 | 471 | /** Get services object id by host name / service name in IDO database |
472 | - * does not catch exceptions |
|
473 | - * @param $hostname string host name |
|
474 | - * @param $name string service name |
|
475 | - * @return array service id |
|
476 | - */ |
|
472 | + * does not catch exceptions |
|
473 | + * @param $hostname string host name |
|
474 | + * @param $name string service name |
|
475 | + * @return array service id |
|
476 | + */ |
|
477 | 477 | protected function getServiceIDByName($hostname,$name) |
478 | 478 | { |
479 | 479 | $db = $this->getIdoDb()->getConnection(); |
@@ -496,10 +496,10 @@ discard block |
||
496 | 496 | } |
497 | 497 | |
498 | 498 | /** Get object name from object_id in IDO database |
499 | - * does not catch exceptions |
|
500 | - * @param int $id object_id (default to null, used first if not null) |
|
501 | - * @return array name1 (host) name2 (service) |
|
502 | - */ |
|
499 | + * does not catch exceptions |
|
500 | + * @param int $id object_id (default to null, used first if not null) |
|
501 | + * @return array name1 (host) name2 (service) |
|
502 | + */ |
|
503 | 503 | protected function getObjectNameByid($id) |
504 | 504 | { |
505 | 505 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
@@ -515,9 +515,9 @@ discard block |
||
515 | 515 | } |
516 | 516 | |
517 | 517 | /** Add handler rule in traps DB |
518 | - * @param array $params : array(<db item>=><value>) |
|
519 | - * @return int inserted id |
|
520 | - */ |
|
518 | + * @param array $params : array(<db item>=><value>) |
|
519 | + * @return int inserted id |
|
520 | + */ |
|
521 | 521 | protected function addHandlerRule($params) |
522 | 522 | { |
523 | 523 | // TODO Check for rule consistency |
@@ -539,9 +539,9 @@ discard block |
||
539 | 539 | } |
540 | 540 | |
541 | 541 | /** Update handler rule in traps DB |
542 | - * @param array(<db item>=><value>) |
|
543 | - * @return array affected rows |
|
544 | - */ |
|
542 | + * @param array(<db item>=><value>) |
|
543 | + * @return array affected rows |
|
544 | + */ |
|
545 | 545 | protected function updateHandlerRule($params,$ruleID) |
546 | 546 | { |
547 | 547 | // TODO Check for rule consistency |
@@ -559,8 +559,8 @@ discard block |
||
559 | 559 | } |
560 | 560 | |
561 | 561 | /** Delete rule by id |
562 | - * @param int $ruleID rule id |
|
563 | - */ |
|
562 | + * @param int $ruleID rule id |
|
563 | + */ |
|
564 | 564 | protected function deleteRule($ruleID) |
565 | 565 | { |
566 | 566 | if (!preg_match('/^[0-9]+$/',$ruleID)) { throw new Exception('Invalid id'); } |
@@ -574,9 +574,9 @@ discard block |
||
574 | 574 | } |
575 | 575 | |
576 | 576 | /** Delete trap by ip & oid |
577 | - * @param $ip string source IP (v4 or v6) |
|
578 | - * @param $oid string oid |
|
579 | - */ |
|
577 | + * @param $ip string source IP (v4 or v6) |
|
578 | + * @param $oid string oid |
|
579 | + */ |
|
580 | 580 | protected function deleteTrap($ip,$oid) |
581 | 581 | { |
582 | 582 | |
@@ -602,9 +602,9 @@ discard block |
||
602 | 602 | |
603 | 603 | |
604 | 604 | /** count trap by ip & oid |
605 | - * @param $ip string source IP (v4 or v6) |
|
606 | - * @param $oid string oid |
|
607 | - */ |
|
605 | + * @param $ip string source IP (v4 or v6) |
|
606 | + * @param $oid string oid |
|
607 | + */ |
|
608 | 608 | protected function countTrap($ip,$oid) |
609 | 609 | { |
610 | 610 | |
@@ -630,8 +630,8 @@ discard block |
||
630 | 630 | } |
631 | 631 | |
632 | 632 | /** get configuration value |
633 | - * @param string $element : configuration name in db |
|
634 | - */ |
|
633 | + * @param string $element : configuration name in db |
|
634 | + */ |
|
635 | 635 | protected function getDBConfigValue($element) |
636 | 636 | { |
637 | 637 | |
@@ -662,9 +662,9 @@ discard block |
||
662 | 662 | } |
663 | 663 | |
664 | 664 | /** add configuration value |
665 | - * @param string $element : name of config element |
|
666 | - * @param string $value : value |
|
667 | - */ |
|
665 | + * @param string $element : name of config element |
|
666 | + * @param string $value : value |
|
667 | + */ |
|
668 | 668 | |
669 | 669 | protected function addDBConfigValue($element,$value) |
670 | 670 | { |
@@ -682,9 +682,9 @@ discard block |
||
682 | 682 | } |
683 | 683 | |
684 | 684 | /** set configuration value |
685 | - * @param string $element : name of config element |
|
686 | - * @param string $value : value |
|
687 | - */ |
|
685 | + * @param string $element : name of config element |
|
686 | + * @param string $value : value |
|
687 | + */ |
|
688 | 688 | protected function setDBConfigValue($element,$value) |
689 | 689 | { |
690 | 690 | |
@@ -698,13 +698,13 @@ discard block |
||
698 | 698 | } |
699 | 699 | |
700 | 700 | /** Check if director is installed |
701 | - * @return bool true/false |
|
702 | - */ |
|
701 | + * @return bool true/false |
|
702 | + */ |
|
703 | 703 | protected function isDirectorInstalled() |
704 | 704 | { |
705 | - $output=array(); |
|
706 | - exec('icingacli module list',$output); |
|
707 | - foreach ($output as $line) |
|
705 | + $output=array(); |
|
706 | + exec('icingacli module list',$output); |
|
707 | + foreach ($output as $line) |
|
708 | 708 | { |
709 | 709 | if (preg_match('/^director .*enabled/',$line)) |
710 | 710 | { |
@@ -22,14 +22,14 @@ discard block |
||
22 | 22 | |
23 | 23 | class TrapsController extends Controller |
24 | 24 | { |
25 | - protected $moduleConfig; //< TrapModuleConfig instance |
|
26 | - protected $trapTableList; //< TrapTableList (by date) |
|
27 | - protected $trapTableHostList; //< TrapTableList (by hosts) |
|
28 | - protected $handlerTableList; //< HandlerTableList instance |
|
29 | - protected $trapDB; //< Trap database |
|
30 | - protected $icingaDB; //< Icinga IDO database; |
|
31 | - protected $MIBData; //< MIBLoader class |
|
32 | - protected $trapClass; //< Trap class for bin/trap_class.php |
|
25 | + protected $moduleConfig; //< TrapModuleConfig instance |
|
26 | + protected $trapTableList; //< TrapTableList (by date) |
|
27 | + protected $trapTableHostList; //< TrapTableList (by hosts) |
|
28 | + protected $handlerTableList; //< HandlerTableList instance |
|
29 | + protected $trapDB; //< Trap database |
|
30 | + protected $icingaDB; //< Icinga IDO database; |
|
31 | + protected $MIBData; //< MIBLoader class |
|
32 | + protected $trapClass; //< Trap class for bin/trap_class.php |
|
33 | 33 | |
34 | 34 | /** Get instance of TrapModuleConfig class |
35 | 35 | * @return TrapModuleConfig |
@@ -43,14 +43,14 @@ discard block |
||
43 | 43 | { |
44 | 44 | $this->redirectNow('trapdirector/settings?message=No database prefix'); |
45 | 45 | } |
46 | - $this->moduleConfig = new TrapModuleConfig($db_prefix); |
|
46 | + $this->moduleConfig=new TrapModuleConfig($db_prefix); |
|
47 | 47 | } |
48 | 48 | return $this->moduleConfig; |
49 | 49 | } |
50 | 50 | |
51 | 51 | public function getTrapListTable() { |
52 | 52 | if ($this->trapTableList == Null) { |
53 | - $this->trapTableList = new TrapTableList(); |
|
53 | + $this->trapTableList=new TrapTableList(); |
|
54 | 54 | $this->trapTableList->setConfig($this->getModuleConfig()); |
55 | 55 | } |
56 | 56 | return $this->trapTableList; |
@@ -60,7 +60,7 @@ discard block |
||
60 | 60 | { |
61 | 61 | if ($this->trapTableHostList == Null) |
62 | 62 | { |
63 | - $this->trapTableHostList = new TrapTableHostList(); |
|
63 | + $this->trapTableHostList=new TrapTableHostList(); |
|
64 | 64 | $this->trapTableHostList->setConfig($this->getModuleConfig()); |
65 | 65 | } |
66 | 66 | return $this->trapTableHostList; |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | { |
71 | 71 | if ($this->handlerTableList == Null) |
72 | 72 | { |
73 | - $this->handlerTableList = new HandlerTableList(); |
|
73 | + $this->handlerTableList=new HandlerTableList(); |
|
74 | 74 | $this->handlerTableList->setConfig($this->getModuleConfig()); |
75 | 75 | } |
76 | 76 | return $this->handlerTableList; |
@@ -82,15 +82,15 @@ discard block |
||
82 | 82 | * @param $test_version bool if set to flase, does not test database version of trapDB |
83 | 83 | * @return array<integer,mixed>|mixed : if test=false, returns DB connexion, else array(error_num,message) or null on error. |
84 | 84 | */ |
85 | - public function getDbByName($DBname,$test=false,$test_version=true) |
|
85 | + public function getDbByName($DBname, $test=false, $test_version=true) |
|
86 | 86 | { |
87 | 87 | try |
88 | 88 | { |
89 | - $dbconn = IcingaDbConnection::fromResourceName($DBname); |
|
89 | + $dbconn=IcingaDbConnection::fromResourceName($DBname); |
|
90 | 90 | } |
91 | 91 | catch (Exception $e) |
92 | 92 | { |
93 | - if ($test) return array(2,$DBname); |
|
93 | + if ($test) return array(2, $DBname); |
|
94 | 94 | $this->redirectNow('trapdirector/settings?dberror=2'); |
95 | 95 | return null; |
96 | 96 | } |
@@ -101,37 +101,37 @@ discard block |
||
101 | 101 | } |
102 | 102 | catch (Exception $e) |
103 | 103 | { |
104 | - if ($test) return array(3,$DBname,$e->getMessage()); |
|
104 | + if ($test) return array(3, $DBname, $e->getMessage()); |
|
105 | 105 | $this->redirectNow('trapdirector/settings?dberror=3'); |
106 | 106 | return null; |
107 | 107 | } |
108 | 108 | try |
109 | 109 | { |
110 | - $query = $db->select() |
|
111 | - ->from($this->getModuleConfig()->getDbConfigTableName(),'value') |
|
110 | + $query=$db->select() |
|
111 | + ->from($this->getModuleConfig()->getDbConfigTableName(), 'value') |
|
112 | 112 | ->where('name=\'db_version\''); |
113 | 113 | $version=$db->fetchRow($query); |
114 | - if ( ($version == null) || ! property_exists($version,'value') ) |
|
114 | + if (($version == null) || !property_exists($version, 'value')) |
|
115 | 115 | { |
116 | - if ($test) return array(4,$DBname); |
|
116 | + if ($test) return array(4, $DBname); |
|
117 | 117 | $this->redirectNow('trapdirector/settings?dberror=4'); |
118 | 118 | return null; |
119 | 119 | } |
120 | 120 | if ($version->value < $this->getModuleConfig()->getDbMinVersion()) |
121 | 121 | { |
122 | - if ($test) return array(5,$version->value,$this->getModuleConfig()->getDbMinVersion()); |
|
122 | + if ($test) return array(5, $version->value, $this->getModuleConfig()->getDbMinVersion()); |
|
123 | 123 | $this->redirectNow('trapdirector/settings?dberror=5'); |
124 | 124 | return null; |
125 | 125 | } |
126 | 126 | } |
127 | 127 | catch (Exception $e) |
128 | 128 | { |
129 | - if ($test) return array(3,$DBname,$e->getMessage()); |
|
129 | + if ($test) return array(3, $DBname, $e->getMessage()); |
|
130 | 130 | $this->redirectNow('trapdirector/settings?dberror=4'); |
131 | 131 | return null; |
132 | 132 | } |
133 | 133 | } |
134 | - if ($test) return array(0,''); |
|
134 | + if ($test) return array(0, ''); |
|
135 | 135 | return $dbconn; |
136 | 136 | } |
137 | 137 | |
@@ -142,17 +142,17 @@ discard block |
||
142 | 142 | */ |
143 | 143 | public function getDb($test=false) |
144 | 144 | { |
145 | - if ($this->trapDB != null && $test = false) return $this->trapDB; |
|
145 | + if ($this->trapDB != null && $test=false) return $this->trapDB; |
|
146 | 146 | |
147 | 147 | $dbresource=$this->Config()->get('config', 'database'); |
148 | 148 | |
149 | - if ( ! $dbresource ) |
|
149 | + if (!$dbresource) |
|
150 | 150 | { |
151 | - if ($test) return array(1,''); |
|
151 | + if ($test) return array(1, ''); |
|
152 | 152 | $this->redirectNow('trapdirector/settings?dberror=1'); |
153 | 153 | return null; |
154 | 154 | } |
155 | - $retDB=$this->getDbByName($dbresource,$test,true); |
|
155 | + $retDB=$this->getDbByName($dbresource, $test, true); |
|
156 | 156 | if ($test == true) return $retDB; |
157 | 157 | $this->trapDB=$retDB; |
158 | 158 | return $this->trapDB; |
@@ -160,78 +160,78 @@ discard block |
||
160 | 160 | |
161 | 161 | public function getIdoDb($test=false) |
162 | 162 | { |
163 | - if ($this->icingaDB != null && $test = false) return $this->icingaDB; |
|
163 | + if ($this->icingaDB != null && $test=false) return $this->icingaDB; |
|
164 | 164 | // TODO : get ido database directly from icingaweb2 config -> (or not if using only API) |
165 | - $dbresource=$this->Config()->get('config', 'IDOdatabase');; |
|
165 | + $dbresource=$this->Config()->get('config', 'IDOdatabase'); ; |
|
166 | 166 | |
167 | - if ( ! $dbresource ) |
|
167 | + if (!$dbresource) |
|
168 | 168 | { |
169 | - if ($test) return array(1,'No database in config.ini'); |
|
169 | + if ($test) return array(1, 'No database in config.ini'); |
|
170 | 170 | $this->redirectNow('trapdirector/settings?idodberror=1'); |
171 | 171 | return null; |
172 | 172 | } |
173 | 173 | |
174 | 174 | try |
175 | 175 | { |
176 | - $dbconn = IcingaDbConnection::fromResourceName($dbresource); |
|
176 | + $dbconn=IcingaDbConnection::fromResourceName($dbresource); |
|
177 | 177 | } |
178 | 178 | catch (Exception $e) |
179 | 179 | { |
180 | - if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2"); |
|
180 | + if ($test) return array(2, "Database $dbresource does not exists in IcingaWeb2"); |
|
181 | 181 | $this->redirectNow('trapdirector/settings?idodberror=2'); |
182 | 182 | return null; |
183 | 183 | } |
184 | 184 | |
185 | 185 | if ($test == false) |
186 | 186 | { |
187 | - $this->icingaDB = $dbconn; |
|
187 | + $this->icingaDB=$dbconn; |
|
188 | 188 | return $this->icingaDB; |
189 | 189 | } |
190 | 190 | |
191 | 191 | try |
192 | 192 | { |
193 | - $query = $dbconn->select() |
|
194 | - ->from('icinga_dbversion',array('version')); |
|
193 | + $query=$dbconn->select() |
|
194 | + ->from('icinga_dbversion', array('version')); |
|
195 | 195 | $version=$dbconn->fetchRow($query); |
196 | - if ( ($version == null) || ! property_exists($version,'version') ) |
|
196 | + if (($version == null) || !property_exists($version, 'version')) |
|
197 | 197 | { |
198 | - return array(4,"$dbresource does not look like an IDO database"); |
|
198 | + return array(4, "$dbresource does not look like an IDO database"); |
|
199 | 199 | } |
200 | 200 | } |
201 | 201 | catch (Exception $e) |
202 | 202 | { |
203 | - return array(3,"Error connecting to $dbresource : " . $e->getMessage()); |
|
203 | + return array(3, "Error connecting to $dbresource : ".$e->getMessage()); |
|
204 | 204 | } |
205 | 205 | |
206 | - return array(0,''); |
|
206 | + return array(0, ''); |
|
207 | 207 | } |
208 | 208 | |
209 | - protected function applyPaginationLimits(Paginatable $paginatable, $limit = 25, $offset = null) |
|
209 | + protected function applyPaginationLimits(Paginatable $paginatable, $limit=25, $offset=null) |
|
210 | 210 | { |
211 | - $limit = $this->params->get('limit', $limit); |
|
212 | - $page = $this->params->get('page', $offset); |
|
211 | + $limit=$this->params->get('limit', $limit); |
|
212 | + $page=$this->params->get('page', $offset); |
|
213 | 213 | |
214 | 214 | $paginatable->limit($limit, $page > 0 ? ($page - 1) * $limit : 0); |
215 | 215 | |
216 | 216 | return $paginatable; |
217 | 217 | } |
218 | 218 | |
219 | - public function displayExitError($source,$message) |
|
219 | + public function displayExitError($source, $message) |
|
220 | 220 | { // TODO : check better ways to transmit data (with POST ?) |
221 | 221 | $this->redirectNow('trapdirector/error?source='.$source.'&message='.$message); |
222 | 222 | } |
223 | 223 | |
224 | 224 | protected function checkReadPermission() |
225 | 225 | { |
226 | - if (! $this->Auth()->hasPermission('trapdirector/view')) { |
|
227 | - $this->displayExitError('Permissions','No permission fo view content'); |
|
226 | + if (!$this->Auth()->hasPermission('trapdirector/view')) { |
|
227 | + $this->displayExitError('Permissions', 'No permission fo view content'); |
|
228 | 228 | } |
229 | 229 | } |
230 | 230 | |
231 | 231 | protected function checkConfigPermission() |
232 | 232 | { |
233 | - if (! $this->Auth()->hasPermission('trapdirector/config')) { |
|
234 | - $this->displayExitError('Permissions','No permission fo configure'); |
|
233 | + if (!$this->Auth()->hasPermission('trapdirector/config')) { |
|
234 | + $this->displayExitError('Permissions', 'No permission fo configure'); |
|
235 | 235 | } |
236 | 236 | } |
237 | 237 | |
@@ -242,10 +242,10 @@ discard block |
||
242 | 242 | */ |
243 | 243 | protected function checkModuleConfigPermission($check=0) |
244 | 244 | { |
245 | - if (! $this->Auth()->hasPermission('trapdirector/module_config')) { |
|
245 | + if (!$this->Auth()->hasPermission('trapdirector/module_config')) { |
|
246 | 246 | if ($check == 0) |
247 | 247 | { |
248 | - $this->displayExitError('Permissions','No permission fo configure module'); |
|
248 | + $this->displayExitError('Permissions', 'No permission fo configure module'); |
|
249 | 249 | } |
250 | 250 | return false; |
251 | 251 | } |
@@ -257,10 +257,10 @@ discard block |
||
257 | 257 | { // TODO : try/catch here ? or within caller |
258 | 258 | if ($this->trapClass == null) |
259 | 259 | { |
260 | - require_once($this->Module()->getBaseDir() .'/bin/trap_class.php'); |
|
260 | + require_once($this->Module()->getBaseDir().'/bin/trap_class.php'); |
|
261 | 261 | $icingaweb2_etc=$this->Config()->get('config', 'icingaweb2_etc'); |
262 | 262 | //$debug_level=4; |
263 | - $this->trapClass = new Trap($icingaweb2_etc); |
|
263 | + $this->trapClass=new Trap($icingaweb2_etc); |
|
264 | 264 | //$Trap->setLogging($debug_level,'syslog'); |
265 | 265 | } |
266 | 266 | return $this->trapClass; |
@@ -294,12 +294,12 @@ discard block |
||
294 | 294 | protected function getHostByIP($ip) |
295 | 295 | { |
296 | 296 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
297 | - $db = $this->getIdoDb()->getConnection(); |
|
297 | + $db=$this->getIdoDb()->getConnection(); |
|
298 | 298 | // TODO : check for SQL injections |
299 | 299 | $query=$db->select() |
300 | 300 | ->from( |
301 | 301 | array('a' => 'icinga_objects'), |
302 | - array('name' => 'a.name1','id' => 'object_id')) |
|
302 | + array('name' => 'a.name1', 'id' => 'object_id')) |
|
303 | 303 | ->join( |
304 | 304 | array('b' => 'icinga_hosts'), |
305 | 305 | 'b.host_object_id=a.object_id', |
@@ -315,12 +315,12 @@ discard block |
||
315 | 315 | protected function getHostByName($name) |
316 | 316 | { |
317 | 317 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
318 | - $db = $this->getIdoDb()->getConnection(); |
|
318 | + $db=$this->getIdoDb()->getConnection(); |
|
319 | 319 | // TODO : check for SQL injections |
320 | 320 | $query=$db->select() |
321 | 321 | ->from( |
322 | 322 | array('a' => 'icinga_objects'), |
323 | - array('name' => 'a.name1','id' => 'object_id')) |
|
323 | + array('name' => 'a.name1', 'id' => 'object_id')) |
|
324 | 324 | ->join( |
325 | 325 | array('b' => 'icinga_hosts'), |
326 | 326 | 'b.host_object_id=a.object_id', |
@@ -336,12 +336,12 @@ discard block |
||
336 | 336 | protected function getHostGroupByName($ip) |
337 | 337 | { |
338 | 338 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
339 | - $db = $this->getIdoDb()->getConnection(); |
|
339 | + $db=$this->getIdoDb()->getConnection(); |
|
340 | 340 | // TODO : check for SQL injections |
341 | 341 | $query=$db->select() |
342 | 342 | ->from( |
343 | 343 | array('a' => 'icinga_objects'), |
344 | - array('name' => 'a.name1','id' => 'object_id')) |
|
344 | + array('name' => 'a.name1', 'id' => 'object_id')) |
|
345 | 345 | ->join( |
346 | 346 | array('b' => 'icinga_hostgroups'), |
347 | 347 | 'b.hostgroup_object_id=a.object_id', |
@@ -357,8 +357,8 @@ discard block |
||
357 | 357 | */ |
358 | 358 | protected function getHostInfoByID($id) |
359 | 359 | { |
360 | - if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
|
361 | - $db = $this->getIdoDb()->getConnection(); |
|
360 | + if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); } |
|
361 | + $db=$this->getIdoDb()->getConnection(); |
|
362 | 362 | $query=$db->select() |
363 | 363 | ->from( |
364 | 364 | array('a' => 'icinga_objects'), |
@@ -378,17 +378,17 @@ discard block |
||
378 | 378 | */ |
379 | 379 | protected function getHostByObjectID($id) // TODO : duplicate of getHostInfoByID above |
380 | 380 | { |
381 | - if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
|
382 | - $db = $this->getIdoDb()->getConnection(); |
|
381 | + if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); } |
|
382 | + $db=$this->getIdoDb()->getConnection(); |
|
383 | 383 | $query=$db->select() |
384 | 384 | ->from( |
385 | 385 | array('a' => 'icinga_objects'), |
386 | - array('name' => 'a.name1','id' => 'a.object_id')) |
|
386 | + array('name' => 'a.name1', 'id' => 'a.object_id')) |
|
387 | 387 | ->join( |
388 | 388 | array('b' => 'icinga_hosts'), |
389 | 389 | 'b.host_object_id=a.object_id', |
390 | - array('display_name' => 'b.display_name' , 'ip' => 'b.address', 'ip6' => 'b.address6')) |
|
391 | - ->where('a.object_id = ?',$id); |
|
390 | + array('display_name' => 'b.display_name', 'ip' => 'b.address', 'ip6' => 'b.address6')) |
|
391 | + ->where('a.object_id = ?', $id); |
|
392 | 392 | return $db->fetchRow($query); |
393 | 393 | } |
394 | 394 | |
@@ -400,16 +400,16 @@ discard block |
||
400 | 400 | protected function getServicesByHostid($id) |
401 | 401 | { |
402 | 402 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
403 | - if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
|
404 | - $db = $this->getIdoDb()->getConnection(); |
|
403 | + if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); } |
|
404 | + $db=$this->getIdoDb()->getConnection(); |
|
405 | 405 | $query=$db->select() |
406 | 406 | ->from( |
407 | 407 | array('s' => 'icinga_services'), |
408 | - array('name' => 's.display_name','id' => 's.service_object_id')) |
|
408 | + array('name' => 's.display_name', 'id' => 's.service_object_id')) |
|
409 | 409 | ->join( |
410 | 410 | array('a' => 'icinga_objects'), |
411 | 411 | 's.service_object_id=a.object_id', |
412 | - array('is_active'=>'a.is_active','name2'=>'a.name2')) |
|
412 | + array('is_active'=>'a.is_active', 'name2'=>'a.name2')) |
|
413 | 413 | ->where('s.host_object_id='.$id.' AND a.is_active = 1'); |
414 | 414 | |
415 | 415 | return $db->fetchAll($query); |
@@ -423,8 +423,8 @@ discard block |
||
423 | 423 | */ |
424 | 424 | protected function getServicesByHostGroupid($id) |
425 | 425 | { |
426 | - if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
|
427 | - $db = $this->getIdoDb()->getConnection(); |
|
426 | + if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); } |
|
427 | + $db=$this->getIdoDb()->getConnection(); |
|
428 | 428 | $query=$db->select() |
429 | 429 | ->from( |
430 | 430 | array('s' => 'icinga_hostgroup_members'), |
@@ -441,11 +441,11 @@ discard block |
||
441 | 441 | foreach ($hosts as $key => $host) |
442 | 442 | { // For each host, get all services and add in common_services if not found or add counter |
443 | 443 | $host_services=$this->getServicesByHostid($host->host_object_id); |
444 | - foreach($host_services as $service) |
|
444 | + foreach ($host_services as $service) |
|
445 | 445 | { |
446 | 446 | if (isset($common_services[$service->name2]['num'])) |
447 | 447 | { |
448 | - $common_services[$service->name2]['num'] +=1; |
|
448 | + $common_services[$service->name2]['num']+=1; |
|
449 | 449 | } |
450 | 450 | else |
451 | 451 | { |
@@ -461,7 +461,7 @@ discard block |
||
461 | 461 | { |
462 | 462 | if ($common_services[$key]['num'] == $num_hosts) |
463 | 463 | { |
464 | - array_push($result,array($key,$common_services[$key]['name'])); |
|
464 | + array_push($result, array($key, $common_services[$key]['name'])); |
|
465 | 465 | } |
466 | 466 | } |
467 | 467 | |
@@ -474,9 +474,9 @@ discard block |
||
474 | 474 | * @param $name string service name |
475 | 475 | * @return array service id |
476 | 476 | */ |
477 | - protected function getServiceIDByName($hostname,$name) |
|
477 | + protected function getServiceIDByName($hostname, $name) |
|
478 | 478 | { |
479 | - $db = $this->getIdoDb()->getConnection(); |
|
479 | + $db=$this->getIdoDb()->getConnection(); |
|
480 | 480 | if ($name == null) |
481 | 481 | { |
482 | 482 | return array(); |
@@ -485,7 +485,7 @@ discard block |
||
485 | 485 | $query=$db->select() |
486 | 486 | ->from( |
487 | 487 | array('s' => 'icinga_services'), |
488 | - array('name' => 's.display_name','id' => 's.service_object_id')) |
|
488 | + array('name' => 's.display_name', 'id' => 's.service_object_id')) |
|
489 | 489 | ->join( |
490 | 490 | array('a' => 'icinga_objects'), |
491 | 491 | 's.service_object_id=a.object_id', |
@@ -503,12 +503,12 @@ discard block |
||
503 | 503 | protected function getObjectNameByid($id) |
504 | 504 | { |
505 | 505 | // select a.name1, b.display_name from icinga.icinga_objects AS a , icinga.icinga_hosts AS b WHERE (b.address = '192.168.56.101' OR b.address6= '123456') and b.host_object_id=a.object_id |
506 | - if (!preg_match('/^[0-9]+$/',$id)) { throw new Exception('Invalid id'); } |
|
507 | - $db = $this->getIdoDb()->getConnection(); |
|
506 | + if (!preg_match('/^[0-9]+$/', $id)) { throw new Exception('Invalid id'); } |
|
507 | + $db=$this->getIdoDb()->getConnection(); |
|
508 | 508 | $query=$db->select() |
509 | 509 | ->from( |
510 | 510 | array('a' => 'icinga_objects'), |
511 | - array('name1' => 'a.name1','name2' => 'a.name2')) |
|
511 | + array('name1' => 'a.name1', 'name2' => 'a.name2')) |
|
512 | 512 | ->where('a.object_id='.$id.' AND a.is_active = 1'); |
513 | 513 | |
514 | 514 | return $db->fetchRow($query); |
@@ -521,17 +521,17 @@ discard block |
||
521 | 521 | protected function addHandlerRule($params) |
522 | 522 | { |
523 | 523 | // TODO Check for rule consistency |
524 | - $db = $this->getDb()->getConnection(); |
|
524 | + $db=$this->getDb()->getConnection(); |
|
525 | 525 | // Add last modified date = creation date and username |
526 | - $params['created'] = new Zend_Db_Expr('NOW()'); |
|
527 | - $params['modified'] = new Zend_Db_Expr('NOW()'); |
|
528 | - $params['modifier'] = $this->Auth()->getUser()->getUsername(); |
|
526 | + $params['created']=new Zend_Db_Expr('NOW()'); |
|
527 | + $params['modified']=new Zend_Db_Expr('NOW()'); |
|
528 | + $params['modifier']=$this->Auth()->getUser()->getUsername(); |
|
529 | 529 | |
530 | 530 | $query=$db->insert( |
531 | 531 | $this->getModuleConfig()->getTrapRuleName(), |
532 | 532 | $params |
533 | 533 | ); |
534 | - if($query==false) |
|
534 | + if ($query == false) |
|
535 | 535 | { |
536 | 536 | return null; |
537 | 537 | } |
@@ -542,13 +542,13 @@ discard block |
||
542 | 542 | * @param array(<db item>=><value>) |
543 | 543 | * @return array affected rows |
544 | 544 | */ |
545 | - protected function updateHandlerRule($params,$ruleID) |
|
545 | + protected function updateHandlerRule($params, $ruleID) |
|
546 | 546 | { |
547 | 547 | // TODO Check for rule consistency |
548 | - $db = $this->getDb()->getConnection(); |
|
548 | + $db=$this->getDb()->getConnection(); |
|
549 | 549 | // Add last modified date = creation date and username |
550 | - $params['modified'] = new Zend_Db_Expr('NOW()'); |
|
551 | - $params['modifier'] = $this->Auth()->getUser()->getUsername(); |
|
550 | + $params['modified']=new Zend_Db_Expr('NOW()'); |
|
551 | + $params['modifier']=$this->Auth()->getUser()->getUsername(); |
|
552 | 552 | |
553 | 553 | $numRows=$db->update( |
554 | 554 | $this->getModuleConfig()->getTrapRuleName(), |
@@ -563,8 +563,8 @@ discard block |
||
563 | 563 | */ |
564 | 564 | protected function deleteRule($ruleID) |
565 | 565 | { |
566 | - if (!preg_match('/^[0-9]+$/',$ruleID)) { throw new Exception('Invalid id'); } |
|
567 | - $db = $this->getDb()->getConnection(); |
|
566 | + if (!preg_match('/^[0-9]+$/', $ruleID)) { throw new Exception('Invalid id'); } |
|
567 | + $db=$this->getDb()->getConnection(); |
|
568 | 568 | |
569 | 569 | $query=$db->delete( |
570 | 570 | $this->getModuleConfig()->getTrapRuleName(), |
@@ -577,10 +577,10 @@ discard block |
||
577 | 577 | * @param $ip string source IP (v4 or v6) |
578 | 578 | * @param $oid string oid |
579 | 579 | */ |
580 | - protected function deleteTrap($ip,$oid) |
|
580 | + protected function deleteTrap($ip, $oid) |
|
581 | 581 | { |
582 | 582 | |
583 | - $db = $this->getDb()->getConnection(); |
|
583 | + $db=$this->getDb()->getConnection(); |
|
584 | 584 | $condition=null; |
585 | 585 | if ($ip != null) |
586 | 586 | { |
@@ -588,10 +588,10 @@ discard block |
||
588 | 588 | } |
589 | 589 | if ($oid != null) |
590 | 590 | { |
591 | - $condition=($condition===null)?'':$condition.' AND '; |
|
591 | + $condition=($condition === null) ? '' : $condition.' AND '; |
|
592 | 592 | $condition.="trap_oid='$oid'"; |
593 | 593 | } |
594 | - if($condition === null) return null; |
|
594 | + if ($condition === null) return null; |
|
595 | 595 | $query=$db->delete( |
596 | 596 | $this->getModuleConfig()->getTrapTableName(), |
597 | 597 | $condition |
@@ -605,10 +605,10 @@ discard block |
||
605 | 605 | * @param $ip string source IP (v4 or v6) |
606 | 606 | * @param $oid string oid |
607 | 607 | */ |
608 | - protected function countTrap($ip,$oid) |
|
608 | + protected function countTrap($ip, $oid) |
|
609 | 609 | { |
610 | 610 | |
611 | - $db = $this->getDb()->getConnection(); |
|
611 | + $db=$this->getDb()->getConnection(); |
|
612 | 612 | $condition=null; |
613 | 613 | if ($ip != null) |
614 | 614 | { |
@@ -616,10 +616,10 @@ discard block |
||
616 | 616 | } |
617 | 617 | if ($oid != null) |
618 | 618 | { |
619 | - $condition=($condition===null)?'':$condition.' AND '; |
|
619 | + $condition=($condition === null) ? '' : $condition.' AND '; |
|
620 | 620 | $condition.="trap_oid='$oid'"; |
621 | 621 | } |
622 | - if($condition ==null) return 0; |
|
622 | + if ($condition == null) return 0; |
|
623 | 623 | $query=$db->select() |
624 | 624 | ->from( |
625 | 625 | $this->getModuleConfig()->getTrapTableName(), |
@@ -635,27 +635,27 @@ discard block |
||
635 | 635 | protected function getDBConfigValue($element) |
636 | 636 | { |
637 | 637 | |
638 | - $db = $this->getDb()->getConnection(); |
|
638 | + $db=$this->getDb()->getConnection(); |
|
639 | 639 | |
640 | 640 | $query=$db->select() |
641 | 641 | ->from( |
642 | 642 | $this->getModuleConfig()->getDbConfigTableName(), |
643 | 643 | array('value'=>'value')) |
644 | - ->where('name=?',$element); |
|
644 | + ->where('name=?', $element); |
|
645 | 645 | $return_row=$db->fetchRow($query); |
646 | - if ($return_row==null) // value does not exists |
|
646 | + if ($return_row == null) // value does not exists |
|
647 | 647 | { |
648 | 648 | $default=$this->getModuleConfig()->getDBConfigDefaults(); |
649 | - if ( ! isset($default[$element])) return null; // no default and not value |
|
649 | + if (!isset($default[$element])) return null; // no default and not value |
|
650 | 650 | |
651 | - $this->addDBConfigValue($element,$default[$element]); |
|
651 | + $this->addDBConfigValue($element, $default[$element]); |
|
652 | 652 | return $default[$element]; |
653 | 653 | } |
654 | 654 | if ($return_row->value == null) // value id empty |
655 | 655 | { |
656 | 656 | $default=$this->getModuleConfig()->getDBConfigDefaults(); |
657 | - if ( ! isset($default[$element])) return null; // no default and not value |
|
658 | - $this->setDBConfigValue($element,$default[$element]); |
|
657 | + if (!isset($default[$element])) return null; // no default and not value |
|
658 | + $this->setDBConfigValue($element, $default[$element]); |
|
659 | 659 | return $default[$element]; |
660 | 660 | } |
661 | 661 | return $return_row->value; |
@@ -666,10 +666,10 @@ discard block |
||
666 | 666 | * @param string $value : value |
667 | 667 | */ |
668 | 668 | |
669 | - protected function addDBConfigValue($element,$value) |
|
669 | + protected function addDBConfigValue($element, $value) |
|
670 | 670 | { |
671 | 671 | |
672 | - $db = $this->getDb()->getConnection(); |
|
672 | + $db=$this->getDb()->getConnection(); |
|
673 | 673 | |
674 | 674 | $query=$db->insert( |
675 | 675 | $this->getModuleConfig()->getDbConfigTableName(), |
@@ -685,10 +685,10 @@ discard block |
||
685 | 685 | * @param string $element : name of config element |
686 | 686 | * @param string $value : value |
687 | 687 | */ |
688 | - protected function setDBConfigValue($element,$value) |
|
688 | + protected function setDBConfigValue($element, $value) |
|
689 | 689 | { |
690 | 690 | |
691 | - $db = $this->getDb()->getConnection(); |
|
691 | + $db=$this->getDb()->getConnection(); |
|
692 | 692 | $query=$db->update( |
693 | 693 | $this->getModuleConfig()->getDbConfigTableName(), |
694 | 694 | array('value'=>$value), |
@@ -703,10 +703,10 @@ discard block |
||
703 | 703 | protected function isDirectorInstalled() |
704 | 704 | { |
705 | 705 | $output=array(); |
706 | - exec('icingacli module list',$output); |
|
706 | + exec('icingacli module list', $output); |
|
707 | 707 | foreach ($output as $line) |
708 | 708 | { |
709 | - if (preg_match('/^director .*enabled/',$line)) |
|
709 | + if (preg_match('/^director .*enabled/', $line)) |
|
710 | 710 | { |
711 | 711 | return true; |
712 | 712 | } |
@@ -87,10 +87,11 @@ discard block |
||
87 | 87 | try |
88 | 88 | { |
89 | 89 | $dbconn = IcingaDbConnection::fromResourceName($DBname); |
90 | - } |
|
91 | - catch (Exception $e) |
|
90 | + } catch (Exception $e) |
|
92 | 91 | { |
93 | - if ($test) return array(2,$DBname); |
|
92 | + if ($test) { |
|
93 | + return array(2,$DBname); |
|
94 | + } |
|
94 | 95 | $this->redirectNow('trapdirector/settings?dberror=2'); |
95 | 96 | return null; |
96 | 97 | } |
@@ -98,10 +99,11 @@ discard block |
||
98 | 99 | try |
99 | 100 | { |
100 | 101 | $db=$dbconn->getConnection(); |
101 | - } |
|
102 | - catch (Exception $e) |
|
102 | + } catch (Exception $e) |
|
103 | 103 | { |
104 | - if ($test) return array(3,$DBname,$e->getMessage()); |
|
104 | + if ($test) { |
|
105 | + return array(3,$DBname,$e->getMessage()); |
|
106 | + } |
|
105 | 107 | $this->redirectNow('trapdirector/settings?dberror=3'); |
106 | 108 | return null; |
107 | 109 | } |
@@ -113,25 +115,32 @@ discard block |
||
113 | 115 | $version=$db->fetchRow($query); |
114 | 116 | if ( ($version == null) || ! property_exists($version,'value') ) |
115 | 117 | { |
116 | - if ($test) return array(4,$DBname); |
|
118 | + if ($test) { |
|
119 | + return array(4,$DBname); |
|
120 | + } |
|
117 | 121 | $this->redirectNow('trapdirector/settings?dberror=4'); |
118 | 122 | return null; |
119 | 123 | } |
120 | 124 | if ($version->value < $this->getModuleConfig()->getDbMinVersion()) |
121 | 125 | { |
122 | - if ($test) return array(5,$version->value,$this->getModuleConfig()->getDbMinVersion()); |
|
126 | + if ($test) { |
|
127 | + return array(5,$version->value,$this->getModuleConfig()->getDbMinVersion()); |
|
128 | + } |
|
123 | 129 | $this->redirectNow('trapdirector/settings?dberror=5'); |
124 | 130 | return null; |
125 | 131 | } |
126 | - } |
|
127 | - catch (Exception $e) |
|
132 | + } catch (Exception $e) |
|
128 | 133 | { |
129 | - if ($test) return array(3,$DBname,$e->getMessage()); |
|
134 | + if ($test) { |
|
135 | + return array(3,$DBname,$e->getMessage()); |
|
136 | + } |
|
130 | 137 | $this->redirectNow('trapdirector/settings?dberror=4'); |
131 | 138 | return null; |
132 | 139 | } |
133 | 140 | } |
134 | - if ($test) return array(0,''); |
|
141 | + if ($test) { |
|
142 | + return array(0,''); |
|
143 | + } |
|
135 | 144 | return $dbconn; |
136 | 145 | } |
137 | 146 | |
@@ -142,31 +151,41 @@ discard block |
||
142 | 151 | */ |
143 | 152 | public function getDb($test=false) |
144 | 153 | { |
145 | - if ($this->trapDB != null && $test = false) return $this->trapDB; |
|
154 | + if ($this->trapDB != null && $test = false) { |
|
155 | + return $this->trapDB; |
|
156 | + } |
|
146 | 157 | |
147 | 158 | $dbresource=$this->Config()->get('config', 'database'); |
148 | 159 | |
149 | 160 | if ( ! $dbresource ) |
150 | 161 | { |
151 | - if ($test) return array(1,''); |
|
162 | + if ($test) { |
|
163 | + return array(1,''); |
|
164 | + } |
|
152 | 165 | $this->redirectNow('trapdirector/settings?dberror=1'); |
153 | 166 | return null; |
154 | 167 | } |
155 | 168 | $retDB=$this->getDbByName($dbresource,$test,true); |
156 | - if ($test == true) return $retDB; |
|
169 | + if ($test == true) { |
|
170 | + return $retDB; |
|
171 | + } |
|
157 | 172 | $this->trapDB=$retDB; |
158 | 173 | return $this->trapDB; |
159 | 174 | } |
160 | 175 | |
161 | 176 | public function getIdoDb($test=false) |
162 | 177 | { |
163 | - if ($this->icingaDB != null && $test = false) return $this->icingaDB; |
|
178 | + if ($this->icingaDB != null && $test = false) { |
|
179 | + return $this->icingaDB; |
|
180 | + } |
|
164 | 181 | // TODO : get ido database directly from icingaweb2 config -> (or not if using only API) |
165 | 182 | $dbresource=$this->Config()->get('config', 'IDOdatabase');; |
166 | 183 | |
167 | 184 | if ( ! $dbresource ) |
168 | 185 | { |
169 | - if ($test) return array(1,'No database in config.ini'); |
|
186 | + if ($test) { |
|
187 | + return array(1,'No database in config.ini'); |
|
188 | + } |
|
170 | 189 | $this->redirectNow('trapdirector/settings?idodberror=1'); |
171 | 190 | return null; |
172 | 191 | } |
@@ -174,10 +193,11 @@ discard block |
||
174 | 193 | try |
175 | 194 | { |
176 | 195 | $dbconn = IcingaDbConnection::fromResourceName($dbresource); |
177 | - } |
|
178 | - catch (Exception $e) |
|
196 | + } catch (Exception $e) |
|
179 | 197 | { |
180 | - if ($test) return array(2,"Database $dbresource does not exists in IcingaWeb2"); |
|
198 | + if ($test) { |
|
199 | + return array(2,"Database $dbresource does not exists in IcingaWeb2"); |
|
200 | + } |
|
181 | 201 | $this->redirectNow('trapdirector/settings?idodberror=2'); |
182 | 202 | return null; |
183 | 203 | } |
@@ -197,8 +217,7 @@ discard block |
||
197 | 217 | { |
198 | 218 | return array(4,"$dbresource does not look like an IDO database"); |
199 | 219 | } |
200 | - } |
|
201 | - catch (Exception $e) |
|
220 | + } catch (Exception $e) |
|
202 | 221 | { |
203 | 222 | return array(3,"Error connecting to $dbresource : " . $e->getMessage()); |
204 | 223 | } |
@@ -446,8 +465,7 @@ discard block |
||
446 | 465 | if (isset($common_services[$service->name2]['num'])) |
447 | 466 | { |
448 | 467 | $common_services[$service->name2]['num'] +=1; |
449 | - } |
|
450 | - else |
|
468 | + } else |
|
451 | 469 | { |
452 | 470 | $common_services[$service->name2]['num']=1; |
453 | 471 | $common_services[$service->name2]['name']=$service->name; |
@@ -591,7 +609,9 @@ discard block |
||
591 | 609 | $condition=($condition===null)?'':$condition.' AND '; |
592 | 610 | $condition.="trap_oid='$oid'"; |
593 | 611 | } |
594 | - if($condition === null) return null; |
|
612 | + if($condition === null) { |
|
613 | + return null; |
|
614 | + } |
|
595 | 615 | $query=$db->delete( |
596 | 616 | $this->getModuleConfig()->getTrapTableName(), |
597 | 617 | $condition |
@@ -619,7 +639,9 @@ discard block |
||
619 | 639 | $condition=($condition===null)?'':$condition.' AND '; |
620 | 640 | $condition.="trap_oid='$oid'"; |
621 | 641 | } |
622 | - if($condition ==null) return 0; |
|
642 | + if($condition ==null) { |
|
643 | + return 0; |
|
644 | + } |
|
623 | 645 | $query=$db->select() |
624 | 646 | ->from( |
625 | 647 | $this->getModuleConfig()->getTrapTableName(), |
@@ -643,18 +665,28 @@ discard block |
||
643 | 665 | array('value'=>'value')) |
644 | 666 | ->where('name=?',$element); |
645 | 667 | $return_row=$db->fetchRow($query); |
646 | - if ($return_row==null) // value does not exists |
|
668 | + if ($return_row==null) { |
|
669 | + // value does not exists |
|
647 | 670 | { |
648 | 671 | $default=$this->getModuleConfig()->getDBConfigDefaults(); |
649 | - if ( ! isset($default[$element])) return null; // no default and not value |
|
672 | + } |
|
673 | + if ( ! isset($default[$element])) { |
|
674 | + return null; |
|
675 | + } |
|
676 | + // no default and not value |
|
650 | 677 | |
651 | 678 | $this->addDBConfigValue($element,$default[$element]); |
652 | 679 | return $default[$element]; |
653 | 680 | } |
654 | - if ($return_row->value == null) // value id empty |
|
681 | + if ($return_row->value == null) { |
|
682 | + // value id empty |
|
655 | 683 | { |
656 | 684 | $default=$this->getModuleConfig()->getDBConfigDefaults(); |
657 | - if ( ! isset($default[$element])) return null; // no default and not value |
|
685 | + } |
|
686 | + if ( ! isset($default[$element])) { |
|
687 | + return null; |
|
688 | + } |
|
689 | + // no default and not value |
|
658 | 690 | $this->setDBConfigValue($element,$default[$element]); |
659 | 691 | return $default[$element]; |
660 | 692 | } |
@@ -31,10 +31,10 @@ discard block |
||
31 | 31 | |
32 | 32 | } |
33 | 33 | |
34 | - /** |
|
35 | - * Get all mibs in db which have at least one trap |
|
36 | - * @return array |
|
37 | - */ |
|
34 | + /** |
|
35 | + * Get all mibs in db which have at least one trap |
|
36 | + * @return array |
|
37 | + */ |
|
38 | 38 | |
39 | 39 | public function getMIBList() |
40 | 40 | { |
@@ -58,9 +58,9 @@ discard block |
||
58 | 58 | |
59 | 59 | |
60 | 60 | /** Get trap list from a mib |
61 | - * @param $mib string mib name |
|
62 | - * @return array : traps |
|
63 | - */ |
|
61 | + * @param $mib string mib name |
|
62 | + * @return array : traps |
|
63 | + */ |
|
64 | 64 | public function getTrapList($mib) |
65 | 65 | { |
66 | 66 | $traps=array(); |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | $query=$dbconn->select() |
69 | 69 | ->from( |
70 | 70 | $this->config->getMIBCacheTableName(), |
71 | - array('name' => 'name', 'oid' => 'oid', 'description' => 'description')) |
|
71 | + array('name' => 'name', 'oid' => 'oid', 'description' => 'description')) |
|
72 | 72 | ->where("mib = '".$mib."' AND type='21'") ; |
73 | 73 | $names=$dbconn->fetchAll($query); |
74 | 74 | foreach ($names as $val) |
@@ -79,9 +79,9 @@ discard block |
||
79 | 79 | } |
80 | 80 | |
81 | 81 | /** Get objects a trap can have |
82 | - * @param int $trap oid of trap |
|
83 | - * @return array|null : null if trap not found, or array ( <oid> => name/mib/type ) |
|
84 | - */ |
|
82 | + * @param int $trap oid of trap |
|
83 | + * @return array|null : null if trap not found, or array ( <oid> => name/mib/type ) |
|
84 | + */ |
|
85 | 85 | public function getObjectList($trap) |
86 | 86 | { |
87 | 87 | $objects=array(); |
@@ -97,15 +97,15 @@ discard block |
||
97 | 97 | if ( ($id == null) || ! property_exists($id,'id') ) return null; |
98 | 98 | |
99 | 99 | $query=$dbconn->select() |
100 | - ->from( |
|
101 | - array('c' => $this->config->getMIBCacheTableName()), |
|
102 | - array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum', |
|
103 | - 'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint', |
|
104 | - 'description' => 'c.description')) |
|
105 | - ->join( |
|
106 | - array('o' => $this->config->getMIBCacheTableTrapObjName()), |
|
107 | - 'o.trap_id='.$id->id ) |
|
108 | - ->where("o.object_id = c.id"); |
|
100 | + ->from( |
|
101 | + array('c' => $this->config->getMIBCacheTableName()), |
|
102 | + array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum', |
|
103 | + 'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint', |
|
104 | + 'description' => 'c.description')) |
|
105 | + ->join( |
|
106 | + array('o' => $this->config->getMIBCacheTableTrapObjName()), |
|
107 | + 'o.trap_id='.$id->id ) |
|
108 | + ->where("o.object_id = c.id"); |
|
109 | 109 | $listObjects=$dbconn->fetchAll($query); |
110 | 110 | if ( count($listObjects)==0 ) return null; |
111 | 111 | |
@@ -123,12 +123,12 @@ discard block |
||
123 | 123 | } |
124 | 124 | |
125 | 125 | /** translate oid in MIB::Name |
126 | - * @param string oid |
|
127 | - * @return array|null : return array with index (oid -> oid, mib -> mib name, name -> oid name, type -> oid type) |
|
128 | - */ |
|
126 | + * @param string oid |
|
127 | + * @return array|null : return array with index (oid -> oid, mib -> mib name, name -> oid name, type -> oid type) |
|
128 | + */ |
|
129 | 129 | public function translateOID($oid) |
130 | 130 | { |
131 | - if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.' |
|
131 | + if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.' |
|
132 | 132 | $retArray=array('oid' => $oid, 'mib' => null, 'name'=>null,'type'=>null); |
133 | 133 | $dbconn = $this->db->getConnection(); |
134 | 134 | |
@@ -136,7 +136,7 @@ discard block |
||
136 | 136 | ->from( |
137 | 137 | array('o' => $this->config->getMIBCacheTableName()), |
138 | 138 | array('mib'=>'o.mib','name' => 'o.name','type'=>'o.syntax', |
139 | - 'type_enum'=>'o.type_enum', 'description'=>'o.description')) |
|
139 | + 'type_enum'=>'o.type_enum', 'description'=>'o.description')) |
|
140 | 140 | ->where('o.oid=\''.$oid.'\''); |
141 | 141 | $object=$dbconn->fetchRow($query); |
142 | 142 | if ($object != null) |
@@ -152,7 +152,7 @@ discard block |
||
152 | 152 | // Try to get oid name from snmptranslate |
153 | 153 | $matches=array(); |
154 | 154 | $translate=exec($this->snmptranslate . ' -m ALL -M +'.$this->snmptranslate_dirs. |
155 | - ' '.$oid); |
|
155 | + ' '.$oid); |
|
156 | 156 | $ret_code=preg_match('/(.*)::(.*)/',$translate,$matches); |
157 | 157 | if ($ret_code===0 || $ret_code===false) { |
158 | 158 | return null; |
@@ -164,8 +164,8 @@ discard block |
||
164 | 164 | " | grep SYNTAX | sed 's/SYNTAX[[:blank:]]*//'"); |
165 | 165 | if (preg_match('/(.*)\{(.*)\}/',$translate,$matches)) |
166 | 166 | { |
167 | - $retArray['type']=$matches[1]; |
|
168 | - $retArray['type_enum']=$matches[2]; |
|
167 | + $retArray['type']=$matches[1]; |
|
168 | + $retArray['type_enum']=$matches[2]; |
|
169 | 169 | } |
170 | 170 | else |
171 | 171 | { |
@@ -229,25 +229,25 @@ discard block |
||
229 | 229 | */ |
230 | 230 | public function getTrapDetails($oid=null,$id=null) |
231 | 231 | { |
232 | - // Get trap id in DB |
|
233 | - if ($oid===null) |
|
234 | - { |
|
235 | - $where="c.id = '$id'"; |
|
236 | - } |
|
237 | - else |
|
238 | - { |
|
239 | - $where="c.oid = '$oid'"; |
|
240 | - } |
|
241 | - $query=$this->db->getConnection()->select() |
|
242 | - ->from( |
|
243 | - array('c' => $this->config->getMIBCacheTableName()), |
|
244 | - array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum', |
|
245 | - 'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint', |
|
246 | - 'description' => 'c.description')) |
|
247 | - ->where($where); |
|
248 | - $trap=$this->db->getConnection()->fetchRow($query); |
|
232 | + // Get trap id in DB |
|
233 | + if ($oid===null) |
|
234 | + { |
|
235 | + $where="c.id = '$id'"; |
|
236 | + } |
|
237 | + else |
|
238 | + { |
|
239 | + $where="c.oid = '$oid'"; |
|
240 | + } |
|
241 | + $query=$this->db->getConnection()->select() |
|
242 | + ->from( |
|
243 | + array('c' => $this->config->getMIBCacheTableName()), |
|
244 | + array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum', |
|
245 | + 'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint', |
|
246 | + 'description' => 'c.description')) |
|
247 | + ->where($where); |
|
248 | + $trap=$this->db->getConnection()->fetchRow($query); |
|
249 | 249 | |
250 | - return $trap; |
|
250 | + return $trap; |
|
251 | 251 | } |
252 | 252 | |
253 | 253 | } |
@@ -21,7 +21,7 @@ discard block |
||
21 | 21 | * @param string $db current database |
22 | 22 | * @param TrapModuleConfig $config TrapModuleConfig class instance |
23 | 23 | */ |
24 | - public function __construct($snmptranslate,$snmptranslate_dirs,$db,$config) |
|
24 | + public function __construct($snmptranslate, $snmptranslate_dirs, $db, $config) |
|
25 | 25 | { |
26 | 26 | $this->snmptranslate=$snmptranslate; |
27 | 27 | $this->snmptranslate_dirs=$snmptranslate_dirs; |
@@ -38,19 +38,19 @@ discard block |
||
38 | 38 | |
39 | 39 | public function getMIBList() |
40 | 40 | { |
41 | - $dbconn = $this->db->getConnection(); |
|
41 | + $dbconn=$this->db->getConnection(); |
|
42 | 42 | $query=$dbconn->select() |
43 | 43 | ->distinct() |
44 | 44 | ->from( |
45 | 45 | $this->config->getMIBCacheTableName(), |
46 | 46 | array('mib' => 'mib')) |
47 | 47 | ->where("type = '21'") |
48 | - ->order('mib ASC'); ; |
|
48 | + ->order('mib ASC'); ; |
|
49 | 49 | $names=$dbconn->fetchAll($query); |
50 | 50 | $mib=array(); |
51 | - foreach($names as $val) |
|
51 | + foreach ($names as $val) |
|
52 | 52 | { |
53 | - array_push($mib,$val->mib); |
|
53 | + array_push($mib, $val->mib); |
|
54 | 54 | } |
55 | 55 | return $mib; |
56 | 56 | |
@@ -64,12 +64,12 @@ discard block |
||
64 | 64 | public function getTrapList($mib) |
65 | 65 | { |
66 | 66 | $traps=array(); |
67 | - $dbconn = $this->db->getConnection(); |
|
67 | + $dbconn=$this->db->getConnection(); |
|
68 | 68 | $query=$dbconn->select() |
69 | 69 | ->from( |
70 | 70 | $this->config->getMIBCacheTableName(), |
71 | 71 | array('name' => 'name', 'oid' => 'oid', 'description' => 'description')) |
72 | - ->where("mib = '".$mib."' AND type='21'") ; |
|
72 | + ->where("mib = '".$mib."' AND type='21'"); |
|
73 | 73 | $names=$dbconn->fetchAll($query); |
74 | 74 | foreach ($names as $val) |
75 | 75 | { |
@@ -87,19 +87,19 @@ discard block |
||
87 | 87 | $objects=array(); |
88 | 88 | |
89 | 89 | // Get trap id in DB |
90 | - $dbconn = $this->db->getConnection(); |
|
90 | + $dbconn=$this->db->getConnection(); |
|
91 | 91 | $query=$dbconn->select() |
92 | 92 | ->from( |
93 | 93 | $this->config->getMIBCacheTableName(), |
94 | 94 | array('id' => 'id')) |
95 | - ->where("oid = '".$trap."'") ; |
|
95 | + ->where("oid = '".$trap."'"); |
|
96 | 96 | $id=$dbconn->fetchRow($query); |
97 | - if ( ($id == null) || ! property_exists($id,'id') ) return null; |
|
97 | + if (($id == null) || !property_exists($id, 'id')) return null; |
|
98 | 98 | |
99 | 99 | $query=$dbconn->select() |
100 | 100 | ->from( |
101 | 101 | array('c' => $this->config->getMIBCacheTableName()), |
102 | - array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum', |
|
102 | + array('name' => 'c.name', 'mib' => 'c.mib', 'oid' => 'c.oid', 'type_enum'=>'c.type_enum', |
|
103 | 103 | 'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint', |
104 | 104 | 'description' => 'c.description')) |
105 | 105 | ->join( |
@@ -107,7 +107,7 @@ discard block |
||
107 | 107 | 'o.trap_id='.$id->id ) |
108 | 108 | ->where("o.object_id = c.id"); |
109 | 109 | $listObjects=$dbconn->fetchAll($query); |
110 | - if ( count($listObjects)==0 ) return null; |
|
110 | + if (count($listObjects) == 0) return null; |
|
111 | 111 | |
112 | 112 | foreach ($listObjects as $val) |
113 | 113 | { |
@@ -128,14 +128,14 @@ discard block |
||
128 | 128 | */ |
129 | 129 | public function translateOID($oid) |
130 | 130 | { |
131 | - if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.' |
|
132 | - $retArray=array('oid' => $oid, 'mib' => null, 'name'=>null,'type'=>null); |
|
133 | - $dbconn = $this->db->getConnection(); |
|
131 | + if (!preg_match('/^\./', $oid)) $oid='.'.$oid; // Add a leading '.' |
|
132 | + $retArray=array('oid' => $oid, 'mib' => null, 'name'=>null, 'type'=>null); |
|
133 | + $dbconn=$this->db->getConnection(); |
|
134 | 134 | |
135 | 135 | $query=$dbconn->select() |
136 | 136 | ->from( |
137 | 137 | array('o' => $this->config->getMIBCacheTableName()), |
138 | - array('mib'=>'o.mib','name' => 'o.name','type'=>'o.syntax', |
|
138 | + array('mib'=>'o.mib', 'name' => 'o.name', 'type'=>'o.syntax', |
|
139 | 139 | 'type_enum'=>'o.type_enum', 'description'=>'o.description')) |
140 | 140 | ->where('o.oid=\''.$oid.'\''); |
141 | 141 | $object=$dbconn->fetchRow($query); |
@@ -151,18 +151,18 @@ discard block |
||
151 | 151 | |
152 | 152 | // Try to get oid name from snmptranslate |
153 | 153 | $matches=array(); |
154 | - $translate=exec($this->snmptranslate . ' -m ALL -M +'.$this->snmptranslate_dirs. |
|
154 | + $translate=exec($this->snmptranslate.' -m ALL -M +'.$this->snmptranslate_dirs. |
|
155 | 155 | ' '.$oid); |
156 | - $ret_code=preg_match('/(.*)::(.*)/',$translate,$matches); |
|
157 | - if ($ret_code===0 || $ret_code===false) { |
|
156 | + $ret_code=preg_match('/(.*)::(.*)/', $translate, $matches); |
|
157 | + if ($ret_code === 0 || $ret_code === false) { |
|
158 | 158 | return null; |
159 | 159 | } |
160 | 160 | $retArray['mib']=$matches[1]; |
161 | 161 | $retArray['name']=$matches[2]; |
162 | 162 | |
163 | - $translate=exec($this->snmptranslate . ' -m ALL -M +'.$this->snmptranslate_dirs.' -Td -On ' . $matches[0] . |
|
163 | + $translate=exec($this->snmptranslate.' -m ALL -M +'.$this->snmptranslate_dirs.' -Td -On '.$matches[0]. |
|
164 | 164 | " | grep SYNTAX | sed 's/SYNTAX[[:blank:]]*//'"); |
165 | - if (preg_match('/(.*)\{(.*)\}/',$translate,$matches)) |
|
165 | + if (preg_match('/(.*)\{(.*)\}/', $translate, $matches)) |
|
166 | 166 | { |
167 | 167 | $retArray['type']=$matches[1]; |
168 | 168 | $retArray['type_enum']=$matches[2]; |
@@ -197,9 +197,9 @@ discard block |
||
197 | 197 | * @param string $type filter by type (21=trap) |
198 | 198 | * @return number number of entries in db. |
199 | 199 | */ |
200 | - public function countObjects($mib=null,$type=null) |
|
200 | + public function countObjects($mib=null, $type=null) |
|
201 | 201 | { |
202 | - $dbconn = $this->db->getConnection(); |
|
202 | + $dbconn=$this->db->getConnection(); |
|
203 | 203 | $query=$dbconn->select() |
204 | 204 | ->from( |
205 | 205 | $this->config->getMIBCacheTableName(), |
@@ -207,11 +207,11 @@ discard block |
||
207 | 207 | $where=null; |
208 | 208 | if ($mib !== null) |
209 | 209 | { |
210 | - $where ="mib = '$mib' "; |
|
210 | + $where="mib = '$mib' "; |
|
211 | 211 | } |
212 | 212 | if ($type !== null) |
213 | 213 | { |
214 | - $where=($where != null)?' AND ':''; |
|
214 | + $where=($where != null) ? ' AND ' : ''; |
|
215 | 215 | $where.="type='$type'"; |
216 | 216 | } |
217 | 217 | if ($where !== null) |
@@ -227,10 +227,10 @@ discard block |
||
227 | 227 | * @param integer $id |
228 | 228 | * @return array trap details |
229 | 229 | */ |
230 | - public function getTrapDetails($oid=null,$id=null) |
|
230 | + public function getTrapDetails($oid=null, $id=null) |
|
231 | 231 | { |
232 | 232 | // Get trap id in DB |
233 | - if ($oid===null) |
|
233 | + if ($oid === null) |
|
234 | 234 | { |
235 | 235 | $where="c.id = '$id'"; |
236 | 236 | } |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | $query=$this->db->getConnection()->select() |
242 | 242 | ->from( |
243 | 243 | array('c' => $this->config->getMIBCacheTableName()), |
244 | - array('name' => 'c.name','mib' => 'c.mib','oid' => 'c.oid','type_enum'=>'c.type_enum', |
|
244 | + array('name' => 'c.name', 'mib' => 'c.mib', 'oid' => 'c.oid', 'type_enum'=>'c.type_enum', |
|
245 | 245 | 'type' => 'c.syntax', 'text_conv' => 'c.textual_convention', 'disp' => 'display_hint', |
246 | 246 | 'description' => 'c.description')) |
247 | 247 | ->where($where); |
@@ -94,7 +94,9 @@ discard block |
||
94 | 94 | array('id' => 'id')) |
95 | 95 | ->where("oid = '".$trap."'") ; |
96 | 96 | $id=$dbconn->fetchRow($query); |
97 | - if ( ($id == null) || ! property_exists($id,'id') ) return null; |
|
97 | + if ( ($id == null) || ! property_exists($id,'id') ) { |
|
98 | + return null; |
|
99 | + } |
|
98 | 100 | |
99 | 101 | $query=$dbconn->select() |
100 | 102 | ->from( |
@@ -107,7 +109,9 @@ discard block |
||
107 | 109 | 'o.trap_id='.$id->id ) |
108 | 110 | ->where("o.object_id = c.id"); |
109 | 111 | $listObjects=$dbconn->fetchAll($query); |
110 | - if ( count($listObjects)==0 ) return null; |
|
112 | + if ( count($listObjects)==0 ) { |
|
113 | + return null; |
|
114 | + } |
|
111 | 115 | |
112 | 116 | foreach ($listObjects as $val) |
113 | 117 | { |
@@ -128,7 +132,10 @@ discard block |
||
128 | 132 | */ |
129 | 133 | public function translateOID($oid) |
130 | 134 | { |
131 | - if (!preg_match('/^\./',$oid)) $oid = '.' . $oid; // Add a leading '.' |
|
135 | + if (!preg_match('/^\./',$oid)) { |
|
136 | + $oid = '.' . $oid; |
|
137 | + } |
|
138 | + // Add a leading '.' |
|
132 | 139 | $retArray=array('oid' => $oid, 'mib' => null, 'name'=>null,'type'=>null); |
133 | 140 | $dbconn = $this->db->getConnection(); |
134 | 141 | |
@@ -166,8 +173,7 @@ discard block |
||
166 | 173 | { |
167 | 174 | $retArray['type']=$matches[1]; |
168 | 175 | $retArray['type_enum']=$matches[2]; |
169 | - } |
|
170 | - else |
|
176 | + } else |
|
171 | 177 | { |
172 | 178 | $retArray['type']=$translate; |
173 | 179 | $retArray['type_enum']=''; |
@@ -233,8 +239,7 @@ discard block |
||
233 | 239 | if ($oid===null) |
234 | 240 | { |
235 | 241 | $where="c.id = '$id'"; |
236 | - } |
|
237 | - else |
|
242 | + } else |
|
238 | 243 | { |
239 | 244 | $where="c.oid = '$oid'"; |
240 | 245 | } |
@@ -9,113 +9,113 @@ |
||
9 | 9 | class Logging |
10 | 10 | { |
11 | 11 | |
12 | - //**** Options from config database |
|
13 | - // Default values |
|
14 | - public $debugLevel=2; // 0=No output 1=critical 2=warning 3=trace 4=ALL |
|
15 | - public $outputMode='syslog'; // alert type : file, syslog, display |
|
16 | - public $outputFile="/tmp/trapdebug.txt"; |
|
17 | - protected $logLevels=array("","Error","Warning","Info","Debug"); |
|
18 | - protected $outputList=array('file', 'syslog', 'display'); |
|
12 | + //**** Options from config database |
|
13 | + // Default values |
|
14 | + public $debugLevel=2; // 0=No output 1=critical 2=warning 3=trace 4=ALL |
|
15 | + public $outputMode='syslog'; // alert type : file, syslog, display |
|
16 | + public $outputFile="/tmp/trapdebug.txt"; |
|
17 | + protected $logLevels=array("","Error","Warning","Info","Debug"); |
|
18 | + protected $outputList=array('file', 'syslog', 'display'); |
|
19 | 19 | |
20 | - /** Send log. Throws exception on critical error |
|
21 | - * @param string $message Message to log |
|
22 | - * @param int $level 1=critical 2=warning 3=trace 4=debug |
|
23 | - * @param string $destination file/syslog/display |
|
24 | - * @return void |
|
25 | - * @throws Exception |
|
26 | - **/ |
|
27 | - public function log( $message, $level, $destination ='') |
|
28 | - { |
|
29 | - if ($this->debugLevel >= $level) |
|
30 | - { |
|
31 | - $message = '['. date("Y/m/d H:i:s") . '] ' . |
|
32 | - '[TrapDirector] ['.$this->logLevels[$level].']: ' .$message . "\n"; |
|
20 | + /** Send log. Throws exception on critical error |
|
21 | + * @param string $message Message to log |
|
22 | + * @param int $level 1=critical 2=warning 3=trace 4=debug |
|
23 | + * @param string $destination file/syslog/display |
|
24 | + * @return void |
|
25 | + * @throws Exception |
|
26 | + **/ |
|
27 | + public function log( $message, $level, $destination ='') |
|
28 | + { |
|
29 | + if ($this->debugLevel >= $level) |
|
30 | + { |
|
31 | + $message = '['. date("Y/m/d H:i:s") . '] ' . |
|
32 | + '[TrapDirector] ['.$this->logLevels[$level].']: ' .$message . "\n"; |
|
33 | 33 | |
34 | - $output = ( $destination != '' ) ? $destination : $this->outputMode; |
|
35 | - switch ($output) |
|
36 | - { |
|
37 | - case 'file': |
|
38 | - file_put_contents ($this->outputFile, $message , FILE_APPEND); |
|
39 | - break; |
|
40 | - case 'syslog': |
|
41 | - switch($level) |
|
42 | - { |
|
43 | - case 1 : $prio = LOG_ERR;break; |
|
44 | - case 2 : $prio = LOG_WARNING;break; |
|
45 | - case 3 : $prio = LOG_INFO;break; |
|
46 | - case 4 : $prio = LOG_DEBUG;break; |
|
47 | - default: $prio = LOG_ERR; |
|
48 | - } |
|
49 | - syslog($prio,$message); |
|
50 | - break; |
|
51 | - case 'display': |
|
52 | - echo $message; |
|
53 | - break; |
|
54 | - default : // nothing we can do at this point |
|
55 | - throw new Exception($message); |
|
56 | - } |
|
57 | - } |
|
58 | - if ($level == 1) |
|
59 | - { |
|
60 | - throw new Exception($message); |
|
61 | - } |
|
62 | - } |
|
34 | + $output = ( $destination != '' ) ? $destination : $this->outputMode; |
|
35 | + switch ($output) |
|
36 | + { |
|
37 | + case 'file': |
|
38 | + file_put_contents ($this->outputFile, $message , FILE_APPEND); |
|
39 | + break; |
|
40 | + case 'syslog': |
|
41 | + switch($level) |
|
42 | + { |
|
43 | + case 1 : $prio = LOG_ERR;break; |
|
44 | + case 2 : $prio = LOG_WARNING;break; |
|
45 | + case 3 : $prio = LOG_INFO;break; |
|
46 | + case 4 : $prio = LOG_DEBUG;break; |
|
47 | + default: $prio = LOG_ERR; |
|
48 | + } |
|
49 | + syslog($prio,$message); |
|
50 | + break; |
|
51 | + case 'display': |
|
52 | + echo $message; |
|
53 | + break; |
|
54 | + default : // nothing we can do at this point |
|
55 | + throw new Exception($message); |
|
56 | + } |
|
57 | + } |
|
58 | + if ($level == 1) |
|
59 | + { |
|
60 | + throw new Exception($message); |
|
61 | + } |
|
62 | + } |
|
63 | 63 | |
64 | 64 | |
65 | - public function setLogging($debugLvl,$outputType,$outputFile=null) |
|
66 | - { |
|
67 | - $this->setLevel($debugLvl); |
|
68 | - switch ($outputType) |
|
69 | - { |
|
70 | - case 'file': |
|
71 | - if ($outputFile == null) throw new Exception("File logging without file !"); |
|
72 | - $this->setFile($outputFile); |
|
73 | - $this->setDestination('file'); |
|
74 | - break; |
|
75 | - default: |
|
76 | - $this->setDestination($outputType); |
|
77 | - } |
|
78 | - } |
|
65 | + public function setLogging($debugLvl,$outputType,$outputFile=null) |
|
66 | + { |
|
67 | + $this->setLevel($debugLvl); |
|
68 | + switch ($outputType) |
|
69 | + { |
|
70 | + case 'file': |
|
71 | + if ($outputFile == null) throw new Exception("File logging without file !"); |
|
72 | + $this->setFile($outputFile); |
|
73 | + $this->setDestination('file'); |
|
74 | + break; |
|
75 | + default: |
|
76 | + $this->setDestination($outputType); |
|
77 | + } |
|
78 | + } |
|
79 | 79 | |
80 | - /** |
|
81 | - * Set logging level |
|
82 | - * @param integer $level |
|
83 | - * @throws Exception |
|
84 | - */ |
|
85 | - public function setLevel($level) |
|
86 | - { |
|
87 | - if (!is_integer($level) || $level < 0 || $level > 10) |
|
88 | - { |
|
89 | - throw new Exception('Invalid log level'); |
|
90 | - } |
|
91 | - $this->debugLevel=$level; |
|
92 | - } |
|
80 | + /** |
|
81 | + * Set logging level |
|
82 | + * @param integer $level |
|
83 | + * @throws Exception |
|
84 | + */ |
|
85 | + public function setLevel($level) |
|
86 | + { |
|
87 | + if (!is_integer($level) || $level < 0 || $level > 10) |
|
88 | + { |
|
89 | + throw new Exception('Invalid log level'); |
|
90 | + } |
|
91 | + $this->debugLevel=$level; |
|
92 | + } |
|
93 | 93 | |
94 | - /** |
|
95 | - * Set logging destination |
|
96 | - * @param string $destination |
|
97 | - * @throws Exception |
|
98 | - */ |
|
99 | - public function setDestination($destination) |
|
100 | - { |
|
101 | - if (!is_string($destination) || ! in_array($destination, $this->outputList)) |
|
102 | - { |
|
103 | - throw new Exception('Invalid log destination'); |
|
104 | - } |
|
105 | - $this->outputMode=$destination; |
|
106 | - } |
|
107 | - /** |
|
108 | - * Set file destination |
|
109 | - * @param string $file |
|
110 | - * @throws Exception |
|
111 | - */ |
|
112 | - public function setFile($file) |
|
113 | - { |
|
114 | - if (!is_string($file)) |
|
115 | - { |
|
116 | - throw new Exception('Invalid log file'); |
|
117 | - } |
|
118 | - $this->outputFile=$file; |
|
119 | - } |
|
94 | + /** |
|
95 | + * Set logging destination |
|
96 | + * @param string $destination |
|
97 | + * @throws Exception |
|
98 | + */ |
|
99 | + public function setDestination($destination) |
|
100 | + { |
|
101 | + if (!is_string($destination) || ! in_array($destination, $this->outputList)) |
|
102 | + { |
|
103 | + throw new Exception('Invalid log destination'); |
|
104 | + } |
|
105 | + $this->outputMode=$destination; |
|
106 | + } |
|
107 | + /** |
|
108 | + * Set file destination |
|
109 | + * @param string $file |
|
110 | + * @throws Exception |
|
111 | + */ |
|
112 | + public function setFile($file) |
|
113 | + { |
|
114 | + if (!is_string($file)) |
|
115 | + { |
|
116 | + throw new Exception('Invalid log file'); |
|
117 | + } |
|
118 | + $this->outputFile=$file; |
|
119 | + } |
|
120 | 120 | |
121 | 121 | } |
122 | 122 | \ No newline at end of file |
@@ -4,17 +4,17 @@ discard block |
||
4 | 4 | |
5 | 5 | use Exception; |
6 | 6 | |
7 | -define("ERROR", 1);define("WARN", 2);define("INFO", 3);define("DEBUG", 4); |
|
7 | +define("ERROR", 1); define("WARN", 2); define("INFO", 3); define("DEBUG", 4); |
|
8 | 8 | |
9 | 9 | class Logging |
10 | 10 | { |
11 | 11 | |
12 | 12 | //**** Options from config database |
13 | 13 | // Default values |
14 | - public $debugLevel=2; // 0=No output 1=critical 2=warning 3=trace 4=ALL |
|
14 | + public $debugLevel=2; // 0=No output 1=critical 2=warning 3=trace 4=ALL |
|
15 | 15 | public $outputMode='syslog'; // alert type : file, syslog, display |
16 | 16 | public $outputFile="/tmp/trapdebug.txt"; |
17 | - protected $logLevels=array("","Error","Warning","Info","Debug"); |
|
17 | + protected $logLevels=array("", "Error", "Warning", "Info", "Debug"); |
|
18 | 18 | protected $outputList=array('file', 'syslog', 'display'); |
19 | 19 | |
20 | 20 | /** Send log. Throws exception on critical error |
@@ -24,29 +24,29 @@ discard block |
||
24 | 24 | * @return void |
25 | 25 | * @throws Exception |
26 | 26 | **/ |
27 | - public function log( $message, $level, $destination ='') |
|
27 | + public function log($message, $level, $destination='') |
|
28 | 28 | { |
29 | 29 | if ($this->debugLevel >= $level) |
30 | 30 | { |
31 | - $message = '['. date("Y/m/d H:i:s") . '] ' . |
|
32 | - '[TrapDirector] ['.$this->logLevels[$level].']: ' .$message . "\n"; |
|
31 | + $message='['.date("Y/m/d H:i:s").'] '. |
|
32 | + '[TrapDirector] ['.$this->logLevels[$level].']: '.$message."\n"; |
|
33 | 33 | |
34 | - $output = ( $destination != '' ) ? $destination : $this->outputMode; |
|
34 | + $output=($destination != '') ? $destination : $this->outputMode; |
|
35 | 35 | switch ($output) |
36 | 36 | { |
37 | 37 | case 'file': |
38 | - file_put_contents ($this->outputFile, $message , FILE_APPEND); |
|
38 | + file_put_contents($this->outputFile, $message, FILE_APPEND); |
|
39 | 39 | break; |
40 | 40 | case 'syslog': |
41 | - switch($level) |
|
41 | + switch ($level) |
|
42 | 42 | { |
43 | - case 1 : $prio = LOG_ERR;break; |
|
44 | - case 2 : $prio = LOG_WARNING;break; |
|
45 | - case 3 : $prio = LOG_INFO;break; |
|
46 | - case 4 : $prio = LOG_DEBUG;break; |
|
47 | - default: $prio = LOG_ERR; |
|
43 | + case 1 : $prio=LOG_ERR; break; |
|
44 | + case 2 : $prio=LOG_WARNING; break; |
|
45 | + case 3 : $prio=LOG_INFO; break; |
|
46 | + case 4 : $prio=LOG_DEBUG; break; |
|
47 | + default: $prio=LOG_ERR; |
|
48 | 48 | } |
49 | - syslog($prio,$message); |
|
49 | + syslog($prio, $message); |
|
50 | 50 | break; |
51 | 51 | case 'display': |
52 | 52 | echo $message; |
@@ -62,7 +62,7 @@ discard block |
||
62 | 62 | } |
63 | 63 | |
64 | 64 | |
65 | - public function setLogging($debugLvl,$outputType,$outputFile=null) |
|
65 | + public function setLogging($debugLvl, $outputType, $outputFile=null) |
|
66 | 66 | { |
67 | 67 | $this->setLevel($debugLvl); |
68 | 68 | switch ($outputType) |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | */ |
99 | 99 | public function setDestination($destination) |
100 | 100 | { |
101 | - if (!is_string($destination) || ! in_array($destination, $this->outputList)) |
|
101 | + if (!is_string($destination) || !in_array($destination, $this->outputList)) |
|
102 | 102 | { |
103 | 103 | throw new Exception('Invalid log destination'); |
104 | 104 | } |
@@ -68,7 +68,9 @@ |
||
68 | 68 | switch ($outputType) |
69 | 69 | { |
70 | 70 | case 'file': |
71 | - if ($outputFile == null) throw new Exception("File logging without file !"); |
|
71 | + if ($outputFile == null) { |
|
72 | + throw new Exception("File logging without file !"); |
|
73 | + } |
|
72 | 74 | $this->setFile($outputFile); |
73 | 75 | $this->setDestination('file'); |
74 | 76 | break; |
@@ -11,128 +11,128 @@ |
||
11 | 11 | class Database |
12 | 12 | { |
13 | 13 | |
14 | - // Databases |
|
15 | - protected $trapDB=null; //< trap database |
|
16 | - protected $idoDB=null; //< ido database |
|
17 | - public $trapDBType; //< Type of database for traps (mysql, pgsql) |
|
18 | - public $idoDBType; //< Type of database for ido (mysql, pgsql) |
|
14 | + // Databases |
|
15 | + protected $trapDB=null; //< trap database |
|
16 | + protected $idoDB=null; //< ido database |
|
17 | + public $trapDBType; //< Type of database for traps (mysql, pgsql) |
|
18 | + public $idoDBType; //< Type of database for ido (mysql, pgsql) |
|
19 | 19 | |
20 | - protected $trapDSN; //< trap database connection params |
|
21 | - protected $trapUsername; //< trap database connection params |
|
22 | - protected $trapPass; //< trap database connection params |
|
20 | + protected $trapDSN; //< trap database connection params |
|
21 | + protected $trapUsername; //< trap database connection params |
|
22 | + protected $trapPass; //< trap database connection params |
|
23 | 23 | |
24 | - protected $idoSet; //< bool true is ido database set |
|
25 | - protected $idoDSN; //< trap database connection params |
|
26 | - protected $idoUsername; //< trap database connection params |
|
27 | - protected $idoPass; //< trap database connection params |
|
24 | + protected $idoSet; //< bool true is ido database set |
|
25 | + protected $idoDSN; //< trap database connection params |
|
26 | + protected $idoUsername; //< trap database connection params |
|
27 | + protected $idoPass; //< trap database connection params |
|
28 | 28 | |
29 | - // Logging function |
|
29 | + // Logging function |
|
30 | 30 | |
31 | - protected $logging; //< logging class |
|
31 | + protected $logging; //< logging class |
|
32 | 32 | |
33 | - /** |
|
34 | - * @param Logging $logClass : where to log |
|
35 | - * @param array $dbParam : array of named params type,host,dbname,username,[port],[password] |
|
36 | - */ |
|
37 | - function __construct($logClass,$dbParam) |
|
38 | - { |
|
39 | - $this->logging=$logClass; |
|
33 | + /** |
|
34 | + * @param Logging $logClass : where to log |
|
35 | + * @param array $dbParam : array of named params type,host,dbname,username,[port],[password] |
|
36 | + */ |
|
37 | + function __construct($logClass,$dbParam) |
|
38 | + { |
|
39 | + $this->logging=$logClass; |
|
40 | 40 | |
41 | - $this->trapDSN=$this->setupDSN($dbParam); |
|
42 | - $this->trapUsername = $dbParam['username']; |
|
43 | - $this->trapPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:''; |
|
44 | - $this->trapDBType=$dbParam['db']; |
|
45 | - $this->logging->log('DSN : '.$this->trapDSN. ';user '.$this->trapUsername,INFO); |
|
46 | - $this->db_connect_trap(); |
|
41 | + $this->trapDSN=$this->setupDSN($dbParam); |
|
42 | + $this->trapUsername = $dbParam['username']; |
|
43 | + $this->trapPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:''; |
|
44 | + $this->trapDBType=$dbParam['db']; |
|
45 | + $this->logging->log('DSN : '.$this->trapDSN. ';user '.$this->trapUsername,INFO); |
|
46 | + $this->db_connect_trap(); |
|
47 | 47 | |
48 | - } |
|
48 | + } |
|
49 | 49 | |
50 | - /** |
|
51 | - * Setup and connect to IDO database |
|
52 | - * @param array $dbParam : array of named params |
|
53 | - */ |
|
54 | - public function setupIDO($dbParam) |
|
55 | - { |
|
56 | - $this->idoDSN=$this->setupDSN($dbParam); |
|
57 | - $this->idoUsername = $dbParam['username']; |
|
58 | - $this->idoPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:''; |
|
59 | - $this->logging->log('DSN : '.$this->idoDSN. ';user '.$this->idoUsername,INFO); |
|
60 | - $this->idoDBType=$dbParam['db']; |
|
61 | - $this->db_connect_ido(); |
|
62 | - } |
|
50 | + /** |
|
51 | + * Setup and connect to IDO database |
|
52 | + * @param array $dbParam : array of named params |
|
53 | + */ |
|
54 | + public function setupIDO($dbParam) |
|
55 | + { |
|
56 | + $this->idoDSN=$this->setupDSN($dbParam); |
|
57 | + $this->idoUsername = $dbParam['username']; |
|
58 | + $this->idoPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:''; |
|
59 | + $this->logging->log('DSN : '.$this->idoDSN. ';user '.$this->idoUsername,INFO); |
|
60 | + $this->idoDBType=$dbParam['db']; |
|
61 | + $this->db_connect_ido(); |
|
62 | + } |
|
63 | 63 | |
64 | - /** |
|
65 | - * Connect to IDO database |
|
66 | - * @return \PDO |
|
67 | - */ |
|
68 | - public function db_connect_ido() |
|
69 | - { |
|
70 | - if ($this->idoDB != null) { |
|
71 | - // Check if connection is still alive |
|
72 | - try { |
|
73 | - $this->idoDB->query('select 1')->fetchColumn(); |
|
74 | - return $this->idoDB; |
|
75 | - } catch (Exception $e) { |
|
76 | - // select 1 failed, try to reconnect. |
|
77 | - $this->logging->log('Database IDO connection lost, reconnecting',WARN); |
|
78 | - } |
|
79 | - } |
|
80 | - try { |
|
81 | - $this->idoDB = new PDO($this->idoDSN,$this->idoUsername,$this->idoPass); |
|
82 | - } catch (PDOException $e) { |
|
83 | - $this->logging->log('Connection failed to IDO : ' . $e->getMessage(),ERROR,''); |
|
84 | - } |
|
85 | - return $this->idoDB; |
|
86 | - } |
|
64 | + /** |
|
65 | + * Connect to IDO database |
|
66 | + * @return \PDO |
|
67 | + */ |
|
68 | + public function db_connect_ido() |
|
69 | + { |
|
70 | + if ($this->idoDB != null) { |
|
71 | + // Check if connection is still alive |
|
72 | + try { |
|
73 | + $this->idoDB->query('select 1')->fetchColumn(); |
|
74 | + return $this->idoDB; |
|
75 | + } catch (Exception $e) { |
|
76 | + // select 1 failed, try to reconnect. |
|
77 | + $this->logging->log('Database IDO connection lost, reconnecting',WARN); |
|
78 | + } |
|
79 | + } |
|
80 | + try { |
|
81 | + $this->idoDB = new PDO($this->idoDSN,$this->idoUsername,$this->idoPass); |
|
82 | + } catch (PDOException $e) { |
|
83 | + $this->logging->log('Connection failed to IDO : ' . $e->getMessage(),ERROR,''); |
|
84 | + } |
|
85 | + return $this->idoDB; |
|
86 | + } |
|
87 | 87 | |
88 | - /** |
|
89 | - * Connect to Trap database |
|
90 | - * @return \PDO |
|
91 | - */ |
|
92 | - public function db_connect_trap() |
|
93 | - { |
|
88 | + /** |
|
89 | + * Connect to Trap database |
|
90 | + * @return \PDO |
|
91 | + */ |
|
92 | + public function db_connect_trap() |
|
93 | + { |
|
94 | 94 | |
95 | - if ($this->trapDB != null) { |
|
96 | - // Check if connection is still alive |
|
97 | - try { |
|
98 | - $this->trapDB->query('select 1')->fetchColumn(); |
|
99 | - return $this->trapDB; |
|
100 | - } catch (Exception $e) { |
|
101 | - // select 1 failed, try to reconnect. |
|
102 | - $this->logging->log('Database connection lost, reconnecting',WARN); |
|
103 | - } |
|
104 | - } |
|
105 | - try { |
|
106 | - $this->trapDB = new PDO($this->trapDSN,$this->trapUsername,$this->trapPass); |
|
107 | - } catch (PDOException $e) { |
|
108 | - $this->logging->log('Connection failed : ' . $e->getMessage(),ERROR,''); |
|
109 | - } |
|
110 | - return $this->trapDB; |
|
111 | - } |
|
95 | + if ($this->trapDB != null) { |
|
96 | + // Check if connection is still alive |
|
97 | + try { |
|
98 | + $this->trapDB->query('select 1')->fetchColumn(); |
|
99 | + return $this->trapDB; |
|
100 | + } catch (Exception $e) { |
|
101 | + // select 1 failed, try to reconnect. |
|
102 | + $this->logging->log('Database connection lost, reconnecting',WARN); |
|
103 | + } |
|
104 | + } |
|
105 | + try { |
|
106 | + $this->trapDB = new PDO($this->trapDSN,$this->trapUsername,$this->trapPass); |
|
107 | + } catch (PDOException $e) { |
|
108 | + $this->logging->log('Connection failed : ' . $e->getMessage(),ERROR,''); |
|
109 | + } |
|
110 | + return $this->trapDB; |
|
111 | + } |
|
112 | 112 | |
113 | - /** |
|
114 | - * Setup dsn and check parameters |
|
115 | - * @param array $configElmt |
|
116 | - * @return string |
|
117 | - */ |
|
118 | - protected function setupDSN($configElmt) |
|
119 | - { |
|
120 | - if (!array_key_exists('db',$configElmt) || |
|
121 | - !array_key_exists('host',$configElmt) || |
|
122 | - !array_key_exists('dbname',$configElmt) || |
|
123 | - !array_key_exists('username',$configElmt)) |
|
124 | - { |
|
125 | - $this->logging->log('Missing DB params',ERROR); |
|
126 | - return ''; |
|
127 | - } |
|
113 | + /** |
|
114 | + * Setup dsn and check parameters |
|
115 | + * @param array $configElmt |
|
116 | + * @return string |
|
117 | + */ |
|
118 | + protected function setupDSN($configElmt) |
|
119 | + { |
|
120 | + if (!array_key_exists('db',$configElmt) || |
|
121 | + !array_key_exists('host',$configElmt) || |
|
122 | + !array_key_exists('dbname',$configElmt) || |
|
123 | + !array_key_exists('username',$configElmt)) |
|
124 | + { |
|
125 | + $this->logging->log('Missing DB params',ERROR); |
|
126 | + return ''; |
|
127 | + } |
|
128 | 128 | |
129 | - // $dsn = 'mysql:dbname=traps;host=127.0.0.1'; |
|
130 | - $dsn= $configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host']; |
|
129 | + // $dsn = 'mysql:dbname=traps;host=127.0.0.1'; |
|
130 | + $dsn= $configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host']; |
|
131 | 131 | |
132 | - if (array_key_exists('port', $configElmt)) |
|
133 | - { |
|
134 | - $dsn .= ';port='.$configElmt['port']; |
|
135 | - } |
|
136 | - return $dsn; |
|
137 | - } |
|
132 | + if (array_key_exists('port', $configElmt)) |
|
133 | + { |
|
134 | + $dsn .= ';port='.$configElmt['port']; |
|
135 | + } |
|
136 | + return $dsn; |
|
137 | + } |
|
138 | 138 | } |
139 | 139 | \ No newline at end of file |
@@ -34,15 +34,15 @@ discard block |
||
34 | 34 | * @param Logging $logClass : where to log |
35 | 35 | * @param array $dbParam : array of named params type,host,dbname,username,[port],[password] |
36 | 36 | */ |
37 | - function __construct($logClass,$dbParam) |
|
37 | + function __construct($logClass, $dbParam) |
|
38 | 38 | { |
39 | 39 | $this->logging=$logClass; |
40 | 40 | |
41 | 41 | $this->trapDSN=$this->setupDSN($dbParam); |
42 | - $this->trapUsername = $dbParam['username']; |
|
43 | - $this->trapPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:''; |
|
42 | + $this->trapUsername=$dbParam['username']; |
|
43 | + $this->trapPass=(array_key_exists('password', $dbParam)) ? $dbParam['password'] : ''; |
|
44 | 44 | $this->trapDBType=$dbParam['db']; |
45 | - $this->logging->log('DSN : '.$this->trapDSN. ';user '.$this->trapUsername,INFO); |
|
45 | + $this->logging->log('DSN : '.$this->trapDSN.';user '.$this->trapUsername, INFO); |
|
46 | 46 | $this->db_connect_trap(); |
47 | 47 | |
48 | 48 | } |
@@ -54,9 +54,9 @@ discard block |
||
54 | 54 | public function setupIDO($dbParam) |
55 | 55 | { |
56 | 56 | $this->idoDSN=$this->setupDSN($dbParam); |
57 | - $this->idoUsername = $dbParam['username']; |
|
58 | - $this->idoPass = (array_key_exists('password', $dbParam)) ? $dbParam['password']:''; |
|
59 | - $this->logging->log('DSN : '.$this->idoDSN. ';user '.$this->idoUsername,INFO); |
|
57 | + $this->idoUsername=$dbParam['username']; |
|
58 | + $this->idoPass=(array_key_exists('password', $dbParam)) ? $dbParam['password'] : ''; |
|
59 | + $this->logging->log('DSN : '.$this->idoDSN.';user '.$this->idoUsername, INFO); |
|
60 | 60 | $this->idoDBType=$dbParam['db']; |
61 | 61 | $this->db_connect_ido(); |
62 | 62 | } |
@@ -74,13 +74,13 @@ discard block |
||
74 | 74 | return $this->idoDB; |
75 | 75 | } catch (Exception $e) { |
76 | 76 | // select 1 failed, try to reconnect. |
77 | - $this->logging->log('Database IDO connection lost, reconnecting',WARN); |
|
77 | + $this->logging->log('Database IDO connection lost, reconnecting', WARN); |
|
78 | 78 | } |
79 | 79 | } |
80 | 80 | try { |
81 | - $this->idoDB = new PDO($this->idoDSN,$this->idoUsername,$this->idoPass); |
|
81 | + $this->idoDB=new PDO($this->idoDSN, $this->idoUsername, $this->idoPass); |
|
82 | 82 | } catch (PDOException $e) { |
83 | - $this->logging->log('Connection failed to IDO : ' . $e->getMessage(),ERROR,''); |
|
83 | + $this->logging->log('Connection failed to IDO : '.$e->getMessage(), ERROR, ''); |
|
84 | 84 | } |
85 | 85 | return $this->idoDB; |
86 | 86 | } |
@@ -99,13 +99,13 @@ discard block |
||
99 | 99 | return $this->trapDB; |
100 | 100 | } catch (Exception $e) { |
101 | 101 | // select 1 failed, try to reconnect. |
102 | - $this->logging->log('Database connection lost, reconnecting',WARN); |
|
102 | + $this->logging->log('Database connection lost, reconnecting', WARN); |
|
103 | 103 | } |
104 | 104 | } |
105 | 105 | try { |
106 | - $this->trapDB = new PDO($this->trapDSN,$this->trapUsername,$this->trapPass); |
|
106 | + $this->trapDB=new PDO($this->trapDSN, $this->trapUsername, $this->trapPass); |
|
107 | 107 | } catch (PDOException $e) { |
108 | - $this->logging->log('Connection failed : ' . $e->getMessage(),ERROR,''); |
|
108 | + $this->logging->log('Connection failed : '.$e->getMessage(), ERROR, ''); |
|
109 | 109 | } |
110 | 110 | return $this->trapDB; |
111 | 111 | } |
@@ -117,21 +117,21 @@ discard block |
||
117 | 117 | */ |
118 | 118 | protected function setupDSN($configElmt) |
119 | 119 | { |
120 | - if (!array_key_exists('db',$configElmt) || |
|
121 | - !array_key_exists('host',$configElmt) || |
|
122 | - !array_key_exists('dbname',$configElmt) || |
|
123 | - !array_key_exists('username',$configElmt)) |
|
120 | + if (!array_key_exists('db', $configElmt) || |
|
121 | + !array_key_exists('host', $configElmt) || |
|
122 | + !array_key_exists('dbname', $configElmt) || |
|
123 | + !array_key_exists('username', $configElmt)) |
|
124 | 124 | { |
125 | - $this->logging->log('Missing DB params',ERROR); |
|
125 | + $this->logging->log('Missing DB params', ERROR); |
|
126 | 126 | return ''; |
127 | 127 | } |
128 | 128 | |
129 | 129 | // $dsn = 'mysql:dbname=traps;host=127.0.0.1'; |
130 | - $dsn= $configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host']; |
|
130 | + $dsn=$configElmt['db'].':dbname='.$configElmt['dbname'].';host='.$configElmt['host']; |
|
131 | 131 | |
132 | 132 | if (array_key_exists('port', $configElmt)) |
133 | 133 | { |
134 | - $dsn .= ';port='.$configElmt['port']; |
|
134 | + $dsn.=';port='.$configElmt['port']; |
|
135 | 135 | } |
136 | 136 | return $dsn; |
137 | 137 | } |