Intalling mysource matrix

Hello,


I am having trouble installing mysource matrix. Basically, running the step_02.php script is producing errors:



Fatal error: Uncaught exception 'Exception' with message 'Could not create database connection: DBError!:could not find driver' in /home/mysource/mysource_matrix/core/include/mysource.inc:2510

Stack trace:

#0 /home/mysource/mysource_matrix/core/include/mysource.inc(211): MySource->changeDatabaseConnection('db')

#1 /home/mysource/mysource_matrix/core/include/init.inc(233): MySource->init()

#2 /home/mysource/mysource_matrix/install/step_02.php(57): require_once('/home/mysource/…')

#3 {main}

thrown in /home/mysource/mysource_matrix/core/include/mysource.inc on line 2510





I have installed all the prerequisites such as the pear modules etc. My system is SuSE linux enterprise 10, postgres 8, apache2, php5.



Anyone know what might cause this problem?



Thanks in advance



Warwick Manns

The error indicates that PHP is not compiled with the PDO driver for PostgreSQL. Did you install a package like pdo_pgsql?


I installed a package called php5-pdo. This was the only package with pdo in the name available on my system. Is there something else I need to install?

Thanks for your reply

Try this: pecl install pdo_pgsql


I don't have pecl on my system. Is there another way to install pdo_pgsql on SuSE?

Thanks

Hi wmanns,


Im not totally sure what the package list for Suse will be to get matrix to run, but here are the list of php packages that are installed on a RHEL 5 box in order to get matrix to run correctly.



Bear in mind that this package list may be a little old and not reflect the final versions for RHEL.





php-common-5.1.6-20.el5

php-5.1.6-20.el5

php-pear-1.4.9-4.el5.1

php-cli-5.1.6-20.el5

php-ldap-5.1.6-20.el5

php-pgsql-5.1.6-20.el5

php-soap-5.1.6-20.el5

php-xml-5.1.6-20.el5

php-pdo-5.1.6-20.el5

php-gd-5.1.6-20.el5



I have the feeling that as Suse is a RPM distro, that the list should be fairly similar.



Cheers

[quote]Hi wmanns,


Im not totally sure what the package list for Suse will be to get matrix to run, but here are the list of php packages that are installed on a RHEL 5 box in order to get matrix to run correctly.



Bear in mind that this package list may be a little old and not reflect the final versions for RHEL.





php-common-5.1.6-20.el5

php-5.1.6-20.el5

php-pear-1.4.9-4.el5.1

php-cli-5.1.6-20.el5

php-ldap-5.1.6-20.el5

php-pgsql-5.1.6-20.el5

php-soap-5.1.6-20.el5

php-xml-5.1.6-20.el5

php-pdo-5.1.6-20.el5

php-gd-5.1.6-20.el5



I have the feeling that as Suse is a RPM distro, that the list should be fairly similar.



Cheers[/quote]



Hi,



Thanks for your help. I have all the right packages now (i got sick of trying to get it to work on SuSE and went with ununtu server), but I'm getting a different error now at step 2. The error is:



Fatal error: Uncaught exception 'Exception' with message 'Could not create database connection: DBError!:SQLSTATE[08006] [7] FATAL: Ident authentication failed for user "matrix"' in /srv/matrix/mysource_matrix/core/include/mysource.inc:2510

Stack trace:

#0 /srv/matrix/mysource_matrix/core/include/mysource.inc(211): MySource->changeDatabaseConnection('db')

#1 /srv/matrix/mysource_matrix/core/include/init.inc(233): MySource->init()

#2 /srv/matrix/mysource_matrix/install/step_02.php(57): require_once('/srv/matrix/mys…')

#3 {main}

thrown in /srv/matrix/mysource_matrix/core/include/mysource.inc on line 2510





Any help appreciated.



Thanks


This is a problem with the way that the host based authentication is configured for the postgres server. In the pg_hba.conf file you need to configure access for the matrix users to the specific database. Typically you can use the 'trust' method, but you may also use passwords if you desire.

Can you post your pg_hba.conf contents?

Cheers,
Owen

[quote]This is a problem with the way that the host based authentication is configured for the postgres server. In the pg_hba.conf file you need to configure access for the matrix users to the specific database. Typically you can use the 'trust' method, but you may also use passwords if you desire.


Can you post your pg_hba.conf contents?



Cheers,

Owen[/quote]



Thanks, I sorted it out. It was with the pg_hba file.

hi all, I'm getting the following error in the 2nd step of the installation (step02.php):


Fatal error: Uncaught exception 'Exception' with message 'Unable to connect to connection "db". No connection with that name is defined in the database config.' in /var/www/matrix/core/include/mysource.inc:2544

Stack trace:

#0 /var/www/matrix/core/include/mysource.inc(211): MySource->changeDatabaseConnection('db')

#1 /var/www/matrix/core/include/init.inc(233): MySource->init()

#2 /var/www/matrix/install/step_02.php(57): require_once('/var/www/matrix…')

#3 {main}

thrown in /var/www/matrix/core/include/mysource.inc on line 2544



Could anybody help me on this ? thanks in advance.

Have you edited db.inc correctly as per the installation instructions?
http://matrix.squiz.net/resources/installation

from experience … Suse (SLES10) will not work with the Squiz server (the stand-alone cli hipo server). if you are thinking of having a large site/assets then you will need to rethink your choice of operating system.