Step 17 fails

Squiz Matrix Installation
1

I have sucessfully installed matrix on a development SUSE 9.1 (Server) machine, but am having trouble repeating the process (I am documenting it for rollout).


As far as I can see everything is identical, except the new machine is running X. All httpd.conf, php.ini, installed packages (including pear) are the same.



On step 17 I get the following error:

    Install Order :
    
    0 => "page",
    1 => "design_area",
    2 => "design",
    3 => "design_area_menu_type",
    4 => "design_area_menu_recursive",
    5 => "design_area_menu_normal",
    6 => "design_area_body",
    7 => "design_area_head",
    8 => "design_area_nest_content",
    9 => "design_area_declared_vars",
    10 => "design_area_metadata",
    11 => "design_area_custom_image",
    12 => "design_area_datetime",
    13 => "design_area_constant_button",
    14 => "design_area_colourise_image",
    15 => "design_area_asset_lineage",
    16 => "design_area_login_form",
    17 => "design_customisation",
    18 => "metadata_field",
    19 => "file",
    20 => "image",
    21 => "word_doc",
    22 => "pdf_file",
    23 => "thumbnail",
    24 => "user",
    25 => "inbox",
    26 => "backend_user",
    27 => "page_standard",
    28 => "bridge",
    29 => "folder",
    30 => "workflow_schema",
    31 => "workflow_step_condition",
    32 => "workflow_step",
    33 => "report",
    34 => "cron_manager",
    35 => "cron_job",
    36 => "trash_folder",
    37 => "layout_manager",
    38 => "designs_folder",
    39 => "root_folder",
    40 => "system_management_folder",
    41 => "authentication",
    42 => "authentication_folder",
    43 => "cache_manager",
    44 => "system_user",
    45 => "remap_manager",
    46 => "login_design",
    47 => "bodycopy_container",
    48 => "bodycopy_div",
    49 => "bodycopy_table",
    50 => "bodycopy",
    51 => "content_type",
    52 => "site",
    53 => "design_area_menu_stalks",
    54 => "metadata_field_select",
    55 => "metadata_field_date",
    56 => "metadata_field_text",
    57 => "metadata_schema",
    58 => "metadata_section",
    59 => "report_incomplete_metadata",
    60 => "workspace",
    61 => "user_group",
    62 => "content_type_wysiwyg",
    63 => "layout",
    64 => "cron_job_future_status",
    65 => "cron_job_future_lineage",
    66 => "system_user_group",
    67 => "root_user",
    68 => "authentication_default"
    
    Fatal error: Call to undefined function: quoteidentifier() in /srv/www/mysource_matrix/core/include/asset_manager.inc on line 285

This obviously refers to a database function, but it's all there…



What am I missing? <_<

2

With debug turned to high I get this:

     MySource Warning
    File:  [SYSTEM_ROOT]/core/include/package_manager.inc  Line:  161
    Message:  Asset "design_area_menu_stalks" fails the "asset" requirement for "design_area_menu_recursive v0.1"
    As specified by [SYSTEM_ROOT]/core/assets/designs/design_areas/menu/design_area_menu_stalks/asset.xml
    Backtrace:  Show


The backtrace shows the following:
    0 => array (
    	"function" => "sq_error_handler",
    	"args" => array (
      0 => 512,
      1 => "Asset \"design_area_menu_stalks\" fails the \"asset\" requirement for \"design_area_menu_recursive v0.1\"\nAs specified by [SYSTEM_ROOT]/core/assets/designs/design_areas/menu/design_area_menu_stalks/asset.xml",
      2 => "[SYSTEM_ROOT]/core/include/package_manager.inc",
      3 => 161,
      4 => array (
     	 [Max Depth Reached]
      ) 
    	) 
    ),
    1 => array (
    	"file" => "[SYSTEM_ROOT]/core/include/package_manager.inc",
    	"line" => 161,
    	"function" => "trigger_error",
    	"args" => array (
      0 => "Asset \"design_area_menu_stalks\" fails the \"asset\" requirement for \"design_area_menu_recursive v0.1\"\nAs specified by [SYSTEM_ROOT]/core/assets/designs/design_areas/menu/design_area_menu_stalks/asset.xml",
      1 => 512 
    	) 
    ),
    2 => array (
    	"file" => "[SYSTEM_ROOT]/core/assets/package_manager_core.inc",
    	"line" => 98,
    	"function" => "checkpackagedetails",
    	"class" => "package_manager_core",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    ),
    3 => array (
    	"file" => "[SYSTEM_ROOT]/install/install.inc",
    	"line" => 275,
    	"function" => "updatepackagedetails",
    	"class" => "package_manager_core",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    ),
    4 => array (
    	"file" => "/srv/www/htdocs/mysource_matrix_installer/steps/databasepopulate.inc",
    	"line" => 240,
    	"function" => "install_core",
    	"args" => array (
      [Empty]
    	) 
    ),
    5 => array (
    	"file" => "/srv/www/htdocs/mysource_matrix_installer/steps/databasepopulate.inc",
    	"line" => 109,
    	"function" => "_step03",
    	"class" => "dbpopulateaction",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    ),
    6 => array (
    	"file" => "/srv/www/htdocs/mysource_matrix_installer/step.inc",
    	"line" => 182,
    	"function" => "processaction",
    	"class" => "dbpopulateaction",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    ),
    7 => array (
    	"file" => "/srv/www/htdocs/mysource_matrix_installer/wizard.inc",
    	"line" => 324,
    	"function" => "process",
    	"class" => "databasepopulate",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    ),
    8 => array (
    	"file" => "/srv/www/htdocs/mysource_matrix_installer/wizard.inc",
    	"line" => 295,
    	"function" => "_processstep",
    	"class" => "installwizard",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    ),
    9 => array (
    	"file" => "/srv/www/htdocs/mysource_matrix_installer/wizard.inc",
    	"line" => 133,
    	"function" => "_processpost",
    	"class" => "installwizard",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    ),
    10 => array (
    	"file" => "/srv/www/htdocs/mysource_matrix_installer/index.php",
    	"line" => 39,
    	"function" => "run",
    	"class" => "installwizard",
    	"type" => "->",
    	"args" => array (
      [Empty]
    	) 
    )


There are no apache, system or postgres errors in the logs.
3

Check to see if you have any files with a 000644 extension (as per this thread). That’s usually the cause of this problem.

4

You more than likely have an outdated PEAR DB package. The quoteIdentifier() function/method that it's complaining about was added in version 1.6.0 of the DB package (released only February this year - so the original SuSE install might not have had it), so updating your PEAR packages may well work.

5

Pear versions are the latest (and the same aas the one on the working machine):

    linux:~ # pear list
    Installed packages:
    ===================
    Package        Version State
    Archive_Tar    1.2     stable
    Auth_SASL      1.0.1   stable
    Cache          1.5.4   stable
    Console_Getopt 1.2     stable
    DB             1.6.8   stable
    HTTP_Client    1.0.0   stable
    HTTP_Request   1.2.3   stable
    Mail           1.1.4   stable
    Mail_Mime      1.2.1   stable
    Net_SMTP       1.2.6   stable
    Net_Socket     1.0.2   stable
    Net_URL        1.0.14  stable
    PEAR           1.3.3   stable
    XML_HTMLSax    2.1.2   stable
    XML_Parser     1.2.1   stable
    XML_RPC        1.1.0   stable


I am checking the file name - might unzip them with another tool just in case.....
6

It may be better to download the tar.gz file and unpack them directly on the SuSE box, instead of using the zip file.

7

Nope - no good.
Even tried reinstalling the OS from scratch…



I guess there is a missing package somewhere that causes this to fail.

I just can't explain why I have one machine working fine, but i can't replicate it !

8

Are you using the web-based installer or the CLI installer? Is it possible to get shell access to this server so that I can take a look?

9

I am using the web based installer - I mught try the CLI to see what happens.


Unfortunately this server is behind a corporate firewall and I can not grant you access.

10

Doh!


Found the problem. :smiley:



The new servers database was called "matrix_db", but the postgresql user was "matrix" - on the old server they were both named "matrix".



This caused some sort of database connection problem. Unfortunately it did not log any errors anywhere that would suggest this…

11

That shouldn't have been the problem – if there was a database issue, you shouldn't have been able to create the tables at all, let alone get to Step 17.

12

Yeah - odd.


All I know is I changed the database name to "matrix" to match the username and it worked.



If I get sometime later today I will try it again with the old name to see what happens…keep you posted.

13

I'm getting a similar problem on step 17, except the "Fatal Error" is different. Running OS X server.






PHP Warning

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



Install Order :



0 => "bodycopy",

1 => "bodycopy_container",

2 => "bodycopy_div",

3 => "bodycopy_table",

4 => "bridge",

5 => "content_type",

6 => "content_type_wysiwyg",

7 => "design_area",

8 => "design_area_asset_lineage",

9 => "design_area_body",

10 => "design_area_colourise_image",

11 => "design_area_constant_button",

12 => "design_area_custom_image",

13 => "design_area_datetime",

14 => "design_area_declared_vars",

15 => "design_area_head",

16 => "design_area_linked_css",

17 => "design_area_login_form",

18 => "design_area_metadata",

19 => "design_area_nest_content",

20 => "design_area_menu_type",

21 => "file",

22 => "image",

23 => "pdf_file",

24 => "thumbnail",

25 => "word_doc",

26 => "folder",

27 => "layout",

28 => "metadata_field",

29 => "metadata_field_date",

30 => "metadata_field_select",

31 => "metadata_field_text",

32 => "metadata_schema",

33 => "metadata_section",

34 => "page",

35 => "page_standard",

36 => "report",

37 => "report_incomplete_metadata",

38 => "site",

39 => "authentication",

40 => "authentication_folder",

41 => "authentication_default",

42 => "cache_manager",

43 => "cron_job",

44 => "cron_manager",

45 => "cron_job_future_lineage",

46 => "cron_job_future_status",

47 => "designs_folder",

48 => "layout_manager",

49 => "remap_manager",

50 => "root_folder",

51 => "system_management_folder",

52 => "trash_folder",

53 => "inbox",

54 => "user",

55 => "user_group",

56 => "workspace",

57 => "workflow_schema",

58 => "workflow_step",

59 => "workflow_step_condition",

60 => "design",

61 => "design_area_menu_normal",

62 => "design_area_menu_recursive",

63 => "design_area_menu_stalks",

64 => "design_css",

65 => "design_css_customisation",

66 => "design_customisation",

67 => "login_design",

68 => "system_user_group",

69 => "backend_user",

70 => "system_user",

71 => "root_user"





Fatal error: main(): Failed opening required 'Cache.php' (include_path='.:/Library/WebServer/Documents/matrix/mysource_matrix_3-1-0-RC2/php_includes:/usr/local/php/lib/php') in /Library/WebServer/Documents/matrix/mysource_matrix_3-1-0-RC2/core/assets/system/cache_manager/cache_manager.inc on line 26

14

[quote]PHP Warning
main(Cache.php): failed to open stream: No such file or directory[/quote]

MySource Matrix v3.1 RC2 requires the PEAR Cache module to be installed, which is not by default. If you run: 

    # pear install cache

it will fix this problem.

15

Thanks Avi :smiley: