Example #1
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'SharedFolderDB::internal::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $SharedFolder_table_structure = array('id' => 'varchar(255)', 'name' => 'varchar(255)', 'server' => 'varchar(255)', 'status' => 'varchar(255)');
     $ret = $SQL->buildTable($sql_conf['prefix'] . SharedFolderDB_internal::$table, $SharedFolder_table_structure, array('id'));
     Logger::debug('main', "SharedFolderDB::internal::init SQL table '" . $sql_conf['prefix'] . SharedFolderDB_internal::$table . "' created");
     return true;
 }
Example #2
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'ProfileDB::internal::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $Profile_table_structure = array('id' => 'varchar(255)');
     $ret = $SQL->buildTable(self::$table, $Profile_table_structure, array('id'));
     Logger::debug('main', "ProfileDB::internal::init SQL table '" . self::$table . "' created");
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_ReportServer::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $servers_history_table_structure = array('fqdn' => 'VARCHAR(255) NOT NULL', 'external_name' => 'VARCHAR(255) NOT NULL', 'timestamp' => 'TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP', 'cpu' => 'FLOAT NOT NULL', 'ram' => 'FLOAT NOT NULL', 'data' => 'LONGTEXT NOT NULL');
     $ret = $SQL->buildTable($sql_conf['prefix'] . 'servers_history', $servers_history_table_structure, array());
     if (!$ret) {
         Logger::error('main', 'Unable to create SQL table \'' . $sql_conf['prefix'] . 'servers_history\'');
         return false;
     }
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_ReportSession::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $sessions_history_table_structure = array('id' => 'VARCHAR(255) NOT NULL', 'start_stamp' => 'TIMESTAMP NOT NULL default CURRENT_TIMESTAMP', 'stop_stamp' => 'TIMESTAMP NULL default NULL', 'stop_why' => 'VARCHAR(16) default NULL', 'user' => 'VARCHAR(255) NOT NULL', 'server' => 'VARCHAR(255) NOT NULL', 'data' => 'LONGTEXT NOT NULL');
     $ret = $SQL->buildTable(self::table, $sessions_history_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create SQL table \'' . self::table . '\'');
         return false;
     }
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_UserGroup_Rule::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $usergroup_rules_table_structure = array('id' => 'int(8) NOT NULL auto_increment', 'attribute' => 'varchar(255)', 'type' => 'varchar(255)', 'value' => 'varchar(255)', 'usergroup_id' => 'varchar(255)');
     $ret = $SQL->buildTable(self::table, $usergroup_rules_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . self::table . '\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . self::table . '\' created');
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_AdminAction::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $tokens_table_structure = array('when' => 'timestamp NOT NULL default CURRENT_TIMESTAMP', 'what' => 'varchar(255) NOT NULL', 'who' => 'varchar(255) NOT NULL', 'where' => 'varchar(255) NOT NULL', 'infos' => 'text');
     $ret = $SQL->buildTable(self::table, $tokens_table_structure, array(), array(), 'ARCHIVE');
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . self::table . '\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . self::table . '\' created');
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_VDI::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $vdi_table_structure = array('id' => 'varchar(64)', 'type' => 'varchar(255)', 'name' => 'varchar(255)', 'server' => 'varchar(255)', 'master_id' => 'varchar(64)', 'used_by' => 'varchar(255)', 'cpu_model' => 'varchar(255)', 'cpu_nb_cores' => 'int(8)', 'ram_total' => 'int(8)', 'status' => 'varchar(32)', 'ip' => 'varchar(15)');
     $ret = $SQL->buildTable(self::table, $vdi_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . self::table . '\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . self::table . '\' created');
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_Network_Folder::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $network_folders_table_structure = array('id' => 'varchar(255)', 'server' => 'varchar(255)', 'status' => 'int(2)');
     $ret = $SQL->buildTable(self::$table, $network_folders_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . self::$table . '\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . self::$table . '\' created');
     return true;
 }
Example #9
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_Task::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $tasks_table_structure = array('id' => 'varchar(32)', 'type' => 'varchar(32)', 'job_id' => 'varchar(32)', 'server' => 'varchar(255)', 'status' => 'varchar(64)', 't_begin' => 'int(10)', 't_end' => 'int(10)', 'applications_line' => 'varchar(255)', 'applications' => 'text');
     $ret = $SQL->buildTable($sql_conf['prefix'] . 'tasks', $tasks_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . $sql_conf['prefix'] . 'tasks\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . $sql_conf['prefix'] . 'tasks\' created');
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_Token::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $tokens_table_structure = array('id' => 'varchar(255) NOT NULL', 'type' => 'varchar(32) NOT NULL', 'link_to' => 'varchar(255) NOT NULL', 'valid_until' => 'int(10) NOT NULL');
     $ret = $SQL->buildTable(self::table, $tokens_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . self::table . '\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . self::table . '\' created');
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_Script::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $script_table_structure = array('id' => 'int(8) NOT NULL auto_increment', 'name' => 'varchar(64)', 'type' => 'varchar(10)', 'os' => 'varchar(10)', 'data' => 'text');
     $ret = $SQL->buildTable(self::$table, $script_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . $sql_conf['prefix'] . self::$table . '\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . $sql_conf['prefix'] . self::$table . '\' created');
     return true;
 }
Example #12
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_Session::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $sessions_table_structure = array('id' => 'varchar(255)', 'server' => 'varchar(255)', 'mode' => 'varchar(32)', 'type' => 'varchar(32)', 'status' => 'varchar(32)', 'settings' => 'text', 'user_login' => 'varchar(255)', 'user_displayname' => 'varchar(255)', 'servers' => 'text', 'applications' => 'text', 'start_time' => 'varchar(255)', 'timestamp' => 'int(10)');
     $ret = $SQL->buildTable($sql_conf['prefix'] . 'sessions', $sessions_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . $sql_conf['prefix'] . 'sessions\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . $sql_conf['prefix'] . 'sessions\' created');
     return true;
 }
 public static function init($prefs_)
 {
     Logger::debug('main', 'Abstract_User_Preferences::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $user_preferences_table_structure = array('login' => 'varchar(1024)', 'key' => 'varchar(255)', 'container' => 'varchar(255)', 'element_id' => 'varchar(255)', 'value' => 'text');
     $ret = $SQL->buildTable(self::$table, $user_preferences_table_structure, array());
     if (!$ret) {
         Logger::error('main', "Unable to create MySQL table '" . self::$table . "'");
         return false;
     }
     Logger::debug('main', "MySQL table '" . self::$table . "' created");
     return true;
 }
Example #14
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_News::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $news_table_structure = array('id' => 'int(8) NOT NULL auto_increment', 'title' => 'varchar(64)', 'content' => 'text', 'timestamp' => 'int(10)');
     $ret = $SQL->buildTable($sql_conf['prefix'] . 'news', $news_table_structure, array('id'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . $sql_conf['prefix'] . 'news\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . $sql_conf['prefix'] . 'news\' created');
     return true;
 }
Example #15
0
 public static function init($prefs_)
 {
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         return false;
     }
     $table = $sql_conf['prefix'] . 'ha';
     $sql2 = SQL::newInstance($sql_conf);
     $ha_table_structure = array('id_host' => 'int(5) NOT NULL AUTO_INCREMENT', 'hostname' => 'VARCHAR(255) NOT NULL', 'address' => 'VARCHAR(255) NOT NULL', 'timestamp' => 'TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP', 'register' => 'ENUM( "yes", "no" ) NOT NULL');
     $ret = $sql2->buildTable($table, $ha_table_structure, array('id_host'));
     if ($ret === false) {
         return false;
     } else {
         return true;
     }
     return false;
 }
Example #16
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'Starting Abstract_Server::init');
     $sql_conf = $prefs_->get('general', 'sql');
     $SQL = SQL::newInstance($sql_conf);
     $servers_table_structure = array('fqdn' => 'varchar(255)', 'status' => 'varchar(255)', 'registered' => 'int(8)', 'locked' => 'int(8)', 'type' => 'varchar(255)', 'version' => 'varchar(255)', 'cpu_model' => 'varchar(255)', 'cpu_nb_cores' => 'int(8)', 'cpu_load' => 'int(8)', 'ram_total' => 'int(16)', 'ram_used' => 'int(16)', 'timestamp' => 'int(10)');
     $ret = $SQL->buildTable($sql_conf['prefix'] . 'servers', $servers_table_structure, array('fqdn'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . $sql_conf['prefix'] . 'servers\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . $sql_conf['prefix'] . 'servers\' created');
     $servers_properties_table_structure = array('fqdn' => 'varchar(255)', 'property' => 'varchar(64)', 'value' => 'varchar(255)');
     $ret = $SQL->buildTable($sql_conf['prefix'] . 'servers_properties', $servers_properties_table_structure, array('fqdn', 'property'));
     if (!$ret) {
         Logger::error('main', 'Unable to create MySQL table \'' . $sql_conf['prefix'] . 'servers_properties\'');
         return false;
     }
     Logger::debug('main', 'MySQL table \'' . $sql_conf['prefix'] . 'servers_properties\' created');
     return true;
 }
Example #17
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'USERGROUPDB::sql::init');
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'USERGROUPDB::sql::init sql conf is not valid');
         return false;
     }
     $usersgroup_table = $sql_conf['prefix'] . 'usergroup';
     $sql2 = SQL::newInstance($sql_conf);
     $usersgroup_table_structure = array('id' => 'int(8) NOT NULL auto_increment', 'name' => 'varchar(150) NOT NULL', 'description' => 'varchar(150) NOT NULL', 'published' => 'tinyint(1) NOT NULL');
     $ret = $sql2->buildTable($usersgroup_table, $usersgroup_table_structure, array('id'));
     if ($ret === false) {
         Logger::error('main', 'USERGROUPDB::sql::init table ' . $usersgroup_table . ' fail to created');
         return false;
     }
     return true;
 }
Example #18
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'WebAppConfDB::sql::init');
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'WebAppConfDB::sql::init sql conf not valid');
         return false;
     }
     $sql2 = SQL::newInstance($sql_conf);
     $WEBAPPCONF_table_structure = array('id' => 'int(8) NOT NULL auto_increment', 'application_id' => 'int(8) NOT NULL', 'url_prefix' => 'text NOT NULL', 'raw_configuration' => 'text NOT NULL', 'values' => 'text NOT NULL');
     $ret = $sql2->buildTable(self::table, $WEBAPPCONF_table_structure, array('id'));
     if ($ret === false) {
         Logger::error('main', 'WebAppConfDB::sql::init table ' . self::table . ' fail to created');
         return false;
     } else {
         Logger::debug('main', 'WebAppConfDB::sql::init table ' . self::table . ' created');
         return true;
     }
 }
 public function isValid()
 {
     Logger::debug('main', 'PREFERENCESADMIN::isValid');
     if (!function_exists('curl_init')) {
         return _('Please install CURL support for PHP');
     }
     $sql_conf = $this->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'PREFERENCESADMIN::isValid db conf failed');
         return _('SQL configuration not valid(2)');
     }
     $sql2 = SQL::newInstance($sql_conf);
     $db_ok = $sql2->CheckLink(false);
     if ($db_ok === false) {
         Logger::error('main', 'PREFERENCESADMIN::isValid db link failed');
         return _('SQL configuration not valid');
     }
     // now we can initialize the system (sql DB ...)
     $ret = init_db($this);
     if ($ret !== true) {
         Logger::error('main', 'init_db failed');
         return _('Initialization failed');
     }
     $modules_ok = true;
     $modules_enable = $this->get('general', 'module_enable');
     foreach ($modules_enable as $module_name) {
         if (!is_null($this->get($module_name, 'enable'))) {
             $enable = $this->get($module_name, 'enable');
             if (is_string($enable)) {
                 $mod_name = $module_name . '_' . $enable;
                 $ret_eval = call_user_func(array($mod_name, 'prefsIsValid'), $this);
                 if ($ret_eval !== true) {
                     Logger::error('main', 'prefs is not valid for module \'' . $mod_name . '\'');
                     $modules_ok = false;
                     return _('prefs is not valid for module') . ' (' . $mod_name . ')';
                     // TODO
                 }
             } else {
                 if (is_array($enable)) {
                     foreach ($enable as $sub_module) {
                         $mod_name = $module_name . '_' . $sub_module;
                         $ret_eval = call_user_func(array($mod_name, 'prefsIsValid'), $this);
                         if ($ret_eval !== true) {
                             Logger::error('main', 'prefs is not valid for module \'' . $mod_name . '\'');
                             $modules_ok = false;
                             return _('prefs is not valid for module') . ' (' . $mod_name . ')';
                             // TODO
                         }
                     }
                 }
             }
         } else {
             Logger::info('main', 'preferences::isvalid module \'' . $module_name . '\' not enable');
         }
     }
     if ($modules_ok === false) {
         Logger::error('main', 'PREFERENCESADMIN::isValid modules false');
         return _('Modules configuration not valid');
     }
     return true;
 }
 public static function init($prefs_)
 {
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'Abstract_Liaison::init sql conf not valid');
         return false;
     }
     $LIAISON_TABLE = $sql_conf['prefix'] . 'liaison';
     // we create the sql table
     $sql2 = SQL::newInstance($sql_conf);
     $LIAISON_table_structure = array('type' => 'varchar(200) NOT NULL', 'element' => 'varchar(200) NOT NULL', 'group' => 'varchar(200) NOT NULL');
     $ret = $sql2->buildTable($LIAISON_TABLE, $LIAISON_table_structure, array());
     if ($ret === false) {
         Logger::error('main', 'Abstract_Liaison::init table ' . $LIAISON_TABLE . ' fail to created');
         return false;
     } else {
         Logger::debug('main', 'Abstract_Liaison::init table ' . $LIAISON_TABLE . ' created');
         return true;
     }
 }
Example #21
0
 public static function prefsIsValid2($prefs_, &$log = array())
 {
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'UserGroupDBDynamic::internal::prefsIsValid2 failed to get sql configuration');
         return false;
     }
     $sql2 = SQL::newInstance($sql_conf);
     $ret = $sql2->DoQuery('SHOW TABLES FROM @1 LIKE %2', $sql_conf['database'], $sql2->prefix . self::table);
     if ($ret !== false) {
         $ret2 = $sql2->NumRows($ret);
         if ($ret2 == 1) {
             return true;
         } else {
             Logger::error('main', 'UserGroupDBDynamic::internal::prefsIsValid table \'' . self::table . '\' does not exist');
             return false;
         }
     } else {
         Logger::error('main', 'UserGroupDBDynamic::internal::prefsIsValid table \'' . self::table . '\' does not exist(2)');
         return false;
     }
 }
 public static function init($prefs_)
 {
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'Abstract_Liaison::init sql conf not valid');
         return false;
     }
     // we create the sql table
     $sql2 = SQL::newInstance($sql_conf);
     $LIAISON_table_structure = array('type' => 'varchar(200) NOT NULL', 'element' => 'varchar(200) NOT NULL', 'group' => 'varchar(200) NOT NULL');
     $ret = $sql2->buildTable(self::table, $LIAISON_table_structure, array(), array('I_TYPE' => array('type'), 'I_ELEMENT' => array('element'), 'I_GROUP' => array('group')));
     if ($ret === false) {
         Logger::error('main', 'Abstract_Liaison::init table ' . self::table . ' fail to created');
         return false;
     } else {
         Logger::debug('main', 'Abstract_Liaison::init table ' . self::table . ' created');
         return true;
     }
 }
Example #23
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'APPLICATIONDB::sql::init');
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'APPLICATIONDB::sql::init sql conf not valid');
         return false;
     }
     $sql2 = SQL::newInstance($sql_conf);
     $APPLICATION_table_structure = array('id' => 'int(8) NOT NULL auto_increment', 'name' => 'text NOT NULL', 'description' => 'text NOT NULL', 'type' => 'text  NOT NULL', 'executable_path' => 'text NOT NULL', 'directory' => 'varchar(512)', 'package' => 'text NOT NULL', 'desktopfile' => 'text default NULL', 'published' => 'tinyint(1) default \'0\'', 'static' => 'tinyint(1) default \'0\'', 'revision' => 'int(8) default \'0\'');
     $ret = $sql2->buildTable(self::table, $APPLICATION_table_structure, array('id'));
     if ($ret === false) {
         Logger::error('main', 'APPLICATIONDB::sql::init table ' . self::table . ' fail to created');
         return false;
     } else {
         Logger::debug('main', 'APPLICATIONDB::sql::init table ' . self::table . ' created');
         return true;
     }
 }
Example #24
0
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 **/
//if (stristr($_SERVER['HTTP_ACCEPT'], 'application/xhtml+xml'))
//	header('Content-Type: application/xhtml+xml; charset=utf-8');
//else
header('Content-Type: text/html; charset=utf-8');
require_once dirname(__FILE__) . '/core-minimal.inc.php';
$folders = array('reporting', 'tmp', 'cache');
foreach ($folders as $folder) {
    $buf = strtoupper($folder) . '_DIR';
    define($buf, SESSIONMANAGER_SPOOL . '/' . $folder);
    if (!check_folder(constant($buf))) {
        Logger::critical('main', constant($buf) . ' does not exist and cannot be created!');
        die_error(constant($buf) . ' does not exist and cannot be created!', __FILE__, __LINE__);
    }
}
$prefs = Preferences::getInstance();
if (is_object($prefs)) {
    define('HAS_PREFERENCES', true);
    $sql_conf = $prefs->get('general', 'sql');
    if (is_array($sql_conf)) {
        define('SERVERS_HISTORY_TABLE', $sql_conf['prefix'] . 'servers_history');
        define('SESSIONS_HISTORY_TABLE', $sql_conf['prefix'] . 'sessions_history');
        SQL::newInstance($sql_conf);
    }
}
Example #25
0
 public static function prefsIsValid($prefs_, &$log = array())
 {
     $ret = parent::prefsIsValid($prefs_, $log);
     if ($ret === false) {
         return false;
     }
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         return false;
     }
     $table = $sql_conf['prefix'] . 'usergroup_dynamic_cached';
     $sql2 = SQL::newInstance($sql_conf);
     $ret = $sql2->DoQuery('SHOW TABLES FROM @1 LIKE %2', $sql_conf['database'], $table);
     if ($ret !== false) {
         $ret2 = $sql2->NumRows();
         if ($ret2 == 1) {
             return true;
         } else {
             Logger::error('main', 'UserGroupDBDynamic_cached::prefsIsValid table \'' . $table . '\' does not exist');
             return false;
         }
     } else {
         Logger::error('main', 'UserGroupDBDynamic_cached::prefsIsValid table \'' . $table . '\' does not exist(2)');
         return false;
     }
 }
Example #26
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'USERDB::sql::init');
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'USERDB::sql::init sql conf not valid');
         return false;
     }
     $table = $sql_conf['prefix'] . 'user';
     $sql2 = SQL::newInstance($sql_conf);
     $user_table_structure = array('login' => 'varchar(100) NOT NULL', 'displayname' => 'varchar(100) NOT NULL', 'password' => 'varchar(50) NOT NULL');
     $ret = $sql2->buildTable($table, $user_table_structure, array('login'));
     if ($ret === false) {
         Logger::error('main', 'USERDB::sql::init table ' . $table . ' fail to created');
         return false;
     } else {
         Logger::debug('main', 'USERDB::sql::init table ' . $table . ' created');
         return true;
     }
 }
Example #27
0
 public static function init($prefs_)
 {
     Logger::debug('main', 'ApplicationsGroupDB::sql::init');
     $sql_conf = $prefs_->get('general', 'sql');
     if (!is_array($sql_conf)) {
         Logger::error('main', 'ApplicationsGroupDB::sql::init sql conf is not valid');
         return false;
     }
     $sql2 = SQL::newInstance($sql_conf);
     $appsgroup_structure = array('id' => 'int(8) NOT NULL auto_increment', 'name' => 'varchar(150) NOT NULL', 'description' => 'varchar(150) NOT NULL', 'published' => 'tinyint(1) NOT NULL');
     $ret = $sql2->buildTable(self::table, $appsgroup_structure, array('id'));
     if ($ret === false) {
         Logger::error('main', 'ApplicationsGroupDB::sql::init table ' . self::table . ' fail to created');
         return false;
     } else {
         Logger::debug('main', 'ApplicationsGroupDB::sql::init table ' . self::table . ' created');
     }
     return true;
 }