Installation on Mac OS 10.4 with MAMP and PostgreSQL


(Bel) #21

Thanks I've now dropped the db, recreated and applied language. Trashed matrix, reinstalled.


I'm getting this error:



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

| PHP Warning |

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

| require_once([SYSTEM_ROOT]/data/private/conf/messaging_service.inc): failed to open stream: No such file or directory |

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



Fatal error: require_once(): Failed opening required '/users/belinda/sites/mysource_matrix/data/private/conf/messaging_service.inc' (include_path='.:/users/belinda/sites/mysource_matrix/php_includes:/Applications/MAMP/bin/php5/lib/php') in /Users/Belinda/Sites/mysource_matrix/core/include/messaging_service.inc on line 18



Here are my installed PEAR packages for php5



Installed packages, channel pear.php.net:

=========================================

Package Version State

Archive_Tar 1.3.2 stable

Console_Getopt 1.2.3 stable

DB 1.7.13 stable

HTTP_Client 1.1.1 stable

HTTP_Request 1.4.2 stable

Mail 1.1.14 stable

Mail_Mime 1.5.2 stable

Mail_Queue 1.2.2 stable

Mail_mimeDecode 1.5.0 stable

Net_Socket 1.0.8 stable

Net_URL 1.0.15 stable

PEAR 1.6.1 stable

Structures_Graph 1.0.2 stable

Text_Diff 1.0.0 stable

XML_HTMLSax 2.1.2 stable

XML_Parser 1.2.8 stable


(Avi Miller) #22

[quote]Thanks I've now dropped the db, recreated and applied language. Trashed matrix, reinstalled.
I'm getting this error:[/quote]



Which step of the installation is generating this error?


(Bel) #23

I get that error on:

/applications/mamp/bin/php5/bin/php install/step_02.php /users/belinda/sites/mysource_matrix
(The instructions say to reference mamp php as that's where all the PEAR modules are installed.)

But I only get it the once. If I run the same install line again directly afterwards, the error message changes to:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42883]: Undefined function: 7 ERROR: function sq_grant_access(unknown) does not exist
LINE 1: SELECT sq_grant_access($1)
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.' in /Users/Belinda/Sites/mysource_matrix/core/lib/DAL/DAL.inc:601
Stack trace:
#0 /Users/Belinda/Sites/mysource_matrix/core/lib/DAL/DAL.inc(601): PDOStatement->execute()
#1 /Users/Belinda/Sites/mysource_matrix/core/lib/db_install/db_install.inc(724): DAL::execPdoQuery(Object(PDOStatement))
#2 /Users/Belinda/Sites/mysource_matrix/install/step_02.php(121): grant_secondary_user_perms()
#3 {main}
thrown in /Users/Belinda/Sites/mysource_matrix/core/lib/DAL/DAL.inc on line 601


If I leave out the mamp reference and simply run php (eg. $ php install/step_02.php /users/belinda/sites/mysource_matrix) I get:

Fatal error: Uncaught exception 'Exception' with message 'Could not create database connection: DBError!:could not find driver' in /Users/Belinda/Sites/mysource_matrix/core/include/mysource.inc:2226
Stack trace:
#0 /Users/Belinda/Sites/mysource_matrix/core/include/mysource.inc(211): MySource->changeDatabaseConnection('db')
#1 /Users/Belinda/Sites/mysource_matrix/core/include/init.inc(231): MySource->init()
#2 /Users/Belinda/Sites/mysource_matrix/install/step_02.php(57): require_once('/Users/Belinda/...')
#3 {main}
thrown in /Users/Belinda/Sites/mysource_matrix/core/include/mysource.inc on line 2226


I really don't know what's going on here... I'm running all these commands under my username, but I'm admin so I didn't think that would matter (?).

(Bel) #24

Hello, I've retried the installation from scratch a few times over the weekend - using MySource Matrix 3.18.2, MAMP, PHP5, OS X 10.5. I've also reinstalled Postgres (postgresqlformac 8.3.1) dropped and recreated the db.


Each time I get to the same error on step_02.php:



[indent]-----------------------------------------------------------------------------------------------------------------------+

| PHP Warning |

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

| require_once([SYSTEM_ROOT]/data/private/conf/messaging_service.inc): failed to open stream: No such file or directory |

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



Fatal error: require_once(): Failed opening required '/users/belinda/sites/mysource_matrix/data/private/conf/messaging_service.inc' (include_path='.:/users/belinda/sites/mysource_matrix/php_includes:/Applications/MAMP/bin/php5/lib/php') in /Users/Belinda/Sites/mysource_matrix/core/include/messaging_service.inc on line 18

Macintosh:mysource_matrix Belinda$ /applications/mamp/bin/php5/bin/php install/step_02.php /users/belinda/sites/mysource_matrix

[/indent]



Should the file "messaging_service.inc" be created in "data/private/conf" after step_01.php?



Could you please tell me why this file might be missing / referencing incorrectly? I wasn't sure if there was an additional config setting I need to define in main.inc (other than the mandatory SQ_CONF_SYSTEM_ROOT_URLS, SQ_CONF_DEFAULT_EMAIL and SQ_CONF_TECH_EMAIL).



Thanks in advance,

Belinda


(Avi Miller) #25

There appears to be a bug in the installer. This is happening on my CentOS5 box as well. I have logged it: http://bugs.matrix.squiz.net/view_bug.php?bug_id=3103


(Bel) #26

I've now started again using the update 3.18.3, however still getting this error on step_02:
-----

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42883]: Undefined function: 7 ERROR: function sq_grant_access(unknown) does not exist

LINE 1: SELECT sq_grant_access($1)

^

HINT: No function matches the given name and argument types. You might need to add explicit type casts.' in /Users/Belinda/Sites/mysource_matrix/core/lib/DAL/DAL.inc:601

Stack trace:

#0 /Users/Belinda/Sites/mysource_matrix/core/lib/DAL/DAL.inc(601): PDOStatement->execute()

#1 /Users/Belinda/Sites/mysource_matrix/core/lib/db_install/db_install.inc(724): DAL::execPdoQuery(Object(PDOStatement))

#2 /Users/Belinda/Sites/mysource_matrix/install/step_02.php(121): grant_secondary_user_perms()

#3 {main}

thrown in /Users/Belinda/Sites/mysource_matrix/core/lib/DAL/DAL.inc on line 601

----

Is anyone able to tell me what is causing this? I've checked that I have created the dbase users with the exact permissions as specified. I would really like to evaluate this CMS but my time is becoming limited now. Any help would be appreciated.