I am trying to install the white branded version of MySource Matrix, version 3.4, using the CLI PHP instructions. I have version 8.0.3 of Postgres installed and have loaded the plpgsql language as instructed.
Step 1 seems to complete successfully but step 2 fails with a "TABLE INSTALL FAILURE". The complete transcript follows. If anyone has any suggestions I would be most grateful. Thanks.
ivansky@myhost% sudo /usr/local/php-4.3.11/bin/php install/step_02.php /udat1/www/mysource/whitematrix
Password:
----------------------------------
<?php
define('SQ_CONF_DB_DSN', 'pgsql://mysourcewb:mydbpw@unix()/mysourcewhitebrand');
define('SQ_CONF_DB2_DSN', '');
define('SQ_CONF_PEAR_PATH', '/udat1/www/mysource/whitematrix/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_ASSET_TREE_BASE', 36);
define('SQ_CONF_ASSET_TREE_SIZE', 4);
define('SQ_CONF_ROLLBACK_ENABLED', '0');
define('SQ_CONF_DEBUG', 0);
define('SQ_CONF_SYSTEM_NAME', 'The System');
define('SQ_CONF_SYSTEM_OWNER', '');
define('SQ_CONF_SYSTEM_ROOT_URLS', 'www.example.com');
define('SQ_CONF_DEFAULT_EMAIL', 'email1');
define('SQ_CONF_TECH_EMAIL', email2');
define('SQ_CONF_MAX_LOGIN_ATTEMPTS', 3);
define('SQ_CONF_MAX_IDLE_TIME', 6000);
define('SQ_CONF_REFRESH_INTERVAL', 120);
define('SQ_CONF_LOCK_LENGTH', 600);
define('SQ_CONF_LOG_FILE', '');
ini_set('error_log', SQ_DATA_PATH.'/private/logs/error.log');
define('SQ_CONF_LOG_ERRORS', true);
ini_set('log_errors', '1');
define('SQ_CONF_ERRORS_HIDE_FRONTEND', false);
define('SQ_CONF_DEFAULT_FRONTEND_LANGUAGE', 'en');
define('SQ_CONF_DEFAULT_CHARACTER_SET', 'iso-8859-1');
define('SQ_CONF_ALLOW_IP_CHANGE', '0');
define('SQ_CONF_COMMIT_BUTTON_TEXT', 'Commit');
?>
----------------------------------
------------------------------------
TABLE CREATION COMPLETE
------------------------------------
------------------------------------
SEQUENCE CREATION COMPLETE
------------------------------------
------------------------------------
PGSQL GRANT ACCESS FUNCTION CREATED
------------------------------------
±--------------------------------------------------------------------------------------------------------+
| MySource Warning |
|---------------------------------------------------------------------------------------------------------|
| DB Error: unknown error |
| SELECT sq_grant_access(FALSE) [nativecode=ERROR: function sq_grant_access(boolean) does not exist |
| HINT: No function matches the given name and argument types. You may need to add explicit type casts.] |
±--------------------------------------------------------------------------------------------------------+
±-----------------------------------------+
| MySource Error |
|------------------------------------------|
| TABLE INSTALL FAILURE |
±-----------------------------------------+
[quote]<?php
define('SQ_CONF_DB_DSN', 'pgsql://mysourcewb:mydbpw@unix()/mysourcewhitebrand');
define('SQ_CONF_DB2_DSN', '');[/quote]
You must configure both SQ_CONF_DB_DSN and SQ_CONF_DB2_DSN – and each one needs to use a different PostgreSQL user account, pointing at the same database. Step_02 then applies the appropriate permission for the second user (which is why the error is occuring – it doesn't know who the second user is!).
Thanks Avi for your amazingly prompt reply. I had not read the install.txt file carefully enough and thought I did not need to define the second user if I didn't plan to use HIPO. Of course it doesn't say that at all.
After deleting the install directory, and the database, and starting from scratch with both users defined, it all seems to be installing correctly. Too bad there isn't some way to incorporate sanity checking in the install scripts so you don't have to start from scratch every time.