/**
* Validate if a database connection can be made
*
* @param InstallationData $data The form data
* @param ExecutionContextInterface $context The forms validation context
*
* @todo Replace SpoonDatabase
*/
public function checkDatabaseConnection(InstallationData $data, ExecutionContextInterface $context)
{
try {
// create instance
$db = new \SpoonDatabase('mysql', $data->getDbHostname(), $data->getDbUsername(), $data->getDbPassword(), $data->getDbDatabase(), $data->getDbPort());
// test table
$table = 'test' . time();
// attempt to create table
$db->execute('DROP TABLE IF EXISTS ' . $table);
$db->execute('CREATE TABLE ' . $table . ' (id int(11) NOT NULL) ENGINE=MyISAM');
// drop table
$db->drop($table);
} catch (\Exception $e) {
$context->addViolation('Problem with database credentials');
}
}
/**
* @param InstallationData $data
* @return array A list of variables that should be parsed into the configuration file(s).
*/
protected function getConfigurationVariables(InstallationData $data)
{
return array('<debug-email>' => $data->hasDifferentDebugEmail() ? $data->getDebugEmail() : $data->getEmail(), '<database-name>' => $data->getDbDatabase(), '<database-host>' => addslashes($data->getDbHostname()), '<database-user>' => addslashes($data->getDbUsername()), '<database-password>' => addslashes($data->getDbPassword()), '<database-port>' => $data->getDbPort(), '<site-protocol>' => isset($_SERVER['SERVER_PROTOCOL']) ? strpos(strtolower($_SERVER['SERVER_PROTOCOL']), 'https') === false ? 'http' : 'https' : 'http', '<site-domain>' => isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : 'fork.local', '<site-default-title>' => 'Fork CMS', '<site-multilanguage>' => $data->getLanguageType() === 'multiple' ? 'true' : 'false', '<site-default-language>' => $data->getDefaultLanguage(), '<path-www>' => PATH_WWW, '<path-library>' => PATH_LIBRARY, '<action-group-tag>' => '\\@actiongroup', '<action-rights-level>' => 7, '<secret>' => Model::generateRandomString(32, true, true, true, false));
}