Hello to all,
I am trying to instal mySource_Matrix 3.16.0 RC1 on Gentoo linux and Postgresql DB…
I did all according manual, I make step01 install (php install/step_01.php /root/mysource_matrix/) - it went ok…
Then I added some info to main.inc as asked in manual and did step02 - it wand badly… was some notices and error at the end:
Notice: Trying to get property of non-object in /root/mysource_matrix/core/include/mysource.inc on line 2187
±-------------------------------------------------------------+
| Unknown Error Type - 2048 |
|--------------------------------------------------------------|
| Assigning the return value of new by reference is deprecated |
±-------------------------------------------------------------+
Notice: Undefined index: SQ_SYSTEM in /root/mysource_matrix/core/include/general.inc on line 975
Notice: Trying to get property of non-object in /root/mysource_matrix/core/include/general.inc on line 975
±-----------------------------------------------------------------------+
| PHP Warning |
|------------------------------------------------------------------------|
| require_once(DB.php): failed to open stream: No such file or directory |
±-----------------------------------------------------------------------+
Fatal error: require_once(): Failed opening required 'DB.php' (include_path='.:/root/mysource_matrix//php_includes:/usr/share/php5:/usr/share/php:/var/www/localhost/htdocsssl/phpreports') in /root/mysource_matrix/core/include/mysource.inc on line 17
I tried to find DB.php in mysource_matrix dir but found nothing…
Where is the problem?
The first problem looks like you have PHP5 installed instead of PHP4. MySource Matrix only works on PHP4. The second problem is that you’re missing the required PEAR modules (DB.php comes from PEAR).
The requirements page on the Matrix website lists all the PHP and PEAR requirements.
yes… im having the same problem…
im using:
debian
php 4.4.7
im sure php was compiled with pear…
how do i find out what pear packages are installed?
when i try a pear command
:/# pear install DB
i get:
-bash: pear: command not found
thanks
michael
aha…
found the issue with pear…
i hadnt yet added pear to the path…
so i just had to use the full path for the commands…
now when i try step2:
php install/step_02.php /home/websites/mysource_matrix
iget this error…
±-----------------------------------------------+
| MySource Error |
|------------------------------------------------|
| DB Error: extension not found |
±-----------------------------------------------+
now i assume that this is because the path to the DB library and pear isnt in the system path…
if so how do i add it to the path?
thanks again
michael
when i type the command:
/usr/local/installer/bin/pear list
i get this list…
Installed packages, channel pear.php.net:
=========================================
Package Version State
Archive_Tar 1.3.2 stable
Console_Getopt 1.2.3 stable
DB 1.7.12 stable
HTML_Template_IT 1.2.1 stable
HTTP_Client 1.1.1 stable
HTTP_Request 1.4.1 stable
MDB2 2.4.1 stable
Mail 1.1.14 stable
Mail_Mime 1.5.2 stable
Mail_Queue 1.2.1 stable
Mail_mimeDecode 1.5.0 stable
Net_Socket 1.0.8 stable
Net_URL 1.0.15 stable
Numbers_Roman 0.2.0 stable
Numbers_Words 0.15.0 beta
PEAR 1.6.2 stable
PEAR_Frontend_Web 0.7.1 beta
Structures_Graph 1.0.2 stable
Text_Diff 0.2.1 beta
XML_HTMLSax 2.1.2 stable
XML_Parser 1.2.8 stable
am i missing anything?
That normally indicates that PHP is not compiled with support for your Database. You'll need the re-compile PHP with PostgreSQL support.
If you're using Debian, you should be able to apt-get install php4-pgsql to get the pgsql.so module for PHP. You will need to restart Apache for it to see this module.
aha…
thanks greg…
damn i have to compiple php again? is there no way around it? maybe editing the php.ini file?
ive got a site on mysource_classic and am trying to work out a way to move it to mysource_matrix…
so at the moment i also have mysource_classic on the same server…
so im just trying to set up mysource_matrix to see if there is a way i can write a script [or two] to automate the process…
is there a recomended setup where i can have both on the same server or should i set them up on diferent servers?
thanks again…
michael
thanks too avi…
if i did this [apt-get php4-pgsql] would it affect my mysource_classic install?
[quote]ive got a site on mysource_classic and am trying to work out a way to move it to mysource_matrix…
so at the moment i also have mysource_classic on the same server…[/quote]
There is no direct mechanism for upgrading/migrating from MySource Classic to Matrix. You should probably contact Squiz Support as we have done this before and we can best advise on how to go about it.
However, you will need to recompile PHP to support PostgreSQL.
No, it shouldn't. Obviously I don't know your exact server configuration so I can't be 100% certain of this. :)
Be careful… apt-get install postgresql may not always get 8.x of postgres.
apt-get install postgresql-8.x is the better way.
But this post may be redundant if you already knew that. 
thanks avi…
yes i realise there is no direct way of upgrading/migrating form classic to matrix…
so i am ready to role my sleeves up and get dirty…
ok, i shall contact someone from sqiz… who and by what method should i contact someone from squiz?
aha… yes aleks… i tried that earlier and got v7…
I would start with sales@squiz.net or calling your local office (if you're in Australia/NZ/London). You can find more contact details on the main Squiz website: http://www.squiz.ne
thanks for that avi…
ive rebuilt my system with aoache2, php4 and postgresql 8…
now when i try step_02 i get this error:
±-----------------------------------------------+
| MySource Error |
|------------------------------------------------|
| DB Error: connect failed |
±-----------------------------------------------+
im assuming that this because i have entered the wrong details for main.inc…
for the SQ_CONF_DB_DSN is:
pgsql://matrix@unix()/mysource_matrix
which i assume is
USER@unix()/DATABASE
is this correct? or do i replace unix() with my machines name [which is debian()]?
does anyone know how to check what users and databases have been created?
thank again for your help…
michael