Forum OpenACS Development: tests cases fail on a 5.5 fresh installation

1. the acs-templating test is because there are Oracle constraint names that don't meet our standard. Feel free to fix them - we PostgreSQL users maintain the PostgreSQL model to meet our standard and therefore pass the test, Oracle users need to maintain such things in Oracle.

2. acs-tcl which tests are failing? I ran them before release and didn't get these errors.

3. acs-content-repository - that didn't fail for me, either

4. acs-authentication - two tests fail if you're not using external authentication. These could be cleaned up but since it's a known issue, thus far no one has bothered.

I'm testing OpenACS on postgresql 8.2.11 in my spare time. As I'm working at UNED, maybe I can ask my boss to test on a Oracle instance.

Looking into more detail my automated tests results... the main problem is about something called "msgcat 1.4"

<h2>acs-authentication</h2>

You are right that acs-authentication fails if you're not using external authentication, for instance..

• auth::password::recover_password proc FAILED: status ok Affirm FAILED, actual = "failed_to_connect", expected = "ok"
• auth::password::retrieve proc FAILED: retrieve pwd from local auth Affirm FAILED, actual = "failed_to_connect", expected = "ok"

I've got another test fail, that now is magically fixed (by itself?) just re-running the test cases, the previous to last one pass said: FAILED: Number of problems Affirm FAILED, actual = "6", expected = "0". Anyway, no bother about that.

<h2>acs-content-repository</h2>

About acs-content-repository/tcl/test/content-search-procs.tcl, the problem is:

  cr_item_search_triggers (body 0): Error during execution: Setup failed with error can't find package msgcat 1.4

   can't find package msgcat 1.4
      while executing
  "package require msgcat 1.4"

<h2>acs-tcl</h2>

• util::age_pretty proc FAILED: can't find package msgcat 1.4
• Test case datamodel__named_constraints...
  
  • FAILED: Table pg_ts_cfg constraint pg_ts_cfg_pkey (pk) violates naming standard (hint: pg_ts_cfg_ts_name_pk)
  • FAILED: Table pg_ts_cfgmap constraint pg_ts_cfgmap_pkey (pk) violates naming standard (hint: pg_ts_cfgmap_pk)
  • FAILED: Table pg_ts_dict constraint pg_ts_dict_pkey (pk) violates naming standard (hint: pg_ts_dict_dict_name_pk)
  • FAILED: Table pg_ts_parser constraint pg_ts_parser_pkey (pk) violates naming standard (hint: pg_ts_parser_prs_name_pk)

<h2>acs-templating</h2>

• sql_date test sql date transform FAILED: can't find package msgcat 1.4

I've already installed msgcat 1.3, what seems to work with OpenACS 5.4.

Not sure how to upgrade msgcat to 1.4 in order to test OpenACS 5.5.

Thanks in advance

Test case datamodel__named_constraints...
FAILED: Table pg_ts_cfg constraint pg_ts_cfg_pkey (pk) violates naming standard (hint: pg_ts_cfg_ts_name_pk)
FAILED: Table pg_ts_cfgmap constraint pg_ts_cfgmap_pkey (pk) violates naming standard (hint: pg_ts_cfgmap_pk)
FAILED: Table pg_ts_dict constraint pg_ts_dict_pkey (pk) violates naming standard (hint: pg_ts_dict_dict_name_pk)
FAILED: Table pg_ts_parser constraint pg_ts_parser_pkey (pk) violates naming standard (hint: pg_ts_parser_prs_name_pk)

Goshawk:openacs-5.5.0 acs$ grep -r -l pg_ts_cfg .
Goshawk:openacs-5.5.0 acs$

This table is not part of acs-core.

Where is it coming from?

Finally I got everything working well. There is no problem as Don says.

So, please... I ask a forum moderator to change the title of this thread from "tests cases fail on a 5.5 fresh installation" to "tests cases fail with Tcl8.5" or something similar.

Thanks.

Just for the record, I have to say that the problem was that I was using Tcl8.5.7 with AOLServer 4.5.1, and although that's fine with OpenACS itself, TESTS cases don't work well with Tcl8.5 due to msgcat is now compiled as a module, and some tests use a file from tcltest where msgcat is called, but is not found.

Anyway, I have recompiled AOLServer with Tcl8.4.19 and everything works well.

The other issue, about pg_ts_* tables is related with Tsearch. Those tables are in my template1, so they appear in OpenACS database when I create it.

Perhaps the compatibility matrix should be changed to reflect this; it currently indicates support for tcl 8.5

http://www.openacs.org/xowiki/openacs-compatibility-matrix

I've updated http://www.openacs.org/xowiki/openacs-compatibility-matrix

Please check everything is OK.