trying to install MySource Matrix:3.18 on our testing server.
got the following error at step02, not sure what was going wrong, could anyone please help? with thanks
Fatal error: Uncaught exception 'DALException' with message 'SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "sq_ast_typ" does not exist' in /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc:632
Stack trace:
#0 /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc(908): DAL::executePdoAssoc(Object(PDOStatement), NULL)
#1 /var/www/html/mysource_matrix/core/include/asset_manager.inc(152): DAL::executeSqlAssoc('SELECT type_cod…')
#2 /var/www/html/mysource_matrix/core/include/asset_manager.inc(121): Asset_Manager->getAssetTypes()
#3 /var/www/html/mysource_matrix/core/include/asset_manager.inc(87): Asset_Manager->_loadAssetTypes()
#4 /var/www/html/mysource_matrix/core/include/mysource.inc(214): Asset_Manager->Asset_Manager()
#5 /var/www/html/mysource_matrix/core/include/init.inc(233): MySource->init()
#6 /var/www/html/mysource_matrix/install/step_02.php(57): require_once('/var/www/html/m…')
#7 {main}
thrown in /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc on line 632
The installer thinks your system was already installed. Maybe you tried installing previously and it failed?
You are doing to need to remove the downloaded files and re-extract them to start the install process again.
[quote]The installer thinks your system was already installed. Maybe you tried installing previously and it failed?
You are doing to need to remove the downloaded files and re-extract them to start the install process again.[/quote]
Thanks for your quick response, I have re-installed, it failed at step02 again with the following error:
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 may need to add explicit type casts.' in /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc:601
Stack trace:
#0 /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc(601): PDOStatement->execute()
#1 /var/www/html/mysource_matrix/core/lib/db_install/db_install.inc(724): DAL::execPdoQuery(Object(PDOStatement))
#2 /var/www/html/mysource_matrix/install/step_02.php(121): grant_secondary_user_perms()
#3 {main}
thrown in /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc on line 601
Have you added the plpgsql language to your database?
$ createlang -U postgres plpgsql database_name
[quote]Have you added the plpgsql language to your database?
$ createlang -U postgres plpgsql database_name[/quote]
Yup, I did
"language "plpgsql" is already installed in database "mysource_matrix""
I would drop the database and clear the filesystem and start the whole thing again. :)
unlucky, drop the database and clear the file and start it again, but failed with the following error at step02 again.
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 may need to add explicit type casts.' in /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc:601
Stack trace:
#0 /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc(601): PDOStatement->execute()
#1 /var/www/html/mysource_matrix/core/lib/db_install/db_install.inc(724): DAL::execPdoQuery(Object(PDOStatement))
#2 /var/www/html/mysource_matrix/install/step_02.php(121): grant_secondary_user_perms()
#3 {main}
thrown in /var/www/html/mysource_matrix/core/lib/DAL/DAL.inc on line 601
[quote]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)[/quote]
What does your db.inc look like? It appears like you haven't configured all three DSNs. You need at least two PostgreSQL users for MySource Matrix and DSN3 uses the second user (DSN1 and DSN2 use the first user).
Thanks, I have restart psql and redo it again, go through the step02, at step 03
I got the error again. did I miss something else?
Fatal error: require_once(): Failed opening required 'Mail.php' (include_path='.:/var/www/html/mysource_matrix/php_includes:/usr/share/pear:/usr/share/php') in /var/www/html/mysource_matrix/core/include/messaging_service.inc on line 19
Are you using PostgreSQL 8.3? If so, you'll need to wait until 3.18.1 or downgrade PostgreSQL.
Now you're missing the PEAR Mail package.
What is the output for this:
$ pear list
You need to have the same PEAR packages installed (with the exception of DB) as Matrix v3.16 and lower, as listed on this page: http://matrix.squiz.net/resources/requirements
[quote]Now you're missing the PEAR Mail package.
What is the output for this:
$ pear list
You need to have the same PEAR packages installed (with the exception of DB) as Matrix v3.16 and lower, as listed on this page: http://matrix.squiz.net/resources/requirements[/quote]
Thanks,
now I installed some pear packages, the list:
Archive_Tar 1.3.2 stable
Auth_SASL 1.0.2 stable
Console_Getopt 1.2.3 stable
DB 1.7.13 stable
HTTP_Request 1.4.1 stable
Image_Canvas 0.3.1 alpha
Image_Color 1.0.2 stable
Image_Graph 0.7.2 alpha
Mail 1.1.14 stable
Mail_Mime 1.5.2 stable
Net_SMTP 1.2.11 stable
Net_Socket 1.0.8 stable
Net_URL 1.0.15 stable
Numbers_Roman 1.0.1 beta
Numbers_Words 0.15.0 beta
PEAR 1.6.2 stable
Structures_Graph 1.0.2 stable
XML_Parser 1.2.8 stable
XML_RPC 1.5.1 stable
XML_RSS 0.9.10 beta
I just continue the step03, and create apache aliases on localhost.
but check the browser at http://matrix.squiz.net/resources/requirements
got the mysource notice:
URL "http://localhost/mysource_matrix/core/web/index.php" not found [SYS0218]
appreciate your help.
Matrix is working. :) You don't need to reference the index.php file, the Alias lines takes care of that. You should now be able to visit http://localhost/_admin to view the Administration Interface of Matrix.
However, localhost is not a fully qualified domain name, so you may run into problems with our security system. You should change the System Root URL configuration in main.inc to either the IP address of your server or localhost.localdomain so that the name is qualified.
[quote]Matrix is working. 
You don’t need to reference the index.php file, the Alias lines takes care of that. You should now be able to visit http://localhost/_admin to view the Administration Interface of Matrix.
However, localhost is not a fully qualified domain name, so you may run into problems with our security system. You should change the System Root URL configuration in main.inc to either the IP address of your server or localhost.localdomain so that the name is qualified.[/quote]
but I check both http://localhost/_admin
and http://localhost/_admin
it appears 404 page not found
[quote]Matrix is working. You don’t need to reference the index.php file, the Alias lines takes care of that. You should now be able to visit http://localhost/_admin to view the Administration Interface of Matrix.
However, localhost is not a fully qualified domain name, so you may run into problems with our security system. You should change the System Root URL configuration in main.inc to either the IP address of your server or localhost.localdomain so that the name is qualified.[/quote]
I have done a clean installation again, got the same problem before I can setup Cron
What does your Apache's error_log file say? There might be something there that can tell us why you're getting a 404.
Thanks
the error log shows:
[Thu Apr 24 23:23:31 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
[Thu Apr 24 23:23:35 2008] [error] [client 127.0.0.1] File does not exist: /var/www/html/_admin
[quote][Thu Apr 24 23:23:31 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
[Thu Apr 24 23:23:35 2008] [error] [client 127.0.0.1] File does not exist: /var/www/html/_admin[/quote]
Having seen your httpd.conf in a PM, this is because you're attempting to view the localhost (127.0.0.1) but your Matrix aliases are configured on your external IP. So, Apache isn't firing Matrix for these requests. You should use the external IP in your browser and see if that works.
Thanks Avi, I have tried both matrix.local, and localhost in httpd.conf and main.inc, no luck,
just wondering why cant see from http://localhost/mysource_matrix/core/web/_admin?
while check the browser at http://localhost/mysource_matrix/core/web/_admin
got the mysource notice:
URL "http://localhost/mysource_matrix/core/web/index.php" not found [SYS0218]
The Alias line in Apache's httpd.conf translates everything from the first / into a request to the index.php file, so you do not need to include it in your URL. Somehow it seems that your Apache Aliases are not firing properly.