On Mon, Dec 14, 2009 at 11:14 PM, Hugh Esco
<..hidden..> wrote:
Did not reach the finish line.
I'm wondering if I need pg 8.3, instead of 8.1.
-- Hugh
first glitch in install so far: perl Makefile.PL gets me: Can't locate inc/Module/Install.pm in @INC
Added to INSTALL doc.
@INC includes .
but $LSMB_INSTALL_DIR includes no inc/
well I found this:
/usr/local/share/perl/5.8.8/inc/Module/Install.pm,
however perl -v says v5.10.0 and no similiar animal exists.
that's a funny name for a module, but
cpan[2]> install inc::Module::Install
did the trick.
unimpeded progress until this one blew up in my face:
$ psql -U postgres -d ymd_lsmb_13 -f /usr/local/ledgersmb13/sql/coa/us/chart/General.sql
BEGIN
psql:/usr/local/ledgersmb13/sql/coa/us/chart/General.sql:5: ERROR: function account_heading_save("unknown", "unknown", "unknown", "unknown") does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
So I skipped for the moment loading the CoA.
Then I see the following errors when invoking this:
$ psql -U postgres -d ymd_lsmb_13 -f ymd_lsmb_13_roles.sql
psql:ymd_lsmb_13_roles.sql:31: ERROR: function eca__list_notes(integer) does not exist
INSERT 0 1
<snip>
GRANT
psql:ymd_lsmb_13_roles.sql:63: ERROR: syntax error at or near "note_id_seq" at character 23
psql:ymd_lsmb_13_roles.sql:63: LINE 1: GRANT ALL ON SEQUENCE note_id_seq TO "lsmb_ymd_lsmb_13__cont...
psql:ymd_lsmb_13_roles.sql:63: ^
GRANT
<snip>
CREATE ROLE
psql:ymd_lsmb_13_roles.sql:1397: ERROR: function admin__add_user_to_role(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1399: ERROR: function admin__remove_user_from_role(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1401: ERROR: function admin__add_function_to_group(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1403: ERROR: function admin__remove_function_from_group(text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1405: ERROR: function admin__get_roles_for_user(integer) does not exist
psql:ymd_lsmb_13_roles.sql:1407: ERROR: function admin__save_user(integer, integer, text, text) does not exist
psql:ymd_lsmb_13_roles.sql:1409: ERROR: function admin__create_group(text) does not exist
psql:ymd_lsmb_13_roles.sql:1411: ERROR: function admin__delete_user(text) does not exist
psql:ymd_lsmb_13_roles.sql:1413: ERROR: function admin__list_roles(text) does not exist
psql:ymd_lsmb_13_roles.sql:1415: ERROR: function admin__delete_group(text) does not exist
GRANT
<snip>
GRANT
psql:ymd_lsmb_13_roles.sql:1425: ERROR: relation "user_listable" does not exist
GRANT
<snip>
GRANT
psql:ymd_lsmb_13_roles.sql:1449: ERROR: function user__get_all_users() does not exist
CREATE ROLE
GRANT
CREATE ROLE
psql:ymd_lsmb_13_roles.sql:1464: ERROR: function voucher__delete(integer) does not exist
psql:ymd_lsmb_13_roles.sql:1467: ERROR: function batch_delete(integer) does not exist
Next obstacle makes me wonder if I should have upgraded to pg 8.3:
psql -U postgres -d ymd_lsmb_13 -t -c "INSERT INTO entity (name, entity_class, created) VALUES ('lsmb', 3, NOW()) RETURNING name, entity_class, created;"
ERROR: syntax error at or near "RETURNING" at character 76
LINE 1: ... entity_class, created) VALUES ('lsmb', 3, NOW()) RETURNING ...
^
Trying it this way:
psql -U postgres -d ymd_lsmb_13 -t -c "INSERT INTO entity (name, entity_class, created) VALUES ('lsmb', 3, NOW());"
ERROR: null value in column "control_code" violates not-null constraint
gives me another error . . .
Hmm. Looks like the use of
initiate.pl was not documented in the INSTALL file.
The easiest way to set this up is using Sadash's contributed interface for database setup. Direct your browser to http://[lsmb-url-dir]/
initiate.pl and enter your database superuser credentials. Then initialize a database on that screen. That works pretty well, actually.
Best Wishes,
Chris Travers