function os($id) { $this->id = $id; // Get the os informations $q0 = get_link()->prepare('SELECT o.id AS ID, o.id_device AS IDDEVICE, o.os_name AS OS_NAME, o.os_type AS OS_TYPE, o.os_port AS OS_PORT, o.os_version AS OS_VERSION, o.os_architecture AS OS_ARCHITECTURE, o.os_serial_number AS OS_SERIAL_NUMBER, o.os_install_date AS OS_INSTALL_DATE, o.os_last_boot_time AS LAST_BOOT_TIME, o.os_memory_size AS MEMORY_SIZE, o.audited AS AUDITED, o.created_date AS CREATED_DATE, o.created_id AS CREATED_ID, o.edited_date AS EDITED_DATE, o.edited_id AS EDITED_ID, o.deleted_date AS DELETED_DATE, o.deleted_id AS DELETED_ID FROM ' . get_ini('BDD_PREFIX') . 'cmdb_dev_os o WHERE id=:id'); $q0->execute(array('id' => $id)); $r0 = $q0->fetch(PDO::FETCH_OBJ); if (isset($r0->ID)) { $this->idDevice = $r0->IDDEVICE; $this->name = $r0->OS_NAME; $this->type = $r0->OS_TYPE; $this->port = $r0->OS_PORT; $this->memorySize = $r0->MEMORY_SIZE; if ($this->memorySize == '') { $this->memorySize = 0; } $this->version = $r0->OS_VERSION; $this->architecture = $r0->OS_ARCHITECTURE; $this->serialNumber = $r0->OS_SERIAL_NUMBER; $this->installDate = $r0->OS_INSTALL_DATE; $this->lastBootDate = $r0->LAST_BOOT_TIME; $this->audited = $r0->AUDITED; $this->createdDate = $r0->CREATED_DATE; $this->createdID = $r0->CREATED_ID; $this->editedDate = $r0->EDITED_DATE; $this->editedId = $r0->EDITED_ID; $this->deletedDate = $r0->DELETED_DATE; $this->deltedId = $r0->DELETED_ID; // Os credentials $this->creds = array(); $q0 = get_link()->prepare('SELECT ID AS ID, user_name AS USERNAME, pass_word AS PASSWORD, SUBSTITUTE_USER_NAME AS SUBUSERNAME, SUBSTITUTE_PASS_WORD AS SUBPASSWORD FROM ' . get_ini('BDD_PREFIX') . 'cmdb_dev_os_creds WHERE id_os = :id_os AND deleted_date=0'); $q0->execute(array('id_os' => $this->id)); $r0 = $q0->fetch(PDO::FETCH_OBJ); if (isset($r0->ID)) { $this->creds['id'] = $r0->ID; $this->creds['login'] = rijn::decrypt($r0->USERNAME); $this->creds['password'] = rijn::decrypt($r0->PASSWORD); $this->creds['subLogin'] = rijn::decrypt($r0->SUBUSERNAME); $this->creds['subPassword'] = rijn::decrypt($r0->SUBPASSWORD); } elseif ($this->type == 'windows') { $this->creds['login'] = get_ini('CMDB_WINDOWS_DEFAULT_LOGIN'); $this->creds['password'] = get_ini('CMDB_WINDOWS_DEFAULT_PASSWORD'); $this->creds['subLogin'] = ''; $this->creds['subPassword'] = ''; } elseif ($this->type == 'linux') { $this->creds['login'] = get_ini('CMDB_LINUX_DEFAULT_LOGIN'); $this->creds['password'] = get_ini('CMDB_LINUX_DEFAULT_PASSWORD'); $this->creds['subLogin'] = get_ini('CMDB_LINUX_DEFAULT_SUB_LOGIN'); $this->creds['subPassword'] = get_ini('CMDB_LINUX_DEFAULT_SUB_PASSWORD'); } else { $this->creds['login'] = ''; $this->creds['password'] = ''; $this->creds['subLogin'] = ''; $this->creds['subPassword'] = ''; } } else { // TODO add log management echo 'The os does not exist.'; exit(100); } }
function dbInstance($id) { $this->id = $id; // Get the disk informations $q0 = get_link()->prepare('SELECT i.id AS ID, i.id_os AS IDOS, i.name AS NAME, i.db_type AS DBTYPE, i.db_version AS DBVERSION, i.db_port AS DBPORT, i.db_bin_path AS DBBINPATH, i.audited AS AUDITED, i.created_date AS CREATED_DATE, i.created_id AS CREATED_ID, i.edited_date AS EDITED_DATE, i.edited_id AS EDITED_ID, i.deleted_date AS DELETED_DATE, i.deleted_id AS DELETED_ID FROM ' . get_ini('BDD_PREFIX') . 'cmdb_db_instances i WHERE i.id=:id AND i.deleted_date=0'); $q0->execute(array('id' => $id)); $r0 = $q0->fetch(PDO::FETCH_OBJ); if (isset($r0->ID)) { $this->idOs = $r0->IDOS; $this->name = $r0->NAME; $this->type = $r0->DBTYPE; $this->version = $r0->DBVERSION; $this->port = $r0->DBPORT; $this->path = $r0->DBBINPATH; $this->audited = $r0->AUDITED; $this->createdDate = $r0->CREATED_DATE; $this->createdID = $r0->CREATED_ID; $this->editedDate = $r0->EDITED_DATE; $this->editedId = $r0->EDITED_ID; $this->deletedDate = $r0->DELETED_DATE; $this->deltedId = $r0->DELETED_ID; // Os credentials $this->creds = array(); $q0 = get_link()->prepare('SELECT ID AS ID, user_name AS USERNAME, pass_word AS PASSWORD, SUBSTITUTE_USER_NAME AS SUBUSERNAME, SUBSTITUTE_PASS_WORD AS SUBPASSWORD FROM ' . get_ini('BDD_PREFIX') . 'cmdb_db_instance_creds WHERE id_instance = :id_instance AND deleted_date=0'); $q0->execute(array('id_instance' => $this->id)); $r0 = $q0->fetch(PDO::FETCH_OBJ); if (isset($r0->ID)) { $this->creds['id'] = $r0->ID; $this->creds['login'] = rijn::decrypt($r0->USERNAME); $this->creds['password'] = rijn::decrypt($r0->PASSWORD); $this->creds['subLogin'] = rijn::decrypt($r0->SUBUSERNAME); $this->creds['subPassword'] = rijn::decrypt($r0->SUBPASSWORD); //} elseif($this->type == 'oracle') { // $this->creds['login']=get_ini('CMDB_WINDOWS_DEFAULT_LOGIN'); // $this->creds['password']=get_ini('CMDB_WINDOWS_DEFAULT_PASSWORD'); // $this->creds['subLogin']=''; // $this->creds['subPassword']=''; //} elseif($this->type == 'mssqlserver') { // $this->creds['login']=get_ini('CMDB_LINUX_DEFAULT_LOGIN'); // $this->creds['password']=get_ini('CMDB_LINUX_DEFAULT_PASSWORD'); // $this->creds['subLogin']=get_ini('CMDB_LINUX_DEFAULT_SUB_LOGIN'); // $this->creds['subPassword']=get_ini('CMDB_LINUX_DEFAULT_SUB_PASSWORD'); //} elseif($this->type == 'mysql') { // $this->creds['login']=get_ini('CMDB_LINUX_DEFAULT_LOGIN'); // $this->creds['password']=get_ini('CMDB_LINUX_DEFAULT_PASSWORD'); // $this->creds['subLogin']=get_ini('CMDB_LINUX_DEFAULT_SUB_LOGIN'); // $this->creds['subPassword']=get_ini('CMDB_LINUX_DEFAULT_SUB_PASSWORD'); } else { $this->creds['login'] = ''; $this->creds['password'] = ''; $this->creds['subLogin'] = ''; $this->creds['subPassword'] = ''; } } else { // TODO add log management echo 'The database instance does not exist.'; exit(100); } }