+1 323 268 0395 kmw@caltek.net

]po[ mailing list archives

Luri, I typed up this e-mail 2 [...]

by
Kenneth Wyrick
- 04/22/2018 17:07:45

Luri,

I typed up this e-mail 2 days ago but discovered this morning that i had
not sent it. I went looking for Berman's reference to install LRN then
]po[ from the package manager. I didn't find it...

I think you should post to the ]po[ forum what happened with the having a
]po[ and LRN not being happy being installed onto it with the
package-manager.

Maybe also mention next you will install LRN and then ]po[ from
package-manager.

If you want me to do it I will.

I'm remembering that I still need to create my own security keys.
On Sun, April 22, 2018 9:32 am, Iuri Sampaio wrote:
Kenneth,

So far, the second instance is up and running .LRN. I’ve changed the
domain to dotlrn.iurix.com <http://dotlrn.iurix.com/>.
However, the attempts to merge it with ]po[ haven’t succeed yet. As
already expected, both, (i.e. .LRN and ]PO[ ) throw a bunch of errors when
they are installed through APM packages. (see logs bellow)

Thus, I’ll be doing more tests and fixes in the instance lrn.iurix.com
<http://lrn.iurix.com/>


I’m going to setup the third instance with .LRN. Once I find a solution
and succeed on merging ]po[ and .LRN, then we move forward to configure
LDAP on both instances (i.e. 2nd and 3rd servers).

Let me know your thoughts and suggestions.



Best wishes,
I




##### .LRN error 1

[21/Apr/2018:22:41:54][14504.7f94e1250700][-conn:dotlrn:0:26-] Notice:
CREATE FUNCTION
[21/Apr/2018:22:41:54][14504.7f94e1250700][-conn:dotlrn:0:26-] Error:
apm_package_install: Error installing dotLRN version 2.5.0:
psql:site-templates-create.sql:91: ERROR:  missing FROM-clause entry for
table "acs_object_id_seq"
LINE 1: select acs_object_id_seq.nextval
               ^
QUERY:  select acs_object_id_seq.nextval
                                         from dual
CONTEXT:  PL/pgSQL function inline_0() line 10 at SQL statement
psql:communities-tree-create.sql:52: WARNING:  changing return type of
function dotlrn_community_types_in_tr from "opaque" to "trigger"
psql:communities-tree-create.sql:101: WARNING:  changing return type of
function dotlrn_communities_in_tr from "opaque" to "trigger"
psql:dotlrn-init.sql:395: ERROR:  missing FROM-clause entry for table
"acs_object_id_seq"
LINE 1: select acs_object_id_seq.nextval
               ^
QUERY:  select acs_object_id_seq.nextval
                                   from dual
CONTEXT:  PL/pgSQL function dotlrn_community_type__new(character
varying,character varying,character varying,character varying,character
varying,integer,timestamp with time zone,integer,character
varying,integer) line 22 at SQL statement
PL/pgSQL function dotlrn_community_type__new(character varying,character
varying,character varying,character varying,character varying) line 9 at
RETURN
SQL statement "SELECT dotlrn_community_type__new(
        'dotlrn_community',
        null,
        '#dotlrn.dotlrn_community_pretty_name#',
        '#dotlrn.dotlrn_community_pretty_plural#',
        '#dotlrn.dotlrn_community_description#'
    )"
PL/pgSQL function inline_0() line 5 at PERFORM
psql:class-memberships-create.sql:224: ERROR:  function
acs_rel_type__create_type(unknown, unknown, unknown, unknown, unknown,
unknown, unknown, unknown, unknown, integer, unknown, unknown, unknown,
integer, unknown) is not unique
LINE 1: SELECT acs_rel_type__create_type (
               ^
HINT:  Could not choose a best candidate function. You might need to add
explicit type casts.
QUERY:  SELECT acs_rel_type__create_type (
        'dotlrn_student_rel',
        'dotLRN Student Community Membership',
        'dotLRN Student Community Memberships',
        'dotlrn_member_rel',
        'dotlrn_student_rels',
        'rel_id',
        'dotlrn_student_rel',
        'dotlrn_class_instance',
        null,
        0,
        null,
        'user',
        'student',
        0,
        null
    )
CONTEXT:  PL/pgSQL function inline_0() line 3 at PERFORM
psql:main-portlet-create.sql:153: ERROR:  missing FROM-clause entry for
table "acs_object_id_seq"
LINE 4:     (acs_object_id_seq.nextval, p_datasource_id, p_config_re...
             ^
QUERY:  insert into portal_datasource_def_params
    (parameter_id, datasource_id, config_required_p, configured_p, key,
value)
    values
    (acs_object_id_seq.nextval, p_datasource_id, p_config_required_p,
p_configured_p, p_key, p_value)
CONTEXT:  PL/pgSQL function
portal_datasource__set_def_param(integer,character varying,character
varying,character varying,character varying) line 10 at SQL statement
SQL statement "SELECT portal_datasource__set_def_param(
        ds_id, 't', 't', 'shadeable_p', 'f'
    )"
PL/pgSQL function inline_0() line 20 at PERFORM

psql:site-templates-create.sql:91: ERROR:  missing FROM-clause entry for
table "acs_object_id_seq"
LINE 1: select acs_object_id_seq.nextval
               ^
QUERY:  select acs_object_id_seq.nextval
                                         from dual

##### .LRN Error 2
ALTER TABLE
Failed to install ACS Kernel, version 5.9.2d1.  The following error was
generated:
            psql:/web/projop/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.9.0-5.9.1d1.sql:3:
ERROR:  insert or update on table "acs_permissions" violates
foreign key constraint "acs_permissions_grantee_id_fk"
DETAIL:  Key (grantee_id)=(13088) is not present in table "parties".

            NOTE: If the error comes from a sql script you may try to
source it manually. When you are done with that you should
revisit the APM and try again but remember to leave the
manually souced sql scipts unchecked on the previous page.

##### PO Error

[21/Apr/2018:23:39:15][16077.7f5f832f5700][-conn:dotlrn:1:63-] Error:
apm_package_install: Error installing ]project-open[ Reporting OpenOffice
version 5.0.2.4.0:
psql:/var/www/dotlrn/packages/intranet-reporting-openoffice/sql/postgresql/intranet-reporting-openoffice-create.sql:29:
ERROR:  relation "im_menus" does not exist
LINE 13:  (select menu_id from im_menus where label = 'projects_admin...
                               ^
psql:/var/www/dotlrn/packages/intranet-reporting-openoffice/sql/postgresql/intranet-reporting-openoffice-create.sql:35:
ERROR:  relation "im_menus" does not exist
LINE 2:  (select menu_id from im_menus where label = 'openoffice_pro...
                              ^
psql:/var/www/dotlrn/packages/intranet-reporting-openoffice/sql/postgresql/intranet-reporting-openoffice-create.sql:52:
ERROR:  relation "im_menus" does not exist