1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
<?php
class ConfigModule
{
public static function insertAdConfig($title, $server, $searchbase, $binddn, $bindpw, $home)
{
Database::exec("LOCK TABLE configtgz_module WRITE");
Database::exec("INSERT INTO configtgz_module (title, moduletype, filepath, contents) "
. " VALUES (:title, 'AD_AUTH', '', '')", array('title' => $title));
$id = Database::lastInsertId();
if (!is_numeric($id)) Util::traceError('Inserting new AD config to DB did not yield a numeric insert id');
// Entry created, now try to get a free port for the proxy
$res = Database::simpleQuery("SELECT moduleid, contents FROM configtgz_module WHERE moduletype = 'AD_AUTH'");
$ports = array();
while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
if ($row['moduleid'] == $id) {
// ...
} else {
$data = json_decode($row['contents'], true);
if (isset($data['proxyport'])) $ports[] = $data['proxyport'];
}
}
$port = 3300;
while (in_array($port, $ports)) {
$port++;
}
// Port determined, carry on...
$ownEntry = array(
'server' => $server,
'searchbase' => $searchbase,
'binddn' => $binddn,
'bindpw' => $bindpw,
'home' => $home,
'proxyport' => $port
);
$data = json_encode($ownEntry);
if ($data === false) Util::traceError('Serializing the AD data failed.');
$moduleTgz = CONFIG_TGZ_LIST_DIR . '/modules/AD_AUTH_id_' . $id . '.' . mt_rand() . '.tgz';
Database::exec("UPDATE configtgz_module SET filepath = :filename, contents = :contents WHERE moduleid = :id LIMIT 1", array(
'id' => $id,
'filename' => $moduleTgz,
'contents' => $data
));
Database::exec("UNLOCK TABLES");
// Add archive file name to array before returning it
$ownEntry['moduleid'] = $id;
$ownEntry['filename'] = $moduleTgz;
return $ownEntry;
}
/**
* Get all existing AD proxy configs.
*
* @return array array of ad configs in DB with fields:
* moduleid, filename, server, searchbase, binddn, bindpw, home, proxyport
*/
public static function getAdConfigs()
{
$res = Database::simpleQuery("SELECT moduleid, filepath, contents FROM configtgz_module WHERE moduletype = 'AD_AUTH'");
$mods = array();
while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
$data = json_decode($row['contents'], true);
$data['moduleid'] = $row['moduleid'];
$data['filename'] = $row['filepath'];
$mods[] = $data;
}
return $mods;
}
public static function insertBrandingModule($title, $archive)
{
Database::exec("INSERT INTO configtgz_module (title, moduletype, filepath, contents) "
. " VALUES (:title, 'BRANDING', '', '')", array('title' => $title));
$id = Database::lastInsertId();
if (!is_numeric($id)) Util::traceError('Inserting new Branding Module into DB did not yield a numeric insert id');
// Move tgz
$moduleTgz = CONFIG_TGZ_LIST_DIR . '/modules/BRANDING_id_' . $id . '.' . mt_rand() . '.tgz';
$task = Taskmanager::submit('MoveFile', array(
'source' => $archive,
'destination' => $moduleTgz
));
$task = Taskmanager::waitComplete($task, 3000);
if (Taskmanager::isFailed($task) || $task['statusCode'] !== TASK_FINISHED) {
Taskmanager::addErrorMessage($task);
Database::exec("DELETE FROM configtgz_module WHERE moduleid = :moduleid LIMIT 1", array(
'moduleid' => $id
));
return false;
}
// Update with path
Database::exec("UPDATE configtgz_module SET filepath = :filename WHERE moduleid = :id LIMIT 1", array(
'id' => $id,
'filename' => $moduleTgz
));
return true;
}
}
|
