/**
* @param $documentId
* @param $config
* @throws \Exception
*/
public function preparePdfGeneration($documentId, $config)
{
$document = $this->getPrintDocument($documentId);
if (Model\Tool\TmpStore::get($document->getLockKey())) {
throw new \Exception("Process with given document alredy running.");
}
Model\Tool\TmpStore::add($document->getLockKey(), true);
$jobConfig = new \stdClass();
$jobConfig->documentId = $documentId;
$jobConfig->config = $config;
$this->saveJobConfigObjectFile($jobConfig);
$this->updateStatus($documentId, 0, "prepare_pdf_generation");
$args = ["-p " . $jobConfig->documentId];
$env = \Pimcore\Config::getEnvironment();
if ($env !== false) {
$args[] = "--environment=" . $env;
}
$cmd = Tool\Console::getPhpCli() . " " . realpath(PIMCORE_PATH . DIRECTORY_SEPARATOR . "cli" . DIRECTORY_SEPARATOR . "console.php") . " web2print:pdf-creation " . implode(" ", $args);
Logger::info($cmd);
if (!$config['disableBackgroundExecution']) {
Tool\Console::execInBackground($cmd, PIMCORE_LOG_DIRECTORY . DIRECTORY_SEPARATOR . "web2print-output.log");
} else {
Processor::getInstance()->startPdfGeneration($jobConfig->documentId);
}
}
/**
* @return bool
*/
public function isAvailable()
{
try {
$ffmpeg = self::getFfmpegCli();
$phpCli = Console::getPhpCli();
if ($ffmpeg && $phpCli) {
return true;
}
} catch (\Exception $e) {
\Logger::warning($e);
}
return false;
}
/**
* @return bool
*/
public function isAvailable()
{
try {
$ghostscript = self::getGhostscriptCli();
$phpCli = Console::getPhpCli();
if ($ghostscript && $phpCli) {
return true;
}
} catch (\Exception $e) {
\Logger::warning($e);
}
return false;
}
/**
* @param $package
* @return string
* @throws \Exception
*/
public static function installPackage($package)
{
$logFile = self::getLogFile();
$jobId = uniqid();
$pidFile = self::getPidFile($jobId);
$console = implode(DIRECTORY_SEPARATOR, [PIMCORE_PATH, 'cli', 'console.php']);
$cmd = implode(' ', [Console::getPhpCli(), $console, 'manager:require', '-p ' . $pidFile, '-r ' . $package]);
if (is_file($logFile)) {
unlink($logFile);
}
file_put_contents($pidFile, $jobId);
Console::execInBackground($cmd, $logFile);
return $jobId;
}
/**
* Returns a list of all class definitions.
*/
public function serverInfoAction()
{
$this->checkUserPermission("system_settings");
$systemSettings = \Pimcore\Config::getSystemConfig()->toArray();
$system = array("currentTime" => time(), "phpCli" => Tool\Console::getPhpCli());
$pimcoreConstants = array();
//only Pimcore_ constants -> others might break the \Zend_Encode functionality
foreach ((array) get_defined_constants() as $constant => $value) {
if (strpos($constant, 'PIMCORE_') === 0) {
$pimcoreConstants[$constant] = $value;
}
}
$pimcore = array("version" => \Pimcore\Version::getVersion(), "revision" => \Pimcore\Version::getRevision(), "instanceIdentifier" => $systemSettings["general"]["instanceIdentifier"], "modules" => array(), "constants" => $pimcoreConstants);
foreach ((array) \Pimcore\API\Plugin\Broker::getInstance()->getModules() as $module) {
$pimcore["modules"][] = get_class($module);
}
$plugins = \Pimcore\ExtensionManager::getPluginConfigs();
$this->encoder->encode(array("success" => true, "system" => $system, "pimcore" => $pimcore, "plugins" => $plugins));
}
public function indexAction()
{
$checksPHP = array();
$checksMySQL = array();
$checksFS = array();
$checksApps = array();
// check for memory limit
$memoryLimit = ini_get("memory_limit");
$memoryLimit = filesize2bytes($memoryLimit . "B");
$state = "ok";
if ($memoryLimit < 67108000) {
$state = "error";
} elseif ($memoryLimit < 134217000) {
$state = "warning";
}
$checksPHP[] = array("name" => "memory_limit (in php.ini)", "link" => "http://www.php.net/memory_limit", "state" => $state);
// mcrypt
$checksPHP[] = array("name" => "mcrypt", "link" => "http://www.php.net/mcrypt", "state" => function_exists("mcrypt_encrypt") ? "ok" : "error");
// pdo_mysql
$checksPHP[] = array("name" => "PDO_Mysql", "link" => "http://www.php.net/pdo_mysql", "state" => @constant("PDO::MYSQL_ATTR_FOUND_ROWS") ? "ok" : "error");
// pdo_mysql
$checksPHP[] = array("name" => "Mysqli", "link" => "http://www.php.net/mysqli", "state" => class_exists("mysqli") ? "ok" : "error");
// iconv
$checksPHP[] = array("name" => "iconv", "link" => "http://www.php.net/iconv", "state" => function_exists("iconv") ? "ok" : "error");
// dom
$checksPHP[] = array("name" => "dom", "link" => "http://www.php.net/dom", "state" => class_exists("DOMDocument") ? "ok" : "error");
// simplexml
$checksPHP[] = array("name" => "SimpleXML", "link" => "http://www.php.net/simplexml", "state" => class_exists("SimpleXMLElement") ? "ok" : "error");
// gd
$checksPHP[] = array("name" => "GD", "link" => "http://www.php.net/gd", "state" => function_exists("gd_info") ? "ok" : "error");
// exif
$checksPHP[] = array("name" => "EXIF", "link" => "http://www.php.net/exif", "state" => function_exists("exif_read_data") ? "ok" : "error");
// multibyte support
$checksPHP[] = array("name" => "Multibyte String (mbstring)", "link" => "http://www.php.net/mbstring", "state" => function_exists("mb_get_info") ? "ok" : "error");
// file_info support
$checksPHP[] = array("name" => "File Information (file_info)", "link" => "http://www.php.net/file_info", "state" => function_exists("finfo_open") ? "ok" : "error");
// zip
$checksPHP[] = array("name" => "zip", "link" => "http://www.php.net/zip", "state" => class_exists("ZipArchive") ? "ok" : "error");
// gzip
$checksPHP[] = array("name" => "zlib / gzip", "link" => "http://www.php.net/zlib", "state" => function_exists("gzcompress") ? "ok" : "error");
// bzip
$checksPHP[] = array("name" => "Bzip2", "link" => "http://www.php.net/bzip2", "state" => function_exists("bzcompress") ? "ok" : "error");
// openssl
$checksPHP[] = array("name" => "OpenSSL", "link" => "http://www.php.net/openssl", "state" => function_exists("openssl_open") ? "ok" : "error");
// Imagick
$checksPHP[] = array("name" => "Imagick", "link" => "http://www.php.net/imagick", "state" => class_exists("Imagick") ? "ok" : "warning");
// OPcache
$checksPHP[] = array("name" => "OPcache", "link" => "http://www.php.net/opcache", "state" => function_exists("opcache_reset") ? "ok" : "warning");
// memcache
$checksPHP[] = array("name" => "Memcache", "link" => "http://www.php.net/memcache", "state" => class_exists("Memcache") ? "ok" : "warning");
// Redis
$checksPHP[] = array("name" => "Redis", "link" => "https://pecl.php.net/package/redis", "state" => class_exists("Redis") ? "ok" : "warning");
// curl for google api sdk
$checksPHP[] = array("name" => "curl", "link" => "http://www.php.net/curl", "state" => function_exists("curl_init") ? "ok" : "warning");
$db = null;
if ($this->getParam("mysql_adapter")) {
// this is before installing
try {
$dbConfig = ['username' => $this->getParam("mysql_username"), 'password' => $this->getParam("mysql_password"), 'dbname' => $this->getParam("mysql_database")];
$hostSocketValue = $this->getParam("mysql_host_socket");
if (file_exists($hostSocketValue)) {
$dbConfig["unix_socket"] = $hostSocketValue;
} else {
$dbConfig["host"] = $hostSocketValue;
$dbConfig["port"] = $this->getParam("mysql_port");
}
$db = \Zend_Db::factory($this->getParam("mysql_adapter"), $dbConfig);
$db->getConnection();
} catch (\Exception $e) {
$db = null;
}
} else {
// this is after installing, eg. after a migration, ...
$db = \Pimcore\Db::get();
}
if ($db) {
// storage engines
$engines = array();
$enginesRaw = $db->fetchAll("SHOW ENGINES;");
foreach ($enginesRaw as $engineRaw) {
$engines[] = strtolower($engineRaw["Engine"]);
}
// innodb
$checksMySQL[] = array("name" => "InnoDB Support", "state" => in_array("innodb", $engines) ? "ok" : "error");
// myisam
$checksMySQL[] = array("name" => "MyISAM Support", "state" => in_array("myisam", $engines) ? "ok" : "error");
// memory
$checksMySQL[] = array("name" => "MEMORY Support", "state" => in_array("memory", $engines) ? "ok" : "error");
// check database charset => utf-8 encoding
$result = $db->fetchRow('SHOW VARIABLES LIKE "character\\_set\\_database"');
$checksMySQL[] = array("name" => "Database Charset UTF8", "state" => $result['Value'] == "utf8" ? "ok" : "error");
// create table
$queryCheck = true;
try {
$db->query("CREATE TABLE __pimcore_req_check (\n id int(11) NOT NULL AUTO_INCREMENT,\n field varchar(255) CHARACTER SET latin1 NULL DEFAULT NULL,\n PRIMARY KEY (id)\n ) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "CREATE TABLE", "state" => $queryCheck ? "ok" : "error");
// alter table
$queryCheck = true;
try {
$db->query("ALTER TABLE __pimcore_req_check ADD COLUMN alter_field varchar(255) NULL DEFAULT NULL");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "ALTER TABLE", "state" => $queryCheck ? "ok" : "error");
// Manage indexes
$queryCheck = true;
try {
$db->query("ALTER TABLE __pimcore_req_check\n CHANGE COLUMN id id int(11) NOT NULL,\n CHANGE COLUMN field field varchar(255) NULL DEFAULT NULL,\n CHANGE COLUMN alter_field alter_field varchar(255) NULL DEFAULT NULL,\n ADD KEY field (field),\n DROP PRIMARY KEY ,\n DEFAULT CHARSET=utf8");
$db->query("ALTER TABLE __pimcore_req_check\n CHANGE COLUMN id id int(11) NOT NULL AUTO_INCREMENT,\n CHANGE COLUMN field field varchar(255) NULL DEFAULT NULL,\n CHANGE COLUMN alter_field alter_field varchar(255) NULL DEFAULT NULL,\n ADD PRIMARY KEY (id) ,\n DEFAULT CHARSET=utf8");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "Manage Indexes", "state" => $queryCheck ? "ok" : "error");
// insert data
$queryCheck = true;
try {
$db->insert("__pimcore_req_check", array("field" => uniqid(), "alter_field" => uniqid()));
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "INSERT", "state" => $queryCheck ? "ok" : "error");
// update
$queryCheck = true;
try {
$db->update("__pimcore_req_check", array("field" => uniqid(), "alter_field" => uniqid()));
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "UPDATE", "state" => $queryCheck ? "ok" : "error");
// select
$queryCheck = true;
try {
$db->fetchAll("SELECT * FROM __pimcore_req_check");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "SELECT", "state" => $queryCheck ? "ok" : "error");
// create view
$queryCheck = true;
try {
$db->query("CREATE OR REPLACE VIEW __pimcore_req_check_view AS SELECT * FROM __pimcore_req_check");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "CREATE VIEW", "state" => $queryCheck ? "ok" : "error");
// select from view
$queryCheck = true;
try {
$db->fetchAll("SELECT * FROM __pimcore_req_check_view");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "SELECT (from view)", "state" => $queryCheck ? "ok" : "error");
// delete
$queryCheck = true;
try {
$db->delete("__pimcore_req_check");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "DELETE", "state" => $queryCheck ? "ok" : "error");
// show create view
$queryCheck = true;
try {
$db->query("SHOW CREATE VIEW __pimcore_req_check_view");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "SHOW CREATE VIEW", "state" => $queryCheck ? "ok" : "error");
// show create table
$queryCheck = true;
try {
$db->query("SHOW CREATE TABLE __pimcore_req_check");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "SHOW CREATE TABLE", "state" => $queryCheck ? "ok" : "error");
// drop view
$queryCheck = true;
try {
$db->query("DROP VIEW __pimcore_req_check_view");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "DROP VIEW", "state" => $queryCheck ? "ok" : "error");
// drop table
$queryCheck = true;
try {
$db->query("DROP TABLE __pimcore_req_check");
} catch (\Exception $e) {
$queryCheck = false;
}
$checksMySQL[] = array("name" => "DROP TABLE", "state" => $queryCheck ? "ok" : "error");
} else {
die("Not possible... no or wrong database settings given.<br />Please fill out the MySQL Settings in the install form an click again on `Check Requirements´");
}
// filesystem checks
// website/var writable
$websiteVarWritable = true;
try {
$files = $this->rscandir(PIMCORE_WEBSITE_VAR);
foreach ($files as $file) {
if (!is_writable($file)) {
$websiteVarWritable = false;
}
}
$checksFS[] = array("name" => "/website/var/ writeable", "state" => $websiteVarWritable ? "ok" : "error");
} catch (\Exception $e) {
$checksFS[] = array("name" => "/website/var/ (not checked - too many files)", "state" => "warning");
}
// pimcore writeable
$checksFS[] = array("name" => "/pimcore/ writeable", "state" => \Pimcore\Update::isWriteable() ? "ok" : "warning");
// system & application checks
// PHP CLI BIN
try {
$phpCliBin = (bool) \Pimcore\Tool\Console::getPhpCli();
} catch (\Exception $e) {
$phpCliBin = false;
}
$checksApps[] = array("name" => "PHP CLI Binary", "state" => $phpCliBin ? "ok" : "error");
// FFMPEG BIN
try {
$ffmpegBin = (bool) \Pimcore\Video\Adapter\Ffmpeg::getFfmpegCli();
} catch (\Exception $e) {
$ffmpegBin = false;
}
$checksApps[] = array("name" => "FFMPEG (CLI)", "state" => $ffmpegBin ? "ok" : "warning");
// WKHTMLTOIMAGE BIN
try {
$wkhtmltopdfBin = (bool) \Pimcore\Image\HtmlToImage::getWkhtmltoimageBinary();
} catch (\Exception $e) {
$wkhtmltopdfBin = false;
}
$checksApps[] = array("name" => "wkhtmltoimage (CLI)", "state" => $wkhtmltopdfBin ? "ok" : "warning");
// HTML2TEXT BIN
try {
$html2textBin = (bool) \Pimcore\Mail::determineHtml2TextIsInstalled();
} catch (\Exception $e) {
$html2textBin = false;
}
$checksApps[] = array("name" => "mbayer html2text (CLI)", "state" => $html2textBin ? "ok" : "warning");
// ghostscript BIN
try {
$ghostscriptBin = (bool) \Pimcore\Document\Adapter\Ghostscript::getGhostscriptCli();
} catch (\Exception $e) {
$ghostscriptBin = false;
}
$checksApps[] = array("name" => "Ghostscript (CLI)", "state" => $ghostscriptBin ? "ok" : "warning");
// LibreOffice BIN
try {
$libreofficeBin = (bool) \Pimcore\Document\Adapter\LibreOffice::getLibreOfficeCli();
} catch (\Exception $e) {
$libreofficeBin = false;
}
$checksApps[] = array("name" => "LibreOffice (CLI)", "state" => $libreofficeBin ? "ok" : "warning");
// PNG optimizer
try {
$pngOptimizer = (bool) \Pimcore\Image\Optimizer::getPngOptimizerCli();
} catch (\Exception $e) {
$pngOptimizer = false;
}
$checksApps[] = array("name" => "PNG Optimizer (pngcrush)", "state" => $pngOptimizer ? "ok" : "warning");
// JPEG optimizer
try {
$jpgOptimizer = (bool) \Pimcore\Image\Optimizer::getJpegOptimizerCli();
} catch (\Exception $e) {
$jpgOptimizer = false;
}
$checksApps[] = array("name" => "JPEG Optimizer (imgmin, jpegoptim)", "state" => $jpgOptimizer ? "ok" : "warning");
// timeout binary
try {
$timeoutBin = (bool) \Pimcore\Tool\Console::getTimeoutBinary();
} catch (\Exception $e) {
$timeoutBin = false;
}
$checksApps[] = array("name" => "timeout - (GNU coreutils)", "state" => $timeoutBin ? "ok" : "warning");
// pdftotext binary
try {
$pdftotextBin = (bool) \Pimcore\Document\Adapter\Ghostscript::getPdftotextCli();
} catch (\Exception $e) {
$pdftotextBin = false;
}
$checksApps[] = array("name" => "pdftotext - (part of poppler-utils)", "state" => $pdftotextBin ? "ok" : "warning");
$this->view->checksApps = $checksApps;
$this->view->checksPHP = $checksPHP;
$this->view->checksMySQL = $checksMySQL;
$this->view->checksFS = $checksFS;
}
public function sendAction()
{
$letter = Newsletter\Config::getByName($this->getParam("name"));
if ($letter) {
$cmd = Tool\Console::getPhpCli() . " " . realpath(PIMCORE_PATH . DIRECTORY_SEPARATOR . "cli" . DIRECTORY_SEPARATOR . "console.php") . " internal:newsletter-send " . escapeshellarg($letter->getName()) . " " . escapeshellarg(Tool::getHostUrl());
Tool\Console::execInBackground($cmd, PIMCORE_LOG_DIRECTORY . "/newsletter--" . $letter->getName() . ".log");
}
$this->_helper->json(array("success" => true));
}
/**
*
*/
public function convert()
{
$this->save();
$cmd = Console::getPhpCli() . " " . realpath(PIMCORE_PATH . DIRECTORY_SEPARATOR . "cli" . DIRECTORY_SEPARATOR . "console.php") . " internal:video-converter " . $this->getProcessId();
Console::execInBackground($cmd);
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$currentRevision = null;
if ($input->getOption("source-build")) {
$currentRevision = $input->getOption("source-build");
}
$availableUpdates = Update::getAvailableUpdates($currentRevision);
if ($input->getOption("list")) {
if (count($availableUpdates["releases"])) {
$rows = [];
foreach ($availableUpdates["releases"] as $release) {
$rows[] = [$release["version"], date("Y-m-d", $release["date"]), $release["id"]];
}
$table = new Table($output);
$table->setHeaders(array('Version', 'Date', 'Build'))->setRows($rows);
$table->render();
}
if (count($availableUpdates["revisions"])) {
$this->output->writeln("The latest available build is: <comment>" . $availableUpdates["revisions"][0]["id"] . "</comment> (" . date("Y-m-d", $availableUpdates["revisions"][0]["date"]) . ")");
}
if (!count($availableUpdates["releases"]) && !count($availableUpdates["revisions"])) {
$this->output->writeln("<info>No updates available</info>");
}
}
if ($input->getOption("update")) {
$returnMessages = [];
$build = null;
$updateInfo = trim($input->getOption("update"));
if (is_numeric($updateInfo)) {
$build = $updateInfo;
} else {
// get build nr. by version number
foreach ($availableUpdates["releases"] as $release) {
if ($release["version"] == $updateInfo) {
$build = $release["id"];
break;
}
}
}
if (!$build) {
$this->writeError("Update with build / version " . $updateInfo . " not found.");
exit;
}
$helper = $this->getHelper('question');
$question = new ConfirmationQuestion("You are going to update to build {$build}! Continue with this action? (y/n)", false);
if (!$helper->ask($input, $output, $question)) {
return;
}
$this->output->writeln("Starting the update process ...");
if ($input->getOption("dry-run")) {
$this->output->writeln("<info>---------- DRY-RUN ----------</info>");
}
$jobs = Update::getJobs($build, $currentRevision);
$steps = count($jobs["parallel"]) + count($jobs["procedural"]);
$progress = new ProgressBar($output, $steps);
$progress->start();
foreach ($jobs["parallel"] as $job) {
if ($job["type"] == "download") {
Update::downloadData($job["revision"], $job["url"]);
}
$progress->advance();
}
$maintenanceModeId = 'cache-warming-dummy-session-id';
Admin::activateMaintenanceMode($maintenanceModeId);
$stoppedByError = false;
foreach ($jobs["procedural"] as $job) {
if ($input->getOption("dry-run")) {
$job["dry-run"] = true;
}
$phpCli = Console::getPhpCli();
$cmd = $phpCli . " " . realpath(PIMCORE_PATH . DIRECTORY_SEPARATOR . "cli" . DIRECTORY_SEPARATOR . "console.php") . " internal:update-processor " . escapeshellarg(json_encode($job));
$return = Console::exec($cmd);
$return = trim($return);
$returnData = @json_decode($return, true);
if (is_array($returnData)) {
if (trim($returnData["message"])) {
$returnMessages[] = [$job["revision"], strip_tags($returnData["message"])];
}
if (!$returnData["success"]) {
$stoppedByError = true;
break;
}
} else {
$stoppedByError = true;
break;
}
$progress->advance();
}
$progress->finish();
Admin::deactivateMaintenanceMode();
$this->output->writeln("\n");
if ($stoppedByError) {
$this->output->writeln("<error>Update stopped by error! Please check your logs</error>");
$this->output->writeln("Last return value was: " . $return);
} else {
$this->output->writeln("<info>Update done!</info>");
if (count($returnMessages)) {
$table = new Table($output);
$table->setHeaders(array('Build', 'Message'))->setRows($returnMessages);
$table->render();
}
}
}
}
/**
* @param $script
* @param $arguments
* @return string
*/
protected static function buildPhpScriptCmd($script, $arguments)
{
$phpCli = Console::getPhpCli();
$cmd = $phpCli . " " . $script;
if (Config::getEnvironment()) {
$cmd .= " --environment=" . Config::getEnvironment();
}
if (!empty($arguments)) {
$cmd .= " " . $arguments;
}
return $cmd;
}
