Topic title looks like its easy to resolve, but I cant seem to solve it.
I get the following error
MySource Error
DB Error: not found
when I try to hit the following urls http://ip/_edi, http://ip/_edi, http://ip/_edi
I’ve tried hostname unix mapped to the same ip without luck.
My mysource install is located in the public www directory.
I have setup mysource matrix correctly via php-cli, it found my postgresql database and installed.
I’ve configured the trust for localhost & all connections in psql, & enabled socket listening. In the main.inc file I refer to local system as unix()
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’);
define(‘SQ_CONF_SYSTEM_ROOT_URLS’, ‘unix’);
<VirtualHost :80>
DocumentRoot /var/www/html/mysource_matrix/core/web
ServerName unix
<Directory “/var/www/html/mysource_matrix”>
Options Indexes FollowSymLinks
Order deny,allow
Deny from all
</Directory>
<Directory “/var/www/html/mysource_matrix/core/web”>
Options Indexes FollowSymLinks
Order allow,deny
Allow from all
</Directory>
<Directory “/var/www/html/mysource_matrix/core/lib”>
Options Indexes FollowSymLinks
Order allow,deny
Allow from all
</Directory>
<Directory “/var/www/html/mysource_matrix/data/public”>
Options Indexes FollowSymLinks
Order allow,deny
Allow from all
</Directory>
<Directory “/var/www/html/mysource_matrix/fudge”>
Options Indexes FollowSymLinks
Order allow,deny
Allow from all
</Directory>
Alias “/__data” “/var/www/html/mysource_matrix/data/public”
Alias “/__lib” “/var/www/html/mysource_matrix/core/lib”
Alias "/_fudge" “/var/www/html/mysource_matrix/fudge”
Alias “/” “/var/www/html/mysource_matrix/core/web/index.php/”
</VirtualHost>
I’ve changed the hosts file to reflect hostname unix as being NIC ip & tried localhost address as well. Have all the required pear modules with correct versions. Have php 4.3.10 installed with correct modules. Used the online installation instructions to prep the psql database with that lang cmd line as well & ran thru all the step.php files without a single error.
Not sure what I could have missed.
Create a test.php file with <?php phpinfo(); ?> in it and make sure the Apache PHP module has PostgreSQL support. 
Yep I have postgres support compiled in with '–with-pgsql=shared'
Further down the page.
dbx
dbx support enabled
dbx version 1.0.0
supported databases MySQL ODBC PostgreSQL Microsoft SQL Server FrontBase Oracle 8 (oci8) Sybase-CT
You need a full PostgreSQL section. DBX is not used. If you don't have a PostgreSQL section, then PHP does not have PostgreSQL support.
*** Problem Solved, Just unpacked the original source & started again ***
Have Postgres subsection now.
Have a feeling Im getting closer.
Stuck on this error in step_03.php
±-------------------------------------------+
| MySource Warning |
|--------------------------------------------|
| Asset #15 does not exist [SYS0087] |
±-------------------------------------------+
±--------------------------------------------------------------------------------------------------------------------------+
| MySource Error |
|---------------------------------------------------------------------------------------------------------------------------|
| [ASSERT EXCEPTION] [NULL] "" is not a valid asset ID (LINE 2468 IN [SYSTEM_ROOT]core/include/asset_manager.inc) [SYS0270] |
±--------------------------------------------------------------------------------------------------------------------------+
***** Problem Solved - Copied all PEAR modules ******
:)’ /> <img src=‘http://forums.matrix.squiz.net/public/style_emoticons/<#EMO_DIR#>/smile.gif’ class=‘bbc_emoticon’ alt='
Still get DB Error: not found
After it installed fine, it couldn't find the pear modules
[client 10.0.0.33] PHP Warning: Error occurred [SYS0051]\nArray\n(\n [0] => /var/www/html/mysource_matrix/data/private/logs/error.log\n)\n in /var/www/html/mysource_matrix/core/include/general.inc on line 943
[client 10.0.0.33] PHP Fatal error: main(): Failed opening required 'DB.php' (include_path='/var/www/html/mysource_matrix/php_includes:/usr/local/php-cli/lib/php;/usr/share/pear;/var/www/html/mysource_matrix/php_includes') in /var/www/html/mysource_matrix/core/include/mysource.inc on line 26
So I just copied the modules to the mysource/php_includes and end up with the DB error.
This is what I have installed
Installed packages:
===================
Package Version State
Archive_Tar 1.1 stable
Cache 1.5.4 stable
Console_Getopt 1.2 stable
DB 1.7.6 stable
HTTP 1.2.2 stable
HTTP_Client 1.0.0 stable
HTTP_Request 1.3.0 stable
Mail 1.1.10 stable
Mail_Mime 1.3.1 stable
Net_SMTP 1.2.3 stable
Net_Socket 1.0.6 stable
Net_URL 1.0.14 stable
PEAR 1.3.2 stable
XML_HTMLSax 2.1.2 stable
XML_Parser 1.0.1 stable
XML_RPC 1.1.0 stable
[quote]***** Problem Solved - Copied all PEAR modules ******
:)’ /> <img src=‘http://forums.matrix.squiz.net/public/style_emoticons/<#EMO_DIR#>/smile.gif’ class=‘bbc_emoticon’ alt='
Still get DB Error: not found
After it installed fine, it couldn't find the pear modules
[client 10.0.0.33] PHP Warning: Error occurred [SYS0051]\nArray\n(\n [0] => /var/www/html/mysource_matrix/data/private/logs/error.log\n)\n in /var/www/html/mysource_matrix/core/include/general.inc on line 943
[client 10.0.0.33] PHP Fatal error: main(): Failed opening required 'DB.php' (include_path='/var/www/html/mysource_matrix/php_includes:/usr/local/php-cli/lib/php;/usr/share/pear;/var/www/html/mysource_matrix/php_includes') in /var/www/html/mysource_matrix/core/include/mysource.inc on line 26
So I just copied the modules to the mysource/php_includes and end up with the DB error.
This is what I have installed
Installed packages:
===================
Package Version State
Archive_Tar 1.1 stable
Cache 1.5.4 stable
Console_Getopt 1.2 stable
DB 1.7.6 stable
HTTP 1.2.2 stable
HTTP_Client 1.0.0 stable
HTTP_Request 1.3.0 stable
Mail 1.1.10 stable
Mail_Mime 1.3.1 stable
Net_SMTP 1.2.3 stable
Net_Socket 1.0.6 stable
Net_URL 1.0.14 stable
PEAR 1.3.2 stable
XML_HTMLSax 2.1.2 stable
XML_Parser 1.0.1 stable
XML_RPC 1.1.0 stable
[right][post=“10049”]<{POST_SNAPBACK}>[/post][/right][/quote]
So could not make sense if you have actually got past this or not… if you have not…
then try this…
Open your php.ini file that you put in place after the PHP installtion and configuration and look for:
; UNIX: "/path1:/path2"
(Note this example is from SUSE Linux)
make sure the line under that looks similar to:
include_path = ".:/php/includes:/usr/lib/php/"
removing the ; to activate the setting.
restart apache to make the changes stick. Note if your using a seperate php.ini for the cli version you will need to make the same change to that file.
I have noticed, that PHP does not find the pear includes directory correctly, so I just added an extra place for it to look…
you can find that by doing a
find /usr -name 'DB.php'
from a shell command, then just copy that path…
hope this helps