/** * This function creates the /etc/airtime configuration folder * and copies the default config files to it. */ public static function CreateIniFiles() { if (!file_exists("/etc/airtime/")) { if (!mkdir("/etc/airtime/", 0755, true)) { echo "Could not create /etc/airtime/ directory. Exiting."; exit(1); } } if (!copy(AirtimeInstall::GetAirtimeSrcDir() . "/build/airtime.conf", AirtimeIni::CONF_FILE_AIRTIME)) { echo "Could not copy airtime.conf to /etc/airtime/. Exiting."; exit(1); } if (!copy(__DIR__ . "/../../python_apps/api_clients/api_client.cfg", AirtimeIni::CONF_FILE_API_CLIENT)) { echo "Could not copy api_client.cfg to /etc/airtime/. Exiting."; exit(1); } if (!copy(__DIR__ . "/../../python_apps/pypo/pypo.cfg", AirtimeIni::CONF_FILE_PYPO)) { echo "Could not copy pypo.cfg to /etc/airtime/. Exiting."; exit(1); } if (!copy(__DIR__ . "/../../python_apps/show-recorder/recorder.cfg", AirtimeIni::CONF_FILE_RECORDER)) { echo "Could not copy recorder.cfg to /etc/airtime/. Exiting."; exit(1); } if (!copy(__DIR__ . "/../../python_apps/pypo/liquidsoap_scripts/liquidsoap.cfg", AirtimeIni::CONF_FILE_LIQUIDSOAP)) { echo "Could not copy liquidsoap.cfg to /etc/airtime/. Exiting."; exit(1); } if (!copy(__DIR__ . "/../../python_apps/media-monitor/media-monitor.cfg", AirtimeIni::CONF_FILE_MEDIAMONITOR)) { echo "Could not copy media-monitor.cfg to /etc/airtime/. Exiting."; exit(1); } }
/** * This function creates the /etc/airtime configuration folder * and copies the default config files to it. */ public static function CreateIniFiles() { if (!file_exists("/etc/airtime/")) { if (!mkdir("/etc/airtime/", 0755, true)) { echo "Could not create /etc/airtime/ directory. Exiting."; exit(1); } } if (!copy(AirtimeInstall::GetAirtimeSrcDir() . "/build/airtime.conf", AirtimeIni::CONF_FILE_AIRTIME)) { echo "Could not copy airtime.conf to /etc/airtime/. Exiting."; exit(1); } else { if (!self::ChangeFileOwnerGroupMod(AirtimeIni::CONF_FILE_AIRTIME, self::CONF_WWW_DATA_GRP)) { echo "Could not set ownership of api_client.cfg to 'pypo'. Exiting."; exit(1); } } if (getenv("python_service") == "0") { if (!copy(__DIR__ . "/../../python_apps/api_clients/api_client.cfg", AirtimeIni::CONF_FILE_API_CLIENT)) { echo "Could not copy api_client.cfg to /etc/airtime/. Exiting."; exit(1); } else { if (!self::ChangeFileOwnerGroupMod(AirtimeIni::CONF_FILE_API_CLIENT, self::CONF_PYPO_GRP)) { echo "Could not set ownership of api_client.cfg to 'pypo'. Exiting."; exit(1); } } if (!copy(__DIR__ . "/../../python_apps/pypo/pypo.cfg", AirtimeIni::CONF_FILE_PYPO)) { echo "Could not copy pypo.cfg to /etc/airtime/. Exiting."; exit(1); } else { if (!self::ChangeFileOwnerGroupMod(AirtimeIni::CONF_FILE_PYPO, self::CONF_PYPO_GRP)) { echo "Could not set ownership of pypo.cfg to 'pypo'. Exiting."; exit(1); } } /* if (!copy(__DIR__."/../../python_apps/pypo/liquidsoap_scripts/liquidsoap.cfg", AirtimeIni::CONF_FILE_LIQUIDSOAP)){ echo "Could not copy liquidsoap.cfg to /etc/airtime/. Exiting."; exit(1); } else if (!self::ChangeFileOwnerGroupMod(AirtimeIni::CONF_FILE_LIQUIDSOAP, self::CONF_PYPO_GRP)){ echo "Could not set ownership of liquidsoap.cfg to 'pypo'. Exiting."; exit(1); } * */ if (!copy(__DIR__ . "/../../python_apps/media-monitor/media-monitor.cfg", AirtimeIni::CONF_FILE_MEDIAMONITOR)) { echo "Could not copy media-monitor.cfg to /etc/airtime/. Exiting."; exit(1); } else { if (!self::ChangeFileOwnerGroupMod(AirtimeIni::CONF_FILE_MEDIAMONITOR, self::CONF_PYPO_GRP)) { echo "Could not set ownership of media-monitor.cfg to 'pypo'. Exiting."; exit(1); } } } }
require_once 'propel/runtime/lib/Propel.php'; Propel::init(AirtimeInstall::GetAirtimeSrcDir() . "/application/configs/db-conf.php"); Propel::init(AirtimeInstall::GetAirtimeSrcDir() . "/application/configs/airtime-conf-production.php"); function pause() { /* Type "sudo -s" to change to root user then type "export AIRTIME_INSTALL_DEBUG=1" and then * start airtime-install to enable this feature. Is used to pause between upgrade scripts * to examine the state of the system and see if everything is as expected. */ if (getenv("AIRTIME_INSTALL_DEBUG") === "1") { echo "Press Enter to Continue" . PHP_EOL; fgets(STDIN); } } AirtimeInstall::DbConnect(true); $con = Propel::getConnection(); $version = AirtimeInstall::GetVersionInstalled(); echo "******************************** Upgrade Begin *********************************" . PHP_EOL; global $CC_CONFIG; $user = $CC_CONFIG['dsn']['username']; $password = $CC_CONFIG['dsn']['password']; $host = $CC_CONFIG['dsn']['hostspec']; $database = $CC_CONFIG['dsn']['database']; $airtime_version = AIRTIME_VERSION; $target_dir = trim(getenv("HOME")); if (strlen($target_dir) == 0) { $target_dir = "/tmp"; } $target_file = "/airtime_{$airtime_version}.sql"; $target_path = $target_dir . $target_file; echo "* Backing up current database to {$target_path}" . PHP_EOL; exec("export PGPASSWORD={$password} && pg_dump -h {$host} -U {$user} -f {$target_path} {$database}", $arr, $return_code);
AirtimeInstall::InstallQuery($sql, false); AirtimeInstall::DropSequence($tablename . "_id"); echo "done." . PHP_EOL; } echo " * Deleting database sequences..." . PHP_EOL; $sql = "SELECT c.relname FROM pg_class c WHERE c.relkind = 'S';"; try { $rows = $con->query($sql)->fetchAll(); } catch (Exception $e) { $rows = array(); } foreach ($rows as $row) { $sequence = $row["relname"]; echo " * Removing database sequence {$sequence}..."; $sql = "DROP SEQUENCE {$sequence} CASCADE"; AirtimeInstall::InstallQuery($sql, false); echo "done." . PHP_EOL; } } } //------------------------------------------------------------------------ // Delete the user //------------------------------------------------------------------------ echo " * Deleting database user '{$CC_CONFIG['dsn']['username']}'..." . PHP_EOL; $command = "echo \"DROP USER IF EXISTS {$CC_CONFIG['dsn']['username']}\" | su postgres -c psql >/dev/null 2>&1"; @exec($command, $output, $results); if ($results == 0) { echo " * User '{$CC_CONFIG['dsn']['username']}' deleted." . PHP_EOL; } else { echo " * Nothing to delete." . PHP_EOL; }
public static function getOpts() { try { $autoloader = Zend_Loader_Autoloader::getInstance(); $opts = new Zend_Console_Getopt(array('help|h' => 'Displays usage information.', 'overwrite|o' => 'Overwrite any existing config files.', 'preserve|p' => 'Keep any existing config files.', 'no-db|n' => 'Turn off database install.', 'reinstall|r' => 'Force a fresh install of this Airtime Version', 'webonly|w' => 'Install only web files')); $opts->parse(); } catch (Zend_Console_Getopt_Exception $e) { print $e->getMessage() . PHP_EOL; AirtimeInstall::printUsage($opts); return NULL; } return $opts; }
<?php set_include_path(__DIR__ . '/..' . PATH_SEPARATOR . get_include_path()); set_include_path(__DIR__ . '/../../../library' . PATH_SEPARATOR . get_include_path()); require_once __DIR__ . '/../Show.php'; require_once __DIR__ . '/../StoredFile.php'; require_once __DIR__ . '/../Playlist.php'; require_once __DIR__ . '/../Schedule.php'; require_once __DIR__ . '/../Preference.php'; require_once __DIR__ . '/../RabbitMq.php'; require_once __DIR__ . '/../../configs/conf.php'; require_once __DIR__ . '/../../../install_minimal/include/AirtimeIni.php'; require_once __DIR__ . '/../../../install_minimal/include/AirtimeInstall.php'; require_once __DIR__ . '/../../../library/propel/runtime/lib/Propel.php'; Propel::init(__DIR__ . '/../../configs/airtime-conf.php'); AirtimeInstall::DbConnect(true); $con = Propel::getConnection(); $sql = "DELETE FROM cc_show"; $con->exec($sql); $sql = "DELETE FROM cc_show_days"; $con->exec($sql); $sql = "DELETE FROM cc_show_instances"; $con->exec($sql); /* // Create a playlist $playlist = new Application_Model_Playlist(); $playlist->create("Calendar Load test playlist ".uniqid()); // Add a file $values = array("filepath" => __DIR__."/test10001.mp3"); $storedFile = Application_Model_StoredFile::Insert($values, false);
<?php require_once dirname(__FILE__) . '/include/AirtimeIni.php'; require_once dirname(__FILE__) . '/include/AirtimeInstall.php'; AirtimeInstall::DirCheck();
} if ($overwrite) { echo "* Creating INI files" . PHP_EOL; AirtimeIni::CreateIniFiles(); } AirtimeIni::CreateMonitFile(); AirtimeInstall::InstallPhpCode(); AirtimeInstall::InstallBinaries(); if ($overwrite) { echo "* Initializing INI files" . PHP_EOL; AirtimeIni::UpdateIniFiles(); } // Update the build.properties file to point to the correct directory. AirtimeIni::UpdateIniValue(AirtimeInstall::CONF_DIR_WWW . '/build/build.properties', 'project.home', AirtimeInstall::CONF_DIR_WWW); require_once AirtimeInstall::GetAirtimeSrcDir() . '/application/configs/conf.php'; echo "* Airtime Version: " . AIRTIME_VERSION . PHP_EOL; AirtimeInstall::InstallStorageDirectory(); if ($db_install) { if ($newInstall) { // This is called with "system" so that we can pass in a parameter. See the file itself // for why we need to do this. system('php ' . __DIR__ . '/airtime-db-install.php y'); AirtimeInstall::DbConnect(true); } else { require_once 'airtime-db-install.php'; } } AirtimeInstall::CreateSymlinksToUtils(); AirtimeInstall::CreateZendPhpLogFile(); AirtimeInstall::CreateCronFile(); /* FINISHED AIRTIME PHP INSTALLER */
} } if ($overwrite) { echo "* Creating INI files" . PHP_EOL; AirtimeIni::CreateIniFiles(); echo "* Initializing INI files" . PHP_EOL; AirtimeIni::UpdateIniFiles(); } if (!$iniExists) { require_once AirtimeInstall::GetAirtimeSrcDir() . '/application/configs/conf.php'; $CC_CONFIG = Config::getConfig(); require_once 'propel/runtime/lib/Propel.php'; Propel::init(AirtimeInstall::GetAirtimeSrcDir() . "/application/configs/airtime-conf-production.php"); } echo "* Airtime Version: " . AIRTIME_VERSION . PHP_EOL; AirtimeInstall::InstallStorageDirectory(); $db_install = getenv("nodb") != "t"; if ($db_install) { echo "* Checking database for correct encoding" . PHP_EOL; exec('su -c \'psql -t -c "SHOW SERVER_ENCODING"\' postgres | grep -i "UTF.*8"', $out, $return_code); if ($return_code != 0) { echo " * Unfortunately your postgresql database has not been created using a UTF-8 encoding." . PHP_EOL; echo " * As of Airtime 2.1, installs will fail unless the encoding has been set to UTF-8. Please verify this is the case" . PHP_EOL; echo " * and try the install again" . PHP_EOL; exit(1); } if ($newInstall) { //call external script. "y" argument means force creation of database tables. passthru('php ' . __DIR__ . '/airtime-db-install.php y'); } else { require_once 'airtime-db-install.php';
$userAnswer = trim(fgets(STDIN)); } if (in_array($userAnswer, array("y", "Y"))) { AirtimeInstall::CreateDatabaseTables($dbuser, $dbpasswd, $dbname, $dbhost); } } else { //Database was just created, meaning the tables do not //exist. Let's create them. AirtimeInstall::CreateDatabaseTables($dbuser, $dbpasswd, $dbname, $dbhost); } } echo " * Setting Airtime version" . PHP_EOL; AirtimeInstall::SetAirtimeVersion(AIRTIME_VERSION); if (AirtimeInstall::$databaseTablesCreated) { AirtimeInstall::SetDefaultTimezone(); // set up some keys in DB AirtimeInstall::SetUniqueId(); AirtimeInstall::SetImportTimestamp(); $ini = parse_ini_file(__DIR__ . "/airtime-install.ini"); $stor_dir = realpath($ini["storage_dir"]) . "/"; echo " * Inserting stor directory location {$stor_dir} into music_dirs table" . PHP_EOL; $con = Propel::getConnection(); $sql = "INSERT INTO cc_music_dirs (directory, type) VALUES ('{$stor_dir}', 'stor')"; try { $con->exec($sql); } catch (Exception $e) { echo " * Failed inserting {$stor_dir} in cc_music_dirs" . PHP_EOL; echo " * Message {$e->getMessage()}" . PHP_EOL; exit(1); } }
if (!file_exists("/etc/airtime/")) { if (!mkdir("/etc/airtime/", 0755, true)) { echo "Could not create /etc/airtime/ directory. Exiting."; exit(1); } } if (!copy("airtime.conf.170", CONF_FILE_AIRTIME)) { echo "Could not copy airtime.conf to /etc/airtime/. Exiting."; exit(1); } if (!copy($AIRTIME_PYTHON_APPS . "/pypo/pypo.cfg", CONF_FILE_PYPO)) { echo "Could not copy pypo.cfg to /etc/airtime/. Exiting."; exit(1); } if (!copy($AIRTIME_PYTHON_APPS . "/show-recorder/recorder.cfg", CONF_FILE_RECORDER)) { echo "Could not copy recorder.cfg to /etc/airtime/. Exiting."; exit(1); } if (!copy($AIRTIME_PYTHON_APPS . "/pypo/liquidsoap_scripts/liquidsoap.cfg", CONF_FILE_LIQUIDSOAP)) { echo "Could not copy liquidsoap.cfg to /etc/airtime/. Exiting."; exit(1); } } CreateIniFiles(); AirtimeIni::UpdateIniFiles(); echo PHP_EOL . "*** Updating Database Tables ***" . PHP_EOL; AirtimeInstall::MigrateTablesToVersion(__DIR__, '20110402164819'); echo PHP_EOL . "*** Updating Pypo ***" . PHP_EOL; system("python " . __DIR__ . "/../../../python_apps/pypo/install/pypo-install.py"); echo PHP_EOL . "*** Recorder Installation ***" . PHP_EOL; system("python " . __DIR__ . "/../../../python_apps/show-recorder/install/recorder-install.py");
function load_airtime_config() { $ini_array = parse_ini_file('/etc/airtime/airtime.conf', true); return $ini_array; } $values = load_airtime_config(); $CC_CONFIG = array('webServerUser' => $values['general']['web_server_user'], 'rabbitmq' => $values['rabbitmq'], 'baseFilesDir' => $values['general']['base_files_dir'], 'storageDir' => $values['general']['base_files_dir'] . "/stor", 'dsn' => array('username' => $values['database']['dbuser'], 'password' => $values['database']['dbpass'], 'hostspec' => $values['database']['host'], 'phptype' => 'pgsql', 'database' => $values['database']['dbname']), 'tblNamePrefix' => 'cc_', 'apiKey' => array($values['general']['api_key']), 'apiPath' => '/api/', 'soundcloud-client-id' => '2CLCxcSXYzx7QhhPVHN4A', 'soundcloud-client-secret' => 'pZ7beWmF06epXLHVUP1ufOg2oEnIt9XhE8l8xt0bBs', 'soundcloud-connection-retries' => $values['soundcloud']['connection_retries'], 'soundcloud-connection-wait' => $values['soundcloud']['time_between_retries'], "rootDir" => __DIR__ . "/../..", 'pearPath' => dirname(__FILE__) . '/../../library/pear', 'zendPath' => dirname(__FILE__) . '/../../library/Zend', 'phingPath' => dirname(__FILE__) . '/../../library/phing'); AirtimeInstall::DbConnect(true); echo PHP_EOL . "*** Updating Database Tables ***" . PHP_EOL; if (AirtimeInstall::DbTableExists('doctrine_migration_versions') === false) { $migrations = array('20110312121200', '20110331111708', '20110402164819'); foreach ($migrations as $migration) { AirtimeInstall::BypassMigrations(__DIR__, $migration); } } AirtimeInstall::MigrateTablesToVersion(__DIR__, '20110406182005'); //setting data for new aggregate show length column. $sql = "SELECT id FROM cc_show_instances"; $show_instances = $CC_DBC->GetAll($sql); foreach ($show_instances as $show_instance) { $sql = "UPDATE cc_show_instances SET time_filled = (SELECT SUM(clip_length) FROM cc_schedule WHERE instance_id = {$show_instance["id"]}) WHERE id = {$show_instance["id"]}"; $CC_DBC->query($sql); } //end setting data for new aggregate show length column. exec("rm -fr /opt/pypo"); exec("rm -fr /opt/recorder"); const CONF_FILE_AIRTIME = "/etc/airtime/airtime.conf"; const CONF_FILE_PYPO = "/etc/airtime/pypo.cfg"; const CONF_FILE_RECORDER = "/etc/airtime/recorder.cfg"; const CONF_FILE_LIQUIDSOAP = "/etc/airtime/liquidsoap.cfg"; $configFiles = array(CONF_FILE_AIRTIME, CONF_FILE_PYPO, CONF_FILE_RECORDER, CONF_FILE_LIQUIDSOAP);
public static function InstallBinaries() { echo "* Installing binaries to " . AirtimeInstall::CONF_DIR_BINARIES . PHP_EOL; exec("mkdir -p " . AirtimeInstall::CONF_DIR_BINARIES); exec("cp -R " . AirtimeInstall::GetUtilsSrcDir() . " " . AirtimeInstall::CONF_DIR_BINARIES); }
$connected = AirtimeInstall::DbConnect(false); if ($connected) { $con = Propel::getConnection(); $sql = "select * from pg_tables where tableowner = 'airtime'"; try { $rows = $con->query($sql)->fetchAll(); } catch (Exception $e) { $rows = array(); } foreach ($rows as $row) { $tablename = $row["tablename"]; echo " * Removing database table {$tablename}..."; if (AirtimeInstall::DbTableExists($tablename)) { $sql = "DROP TABLE {$tablename} CASCADE"; AirtimeInstall::InstallQuery($sql, false); AirtimeInstall::DropSequence($tablename . "_id"); } echo "done." . PHP_EOL; } } } //------------------------------------------------------------------------ // Delete the user //------------------------------------------------------------------------ echo " * Deleting database user '{$CC_CONFIG['dsn']['username']}'..." . PHP_EOL; $command = "echo \"DROP USER IF EXISTS {$CC_CONFIG['dsn']['username']}\" | su postgres -c psql >/dev/null 2>&1"; @exec($command, $output, $results); if ($results == 0) { echo " * User '{$CC_CONFIG['dsn']['username']}' deleted." . PHP_EOL; } else { echo " * Nothing to delete." . PHP_EOL;
$rows = array(); } foreach ($rows as $row) { $tablename = $row["tablename"]; echo " * Removing database table {$tablename}..."; if (AirtimeInstall::DbTableExists($tablename)) { $sql = "DROP TABLE {$tablename} CASCADE"; AirtimeInstall::InstallQuery($sql, false); $CC_DBC->dropSequence($tablename . "_id"); } echo "done." . PHP_EOL; } } } //------------------------------------------------------------------------ // Delete the user //------------------------------------------------------------------------ echo " * Deleting database user '{$CC_CONFIG['dsn']['username']}'..." . PHP_EOL; $command = "echo \"DROP USER IF EXISTS {$CC_CONFIG['dsn']['username']}\" | su postgres -c psql >/dev/null 2>&1"; @exec($command, $output, $results); if ($results == 0) { echo " * User '{$CC_CONFIG['dsn']['username']}' deleted." . PHP_EOL; } else { echo " * Nothing to delete." . PHP_EOL; } AirtimeInstall::RemoveSymlinks(); AirtimeInstall::UninstallBinaries(); AirtimeInstall::RemoveLogDirectories(); AirtimeIni::RemoveMonitFile(); @unlink('/etc/cron.d/airtime-crons'); /* FINISHED AIRTIME PHP UNINSTALLER */