Hi All - would be great if I could get a hand - trying to implement it on our Intranet before we get squiz to implement it on our website (most likely Standard Package).
When up to: $ php install/step_02.php /home/websites/mysource_matrix
I get an error 'DB Error: extension not found' with an e-mail which I have set up to be sent to me:
MySource Error
File : [SYSTEM_ROOT]/core/include/mysource.inc
Line : 1822
DB Error: extension not found
------------------------------------------------------------------
Root Urls
exampleserver.example.gov.au
------------------------------------------------------------------
Command and Arguments
step_02.php /home/websites/mysource_matrix
------------------------------------------------------------------
Back Trace
0 => array (
"function" => "sq_error_handler",
"args" => array (
0 => 256,
1 => "DB Error: extension not found",
2 => "[SYSTEM_ROOT]/core/include/mysource.inc",
3 => 1822,
4 => array (
[Max Depth Reached]
)
)
),
1 => array (
"file" => "[SYSTEM_ROOT]/core/include/mysource.inc",
"line" => 1822,
"function" => "trigger_error",
"args" => array (
0 => "DB Error: extension not found",
1 => 256
)
),
2 => array (
"file" => "[SYSTEM_ROOT]/core/include/mysource.inc",
"line" => 215,
"function" => "changedatabaseconnection",
"class" => "mysource",
"type" => "->",
"args" => array (
0 => "db"
)
),
3 => array (
"file" => "[SYSTEM_ROOT]/core/include/init.inc",
"line" => 213,
"function" => "init",
"class" => "mysource",
"type" => "->",
"args" => array (
[Empty]
)
),
4 => array (
"file" => "[SYSTEM_ROOT]/install/step_02.php",
"line" => 65,
"args" => array (
0 => "[SYSTEM_ROOT]/core/include/init.inc"
),
"function" => "require_once"
)
Previously in the PGSQL command prompt, I have entered a pgsql:… command and it just goes to a new line. If I enter the same command with a semi-colon on the end it comes up with:
mysource_matrix=> pgsql://matrix@unix()/mysource_matrix;
ERROR: syntax error at or near "pgsql" at character 1
LINE 1: pgsql://matrix@unix()/mysource_matrix;
Is my syntax wrong - or am I even meant to be entering this in to the db - lol? I have kept ALL of the naming the same of the documentation as this is the first test-install and I want to minimise confusion.
I have tried just about everything but I'm getting no where fast! I have put into the main.inc file the following entries:
define('SQ_CONF_DB_DSN', 'pgsql://matrix@unix()/mysource_matrix');
define('SQ_CONF_DB2_DSN', 'pgsql://matrix@unix()/mysource_matrix');
define('SQ_CONF_DB3_DSN', 'pgsql://matrix_secondary@unix()/mysource_matrix');
Is it true that you have to have unix() instead of localhost or 127.0.0.1 if you are running postgreSQL? - Well i've tried both anyway with no luck - somehow believe that it's definately related to the pgsql: db function.
Thanks for anyone who is patient enough to read and respond to this posting. 
You have two issues here:
- Your copy of PHP doesn't have PostgreSQL support. If you're running Fedora Core, RHEL or CentOS, try running this at the Linux command line:
# yum install php-pgsql
2. Secondly, you'll need to edit the /var/lib/pgsql/data/pg_hba.conf file to allow connections to PostgreSQL from the local server without a password. Do this by editing the "local" line and change "ident sameuser" to "trust"
Hope that makes sense!
Hi Avi,
Thanks heaps for the prompt reply. After extracting the yum 2.0.5 tar file and running ‘./configure’, ‘make’ and ‘make install’, I try to run the command you suggested from the CLI and get the following. When I put the address below which tries to grab the header.info file, into a web browser, it comes up with a file not found error - any ideas??
[color=“blue”][root@EMU bin]# yum install php-pgsql
Gathering header information file(s) from server(s)
Server: Red Hat Linux 3ES - i386 - Base
retrygrab() failed for:
http://mirror.dulug.duke.edu/pub/yum-repository/redhat/3ES/i386/headers/header.inf
Executing failover method
failover: out of servers to try
Error getting file http://mirror.dulug.duke.edu/pub/yum-repository/redhat/3ES/i386/headers/header.inf
[Errno 7] HTTP Error (CannotSendRequest):
[root@EMU bin]#
PS. I regards to your step 2, I simply dropped the database and users and recreated them with passwords - I hope that will be the same and following your suggestion.
Thanks so much for your help.
If you're running RHEL3, you'll need to use up2date to install additional packages. However, RHEL3 does not ship with the required versions of PHP or PostgreSQL required to run MySource Matrix v3.6 or higher.
I highly recommend upgraded to RHEL4.
I can't get past set up 02 because of this error:
PHP Warning
pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "matrix"
Warning: fopen(/var/www/html/mysource_matrix//data/private/logs/error.log): failed to open stream: Permission denied in /var/www/html/mysource_matrix/core/include/general.inc on line 850
Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/mysource_matrix/core/include/general.inc on line 851
Warning: Error occurred [SYS0051] Array ( [0] => /var/www/html/mysource_matrix//data/private/logs/error.log ) in /var/www/html/mysource_matrix/core/include/general.inc on line 943
PHP Warning
Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]core/include/general.inc:174)
Warning: fopen(/var/www/html/mysource_matrix//data/private/logs/error.log): failed to open stream: Permission denied in /var/www/html/mysource_matrix/core/include/general.inc on line 850
Warning: fwrite(): supplied argument is not a valid stream resource in /var/www/html/mysource_matrix/core/include/general.inc on line 851
Warning: Error occurred [SYS0051] Array ( [0] => /var/www/html/mysource_matrix//data/private/logs/error.log ) in /var/www/html/mysource_matrix/core/include/general.inc on line 943
MySource Error
DB Error: connect failed
I am running Centos 04
Linux aetn.portal 2.6.9-34.EL #1 Wed Mar 8 00:07:35 CST 2006 i686 i686 i386 GNU/Linux
Apache:
Server version: Apache/2.0.52
Server built: Jan 5 2006 12:31:31
PHP
PHP 4.3.9 (cgi) (built: Nov 10 2005 20:38:14)
Copyright © 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies
Postgres:
pg_ctl --version
pg_ctl (PostgreSQL) 7.4.8
[quote]pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "matrix"
[right][post=“9698”]<{POST_SNAPBACK}>[/post][/right][/quote]
This is a PostgreSQL permissions issue. Find and edit pg_hba.conf file on your distribution and make sure that you set the local access to “trust” instead of “ident sameuser”. On CentOS, this file should be in /var/lib/pgsql/data
okay now I changed that, after running it I get this:
MySource Warning
Error text not found for this code and locale [SYS0209]
array (
0 => 'public_user',
)
PHP Warning
Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]core/include/general.inc:174)
PGSQL STORED FUNCTIONS CREATED
sq_grant_access Function
sq_set_rollback_timestamp(TIMESTAMP) Function
sq_set_rollback_timestamp Function
sq_get_rollback_timestamp Function
sq_get_lineage_from_url Function
sq_rb_get_parent_treeids Function
sq_get_parent_treeids(VARCHAR, INT) Function
sq_get_parent_treeids(VARCHAR, INT, TIMESTAMP) Function
atoi Function
asset_link_treeid_convert Function
TABLE CREATION COMPLETE
New Tables:
sq_pkg
sq_ast
sq_rb_ast
sq_ast_lnk
sq_rb_ast_lnk
sq_shdw_ast_lnk
sq_rb_shdw_ast_lnk
sq_ast_lnk_tree
sq_rb_ast_lnk_tree
sq_ast_typ
sq_ast_attr
sq_ast_attr_val
sq_rb_ast_attr_val
sq_ast_attr_uniq_val
sq_rb_ast_attr_uniq_val
sq_ast_typ_inhd
sq_ast_url
sq_rb_ast_url
sq_ast_path
sq_rb_ast_path
sq_ast_lookup
sq_rb_ast_lookup
sq_ast_lookup_value
sq_rb_ast_lookup_value
sq_ast_lookup_remap
sq_rb_ast_lookup_remap
sq_ast_perm
sq_rb_ast_perm
sq_ast_edit_access
sq_rb_ast_edit_access
sq_ast_mdata
sq_rb_ast_mdata
sq_ast_mdata_val
sq_rb_ast_mdata_val
sq_ast_mdata_dflt_val
sq_rb_ast_mdata_dflt_val
sq_ast_wflow
sq_rb_ast_wflow
sq_internal_msg
sq_hipo_job
sq_lock
sq_patches
sq_trig
sq_rb_trig
sq_trig_hash
sq_file_vers_file
sq_file_vers_history
sq_file_vers_lock
sq_thes_term
sq_thes_lnk
sq_thes_lnk_tree
sq_ast_role
sq_cache
INDEX CREATION COMPLETE
New Indexes:
sq_ast_type_code
sq_rb_ast_type_code
sq_ast_name
sq_rb_ast_name
sq_ast_created
sq_rb_ast_created
sq_ast_updated
sq_rb_ast_updated
sq_ast_published
sq_rb_ast_published
sq_ast_lnk_majorid
sq_rb_ast_lnk_majorid
sq_ast_lnk_minorid
sq_rb_ast_lnk_minorid
sq_ast_lnk_link_type
sq_rb_ast_lnk_link_type
sq_shdw_ast_lnk_majorid
sq_rb_shdw_ast_lnk_majorid
sq_shdw_ast_lnk_minorid
sq_rb_shdw_ast_lnk_minorid
sq_shdw_ast_lnk_link_type
sq_rb_shdw_ast_lnk_link_type
sq_ast_lnk_tree_linkid
sq_rb_ast_lnk_tree_linkid
sq_ast_typ_lvl
sq_ast_attr_type_code
sq_ast_attr_name
sq_ast_attr_val_attrid
sq_rb_ast_attr_val_attrid
sq_ast_attr_val_assetid
sq_rb_ast_attr_val_assetid
sq_ast_attr_val_concat
sq_rb_ast_attr_val_concat
sq_ast_typ_inhd_inhd_type_code
sq_ast_typ_inhd_type_code
sq_ast_url_assetid
sq_rb_ast_url_assetid
sq_ast_path_assetid
sq_rb_ast_path_assetid
sq_ast_lookup_assetid
sq_rb_ast_lookup_assetid
sq_ast_lookup_value_value
sq_rb_ast_lookup_value_value
sq_ast_perm_assetid
sq_rb_ast_perm_assetid
sq_ast_perm_userid
sq_rb_ast_perm_userid
sq_internal_msg_userto
sq_internal_msg_type
sq_lock_source_lockid
sq_trig_active
sq_rb_trig_active
sq_trig_hash_event
sq_trig_hash_assetid
sq_trig_hash_asset_type
sq_trig_hash_treeid
sq_trig_hash_tree_propagate
sq_trig_hash_triggerid
sq_trig_hash_parentid
sq_trig_hash_parent_type
sq_trig_hash_childid
sq_trig_hash_child_type
sq_file_vers_history_from_date
sq_file_vers_history_to_date
sq_thes_term_thesid
sq_thes_lnk_major
sq_thes_lnk_minor
sq_thes_lnk_relation
sq_thes_lnk_thesid
sq_thes_lnk_tree_linkid
sq_thes_lnk_tree_treeid
sq_thes_lnk_tree_thesid
sq_cache_assetid
sq_cache_expires
SEQUENCE CREATION COMPLETE
PGSQL STORED VIEWS CREATED
sq_vw_ast_lnk_minor View
sq_vw_ast_lnk_major View
sq_vw_ast_lnk_minor Rollback View
sq_vw_ast_lnk_major Rollback View
sq_vw_ast_role View
sq_vw_ast_perm View
PGSQL SECONDARY AND TERTIARY USER PERMISSIONS FIXED
So it looks like it is complete but for the error.
How do I fix that?
You're trying to install this with the CGI binary, which is not recommended. You won't be able to run the compile_locales.php script (which compiles the language files) and you may have problems with step_03.php as well.
Unfortunately, RHEL4 and CentOS4 do not include a PHP CLI binary in the standard install. You may need to recompile PHP yourself or modify the PHP source RPM to build the CLI.
Additionally, now that you've fixed your PostgreSQL issue, you may want to start the installation again – delete the database and the filesystem, unpack everything again and start at the beginning.
Good luck!
Avi-
Is this still relavent?
http://forums.matrix.squiz.net/index.php?showtopic=6&pid=6285&st=0&#entry6285
It is.
I’ve added our PHP CLI RPM as a pinned topic in the Installation Forum, so you can download it.