Step 2

Squiz Matrix Installation
1

ok first of all i need to let you guys know i am a complete noob when it comes to databases, an area i want to learn but havnt had the chance of yet


when i try to run step 2 of the setup it comes up with DB error: connect failed



i assume that this is saying it is unable to connect to my database.

while i followed the setup of mysouce step by step this always got me, i inserted the details of my server into main.inc when it said, wasnt too sure if i have to replace unix() tags with the host name of my server or not, but it didnt make any difference



Any help would be much apreciated



Running Linux RedHat 9

Apache 2.0.58 - built from Source code

PHP 4.4.2 - built from Source code

Postgresql 7.3 - from RPM packages (should i have built this from source code too?)



once again all help will be apreciated



Thanks in advance

2

If you're trying to run MySource Matrix v3.8 you'll need PostgreSQL v7.4 or higher. Also, we highly recommend using v8.1.

3

yeah i re-read the requirements and picked up on that


i am now running postgresql 7.4.11 from the RedHat 9 RPMS, but i am still getting the DB error: connect failed



is there some config setting i have to change in the configuration files to allow the connection?

4

A few things:

  1. Make sure the PostgreSQL pg_hba.conf allows a "trust" connection for localhost.
  2. Use unix() exactly like that as the location.
  3. Make sure PHP is compiled with PostgreSQL support.
  4. Make sure you've created the database (createdb databasename)
  5. Make sure you've added the plpgsql language (createlang plpgsql databasename)
5

ok added trust connection to localhost
using unix() in the main.inc file

checked that php has Postgresql support

confirmed that i created the database and language but still no joy :frowning:



i will try postgresql version 8.1 from source when i get a chance, and read up some more on postgresql. Thanks

6

Can you post the three DSN lines from your main.inc file?

7

[quote]Can you post the three DSN lines from your main.inc file?
[right][post=“10010”]<{POST_SNAPBACK}>[/post][/right][/quote]



sorry for taking so long to get back to you, been too busy


[quote]define ('SQ_CONF_DB_DSN', 'pgsql://matrix@unix()/mysource_matrix');

define ('SQ_CONF_D2B_DSN', 'pgsql://matrix@unix()/mysource_matrix');

define ('SQ_CONF_DB3_DSN', 'pgsql://matrix_secondary@unix()/mysource_matrix');[/quote]



i got it installed but now i am getting the URL "localhost" not found [SYS0218] error

8

[quote]define (‘SQ_CONF_DB_DSN’, ‘pgsql://matrix@unix()/mysource_matrix’);
-----> define (‘SQ_CONF_D2B_DSN’, ‘pgsql://matrix@unix()/mysource_matrix’);

define (‘SQ_CONF_DB3_DSN’, ‘pgsql://matrix_secondary@unix()/mysource_matrix’);[/quote]



SQ_CONF_D2B_DSN should be SQ_CONF_DB2_DSN



Also, you will not be able to see anything until you create a site asset and assign a URL to it. Try going to the backend http://localhost/_admin . However, I am not sure if localhost is a valid URL in 3.8.2 .



Edit: Ahh Avi replied while I was editing my post… Too quick for me :slight_smile:

9

[quote]sorry for taking so long to get back to you, been too busy
i got it installed but now i am getting the URL “localhost” not found [SYS0218] error

[right][post=“10079”]<{POST_SNAPBACK}>[/post][/right][/quote]



And once you fix the above error, your system is working. :slight_smile: Just add /_admin to the end of the URL to login to the Administration Interface.

10

[quote]And once you fix the above error, your system is working. :slight_smile: Just add /_admin to the end of the URL to login to the Administration Interface.
[right][post=“10082”]<{POST_SNAPBACK}>[/post][/right][/quote]



yeah got it going now, Thanks for all the assistance

just gotta get Java installed and configured in PHP and i’m set



Thanks again for all the help :slight_smile: