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);
}
}
