I'm pretty new to installing MySource Matrix, but figured that since I managed to install it to use a PostgreSQL backend on a test machine, it surely can't be that hard to try a production install with our prod Oracle backend.
So after successfully building the PHP 5.1.6/Apache 2.2.3-11 CLI requirements on a Centos 5.2 (x64 system) for connecting to Oracle, I am now attempting to install MySource Matrix 3.20.1 with an Oracle 11g instance on a separate dedicated DB server ( PHP does list OCI8 as a supported extension from the phpinfo()) — but I keep running into issues at install/step_03.php.
When I attempt to run install/Step_03.php, I keep encountering this error:
Fatal error: Uncaught exception 'Exception' with message 'Unable to create root folder, as it did not receive asset ID #1. Fragments of another system may exist in the database; please ensure the database is clear of previous installations before installing.' in /home/websites/mysource_matrix/core/assets/system/root_folder/root_folder.inc:72
Stack trace:
#0 /home/websites/mysource_matrix/core/assets/package_manager_core.inc(152): Root_Folder->create(Array)
#1 /home/websites/mysource_matrix/core/include/package_manager.inc(850): Package_Manager_Core->createRootFolder()
#2 /home/websites/mysource_matrix/install/install.inc(334): Package_Manager->installSystemAssets()
#3 /home/websites/mysource_matrix/install/step_03.php(128): install_core(Array)
#4 {main}
thrown in /home/websites/mysource_matrix/core/assets/system/root_folder/root_folder.inc on line 72This is despite having dropped the Matrix tablespace everytime to repeat the installation process from a clean mysource_matrix folder (freshly extracted from mysource_3-20-1.tar.gz)
DROP INDEX MATRIX.sq_sch_idx_value;
DROP TABLESPACE MATRIX INCLUDING CONTENTS;(and even rm the matrix.dbf for good measure)
Please can anyone point me in the right direction for resolving this issue?
Thanks so much in advanced,
Eric.
PS: All the installation steps prior to install/step_03.php seem to work just fine, so I assumed the main.inc and db.inc were correctly setup, but included here for inspection with our server IPs masked as # (note that both matrix and matrix2 users have identical privileges - e.g. "GRANT CREATE VIEW TO matrix;" also was done for matrix2).
<?php
define('SQ_CONF_PEAR_PATH', SQ_SYSTEM_ROOT.'/php_includes');
$inc_dir = ini_get('include_path');
$inc_dir = (substr($inc_dir, 0, 2) == '.:') ? '.:'.SQ_CONF_PEAR_PATH.':'.substr($inc_dir, 2) : SQ_CONF_PEAR_PATH.':'.$inc_dir;
ini_set('include_path', $inc_dir);
define('SQ_CONF_BACKEND_SUFFIX', '_admin');
define('SQ_CONF_LIMBO_SUFFIX', '_edit');
define('SQ_CONF_LOGIN_SUFFIX', '_login');
define('SQ_CONF_NOCACHE_SUFFIX', '_nocache');
define('SQ_CONF_RECACHE_SUFFIX', '_recache');
define('SQ_CONF_ASSET_TREE_BASE', 64);
define('SQ_CONF_ASSET_TREE_SIZE', 4);
define('SQ_CONF_ASSET_CACHE_SIZE_WEB', -1);
define('SQ_CONF_ASSET_CACHE_SIZE_CLI', -1);
define('SQ_CONF_ROLLBACK_ENABLED', '0');
define('SQ_CONF_DEBUG', 0);
define('SQ_CONF_SYSTEM_NAME', 'CGEBS');
define('SQ_CONF_SYSTEM_OWNER', 'PROD');
define('SQ_CONF_SYSTEM_ROOT_URLS', 'matrix.intranet
#.#.#.#');
define('SQ_CONF_SYSTEM_PARENT_DOMAINS', '');
define('SQ_CONF_STATIC_ROOT_URL', '');
define('SQ_CONF_WEB_PATH_SEPARATOR', '-');
define('SQ_CONF_STATIC_ROOT_HTTP', true);
define('SQ_CONF_STATIC_ROOT_HTTPS', false);
define('SQ_CONF_DEFAULT_EMAIL', 'noah@the-ark.org.au');
define('SQ_CONF_TECH_EMAIL', 'noah@the-ark.org.au');
define('SQ_CONF_MAX_LOGIN_ATTEMPTS', 3);
define('SQ_CONF_REFRESH_INTERVAL', 120);
define('SQ_CONF_LOCK_LENGTH', 600);
define('SQ_CONF_ASSET_MAP_ASSET_LIMIT', 50);
define('SQ_CONF_ASSET_MAP_ASSET_DISPLAY_NAME', '%asset_short_name%');
define('SQ_CONF_SEND_CACHEABLE_HEADER', '0');
define('SQ_CONF_SEND_LAST_MODIFIED_HEADER', '0');
define('SQ_CONF_SEND_NOT_MODIFIED_HEADER', '0');
define('SQ_CONF_SEND_NO_CACHE_HEADER', '0');
define('SQ_CONF_SEND_404_CACHEABLE_HEADER', '0');
define('SQ_CONF_ERRORS_HIDE_FRONTEND', false);
define('SQ_CONF_DEFAULT_FRONTEND_LANGUAGE', 'en');
define('SQ_CONF_DEFAULT_BACKEND_LOCALE', 'en_AU');
define('SQ_CONF_DEFAULT_CHARACTER_SET', 'iso-8859-1');
define('SQ_CONF_ALLOW_IP_CHANGE', '0');
define('SQ_CONF_ALLOW_HTTP_LOGIN', '0');
define('SQ_CONF_ENABLE_HTTP_LOGIN', '0');
define('SQ_CONF_ENABLE_EXTERNAL_AUTH_SYSTEMS', true);
define('SQ_CONF_HTTP_LOGIN_VAR', 'REMOTE_USER');
define('SQ_CONF_ACCEPT_HTTP_CREDS', '0');
define('SQ_CONF_COMMIT_BUTTON_TEXT', 'Commit');
define('SQ_CONF_CONFIRM_SAVE_CHANGES', '1');
define('SQ_CONF_LOG_EXTENSION', '.log');
define('SQ_CONF_LOG_FILE_SYSTEM', 'system');
define('SQ_CONF_LOG_FILE_ERROR', 'error');
ini_set('error_log', SQ_LOG_PATH.'/'.SQ_CONF_LOG_FILE_ERROR.SQ_CONF_LOG_EXTENSION);
define('SQ_CONF_LOG_ERRORS', true);
ini_set('log_errors', '1');
define('SQ_CONF_SESSION_HANDLER', '');
define('SQ_CONF_SESSION_GC_MAXLIFETIME', 604800);
ini_set('session.gc_maxlifetime', 604800);
define('SQ_CONF_EDITING_TIME', 3600);
define('SQ_CONF_NUM_DATA_DIRS', 20);
define('SQ_CONF_FORCE_SECURE_LOGIN_URLS', '');
define('SQ_CONF_WEB_MEMORY_LIMIT', 64);
define('SQ_CONF_CRON_MEMORY_LIMIT', 64);
define('SQ_CONF_USE_DEFAULT_SESSION_SAVE_PATH', false);
define('SQ_CONF_CUSTOM_SESSION_SAVE_PATH', '');
define('SQ_CONF_ENABLE_ROLES_SYSTEM', true);
define('SQ_CONF_ENABLE_GLOBAL_ROLES', true);
define('SQ_CONF_TIMEZONE', 'Australia/Perth');
?></pre><br />
<?php
$db_conf = array (
'db' => array (
'DSN' => '#.#.#.#/PRODDB',
'user' => 'matrix',
'password' => 'password',
'type' => 'oci',
),
'db2' => array (
'DSN' => '#.#.#.#/PRODDB',
'user' => 'matrix',
'password' => 'password',
'type' => 'oci',
),
'db3' => array (
'DSN' => '#.#.#.#/PRODDB',
'user' => 'matrix2',
'password' => 'password',
'type' => 'oci',
),
'dbcache' => NULL,
'dbsearch' => NULL,
);
return $db_conf;
?></pre>
