Beispiel #1
0
/**
 * Check MySQL version: returns false only if version is gathered and it isn't suit
 *
 * @param string   $errorMsg    Error message if checking failed
 * @param string   $value       Actual value of the checked parameter
 * @param resource $isConnected MySQL connection link OPTIONAL
 *
 * @return boolean
 */
function checkMysqlVersion(&$errorMsg, &$value, $isConnected = false)
{
    global $isDBConnected;
    $result = true;
    $value = xtr('unknown');
    $pdoErrorMsg = '';
    $version = false;
    if (defined('DB_URL')) {
        // Connect via PDO and get DB version
        $data = unserialize(constant('DB_URL'));
        // Support of Drupal 6 $db_url
        if (!is_array($data)) {
            $data = parseDbURL(constant('DB_URL'));
        }
        $isConnected = dbConnect($data, $pdoErrorMsg);
        if (!$isConnected) {
            $errorMsg = xtr('Can\'t connect to MySQL server') . (!empty($pdoErrorMsg) ? ': ' . $pdoErrorMsg : '');
        }
    }
    if ($isConnected || $isDBConnected) {
        try {
            $version = \Includes\Utils\Database::getDbVersion();
        } catch (Exception $e) {
            $pdoErrorMsg = $e->getMessage();
        }
        // Check version
        if ($version) {
            x_install_log(xtr('MySQL version: ' . $version));
            if (version_compare($version, constant('LC_MYSQL_VERSION_MIN')) < 0) {
                $result = false;
                $errorMsg = xtr('MySQL version must be :minver as a minimum.', array(':minver' => constant('LC_MYSQL_VERSION_MIN')));
            } else {
                // Check for InnoDb support
                if (!\Includes\Utils\Database::isInnoDBSupported()) {
                    $result = false;
                    $errorMsg = xtr('MySQL server doesn\'t support InnoDB engine. It is required for X-Cart operation');
                }
            }
        } else {
            $errorMsg = xtr('Cannot get the MySQL server version') . (!empty($pdoErrorMsg) ? ' : ' . $pdoErrorMsg : '.');
        }
    }
    $value = $version;
    return $result;
}
Beispiel #2
0
/**
 * Check if LiteCommerce installed
 * Use into Drupal connector
 *
 * :FIXME: check this carefully
 *
 * @param string $dbURL Database Url string (e.g. mysql://username:password@localhost/databasename)
 *
 * @return bool
 */
function isLiteCommerceInstalled($dbURL = null, &$message)
{
    // Check by template and config.php file
    $checkResult = file_exists(LC_DIR_SKINS . 'admin/en/welcome.tpl') && (file_exists(LC_DIR_CONFIG . 'config.php') || file_exists(LC_DIR_CONFIG . 'config.local.php'));
    if ($checkResult) {
        // Get database options from config.php
        $configData = \Includes\Utils\ConfigParser::getOptions('database_details');
        if (is_array($configData)) {
            // Check if host, dbname and username is not empty
            $checkResult = !empty($configData['hostspec']) && !empty($configData['database']) && !empty($configData['username']);
            if ($checkResult) {
                if (isset($dbURL)) {
                    // Support of Drupal 6 installation
                    if (is_array($dbURL)) {
                        $data = $dbURL;
                    } else {
                        $data = parseDbURL($dbURL);
                    }
                    if (!empty($data)) {
                        // Compare database options from config and from parameter
                        $checkResult = $configData['hostspec'] == $data['mysqlhost'] && $configData['username'] == $data['mysqluser'] && $configData['password'] == $data['mysqlpass'] && $configData['database'] == $data['mysqlbase'] && (!isset($data['mysqlport']) || $configData['port'] == $data['mysqlport']) && (!isset($data['mysqlsock']) || $configData['socket'] == $data['mysqlsock']);
                        if (!$checkResult) {
                            $message = 'Database parameters (specified in Drupal and LiteCommerce configs) comparison failed';
                        }
                    } else {
                        $message = '$dbURL passed but hasn\'t any data or corrupted';
                        $checkResult = false;
                    }
                } else {
                    $data = null;
                }
                if ($checkResult) {
                    // Check if connection works
                    $checkResult = dbConnect($data, $errorMsg);
                    if ($checkResult) {
                        $res = dbFetchColumn('SELECT profile_id from xlite_profiles LIMIT 1', $errorMsg);
                        if (empty($res)) {
                            $message = 'There are no profiles found in the database';
                            $checkResult = false;
                        } elseif (\Includes\Decorator\Utils\CacheManager::isRebuildNeeded(\Includes\Decorator\Utils\CacheManager::STEP_THIRD)) {
                            $message = 'Cache isn\'t built yet';
                            $checkResult = false;
                        }
                    } else {
                        $message = 'Cannot connect to the database';
                    }
                }
            } else {
                $message = 'Host, username or database name are empty';
            }
        } else {
            $message = 'Corrupted LiteCommerce config file';
            $checkResult = false;
        }
    } else {
        $message = 'config.php or admin/en/welcome.tpl files are not found';
    }
    return $checkResult;
}