Step 02 problem, DB Error: extension not found

I think I am finally getting how to install Matrix. But I just ran into one problem, I started step 02 and this is what I get:




±-----------------------------------------------+

| MySource Error |

|------------------------------------------------|

| DB Error: extension not found |

±-----------------------------------------------+



Any help?

Ok, I edited my main.inc file, and realised I had missed some things. Here is what it currenly looks like:

    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_PEAR_PATH', SQ_SYSTEM_ROOT.'/php_includes');
    $inc_dir = ini_get('include_path');
    $inc_dir = (substr($inc_dir, 0, 2) == '.:') ? '.:'.SQ_CONF_PEAR_PATH.':'.substr($inc_dir, 2) : SQ_CONF_PEAR_PATH.':'.$inc_dir;
    ini_set('include_path', $inc_dir);
    
    define('SQ_CONF_BACKEND_SUFFIX', '_admin');
    define('SQ_CONF_LIMBO_SUFFIX', '_edit');
    define('SQ_CONF_NOCACHE_SUFFIX', '_nocache');
    define('SQ_CONF_ASSET_TREE_BASE', 64);
    define('SQ_CONF_ASSET_TREE_SIZE', 4);
    define('SQ_CONF_ASSET_CACHE_SIZE_WEB', -1);
    define('SQ_CONF_ASSET_CACHE_SIZE_CLI', -1);
    define('SQ_CONF_ROLLBACK_ENABLED', '0');
    define('SQ_CONF_DEBUG', 0);
    define('SQ_CONF_SYSTEM_NAME', 'The System');
    define('SQ_CONF_SYSTEM_OWNER', '');
    define('SQ_CONF_SYSTEM_ROOT_URLS', '10.50.3.23');
    define('SQ_CONF_STATIC_ROOT_URL', '');
    define('SQ_CONF_WEB_PATH_SEPARATOR', '_');
    define('SQ_CONF_STATIC_ROOT_HTTP', true);
    define('SQ_CONF_STATIC_ROOT_HTTPS', false);
    define('SQ_CONF_DEFAULT_EMAIL', 'webmaster@puc.edu');
    define('SQ_CONF_TECH_EMAIL', 'webmaster@puc.ed');
    define('SQ_CONF_MAX_LOGIN_ATTEMPTS', 3);
    define('SQ_CONF_REFRESH_INTERVAL', 120);
    define('SQ_CONF_LOCK_LENGTH', 600);
    define('SQ_CONF_ASSET_MAP_ASSET_LIMIT', 50);
    define('SQ_CONF_SEND_CACHEABLE_HEADER', '1');
    define('SQ_CONF_SEND_LAST_MODIFIED_HEADER', '0');
    define('SQ_CONF_SEND_NOT_MODIFIED_HEADER', '0');
    define('SQ_CONF_ERRORS_HIDE_FRONTEND', false);
    define('SQ_CONF_DEFAULT_FRONTEND_LANGUAGE', 'en');
    define('SQ_CONF_DEFAULT_BACKEND_LOCALE', 'en_AU');
    define('SQ_CONF_DEFAULT_CHARACTER_SET', 'iso-8859-1');
    define('SQ_CONF_ALLOW_IP_CHANGE', '0');
    define('SQ_CONF_ALLOW_HTTP_LOGIN', '0');
    define('SQ_CONF_ACCEPT_HTTP_CREDS', '0');
    define('SQ_CONF_COMMIT_BUTTON_TEXT', 'Commit');
    define('SQ_CONF_LOG_EXTENSION', '.log');
    define('SQ_CONF_LOG_FILE_SYSTEM', 'system');
    define('SQ_CONF_LOG_FILE_ERROR', 'error');
    ini_set('error_log',  SQ_LOG_PATH.'/'.SQ_CONF_LOG_FILE_ERROR.SQ_CONF_LOG_EXTENSION);
    define('SQ_CONF_LOG_ERRORS', true);
    ini_set('log_errors', '1');
    define('SQ_CONF_SESSION_GC_MAXLIFETIME', 604800);
    ini_set('session.gc_maxlifetime', 604800);
    define('SQ_CONF_EDITING_TIME', 3600);


Still getting the same error after correction. I even recompiled PHP and made sure that CLI was enabled. So, I don't think that is the problem, maybe I have done thing out of order, or am just missing something....

Looks like PHP doesn't have PostgreSQL support compiled. You need to compile PHP --with-pgsql on the configure line.

Fixed some more things, got php working with pgsql. But I am getting a new error on step 2.


PHP Notice: Undefined index: SQ_SYSTEM in /home/websites/mysource_matrix/core/include/general.inc on line 817



Notice: Undefined index: SQ_SYSTEM in /home/websites/mysource_matrix/core/include/general.inc on line 817

PHP Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862



Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862

PHP Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863



Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863

PHP Warning: Error occurred [SYS0051]

Array

(

[0] => /home/websites/mysource_matrix/data/private/logs/error.log

)

in /home/websites/mysource_matrix/core/include/general.inc on line 955



Warning: Error occurred [SYS0051]

Array

(

[0] => /home/websites/mysource_matrix/data/private/logs/error.log

)

in /home/websites/mysource_matrix/core/include/general.inc on line 955

±---------------------------------------------------------------+

| PHP Warning |

|----------------------------------------------------------------|

| main(DB.php): failed to open stream: No such file or directory |

±---------------------------------------------------------------+

PHP Fatal error: main(): Failed opening required 'DB.php' (include_path='.:/home/websites/mysource_matrix/php_includes:/usr/local/lib/php') in /home/websites/mysource_matrix/core/include/mysource.inc on line 26



Fatal error: main(): Failed opening required 'DB.php' (include_path='.:/home/websites/mysource_matrix/php_includes:/usr/local/lib/php') in /home/websites/mysource_matrix/core/include/mysource.inc on line 26



Any help? Do I have my permisions wrong?

Nope. you need to install the PEAR DB module.

Ok, I fixed the PEAR issue, and finally got step 2, step 3 installed! I finished the rest of the configuration, and added the virtual host line to apache. Now, when I access my site, I get tons of errors, looks like permissions!

    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    PHP Warning
    session_start(): open([SYSTEM_ROOT]/cache/sess_d49fa0be7f6c89e4f747f2605ab56f42, O_RDWR) failed: Permission denied (13)
    
    
    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    PHP Warning
    session_start(): Cannot send session cookie - headers already sent by (output started at [SYSTEM_ROOT]/core/include/general.inc:862)
    
    
    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    PHP Warning
    session_start(): Cannot send session cache limiter - headers already sent (output started at [SYSTEM_ROOT]/core/include/general.inc:862)
    
    
    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    PHP Warning
    Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]/core/include/general.inc:862)
    
    
    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    PHP Warning
    Cannot modify header information - headers already sent by (output started at [SYSTEM_ROOT]/core/include/general.inc:862)
    
    
    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    MySource Notice
    URL "10.50.3.22" not found [SYS0218]
    
    
    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    PHP Warning
    Unknown(): open(/home/websites/mysource_matrix/cache/sess_d49fa0be7f6c89e4f747f2605ab56f42, O_RDWR) failed: Permission denied (13)
    
    
    Warning: fopen(/home/websites/mysource_matrix/data/private/logs/error.log): failed to open stream: Permission denied in /home/websites/mysource_matrix/core/include/general.inc on line 862
    
    Warning: fwrite(): supplied argument is not a valid stream resource in /home/websites/mysource_matrix/core/include/general.inc on line 863
    
    Warning: Unable to Write to log file /home/websites/mysource_matrix/data/private/logs/error.log [SYS0051] in /home/websites/mysource_matrix/core/include/locale_manager.inc on line 512
    
    PHP Warning
    Unknown(): Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/home/websites/mysource_matrix/cache)


Now what?

You need to make sure that the data/ and cache/ directories of your MySource Matrix installation are owned by the Apache user.

Good, that has been fixed, and now I am getting one small error when trying to log into the admin panel…


MySource Notice

URL "10.50.3.22" not found [SYS0218]



But that is the ip address of my computer, and site. This is the page that I am getting the error on, and the ip that will be the one that I access for the pages. Did I do something wrong with this? Should I use local host instead since I am using this internally for now? Not sure what to do now…



Also, here is an excerpt from my apache error log:


    [Mon Jul 03 17:27:49 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:50 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:27:50 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:50 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:27:51 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:51 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:27:52 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:52 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:27:53 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:53 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:27:53 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:53 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:27:54 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:54 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:27:55 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:27:55 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:28:24 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/fjdklsa
    [Mon Jul 03 17:28:24 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:28:37 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/core/web/index.php
    [Mon Jul 03 17:28:37 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:28:56 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/home/websites/mysource_matrix/core/web/index.php
    [Mon Jul 03 17:28:56 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:31:45 2006] [notice] Graceful restart requested, doing restart
    [Mon Jul 03 17:31:45 2006] [notice] Apache/2.2.2 (Unix) PHP/4.4.2 configured -- resuming normal operations
    [Mon Jul 03 17:31:45 2006] [error] [client ::1] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:31:45 2006] [error] [client ::1] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:31:45 2006] [error] [client ::1] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:31:45 2006] [error] [client ::1] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:31:45 2006] [error] [client ::1] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:31:45 2006] [error] [client ::1] File does not exist: /home/websites/mysource_matrix/core/web/index.php/
    [Mon Jul 03 17:31:48 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/home/websites/mysource_matrix/core/web/index.php
    [Mon Jul 03 17:31:48 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:31:50 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/home/websites/mysource_matrix/core/web/index.php
    [Mon Jul 03 17:31:50 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/favicon.ico
    [Mon Jul 03 17:31:51 2006] [error] [client 10.50.3.23] File does not exist: /home/websites/mysource_matrix/core/web/index.php/home/websites/mysource_matrix/core/web/index.php

NEVERMIND. I realized I had to access the admin control panel by adding /_admin I think that is something you should add on the last step of the installation page. It would just be a quick help for people slightly confiused.

[quote]NEVERMIND.  I realized I had to access the admin control panel by adding /_admin  I think that is something you should add on the last step of the installation page.  It would just be a quick help for people slightly confiused.
[right][post=“10790”]<{POST_SNAPBACK}>[/post][/right][/quote]

Thanks for spotting this. There should have been some instructions in the guide. I have changed the instructions to try and make it clearer.

Greg or Avi,


I am trying to install on a debian system and on step three I get this error:



+———————————————+

| MySource Warning |

|———————————————|

| Asset #2 does not exist [SYS0087] |

+———————————————+

+———————————————————————————————————————————+

| MySource Error |

|———————————————————————————————————————————|

| [ASSERT EXCEPTION] Cannot create asset without an asset to link to (LINE 245 IN [SYSTEM_ROOT]/core/include/asset.inc) [SYS0270] |

+———————————————————————————————————————————+



All dependancies I think are good.



I setup the system based on this page:

http://www.code-poetry.com/2006/05/28/tutorial-step-by-step-setup-of-a-mysource-matrix-cms-on-a-blank-debian-31/

Looks like step_03.php bailed the first time and now you're left with a half-installed system. Delete the mysource_matrix folder, drop the database and start again. :slight_smile:


We know Matrix is not terribly resilient to failures during the initial installation process. Its something that we will take great care with while we develop MySource 4.0. :smiley: