Step_02 error. DB related

Squiz Matrix Installation
1

Just trying out mysource for the first time, And am running in to this error on step_02.php


When I run…


    php /applications/web/mysource/install/step_02.php /applications/web/httpd/htdocs/mysource

(this worked for step_01, so I know I did that much right)

I get at the command line buried in the html… 


    DB Error: no such database


Though, from the same command line I'm able to 
    psql -U matrix mysource_matrix
and get to the CLI interface for PSQL with out any errors. Same with the GUI tool I use on my winXP work station.

Here is my main.inc code (first few lines at least).

    define('SQ_CONF_DB_DSN', 'pgsql://matrix@localhost/mysource_matrix');
    define('SQ_CONF_DB2_DSN', 'pgsql://matrix@localhost/mysource_matrix');
    define('SQ_CONF_DB3_DSN', 'pgsql://matrix_secondary@localhost/mysource_matrix');


This is on a REDHAT ES V3 server.

Any help?
Thanks!
2

[quote]

    define(‘SQ_CONF_DB_DSN’, ‘pgsql://matrix@localhost/mysource_matrix’);

define(‘SQ_CONF_DB2_DSN’, ‘pgsql://matrix@localhost/mysource_matrix’);

define(‘SQ_CONF_DB3_DSN’, ‘pgsql://matrix_secondary@localhost/mysource_matrix’);


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



For PostgreSQL, change localhost to unix() unless you’ve specifically allowed PostgreSQL to accept IP connections on the localhost (127.0.0.1) adapter. Also, ensure that pg_hba.conf allows you to connect via 127.0.0.1.


[quote]This is on a REDHAT ES V3 server.[/quote]



The stock version of PostgreSQL on RHEL3 is 7.3, which is too low for MySource Matrix v3.6 or higher. You need to upgrade to at least PostgreSQL v7.4, but 8.1 is highly recommend because of significant performance increases.

3

[quote]For PostgreSQL, change localhost to unix() … snip


The stock version of PostgreSQL on RHEL3 is 7.3, which is too low for MySource Matrix v3.6 or higher. You need to upgrade to at least PostgreSQL v7.4, but 8.1 is highly recommend because of significant performance increases.

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




    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');


and 
                                                     version
    ----------------------------------------------------------------------------------------------------------
     PostgreSQL 7.4.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-53)
    (1 row)


I'm still receiving the same DB Error, where the database can't be found.
4

here is my phpinfo(); output.


Important parts…

    PHP Version 4.4.2
    
    System  Linux portaldev.uarts.edu 2.4.21-37.ELsmp #1 SMP Wed Sep 7 13:28:55 EDT 2005 i686
    Build Date  Mar 24 2006 12:08:53
    Configure Command  './configure' '--with-apxs2=/applications/web/httpd/bin/apxs' '--with-mysql' '--prefix=/applications/web/httpd/php' '--with-config-file-path=/applications/web/httpd/php' '--enable-force-cgi-redirect' '--disable-cgi' '--with-zlib' '--with-gettext' '--with-gdbm' '--with-pgsql=/usr/local/pgsql'
    Server API  Apache 2.0 Handler
    Virtual Directory Support  disabled
    Configuration File (php.ini) Path  /applications/web/httpd/php/php.ini
    PHP API  20020918
    PHP Extension  20020429
    Zend Extension  20050606
    Debug Build  no
    Zend Memory Manager  enabled
    Thread Safety  disabled
    Registered PHP Streams  php, http, ftp, compress.zlib


and

    pgsql
    PostgreSQL Support	enabled
    PostgreSQL(libpq) Version  7.4.9
    Multibyte character support  enabled
    SSL support  disabled
    Active Persistent Links  0
    Active Links  0

Directive	Local Value	Master Value
pgsql.allow_persistent	On	On
pgsql.auto_reset_persistent	Off	Off
pgsql.ignore_notice	Off	Off
pgsql.log_notice	Off	Off
pgsql.max_links	Unlimited	Unlimited
pgsql.max_persistent	Unlimited	Unlimited</pre><br />




I'm still getting the same errors.

Any other thoughts?
5

Here's a test script that you can use to test the connection to the database. If this works then the problem lies somewhere other than the connection details.
test.php (422 Bytes)

6

[quote]Here’s a test script that you can use to test the connection to the database. If this works then the problem lies somewhere other than the connection details.
[right][post=“9355”]<{POST_SNAPBACK}>[/post][/right][/quote]



where is your db.php include?

7

DB.php includes the PEAR:DB package, which should be in your php include path.

8

Solved the DB errors, I was running PHP, 4.4.2 and went back down to 4.3.11 and everythings seemed to work…


until I tried to log on.

But I'll start a new thread for that. thank you.