Hi all,
I wonder if someone could help me. I'm new to MySource Matrix and I'm trying to install it on a Sun box running Solaris 10 with Apache2 and PHP v5.3.3.
At the stage "php install/step_02.php /usr/local/mysource_matrix" I'm getting the following errors :
PHP Deprecated: Assigning the return value of new by reference is deprecated in
/usr/local/mysource_matrix/install/step_02.php on line 68
Deprecated: Assigning the return value of new by reference is deprecated in /usr
/local/mysource_matrix/install/step_02.php on line 68
PHP Deprecated: Function set_magic_quotes_runtime() is deprecated in /usr/local
/mysource_matrix/core/include/init.inc on line 30
Deprecated: Function set_magic_quotes_runtime() is deprecated in /usr/local/myso
urce_matrix/core/include/init.inc on line 30
$db_conf = array (
'intranet' => array (
'DSN' => 'defiant.cwl.uk.ba.com',
'user' => 'matrix',
'password' => '********',
'type' => 'oci',
),
);
Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to c
onnection "db". No connection with that name is defined in the database config.'
in /usr/local/mysource_matrix/core/include/mysource.inc:3311
Stack trace:
#0 /usr/local/mysource_matrix/core/include/mysource.inc(220): MySource->changeDa
tabaseConnection('db')
#1 /usr/local/mysource_matrix/core/include/init.inc(243): MySource->init()
#2 /usr/local/mysource_matrix/install/step_02.php(57): require_once('/usr/local/
myso…')
#3 {main}
thrown in /usr/local/mysource_matrix/core/include/mysource.inc on line 3311
Also I'm not sure if my "db.inc" file database connection definition is correct :-(.
I notice in the documentation that PHP v5.3 is not supported. I'm wondering if that is the same with v5.3.3 ?
Any help would be much appreciated
Rgds djware
Newbie install error at step_02.php
Apologies … I failed to include that the database is Oracle 10g
[quote]
I notice in the documentation that PHP v5.3 is not supported. I'm wondering if that is the same with v5.3.3 ?
[/quote]
Yes, this would mean 5.3x won't work, but I think support/patch is coming soon.
Hi,
[quote]
Hi all,
I wonder if someone could help me. I'm new to MySource Matrix and I'm trying to install it on a Sun box running Solaris 10 with Apache2 and PHP v5.3.3.
[/quote]
As pointed out, php 5.3.x isn't supported. The next release will support it.
[quote]
$db_conf = array (
'intranet' => array (
'DSN' => 'defiant.cwl.uk.ba.com',
'user' => 'matrix',
'password' => '********',
'type' => 'oci',
),
);
[/quote]
Also you can't rename 'db' 'db2' 'db3' - those names are required. Change 'intranet' back to 'db'.
Thanks "nnhubbard" and Chris Smith for your feedback.
I'll make those changes and see where we get 
Definate improvement - no deprecated errors ! My colleague is working on php v5.2.14 install - tweaking it . I ran step2 ie php install/step_02.php /usr/local/mysource_matrix
and got the following errors :
Liberator - Root -->php install/step_02.php /usr/local/mysource_matrix
$db_conf = array (
'db' => array (
'DSN' => 'defiant.cwl.uk.ba.com',
'user' => 'matrix',
'password' => '',
'type' => 'oci',
),
'db2' => array (
'DSN' => 'defiant.cwl.uk.ba.com',
'user' => 'matrix',
'password' => '',
'type' => 'oci',
),
'db3' => array (
'DSN' => '10.61.23.53',
'user' => 'matrix',
'password' => '*******',
'type' => 'oci',
),
);
Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to c
onnection "db". No connection with that name is defined in the database config.'
in /usr/local/mysource_matrix/core/include/mysource.inc:3311
Stack trace:
#0 /usr/local/mysource_matrix/core/include/mysource.inc(220): MySource->changeDa
tabaseConnection('db')
#1 /usr/local/mysource_matrix/core/include/init.inc(243): MySource->init()
#2 /usr/local/mysource_matrix/install/step_02.php(57): require_once('/usr/local/
myso…')
#3 {main}
thrown in /usr/local/mysource_matrix/core/include/mysource.inc on line 3311
This 'db' thing is coming up again. I hope you havent got to use "matrix" for the database name since we already have one.
Any guidance would be much appreciated
Forgot to mention our database "intranet" tnspings OK :
Liberator - Root -->tnsping intranet
TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 03-NOV-2010 11:
53:56
Copyright © 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = defiant.cwl.uk.ba.com)(PORT = 1523))) (CONNECT_DATA = (SID = intranet) (
SERVER = DEDICATED)))
OK (10 msec)
Good news … we have resolved our php problems and reached the "Apache aliases" stage of the installation.
We have observed that when we introduce the following VirualHost directive into httpd.conf, an example php file doesnt load in our browser, but without the VirualHost directive it will load :
<VirtualHost *:80>
ServerName liberator.cwl.uk.ba.com
DocumentRoot /usr/local/mysource_matrix/core/web
Options -Indexes FollowSymLinks
<Directory /usr/local/mysource_matrix>
Order deny,allow
Deny from all
</Directory>
<DirectoryMatch "^/usr/local/mysource_matrix/(core/(web|lib)|data/public|fudge)"
>
Order allow,deny
Allow from all
</DirectoryMatch>
<FilesMatch "\.inc$">
Order allow,deny
Deny from all
</FilesMatch>
<LocationMatch "/(CVS|\.FFV)/">
Order allow,deny
Deny from all
</LocationMatch>
Alias /__fudge /usr/local/mysource_matrix/fudge
Alias /__data /usr/local/mysource_matrix/data/public
Alias /__lib /usr/local/mysource_matrix/core/lib
Alias / /usr/local/mysource_matrix/core/web/index.php/
</VirtualHost>
Therefore it follows that when we try to load the web page "liberator.cwl.uk.ba.com/_admin" we get a blank screen.
I wonder does the directive have to be placed in a particular location within the httpd.conf file…
Any guidance would be much appreciated
djware
[quote]
Therefore it follows that when we try to load the web page "liberator.cwl.uk.ba.com/_admin" we get a blank screen.
I wonder does the directive have to be placed in a particular location within the httpd.conf file…
Any guidance would be much appreciated
djware
[/quote]
Anything in /usr/local/mysource_matrix/data/private/log/error.log ? Or anything in the Apache access and error log? I think you might see a message there why it went wrong.
Edit: snip snip the quote
Thanks for the feedback Benjamin, things seem in order as the Apache error_log reports :
Liberator - Root -->more error_log
[Thu Nov 04 07:52:30 2010] [notice] Apache/2.2.16 (Unix) PHP/5.2.14 configured -
- resuming normal operations
[Thu Nov 04 07:58:17 2010] [notice] caught SIGTERM, shutting down
[Thu Nov 04 07:58:20 2010] [notice] Apache/2.2.16 (Unix) PHP/5.2.14 configured -
- resuming normal operations
[Thu Nov 04 07:59:35 2010] [notice] caught SIGTERM, shutting down
[Thu Nov 04 07:59:42 2010] [notice] Apache/2.2.16 (Unix) PHP/5.2.14 configured -
- resuming normal operations
Liberator - Root -->pwd
/usr/local/apache2/logs
and theres no error log in "/usr/local/mysource_matrix/data/private/logs" which I suppose is a good thing ? :
Liberator - Root -->pwd
/usr/local/mysource_matrix/data/private
Liberator - Root -->cd logs
Liberator - Root -->ls -al
total 8
drwxrwxr-x 3 bamcops staff 512 Sep 6 07:45 .
drwxrwxr-x 13 bamcops staff 512 Sep 6 07:45 …
-rwxrwxr-x 1 bamcops staff 7 Mar 8 2005 .cvsignore
drwxrwxr-x 2 bamcops staff 512 Sep 6 07:45 CVS
Liberator - Root -->
Any other suggestions will be much appreciated … we are definately getting there !
[quote]
Thanks for the feedback Benjamin, things seem in order as the Apache error_log reports :
Liberator - Root -->more error_log
[Thu Nov 04 07:52:30 2010] [notice] Apache/2.2.16 (Unix) PHP/5.2.14 configured -
- resuming normal operations
[Thu Nov 04 07:58:17 2010] [notice] caught SIGTERM, shutting down
[Thu Nov 04 07:58:20 2010] [notice] Apache/2.2.16 (Unix) PHP/5.2.14 configured -
- resuming normal operations
[Thu Nov 04 07:59:35 2010] [notice] caught SIGTERM, shutting down
[Thu Nov 04 07:59:42 2010] [notice] Apache/2.2.16 (Unix) PHP/5.2.14 configured -
- resuming normal operations
Liberator - Root -->pwd
/usr/local/apache2/logs
and theres no error log in "/usr/local/mysource_matrix/data/private/logs" which I suppose is a good thing ? :
Liberator - Root -->pwd
/usr/local/mysource_matrix/data/private
Liberator - Root -->cd logs
Liberator - Root -->ls -al
total 8
drwxrwxr-x 3 bamcops staff 512 Sep 6 07:45 .
drwxrwxr-x 13 bamcops staff 512 Sep 6 07:45 …
-rwxrwxr-x 1 bamcops staff 7 Mar 8 2005 .cvsignore
drwxrwxr-x 2 bamcops staff 512 Sep 6 07:45 CVS
Liberator - Root -->
Any other suggestions will be much appreciated … we are definately getting there !
[/quote]
Is your apache work as bamcops:staff ?
If not, change permission for correct user:group.
Regards
Arek
Thanks Arek, yes … apache2 is setup to work as user/group bamcops:staff. Here is an extract from "/usr/local/apache2/conf/httpd.conf" :
User/Group: The name (or #number) of the user/group to run httpd as.
It is usually good practice to create a dedicated user and group for
running httpd, as with most system services.
#
User bamcops
Group staff
Any further advice will be welcomed
[quote]
Thanks Arek, yes … apache2 is setup to work as user/group bamcops:staff. Here is an extract from "/usr/local/apache2/conf/httpd.conf" :
User/Group: The name (or #number) of the user/group to run httpd as.
It is usually good practice to create a dedicated user and group for
running httpd, as with most system services.
#
User bamcops
Group staff
Any further advice will be welcomed
[/quote]
What do you have in apache access log?
Also php error reporting is enable?
What is happen if you put another vhost with simple php code, it is work?
Regards
Arek
P.S.
Sorry about my English.
Hi Arek,
I work with djware and he is away today so I am progressing this for him.
When trying to access the "_admin" page the following is entered into the apache access)log
161.2.8.14 - - [08/Nov/2010:12:05:00 +0000] "GET /_admin/ HTTP/1.1" 200 -
Not sure how to check if php logging is enabled.
When trying to access a simple php file when the virtual host is enabled, we just get a blank screen.
I have also noticed that even though the php scripts seemed to run with no errors during installation (we did a complete new installation), there are no tables or views etc. in the oracle database within the Matrix schema.
[quote]
Hi Arek,
I work with djware and he is away today so I am progressing this for him.
When trying to access the “_admin” page the following is entered into the apache access)log
161.2.8.14 - - [08/Nov/2010:12:05:00 +0000] “GET /_admin/ HTTP/1.1” 200 -
Not sure how to check if php logging is enabled.
When trying to access a simple php file when the virtual host is enabled, we just get a blank screen.
I have also noticed that even though the php scripts seemed to run with no errors during installation (we did a complete new installation), there are no tables or views etc. in the oracle database within the Matrix schema.
[/quote]
About php logging:
in php.ini
display_errors = On
and
error_reporting = E_ALL
Nice web site about php debugging.
Are you have any info in Oracle logs?
What do you have in /_admin page source?
It is x86 or sparc machine?
I had a lots of problems with PHP on my SUN Sparc machine. May be this is a problem?
Did you try install MSM on x86 os and connect to yours Oracle?
Regards
Arek
Rightly or wrongly I decided to start again with MSM v3.28.8.
The install seemed successful with no errors through steps 1-3 but again as with our previous attempt the "http://liberator.cwl.uk.ba.com/_admin/" page shows nothing, plus there are no tables or views etc. in the oracle database within the Matrix schema.
Anyone have any ideas where we should go with this as its very frustrating
thanks and regards
Hi,
[quote]
Rightly or wrongly I decided to start again with MSM v3.28.8.
The install seemed successful with no errors through steps 1-3 but again as with our previous attempt the "http://liberator.cwl.uk.ba.com/_admin/" page shows nothing, plus there are no tables or views etc. in the oracle database within the Matrix schema.
Anyone have any ideas where we should go with this as its very frustrating
thanks and regards
[/quote]
If there's nothing in the database then step2 didn't work and so nothing else would have.
Anything in data/private/logs/error.log or data/private/logs/system.log?
Can you run step2 again and post the complete output?
[quote]
Hi,
If there's nothing in the database then step2 didn't work and so nothing else would have.
Anything in data/private/logs/error.log or data/private/logs/system.log?
Can you run step2 again and post the complete output?
[/quote]
Thanks for feedback Chris …
No logs in data/private/logs … strange I suppose. Heres the step2 command execution dialog :
Liberator - Root -->pwd
/usr/local/mysource_matrix/data/private/logs
Liberator - Root -->ls
CVS
Liberator - Root -->ls -al
total 8
drwxrwxr-x 3 bamcops staff 512 Jan 4 03:16 .
drwxrwxr-x 13 bamcops staff 512 Jan 4 03:16 …
-rwxrwxr-x 1 bamcops staff 7 Mar 8 2005 .cvsignore
drwxrwxr-x 2 bamcops staff 512 Jan 4 03:16 CVS
Liberator - Root -->pwd
/usr/local/mysource_matrix/data/private/logs
Liberator - Root -->cd /usr/local/mysource_matrix
Liberator - Root -->pwd
/usr/local/mysource_matrix
Liberator - Root -->php install/step_02.php /usr/local/mysource_matrix
Liberator - Root -->
As you can see there's no error messages or report from the step 2 command.
For info. here is our db.inc definition :
"Liberator - Root -->more db.inc
<?php
$db_conf = array (
'db' => array (
'DSN' => 'INTRANET',
'user' => 'matrix',
'password' => 'redshirt',
'type' => 'oci',
),
'db2' => array (
'DSN' => 'INTRANET',
'user' => 'matrix',
'password' => 'redshirt',
'type' => 'oci',
),
'db3' => array (
'DSN' => 'INTRANET2',
'user' => 'matrix',
'password' => 'redshirt',
'type' => 'oci',
),
'dbcache' => NULL,
'dbsearch' => NULL,
);
return $db_conf;
?>
Liberator - Root -->"
Also the database responds to a tnsping :
"Liberator - Root -->tnsping intranet
TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 28-JAN-2011 09:
19:43
Copyright © 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = defiant.cwl.uk.ba.com)(PORT = 1523))) (CONNECT_DATA = (SID = intranet) (
SERVER = DEDICATED)))
OK (10 msec)
Liberator - Root -->"
Any guidance will be gratefully received.
Thanks and Regards
[quote]
Liberator - Root -->php install/step_02.php /usr/local/mysource_matrix
Liberator - Root -->
As you can see there's no error messages or report from the step 2 command.
For info. here is our db.inc definition :
[/quote]
There is absolutely no output?That is very strange as you should see what step 2 is doing, the first thing you should see is a dump of your data/private/conf/main.inc and the last thing step 2 outputs is: "PGSQL SECONDARY AND TERTIARY USER PERMISSIONS FIXED"
Can you perhaps check where php would be reporting errors normally for any error messages? It would depend on the distro, but to guess it would either be syslog or messages in /var/log ?
Can you please double check you have meet the Matrix requirements including php modules and pear libraries?
[quote]
There is absolutely no output?That is very strange as you should see what step 2 is doing, the first thing you should see is a dump of your data/private/conf/main.inc and the last thing step 2 outputs is: "PGSQL SECONDARY AND TERTIARY USER PERMISSIONS FIXED"
Can you perhaps check where php would be reporting errors normally for any error messages? It would depend on the distro, but to guess it would either be syslog or messages in /var/log ?
Can you please double check you have meet the Matrix requirements including php modules and pear libraries?
[/quote]
Thanks for feedback Benjamin. To give you an idea here are the software versions we are running :
MSM v3.28.8
Oracle 10g
PHP v5.2.14
Apache2 (v2.2.16)
PEAR v1.9.1
I again installed MSM today running through steps 1-4 and step 2 just returned to the command prompt. 
We felt there may be a problem with php and pear so installed php, and this is the resulting dialog :
Installing PHP SAPI module: cgi
Installing PHP CGI binary: /usr/local/bin/
Installing PHP CLI binary: /usr/local/bin/
Installing PHP CLI man page: /usr/local/man/man1/
Installing build environment: /usr/local/lib/php/build/
Installing header files: /usr/local/include/php/
Installing helper programs: /usr/local/bin/
program: phpize
program: php-config
Installing man pages: /usr/local/man/man1/
page: phpize.1
page: php-config.1
Installing PEAR environment: /usr/local/lib/php/
[PEAR] Archive_Tar - already installed: 1.3.7
[PEAR] Console_Getopt - already installed: 1.2.3
[PEAR] Structures_Graph- already installed: 1.0.3
[PEAR] XML_Util - already installed: 1.2.1
[PEAR] PEAR - already installed: 1.9.1
Wrote PEAR system config file at: /usr/local/etc/pear.conf
You may want to add: /usr/local/lib/php to your php.ini include_path
Installing PDO headers: /usr/local/include/php/ext/pdo/
Any guidance would be gratefully received
Regards