CLI install problem

elucid · April 29, 2005, 6:11am

Hi folks,

After failing at the web-based install I tried the CLI install.

Here are some comments:

I needed to edit steps 02 and 03 to put in the System Root:

Fatal error: You need to supply the path to the System Root as the first argument
in step 02 I got the following error:

------------------------------------

TABLE CREATION COMPLETE

------------------------------------

------------------------------------

SEQUENCE CREATION COMPLETE

------------------------------------

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

| MySource Warning |

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

| DB Error: unknown error |

| |

| CREATE OR REPLACE FUNCTION sq_grant_access(character varying) RETURNS TEXT |

| AS ' |

| DECLARE |

| user_name ALIAS FOR $1; |

| table RECORD; |

| tablename TEXT; |

| BEGIN |

| FOR table IN SELECT c.relname AS name FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE c.relkind IN (''r'',''v'',''S'','''') AND n.nspname NOT IN (''pg_catalog'', ''pg_toast'') AND pg_catalog.pg_table_is_visible(c.oid) LOOP |

| tablename=table.name; |

| RAISE NOTICE ''tablename is %'', tablename; |

| EXECUTE ''GRANT ALL ON '' || quote_ident(tablename) || '' TO '' || quote_ident(user_name::text); |

| END LOOP; |

| RETURN ''access granted.''; |

| END; |

| ' |

| LANGUAGE plpgsql; |

| [nativecode=ERROR: language "plpgsql" does not exist |

| HINT: You need to use "createlang" to load the language into the database.] |

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

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

| MySource Error |

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

| TABLE INSTALL FAILURE |

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

so I ran 'createlang plpgsql dbname' as the postgres user.
then I ran step 03 and got the following:

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

| MySource Error |

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

| [ASSERT EXCEPTION] DB Error: no such table |

| SELECT type_code, version, name, instantiable, allowed_access, parent_type, dir, customisation |

| FROM sq_ast_typ [nativecode=ERROR: relation "sq_ast_typ" does not exist] (LINE 110 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) |

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

Any clues?

Thanks,

Chris

Avi_Miller · April 29, 2005, 6:21am

You need to install the PL/pgSQL language into your database before you start the Matrix installation process, by using the following command:

[font=“courier”]# createlang plpgsql <database-name>[/font]

Also, you don’t need to edit step_02.php or step_03.php – just provide the path to SYSTEM_ROOT as a parameter, like so:

[font=“courier”]# php install/step_02.php /path/to/matrix[/font]

elucid · April 29, 2005, 6:28am

Thanks for the response.

I did that, though - I ran the createlang command after the error pointed me to it.

And, sure, I can add the path as an argument but hardcoding it into the script won't make it fail - surely?!?

One thing: I only just noticed the dots after the commands for steps 02 and 03. WHat do these do? I ran those two scripts again and I get exactly the same outputs…

Ta,

Chris

Avi_Miller · April 29, 2005, 6:36am

The dots are the representations of the current directory for the SYSTEM_ROOT value. Though, you can't just add PL/pgSQL and continue the installation. You need to do that right at the beginning, or step_02.php won't complete successfully. Until you have a successful step_02.php run, step_03.php won't run.

elucid · April 29, 2005, 7:15am

Wow, I can’t tell you how much I’m loving Postgresql.

:blink:

Thanks for the info about the dots. Of course! D’oh!

I started everything from scratch and it now finishes the scripts successfully.

In my browser I enter http://serveraddress/sitename (as I specified in main.inc) and I get:

MySource Notice

URL “serveraddress/sitename” not found

So close! And yet so far…

Any further clues (and thanks for all your help so far)?

Chris

Avi_Miller · April 29, 2005, 7:31am

That means Matrix is up and running. You haven't created any sites yet, so it has nothing to display (hence the message). Add /_admin to the end of that URL and you'll be given a username/password dialog box to login to the Adminstration Interface.

The username is "root" – if you used the CLI installation method, the password will be "root" as well. I recommend changing that.

elucid · April 29, 2005, 7:31am

I've tried adding the _edit after the URL and I successfully get the login screen but what is the username and password when you do a CLI install…?

Thanks,

Chris

elucid · April 29, 2005, 7:32am

You just beat me to it!

Thanks and have a good weekend!

Chris

elucid · April 29, 2005, 7:34am

'Fraid I now get:

MySource Warning

Unable to find an Asset for the URL "serveraddress/sitename"

Any clues?

Chris

elucid · April 29, 2005, 7:38am

Ah. I changed the _edit to _admin and I'm in.

I'll read the doco now…

Once again - have a great weekend!

Chris

AbgRyan · September 24, 2005, 4:22am

step_02.php giving lots of errors in my console:

PEAR.php on line 103

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 112

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 112

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 121

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 121

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 129

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 129

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 137

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 137

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 777

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 777

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 778

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 778

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 779

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 779

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 780

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 780

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 781

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 781

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 782

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 782

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\php\pear\PEAR.p

hp on line 783

Notice: Trying to get property of non-object in E:\Program Files\xampp\php\pear\

PEAR.php on line 783

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\mysource_object.inc on line 43

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\mysource_object.inc on li

ne 43

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line 44

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line

44

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line 52

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line

52

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line 61

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line

61

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line 68

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line

68

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line 75

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line

75

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line 5287

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\asset_manager.inc on line

5287

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

| Unknown Error Type - 2048 |

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

| Assigning the return value of new by reference is deprecated |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on line 50

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on lin

e 50

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on line 59

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on lin

e 59

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on line 68

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on lin

e 68

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

Notice: Undefined variable: SQ_SYSTEM in E:\Program Files\xampp\htdocs\mysource

_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on line 77

Notice: Trying to get property of non-object in E:\Program Files\xampp\htdocs\my

source_matrix_3-6-0\mysource_matrix_3-6-0\core\include\locale_manager.inc on lin

e 77

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

| Unknown Error Type - 2048 |

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

| var: Deprecated. Please use the public/private/protected modifiers |

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

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

| Unknown Error Type - 2048 |

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

| is_a(): Deprecated. Please use the instanceof operator |

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

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

| Unknown Error Type - 2048 |

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

| is_a(): Deprecated. Please use the instanceof operator |

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

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

| Unknown Error Type - 2048 |

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

| is_a(): Deprecated. Please use the instanceof operator |

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

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

| Unknown Error Type - 2048 |

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

| is_a(): Deprecated. Please use the instanceof operator |

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

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

| Unknown Error Type - 2048 |

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

| Non-static method DB::isError() should not be called statically |

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

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

| Unknown Error Type - 2048 |

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

| is_a(): Deprecated. Please use the instanceof operator |

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

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

| MySource Error |

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

| Error occurred [SYS0270] |

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

Warning: mail(): SMTP server response: 550 5.7.1 Unable to relay for jims@yah

oo.com in E:\Program Files\xampp\htdocs\mysource_matrix_3-6-0\mysource_matrix_3-

6-0\core\include\general.inc on line 274

using Win 2003/apache2/php5/postgresql8

Avi_Miller · September 24, 2005, 5:17am

PHP5 and PHP4.4 are not supported by MySource Matrix. You will need to downgrade to PHP4.3.x.

AbgRyan · September 24, 2005, 5:41am

[quote]PHP5 and PHP4.4 are not supported by MySource Matrix. You will need to downgrade to PHP4.3.x.
[right][post=“6960”]<{POST_SNAPBACK}>[/post][/right][/quote]

wow thats fast reply… thanks it work well!